DP-300 Exam Question 101
You are designing a security model for an Azure Synapse Analytics dedicated SQL pool that will support multiple companies.
You need to ensure that users from each company can view only the data of their respective company.
Which two objects should you include in the solution? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
You need to ensure that users from each company can view only the data of their respective company.
Which two objects should you include in the solution? Each correct answer presents part of the solution.
NOTE: Each correct selection is worth one point.
DP-300 Exam Question 102
Hotspot Question
You have an Azure subscription that contains an Azure SQL database.
The database fails to respond to queries in a timely manner.
You need to identify whether the issue relates to resource_semaphore waits.
How should you complete the Transact-SQL query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You have an Azure subscription that contains an Azure SQL database.
The database fails to respond to queries in a timely manner.
You need to identify whether the issue relates to resource_semaphore waits.
How should you complete the Transact-SQL query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

DP-300 Exam Question 103
You have an Azure subscription.
You need to create a new database named DB1 in the subscription. The solution must meet the following requirements:
- Ensure that tables created in DB1 automatically provide cryptographic proof when data is altered.
- Ensure that auditors can verify whether the data has NOT been
modified.
Which T-SQL command should you run?
You need to create a new database named DB1 in the subscription. The solution must meet the following requirements:
- Ensure that tables created in DB1 automatically provide cryptographic proof when data is altered.
- Ensure that auditors can verify whether the data has NOT been
modified.
Which T-SQL command should you run?
DP-300 Exam Question 104
You have a Microsoft SQL Server 2019 database named DB1 and an Azure SQL managed instance named SQLMI1.
You need to move a SQL Server Agent job from DB1 to SQLMI1.
Which job attribute is unsupported in SQLMI1?
You need to move a SQL Server Agent job from DB1 to SQLMI1.
Which job attribute is unsupported in SQLMI1?
DP-300 Exam Question 105
Hotspot Question
You have an Azure subscription that contains an Azure SQL managed instance named SQL1.
You use the Microsoft Power BI service.
You need to configure connectivity from the Power BI service to SQL1. The solution must ensure that only the Power BI service can initiate connections to SQL1.
Which type of endpoint should you use for SQL1, and what should you use to control the connections to SQL1? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You have an Azure subscription that contains an Azure SQL managed instance named SQL1.
You use the Microsoft Power BI service.
You need to configure connectivity from the Power BI service to SQL1. The solution must ensure that only the Power BI service can initiate connections to SQL1.
Which type of endpoint should you use for SQL1, and what should you use to control the connections to SQL1? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.



