Free Microsoft DP-300 Exam Questions
Try our Free Demo Practice Tests for Comprehensive DP-300 Exam Preparation
-
Microsoft DP-300 Exam Questions
-
Provided By: Microsoft
- Exam: Administering Microsoft Azure SQL Solutions
- Certification: Microsoft Azure
-
Total Questions: 462
-
Updated On: Feb 18, 2025
-
Rated: 4.9 |
-
Online Users: 924
-
Question 1
-
You have an Azure SQL database.
You identify a long running query.
You need to identify which operation in the query is causing the performance issue.
What should you use to display the query execution plan in Microsoft SQL Server Management Studio (SSMS)?
Answer: A
-
You have an Azure SQL database.
-
Question 2
-
You have a Microsoft SQL Server 2017 server.
You need to migrate the server to Azure. The solution must meet the following requirements:
• Ensure that the latest version of SQL Server is used.
• Support the SQL Server Agent service.
• Minimize administrative effort.
What should you use?
Answer: C
-
You have a Microsoft SQL Server 2017 server.
-
Question 3
-
You plan to deploy an Azure SQL managed instance.
You need to restore database backups across regions.
Which type of storage account should you use?
Answer: D
-
You plan to deploy an Azure SQL managed instance.
-
Question 4
-
You have an on-premises Microsoft SQL Server named SQL1 that hosts five databases.
You need to migrate the databases to an Azure SQL managed instance. The solution must minimize downtime and prevent data loss.
What should you use?
Answer: D
-
You have an on-premises Microsoft SQL Server named SQL1 that hosts five databases.
-
Question 5
-
You're attempting to authenticate users in your Azure SQL Database. Which two methods can you use to authenticate against Azure SQL using identities in Entra ID?
Answer: A,B
-
You're attempting to authenticate users in your Azure SQL Database. Which two methods can you use to authenticate against Azure SQL using identities in Entra ID?