DP-300 Exam Question 56
You have an Azure Database for MySQL database. You have to identify which database queries are consuming the most resources.
Which of the following tool can be used for this requirement?
Which of the following tool can be used for this requirement?
DP-300 Exam Question 57
Hotspot Question
You have an on-premises Microsoft SQL Server instance named SQLSVR1 that hosts a database named DB1.
You have an Azure subscription that contains an Azure SQL database named SQLDB1.
You need to perform the following actions:
- Sync DB1 with SQLDB1 by using SQL Data Sync.
- Configure an index in DB1 by using CREATE INDEX.
- Add data to DB1 at regular intervals by using BULK INSERT.
Which option should you specify when you use BULK INSERT, and which parameter should you specify when you use CREATE INDEX? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You have an on-premises Microsoft SQL Server instance named SQLSVR1 that hosts a database named DB1.
You have an Azure subscription that contains an Azure SQL database named SQLDB1.
You need to perform the following actions:
- Sync DB1 with SQLDB1 by using SQL Data Sync.
- Configure an index in DB1 by using CREATE INDEX.
- Add data to DB1 at regular intervals by using BULK INSERT.
Which option should you specify when you use BULK INSERT, and which parameter should you specify when you use CREATE INDEX? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

DP-300 Exam Question 58
Hotspot Question
You have an Azure SQL database named DB1.
You need to identify how much unused space in megabytes was allocated to DB1.
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 SQL database named DB1.
You need to identify how much unused space in megabytes was allocated to DB1.
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 59
You have an Azure SQL database named DB1.
You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails.
The solution must minimize costs.
Which deployment option and pricing tier should you configure?
You need to ensure that DB1 will support automatic failover without data loss if a datacenter fails.
The solution must minimize costs.
Which deployment option and pricing tier should you configure?
DP-300 Exam Question 60
You have an on-premises app named App1 that stores data in an on-premises Microsoft SQL Server 2016 database named DB1.
You plan to deploy additional instances of App1 to separate Azure regions. Each region will have a separate instance of App1 and DB1. The separate instances of DB1 will sync by using Azure SQL Data Sync.
You need to recommend a database service for the deployment. The solution must minimize administrative effort.
What should you include in the recommendation?
You plan to deploy additional instances of App1 to separate Azure regions. Each region will have a separate instance of App1 and DB1. The separate instances of DB1 will sync by using Azure SQL Data Sync.
You need to recommend a database service for the deployment. The solution must minimize administrative effort.
What should you include in the recommendation?


