How should you configure the dynamic data mask?

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...

July 1, 2020 No Comments READ MORE +

Which three actions should you perform in sequence?

Testlet 1 This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are...

June 29, 2020 No Comments READ MORE +

Which three actions should you perform in sequence?

DRAG DROP You have a new Azure SQL database named DB1 on an Azure SQL server named AzSQL1. The only user who was created is the server administrator. You need to create a contained database user in DB1 who will use Azure Active Directory (Azure AD) for authentication. Which three...

June 29, 2020 No Comments READ MORE +

Which three metrics should you use to size the elastic pool to meet the demands of your workload?

You have 20 Azure SQL databases provisioned by using the vCore purchasing model. You plan to create an Azure SQL Database elastic pool and add the 20 databases. Which three metrics should you use to size the elastic pool to meet the demands of your workload? Each correct answer presents...

June 29, 2020 No Comments READ MORE +

How should you collect and stream metrics?

Testlet 1 This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are...

June 28, 2020 No Comments READ MORE +