Free Microsoft DP-300 Exam Questions
Absolute Free DP-300 Exam Practice for Comprehensive Preparation
-
Microsoft DP-300 Exam Questions
-
Provided By: Microsoft
- Exam: Administering Microsoft Azure SQL Solutions
- Certification: Microsoft Azure
-
Total Questions: 507
-
Updated On: May 21, 2026
-
Rated: 4.9 |
-
Online Users: 1014
-
Question 1
-
You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance namedSQLVM1. SQLVM1 has the following configurations:Automated patching is enabled.The SQL Server laaS Agent extension is installed.The Microsoft SQL Server instance on SQLVM1 is managed by using the Azuie portal.You need to automate the deployment of cumulative updates to SQLVM1 by using Azure UpdateManager. The solution must ensure that the SQL Server instance on SQLVM1 can be managed byusing the Azure portal.What should you do first on SQLVM1?
Answer: B
-
You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance namedSQLVM1. SQLVM1 has the following configurations:Automated patching is enabled.The SQL Server laaS Agent extension is installed.The Microsoft SQL Server instance on SQLVM1 is managed by using the Azuie portal.You need to automate the deployment of cumulative updates to SQLVM1 by using Azure UpdateManager. The solution must ensure that the SQL Server instance on SQLVM1 can be managed byusing the Azure portal.What should you do first on SQLVM1?
-
Question 2
-
You have an Azure virtual machine named VM1 that runs Windows Server 2022 and hosts a Microsoft SQL Server 2019 instance named SQL1.
You need to configure SQL1 to use mixed mode authentication.
Which procedure should you run?
Answer: B
-
You have an Azure virtual machine named VM1 that runs Windows Server 2022 and hosts a Microsoft SQL Server 2019 instance named SQL1.
-
Question 3
-
You have an Azure Data Factory that contains 10 pipelines.
You need to label each pipeline with its main purpose of either ingest, transform, or load. The labels must be available for grouping and filtering when using the monitoring experience in Data Factory.
What should you add to each pipeline?
Answer: A
-
You have an Azure Data Factory that contains 10 pipelines.
-
Question 4
-
You're analyzing the performance metrics of an Azure SQL Database. Which combination of tools would provide both real-time and historical insights into query performance?
Answer: A,C
-
You're analyzing the performance metrics of an Azure SQL Database. Which combination of tools would provide both real-time and historical insights into query performance?
-
Question 5
-
You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance namedSQLVM1. SQLVM1 has the following configurations:Automated patching is enabled.The SQL Server laaS Agent extension is installed.The Microsoft SQL Server instance on SQLVM1 is managed by using the Azuie portal.You need to automate the deployment of cumulative updates to SQLVM1 by using Azure UpdateManager. The solution must ensure that the SQL Server instance on SQLVM1 can be managed byusing the Azure portal.What should you do first on SQLVM1?
Answer: B
-
You have an Azure subscription that contains a SQL Server on Azure Virtual Machines instance namedSQLVM1. SQLVM1 has the following configurations:Automated patching is enabled.The SQL Server laaS Agent extension is installed.The Microsoft SQL Server instance on SQLVM1 is managed by using the Azuie portal.You need to automate the deployment of cumulative updates to SQLVM1 by using Azure UpdateManager. The solution must ensure that the SQL Server instance on SQLVM1 can be managed byusing the Azure portal.What should you do first on SQLVM1?