DP-300 Microsoft Administering Relational Databases on Microsoft Azure exact Exam Questions

Administering Relational Databases on Microsoft Azure

Last Update 10 hours ago Total Questions : 408

The Administering Relational Databases on Microsoft Azure content is now fully updated, with all current exam questions added 10 hours ago. Deciding to include DP-300 practice exam questions in your study plan goes far beyond basic test preparation.

You'll find that our DP-300 exam questions frequently feature detailed scenarios and practical problem-solving exercises that directly mirror industry challenges. Engaging with these DP-300 sample sets allows you to effectively manage your time and pace yourself, giving you the ability to finish any Administering Relational Databases on Microsoft Azure practice test comfortably within the allotted time.

Question # 61

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 # 62

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).

Answer:

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 # 63

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.

Answer:

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 # 64

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

Answer:

Explanation:

The Tumbling window trigger supports backfill scenarios. Pipeline runs can be scheduled for windows in the past.

[Reference:, https://docs.microsoft.com/en-us/azure/data-factory/concepts-pipeline-execution-triggers, , , , , , Basic Concept: This question tests task automation for database administration, including which Azure or SQL mechanism can run repeatable maintenance and configuration work., Why A is Correct: A tumbling window divides a stream into fixed, non-overlapping time windows, so every event belongs to one window only. The scenario asks for: 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. That makes tumbling window the option that satisfies the required Azure SQL layer and operational outcome., Why B is Wrong: on-demand 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 C is Wrong: event 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 D is Wrong: schedule 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 # 65

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.

Answer:

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 # 66

You have an Azure subscription that contains an Azure SQL database named DB1.

You need to migrate DB1 to a vCore-based purchasing model by using the Azure Command-Line Interface (Azure CLI). The solution must meet the following requirements:

• Include two high availability replicas.

• Minimize downtime.

How should you complete the Azure CLI command? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Question # 67

You have a Microsoft SQL Server 2017 server that hosts five databases.

You Plan to migrate the databases to Azure.

You need to recommend a solution that meets the following requirements:

Automatically scales compute based on the workload demand

Provides per-second billing

What should you include in the recommendation? To answer, select the appropriate options in the answer area.

Question # 68

You have an Azure subscription that contains an Azure SQL database. The database contains a table named table1 that uses partitioned columnstores. You need to configure table1 to meet the following requirements:

• Each partition must be compressed

• The compression ratio must be maximized.

• You must be able to index the compressed data.

What should you use?

page compression

columnstore compression

columnstore archival compresssion

GZIP compression

Question # 69

You have an on-premises Microsoft SQL Server instance named SQL1 that hosts multiple databases. You have an Azure subscription that contains an Azure SQL managed instance named SQLM11. You need to perform an offline migration of the SQLi databases to SQLMH by using Azure Data Studio. What should you install on SQL1?

Data Migration Assistant (DMA)

a self-hosted integration runtime

SQL Server Data Tools (SSDT)

an Azure Migrate appliance

Question # 70

Note: This question is part of a series of questions that present the same scenario. Each question in the series contains a unique solution that might meet the stated goals. Some question sets might have more than one correct solution, while others might not have a correct solution.

After you answer a question in this section, you will NOT be able to return to it. As a result, these questions will not appear in the review screen.

You have SQL Server 2019 on an Azure virtual machine.

You are troubleshooting performance issues for a query in a SQL Server instance.

To gather more information, you query sys.dm_exec_requests and discover that the wait type is PAGELATCH_UP and the wait_resource is 2:3:905856.

You need to improve system performance.

Solution: You create additional tempdb files.

Does this meet the goal?

Yes