Question 76
You have an Azure SQL database.
You run the following PowerShell script.
For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.
You run the following PowerShell script.
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 77
HOTSPOT
You have an Azure SQL database that contains a table named Customer. Customer has the columns shown in
the following table.
You plan to implement a dynamic data mask for the Customer_Phone column. The mask must meet the
following requirements:
* The first six numerals of each customer's phone number must be masked.
* The last four digits of each customer's phone number must be visible.
* Hyphens must be preserved and displayed.
How should you configure the dynamic data mask? To answer, select the appropriate options in the answer
area.
Hot Area:
You have an Azure SQL database that contains a table named Customer. Customer has the columns shown in
the following table.
You plan to implement a dynamic data mask for the Customer_Phone column. The mask must meet the
following requirements:
* The first six numerals of each customer's phone number must be masked.
* The last four digits of each customer's phone number must be visible.
* Hyphens must be preserved and displayed.
How should you configure the dynamic data mask? To answer, select the appropriate options in the answer
area.
Hot Area:
Question 78
You are building an Azure Stream Analytics job to retrieve game data.
You need to ensure that the job returns the highest scoring record for each five-minute time interval of each game.
How should you complete the Stream Analytics query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
You need to ensure that the job returns the highest scoring record for each five-minute time interval of each game.
How should you complete the Stream Analytics query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.
Question 79
Task 4
You need to enable change data capture (CDC) for db1.
You need to enable change data capture (CDC) for db1.
Question 80
You have an Azure SQL database named DB1.
You need to display the estimated execution plan of a query by using the query editor in the Azure portal.
What should you do first?
You need to display the estimated execution plan of a query by using the query editor in the Azure portal.
What should you do first?