Microsoft DP-300 Free Certification Exam Questions Answer Aug 2026 update

You have two on-premises Microsoft SQL Server instances named SQL1 and SQL2.

You have an Azure subscription

You need to sync a subset of tables between the databases hosted on SQL1 and SQL2 by using SQL Data Sync.

Which five actions should you perform in sequence ' To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Question # 12

You are monitoring an Azure Stream Analytics job.

You discover that the Backlogged input Events metric is increasing slowly and is consistently non-zero.

You need to ensure that the job can handle all the events.

What should you do?

Remove any named consumer groups from the connection and use $default.

Change the compatibility level of the Stream Analytics job.

Create an additional output stream for the existing input stream.

Increase the number of streaming units (SUs).

Explanation:

Backlogged Input Events: Number of input events that are backlogged. A non-zero value for this metric implies that your job isn ' t able to keep up with the number of incoming events. If this value is slowly increasing or consistently non-zero, you should scale out your job, by increasing the SUs.

[Reference:, https://docs.microsoft.com/en-us/azure/stream-analytics/stream-analytics-monitoring, , , , , , Basic Concept: This question tests Azure monitoring and performance management, including which metric, log destination, or alerting behavior fits the operational requirement., Why D is Correct: Increase the number of streaming units (SUs). is related to operational monitoring or tuning, but it must match the exact signal needed: query history, resource utilization, wait/blocking detail, or automatic remediation. This fits the case because the requested outcome is: You need to ensure that the job can handle all the events. The selected feature addresses that outcome directly rather than relying on a workaround., Why A is Wrong: Remove any named consumer groups from the connection and use $default. is related to operational monitoring or tuning, but it must match the exact signal needed: query history, resource utilization, wait/blocking detail, or automatic remediation. It is useful in other troubleshooting paths, but this scenario requires a more specific monitoring or optimization feature., Why B is Wrong: Change the compatibility level of the Stream Analytics job. is related to operational monitoring or tuning, but it must match the exact signal needed: query history, resource utilization, wait/blocking detail, or automatic remediation. It would produce a different operational signal than the one needed to investigate, alert, or tune the workload in this question., Why C is Wrong: Create an additional output stream for the existing input stream. is related to operational monitoring or tuning, but it must match the exact signal needed: query history, resource utilization, wait/blocking detail, or automatic remediation. It does not expose the required metric, query history, wait/blocking signal, or tuning mechanism; using it would not give the administrator the evidence requested., ]

Question # 13

You have the following Azure Data Factory pipelines:

Ingest Data from System1

Ingest Data from System2

Populate Dimensions

Populate Facts

Ingest Data from System1 and Ingest Data from System2 have no dependencies. Populate Dimensions must execute after Ingest Data from System1 and Ingest Data from System2. Populate Facts must execute after the Populate Dimensions pipeline. All the pipelines must execute every eight hours.

What should you do to schedule the pipelines for execution?

Add a schedule trigger to all four pipelines.

Add an event trigger to all four pipelines.

Create a parent pipeline that contains the four pipelines and use an event trigger.

Create a parent pipeline that contains the four pipelines and use a schedule trigger.

Explanation:

[Reference:, https://www.mssqltips.com/sqlservertip/6137/azure-data-factory-control-flow-activities-overview/, , , , , , Basic Concept: This question tests task automation for database administration, including which Azure or SQL mechanism can run repeatable maintenance and configuration work., Why D is Correct: Create a parent pipeline that contains the four pipelines and use a schedule trigger. matches the expected DP-300 administration action. Create a parent pipeline that contains the four pipelines and use a schedule trigger. is part of the availability or recovery design space, but the correct choice must satisfy the specified failover, restore, quorum, RPO, or RTO requirement. The question is not asking for a general Azure capability; it is asking for the feature that produces this result: Populate Dimensions must execute after Ingest Data from System1 and Ingest Data from System2., Why A is Wrong: Add a schedule trigger to all four pipelines. is part of the availability or recovery design space, but the correct choice must satisfy the specified failover, restore, quorum, RPO, or RTO requirement. It does not meet the failover, restore, quorum, or cross-region continuity target stated in the question, even if it is valid in a different availability design., Why B is Wrong: Add an event trigger to all four pipelines. is part of the availability or recovery design space, but the correct choice must satisfy the specified failover, restore, quorum, RPO, or RTO requirement. It handles a different resilience pattern and would not deliver the failover or recovery behavior required here., Why C is Wrong: Create a parent pipeline that contains the four pipelines and use an event trigger. is part of the availability or recovery design space, but the correct choice must satisfy the specified failover, restore, quorum, RPO, or RTO requirement. It is not wrong technology in general, but it is the wrong HA/DR control for this scenario's failure model., ]

Question # 14

You have an Azure Data Factory pipeline that performs an incremental load of source data to an Azure Data Lake Storage Gen2 account.

Data to be loaded is identified by a column named LastUpdatedDate in the source table.

You plan to execute the pipeline every four hours.

You need to ensure that the pipeline execution meets the following requirements:

Automatically retries the execution when the pipeline run fails due to concurrency or throttling limits.

Supports backfilling existing data in the table.

Which type of trigger should you use?

tumbling window

on-demand

event

schedule

Question # 15

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?

Disable purge protection on vault1.

Remove the linked service from df1.

Create a self-hosted integration runtime.

Disable soft delete on vault1.

Explanation:

A customer-managed key can only be configured on an empty data Factory. The data factory can ' t contain any resources such as linked services, pipelines and data flows. It is recommended to enable customer-managed key right after factory creation.

Note: Azure Data Factory encrypts data at rest, including entity definitions and any data cached while runs are in progress. By default, data is encrypted with a randomly generated Microsoft-managed key that is uniquely assigned to your data factory.

[Reference:, https://docs.microsoft.com/en-us/azure/data-factory/enable-customer-managed-key, , , , , , , , , , Basic Concept: This question tests secure database administration, where the control must match the data state, access boundary, identity model, or compliance requirement., Why C is Correct: Create a self-hosted integration runtime. is correct because it is the feature whose normal purpose matches the stated requirement. Create a self-hosted integration runtime. is a security-related control, but its value depends on whether the requirement is identity, encryption, auditing, network isolation, or data exposure reduction. The scenario wording points to that specific behavior: You need to encrypt df1 by using key1., Why A is Wrong: Disable purge protection on vault1. is a security-related control, but its value depends on whether the requirement is identity, encryption, auditing, network isolation, or data exposure reduction. It does not satisfy the required identity, encryption, firewall, auditing, or data-exposure boundary described in the scenario: You need to encrypt df1 by using key1., Why B is Wrong: Remove the linked service from df1. is a security-related control, but its value depends on whether the requirement is identity, encryption, auditing, network isolation, or data exposure reduction. It protects or manages a different security layer, so the required database access or protection behavior would still be incomplete., Why D is Wrong: Disable soft delete on vault1. is a security-related control, but its value depends on whether the requirement is identity, encryption, auditing, network isolation, or data exposure reduction. It does not satisfy the required identity, encryption, firewall, auditing, or data-exposure boundary described in the scenario: You need to encrypt df1 by using key1., ]

Question # 16

You have an Azure SQL database named DB1 that contains two tables named Table1 and Table2. Both tables contain a column named a Column1. Column1 is used for joins by an application named App1.

You need to protect the contents of Column1 at rest, in transit, and in use.

How should you protect the contents of Column1? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Question # 17

What should you implement to meet the disaster recovery requirements for the PaaS solution?

Availability Zones

failover groups

Always On availability groups

geo-replication

Question # 18

You are evaluating the role assignments.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.

NOTE: Each correct selection is worth one point.

Question # 19

Based on the PaaS prototype, which Azure SQL Database compute tier should you use?

Business Critical 4-vCore

Hyperscale

General Purpose v-vCore

Serverless

Explanation:

There are CPU and Data I/O spikes for the PaaS prototype. Business Critical 4-vCore is needed.

[Reference:, https://docs.microsoft.com/en-us/azure/azure-sql/database/reserved-capacity-overview, , , , , , Basic Concept: This question tests Azure SQL sizing and purchasing choices, where compute model, scaling behavior, licensing benefits, and cost pattern must be evaluated together., Why D is Correct: The serverless tier automatically scales compute and can pause during inactive periods, making it suitable for intermittent workloads with bursts and idle windows. The scenario asks for: Based on the PaaS prototype, which Azure SQL Database compute tier should you use? That makes Serverless the option that satisfies the required Azure SQL layer and operational outcome., Why A is Wrong: Business Critical provides low-latency local SSD storage and high availability for demanding workloads, but it is usually more expensive than necessary for bursty idle workloads. That design keeps capacity available for a different kind of workload and does not match the cost behavior expected from an idle-and-burst database pattern., Why B is Wrong: Hyperscale is designed for very large databases and fast scale-out storage architecture, not merely for intermittent CPU bursts. That design keeps capacity available for a different kind of workload and does not match the cost behavior expected from an idle-and-burst database pattern., Why C is Wrong: The vCore purchasing model separates compute and storage sizing and supports Azure Hybrid Benefit for eligible SQL Server licenses. It applies to a different Azure data-platform design than the one the question is testing., Verification Note: The original listed answer was A; the corrected answer is D because The prototype shows intermittent spikes with idle periods; the serverless compute tier is designed for intermittent usage and automatic pause/resume cost savings., ]

Question # 20

You need to implement a solution to notify the administrators. The solution must meet the monitoring requirements.

What should you do?

Create an Azure Monitor alert rule that has a static threshold and assign the alert rule to an action group.

Add a diagnostic setting that logs QueryStoreRuntimeStatistics and streams to an Azure event hub.

Add a diagnostic setting that logs Timeouts and streams to an Azure event hub.

Create an Azure Monitor alert rule that has a dynamic threshold and assign the alert rule to an action group.

Summer Sale Special - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

Free Practice Questions for Microsoft DP-300 Exam

The Answer Is:

Explanation:

The Answer Is:

Explanation:

The Answer Is:

Explanation:

The Answer Is:

Explanation:

The Answer Is:

Explanation:

The Answer Is:

Explanation:

The Answer Is:

Explanation:

The Answer Is:

Explanation:

The Answer Is:

Explanation:

The Answer Is:

Explanation: