Question 66

You have an Azure SQL database named db1 on a server named server1.
You need to modify the MAXDOP settings for db1.
What should you do?
  • Question 67

    You have several Azure SQL databases on the same Azure SQL Database server in a resource group named ResourceGroup1.
    You must be alerted when CPU usage exceeds 80 percent for any database. The solution must apply to any additional databases that are created on the Azure SQL server.
    Which resource type should you use to create the alert?
  • Question 68

    You are evaluating the role assignments.
    For each of the following statements, select Yes if the statement is true. Otherwise, select No.
    NOTE: Each correct selection is worth one point.

    Question 69

    You have an Always On availability group deployed to Azure virtual machines. The availability group contains a database named DB1 and has two nodes named SQL1 and SQL2. SQL1 is the primary replica.
    You need to initiate a full backup of DB1 on SQL2.
    Which statement should you run?
  • Question 70

    You are performing exploratory analysis of bus fare data in an Azure Data Lake Storage Gen2 account by using an Azure Synapse Analytics serverless SQL pool.
    You execute the Transact-SQL query shown in the following exhibit.

    Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.