You have the following Azure Resource Manager template.

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

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/purchasing-models
https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-arm-template-quickstart

Comment: *

Name: *

Email: *

Verification: *

You have a new Azure SQL database. The database contains a column that stores confidential information.
You need to track each time values from the column are returned in a query. The tracking information must be stored for 365 days from the date the query was executed.
Which three actions should you perform? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.

• A.Turn on auditing and write audit logs to an Azure Storage account.
• B.Add extended properties to the column.
• C.Turn on Advanced Data Security for the Azure SQL server.
• D.Apply sensitivity labels named Highly Confidential to the column.
• E.Turn on Azure Advanced Threat Protection (ATP).

Correct Answer: A,C,D

C: Advanced Data Security (ADS) is a unified package for advanced SQL security capabilities. ADS is available for Azure SQL Database, Azure SQL Managed Instance, and Azure Synapse Analytics. It includes functionality for discovering and classifying sensitive data D: You can apply sensitivity-classification labels persistently to columns by using new metadata attributes that have been added to the SQL Server database engine. This metadata can then be used for advanced, sensitivity-based auditing and protection scenarios.
A: An important aspect of the information-protection paradigm is the ability to monitor access to sensitive data. Azure SQL Auditing has been enhanced to include a new field in the audit log called data_sensitivity_information. This field logs the sensitivity classifications (labels) of the data that was returned by a query. Here's an example:

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/data-discovery-and-classification-overview

Comment: *

Name: *

Email: *

Verification: *

You have an Azure subscription.
You plan to deploy an Azure SQL database by using an Azure Resource Manager template.
How should you complete the template? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Correct Answer:

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-arm-template-quickstart

Comment: *

Name: *

Email: *

Verification: *

SIMULATION
You need to ensure that any unused indexes of the databases on sql12345678 are removed automatically.
To complete this task, sign in to the virtual machine. You may need to use SQL Server Management Studio and the Azure portal.

Correct Answer:

Comment: *

Name: *

Email: *

Verification: *

You have SQL Server on an Azure virtual machine that contains a database named DB1.
You view a plan summary that shows the duration in milliseconds of each execution of query 1178902 as shown in the following exhibit:

What should you do to ensure that the query uses the execution plan which executes in the least amount of time?

• A.Force the query execution plan for plan 1221065.
• B.Run the DBCC FREEPROCCACHE command.
• C.Force the query execution plan for plan 1220917.
• D.Disable parameter sniffing.

Comment: *

Name: *

Email: *

Verification: *