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: Jul 15, 2026
-
Rated: 4.9 |
-
Online Users: 1014
-
Question 1
-
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 2
-
You plan to build a structured streaming solution in Azure Databricks. The solution will count new events in five-minute intervals and report only events that arrive during the interval.
The output will be sent to a Delta Lake table.
Which output mode should you use?
Answer: A
-
You plan to build a structured streaming solution in Azure Databricks. The solution will count new events in five-minute intervals and report only events that arrive during the interval.
-
Question 3
-
You have an Azure subscription that contains an Azure Data Factory version 2 (V2) data factory named df1. DF1 contains a linked service.
You have an Azure Key vault named vault1 that contains an encryption kay named key1.
You need to encrypt df1 by using key1.
What should you do first?
Answer: B
-
You have an Azure subscription that contains an Azure Data Factory version 2 (V2) data factory named df1. DF1 contains a linked service.
-
Question 4
-
Which of the following is NOT a primary purpose of using SQL Insights for monitoring?
Answer: B
-
Which of the following is NOT a primary purpose of using SQL Insights for monitoring?
-
Question 5
-
You have two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2.
You need to migrate the databases hosted on SQL1 to Azure. The solution must meet the following requirements:
• The service that hosts the migrated databases must be able to communicate with SQL2 by using linked server connections.
• Administrative effort must be minimized.
What should you use to host the databases?
Answer: C
-
You have two on-premises Microsoft SQL Server 2019 instances named SQL1 and SQL2.