DP-300 Exam Dumps - Administering Relational Databases on Microsoft Azure

Basic Concept: This question tests monitor, configure, and optimize database resources in the DP-300 exam context. The correct choice is determined by the exact service boundary and operational requirement stated in the scenario.

Why B is Correct: Add a target. 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 correlate the session events with events captured by Event Tracing for Windows (ETW). The selected feature addresses that outcome directly rather than relying on a workaround.

Why A is Wrong: A session window groups events separated by periods of inactivity, which is useful for user sessions rather than fixed continuous aggregation. 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: Add an action. 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 D is Wrong: A session window groups events separated by periods of inactivity, which is useful for user sessions rather than fixed continuous aggregation. It would produce a different operational signal than the one needed to investigate, alert, or tune the workload in this question.

BACKUP DATABASE supports only copy-only full backups of databases, files, or filegroups when it ' s executed on secondary replicas. Copy-only backups don ' t impact the log chain or clear the differential bitmap.

Box 1: SET AUTOMATIC_TUNING = AUTO

To enable automatic tuning on a single database via T-SQL, connect to the database and execute the following query:

ALTER DATABASE current SET AUTOMATIC_TUNING = AUTO

Setting automatic tuning to AUTO will apply Azure Defaults.

Box 2: SET AUTOMATIC_TUNING (FORCE_LAST_GOOD_PLAN = ON)

To configure individual automatic tuning options via T-SQL, connect to the database and execute the query such as this one:

ALTER DATABASE current SET AUTOMATIC_TUNING (FORCE_LAST_GOOD_PLAN = ON)

Setting the individual tuning option to ON will override any setting that database inherited and enable the tuning option. Setting it to OFF will also override any setting that database inherited and disable the tuning option.

Azure Private Link enables you to access Azure PaaS Services (for example, Azure Storage and SQL Database) and Azure hosted customer-owned/partner services over a private endpoint in your virtual network.

Traffic between your virtual network and the service travels the Microsoft backbone network. Exposing your service to the public internet is no longer necessary.

Basic Concept: This question tests monitor, configure, and optimize database resources in the DP-300 exam context. The correct choice is determined by the exact service boundary and operational requirement stated in the scenario.

Why the selected answer is Correct: The selected values fit this scenario because they apply the required Azure SQL configuration at the correct scope and sequence: You have a SQL Server on Azure Virtual Machines instance named VM1 .

Why the alternate choices are Wrong: The alternate selections apply to different administrative stages or different scopes. In a hotspot or drag-drop task, order and scope are part of the answer, so a technically valid Azure feature can still be wrong if it is placed in the wrong step.

A: Auto-failover groups allow you to manage replication and failover of a group of databases on a server or all

databases in a managed instance to another region.

E: Because verification of the scale of the outage and how quickly it can be mitigated involves human actions

by the operations team, the grace period cannot be set below one hour. This limitation applies to all databases

in the failover group regardless of their data synchronization state.

Basic Concept: This question tests performance optimization for SQL workloads, including Query Store, automatic tuning, index/statistics maintenance, and engine-level resource behavior.

Why B is Correct: Use Transact-SQL to enable the force_last_good_plan option. 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. In this scenario, the important constraint is: You need to implement automatic tuning for the databases of MI1. Use Transact-SQL to enable the force_last_good_plan option. satisfies that constraint without adding an unrelated service or manual process.

Why A is Wrong: Use the REST API to call the patch operation and modify the AutomaticTuningServerMode property. 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: Automatic tuning uses built-in recommendations and verification to create/drop indexes or force last known good plans where supported. 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.