Question 31

You have SQL Server on an Azure virtual machine that contains a database named Db1.
You need to enable automatic tuning for Db1.
How should you complete the statements? To answer, select the appropriate answer in the answer area.
NOTE: Each correct selection is worth one point.

Question 32

You have an Azure SQL database that contains a table named Customers Customers contains the following columns.

The data in the PhoneNumber and Email columns is encrypted.
You need to recommend a data classification strategy for Customers. The solution must meet the following requirements:
* Support data security and privacy requirements.
* Support the auditing of access to sensitive data
* Minimize administrative effort.
What should you recommend?
  • Question 33

    You have an Azure AD tenant and a logical Microsoft SQL server named SQL1 that hosts several Azure SQL databases.
    You plan to assign Azure AD users permissions to the databases automatically by using Azure Automation.
    You need to create the required Automation accounts.
    Which two accounts should you create? Each correct answer presents part of the solution.
    NOTE: Each correct selection is worth one point.
  • Question 34

    You need to recommend a configuration for ManufacturingSQLDb1 after the migration to Azure. The solution must meet the business requirements.
    What should you include in the recommendation? To answer, select the appropriate options in the answer area.
    NOTE: Each correct selection is worth one point.

    Question 35

    You have two Azure virtual machines named VM1 and VM2 that run Windows Server 2019. VM1 and VM2 each host a default Microsoft SQL Server 2019 instance. VM1 contains a database named DB1 that is backed up to a file named D:\DB1.bak.
    You plan to deploy an Always On availability group that will have the following configurations:
    VM1 will host the primary replica of DB1.
    VM2 will host a secondary replica of DB1.
    You need to prepare the secondary database on VM2 for the availability group.
    How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.