Explanation:

Basic Concept: This question tests plan and implement data platform 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 need to identify and repair any physical or logical corruption in DB1.
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.

Basic Concept: This question tests identity and authentication for Azure SQL and SQL Server workloads, including when to use contained users, directory identities, certificate validation, or authentication profiles.
Why D and E is Correct: On Server1. set the AllowDownloadedDobsTonatehProxyName registry entry to 1.
is correct because it is the feature whose normal purpose matches the stated requirement. On Server1. set the AllowDownloadedDobsTonatehProxyName registry entry to 1. 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 ensure that the SQL Server Agent job steps can be downloaded from Server1 and run on Server2. On Server2. set the AllowDownloadedJobsToNatchProxyName registry entry to 1. is correct because it is the feature whose normal purpose matches the stated requirement. On Server2. set the AllowDownloadedJobsToNatchProxyName registry entry to 1. 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 ensure that the SQL Server Agent job steps can be downloaded from Server1 and run on Server2.
Why A is Wrong: On Server2, grant the contoso\sqlproxy account the Impersonate a client after authentication user right. 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 ensure that the SQL Server Agent job steps can be downloaded from Server1 and run on Server2.
Why B is Wrong: On Server2, grant the contoso\sqlproxy account the Access this computer from the network user right. 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 C is Wrong: On Server2. create a proxy account. is a security-related control, but its value depends on whether the requirement is identity, encryption, auditing, network isolation, or data exposure reduction. It is not the right enforcement point for this case; the scenario needs the control that governs the data or identity path being tested.

Serverless SQL pool can automatically synchronize metadata from Apache Spark. A serverless SQL pool database will be created for each database existing in serverless Apache Spark pools.
For each Spark external table based on Parquet and located in Azure Storage, an external table is created in a serverless SQL pool database. As such, you can shut down your Spark pools and still query Spark external tables from serverless SQL pool.
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-storage-files-spark-tables 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 C is Correct: Parquet 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 when tables are created in DB1, the tables are available automatically as external tables to the built-in serverless SQL pool. The selected feature addresses that outcome directly rather than relying on a workaround.
Why A is Wrong: JSON 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.
Why B is Wrong: CSV 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: ORC 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.

Explanation:

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 need to identify whether a delayed query execution is associated to a RESOURCE wait.
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.

Ref: https://docs.microsoft.com/en-us/azure/dms/tutorial-sql-server-to-azure-sql Basic Concept: This question tests choosing the correct Azure migration approach by matching the source platform, target service, downtime tolerance, and administrative effort.
Why D is Correct: Database Migration Assistant is an Azure data-platform feature, but it must match the workload model, service tier, migration path, or deployment constraint described in the scenario. In this scenario, the important constraint is: What should you use to minimize downtime and data loss during the migration? Database Migration Assistant satisfies that constraint without adding an unrelated service or manual process.
Why A is Wrong: distributed availability groups is an Azure data-platform feature, but it must match the workload model, service tier, migration path, or deployment constraint described in the scenario. It would solve a neighboring problem, but not the deployment, sizing, or migration requirement in this item.
Why B is Wrong: database mirroring is an Azure data-platform feature, but it must match the workload model, service tier, migration path, or deployment constraint described in the scenario. It mismatches the target platform, migration method, compute tier, or deployment model described in the scenario, so it would not satisfy the workload as stated.
Why C is Wrong: Log shipping is a SQL Server HA/DR technique that copies and restores log backups to a secondary database; it is more manual and operationally heavier for Azure SQL Managed Instance migration than LRS. It applies to a different Azure data-platform design than the one the question is testing.