DP-300 Exam Question 86
You have SQL Server on an Azure virtual machine that contains a database named DB1. DB1 contains a table named CustomerPII.
You need to record whenever users query the CustomerPII table.
Which two options should you enable? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You need to record whenever users query the CustomerPII table.
Which two options should you enable? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
DP-300 Exam Question 87
You have an Azure subscription that contains an Azure SQL database named DB1.
You need to migrate DB1 to a vCore-based purchasing model by using the Azure Command-Line Interface (Azure CLI). The solution must meet the following requirements:
* Include two high availability replicas.
* Minimize downtime.
How should you complete the Azure CLI command? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You need to migrate DB1 to a vCore-based purchasing model by using the Azure Command-Line Interface (Azure CLI). The solution must meet the following requirements:
* Include two high availability replicas.
* Minimize downtime.
How should you complete the Azure CLI command? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

DP-300 Exam Question 88
You have an Azure subscription.
You plan to deploy four SQL Server on Azure Virtual Machines instances to two Azure regions. Two instances will be deployed to each region. Each region will host a domain-independent availability group.
You need to recommend a high availability, disaster recovery (HA/DR) solution for the planned deployment.
The solution must minimize administrative effort. What should you include in the recommendation?
You plan to deploy four SQL Server on Azure Virtual Machines instances to two Azure regions. Two instances will be deployed to each region. Each region will host a domain-independent availability group.
You need to recommend a high availability, disaster recovery (HA/DR) solution for the planned deployment.
The solution must minimize administrative effort. What should you include in the recommendation?
DP-300 Exam Question 89
You have a Microsoft SQL Server database named DB1 that contains a table named Table1.
The database role membership for a user named User1 is 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.
NOTE: Each correct selection is worth one point.

The database role membership for a user named User1 is 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.
NOTE: Each correct selection is worth one point.

DP-300 Exam Question 90
You need to trigger an Azure Data Factory pipeline when a file arrives in an Azure Data Lake Storage Gen2 container.
Which resource provider should you enable?
Which resource provider should you enable?




