Latest Microsoft DP-300 Dumps PDF Questions Answers 2025

Administering Relational Databases on Microsoft Azure Questions and Answers

Question 1

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.

Options:

Buy Now

Question 2

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

What should you do?

Options:

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.

Question 3

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

Options:

Availability Zones

failover groups

Always On availability groups

geo-replication

Question 4

What should you use to migrate the PostgreSQL database?

Options:

Azure Data Box

AzCopy

Azure Database Migration Service

Azure Site Recovery

Question 5

Which audit log destination should you use to meet the monitoring requirements?

Options:

Azure Storage

Azure Event Hubs

Azure Log Analytics

Question 6

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

Options:

Business Critical 4-vCore

Hyperscale

General Purpose v-vCore

Serverless

Answer:

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 7

You need to provide an implementation plan to configure data retention for ResearchDB1. The solution must meet the security and compliance requirements.

What should you include in the plan?

Options:

Configure the Deleted databases settings for ResearchSrvOL

Deploy and configure an Azure Backup server.

Configure the Advanced Data Security settings for ResearchDBL

Configure the Manage Backups settings for ResearchSrvOL

Question 8

You need to implement the monitoring of SalesSQLDb1. The solution must meet the technical requirements.

How should you collect and stream metrics? To answer, select the appropriate options in the answer area.

NOTE: Each correct selection is worth one point.

Options:

Question 9

You are evaluating the business goals.

Which feature should you use to provide customers with the required level of access based on their service agreement?

Options:

dynamic data masking

Conditional Access in Azure

service principals

row-level security (RLS)

Question 10

What should you do after a failover of SalesSQLDb1 to ensure that the database remains accessible to SalesSQLDb1App1?

Options:

Configure SalesSQLDb1 as writable.

Update the connection strings of SalesSQLDb1App1.

Update the firewall rules of SalesSQLDb1.

Update the users in SalesSQLDb1.

Question 11

You need to implement statistics maintenance for SalesSQLDb1. The solution must meet the technical requirements.

Which four 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.

Options:

Question 12

You create all of the tables and views for ResearchDB1.

You need to implement security for ResearchDB1. The solution must meet the security and compliance requirements.

Which three 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.

Options:

Question 13

You need to recommend a configuration for ManufacturingSQLDb1 after the migration to Azure. The solution must meet the business requirements.

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

NOTE: Each correct selection is worth one point.

Options:

Question 14

You need to configure user authentication for the SERVER1 databases. The solution must meet the security and compliance requirements.

Which three 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.

Options:

Question 15

You need to implement authentication for ResearchDB1. The solution must meet the security and compliance requirements.

What should you run as part of the implementation?

Options:

CREATE LOGIN and the FROM WINDOWS clause

CREATE USER and the FROM CERTIFICATE clause

CREATE USER and the FROM LOGIN clause

CREATE USER and the ASYMMETRIC KEY clause

CREATE USER and the FROM EXTERNAL PROVIDER clause

Answer:

Explanation:

Scenario: Authenticate database users by using Active Directory credentials.

(Create a new Azure SQL database named ResearchDB1 on a logical server named ResearchSrv01.)

Authenticate the user in SQL Database or SQL Data Warehouse based on an Azure Active Directory user:

CREATE USER [Fritz@contoso.com] FROM EXTERNAL PROVIDER;

[Reference:, https://docs.microsoft.com/en-us/sql/t-sql/statements/create-user-transact-sql, , , , , , , , 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 E is Correct: CREATE USER ... FROM EXTERNAL PROVIDER creates contained users mapped to Microsoft Entra identities for Azure SQL authentication. The scenario asks for: You need to implement authentication for ResearchDB1. That makes CREATE USER and the FROM EXTERNAL PROVIDER clause the option that satisfies the required Azure SQL layer and operational outcome., Why A is Wrong: CREATE LOGIN and the FROM WINDOWS clause 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., Why B is Wrong: Certificates support encryption and authentication, but the correct certificate-related object depends on whether the task is TLS, Always Encrypted, or user authentication. It does not satisfy the required identity, encryption, firewall, auditing, or data-exposure boundary described in the scenario: You need to implement authentication for ResearchDB1., Why C is Wrong: CREATE USER and the FROM LOGIN clause 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: CREATE USER and the ASYMMETRIC KEY clause 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., ]

Question 16

You need to recommend the appropriate purchasing model and deployment option for the 30 new databases. The solution must meet the technical requirements and the business requirements.

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

NOTE: Each correct selection is worth one point.

Options:

Question 17

You need to identify the cause of the performance issues on SalesSQLDb1.

Which two dynamic management views should you use? Each correct answer presents part of the solution.

NOTE: Each correct selection is worth one point.

Options:

sys.dm_pdw_nodes_tran_locks

sys.dm_exec_compute_node_errors

sys.dm_exec_requests

sys.dm_cdc_errors

sys.dm_pdw_nodes_os_wait_stats

sys.dm_tran_locks

Question 18

You are planning the migration of the SERVER1 databases. The solution must meet the business requirements.

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

NOTE: Each correct selection is worth one point.

Options:

Question 19

You need to recommend a solution to ensure that the customers can create the database objects. The solution must meet the business goals.

What should you include in the recommendation?

Options:

For each customer, grant the customer ddl_admin to the existing schema.

For each customer, create an additional schema and grant the customer ddl_admin to the new schema.

For each customer, create an additional schema and grant the customer db_writerto the new schema.

For each customer, grant the customer db_writerto the existing schema.

Answer:

Explanation:

Basic Concept: This question tests plan and configure a high availability and disaster recovery (ha/dr) environment 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: For each customer, create an additional schema and grant the customer ddl_admin to the new schema. matches the expected DP-300 administration action. For each customer, create an additional schema and grant the customer ddl_admin to the new schema. 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: You need to recommend a solution to ensure that the customers can create the database objects.

Why A is Wrong: For each customer, grant the customer ddl_admin to the existing schema. 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: For each customer, create an additional schema and grant the customer db_writerto the new schema. 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 D is Wrong: For each customer, grant the customer db_writerto the existing schema. 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.

Question 20

Task 8

You plan to perform performance testing of db1.

You need prevent db1 from reverting to the last known good query plan.

Options:

Question 21

Task 3

You need to prevent users from accidentally deleting db1 from the Azure portal. You may need to use SQL Server Management Studio and the Azure portal.

Options:

Answer:

See the explanation part for the complete Solution.

Explanation:

Apply an Azure Resource Manager Delete lock / CanNotDelete lock directly to the Azure SQL database resource db1.

Microsoft states that Azure resource locks can be applied at subscription, resource group, or resource scope to protect resources from accidental deletion or modification. In the Azure portal, the lock types are shown as Delete and Read-only; in CLI/PowerShell, they are called CanNotDelete and ReadOnly. A CanNotDelete/Delete lock allows users to read and modify the resource, but prevents deletion.

Azure Portal Method — Recommended for Simulation

Step 1: Open the database resource

In the search bar, search for SQL databases.

Select the database named db1.

Make sure you select the database resource itself, not only the SQL logical server.

Step 2: Open Locks

In the left menu of db1, scroll to Settings.

Select Locks.

Select Add.

Step 3: Create the delete lock

Configure the lock as follows:

Setting

Value

Lock name

PreventDelete-db1

Lock type

Delete

Notes

Prevent accidental deletion of db1

Then select OK or Save.

In the portal, choose Delete, not Read-only. A Read-only lock is too restrictive because it can block management updates. For this task, the requirement is only to stop accidental deletion, so Delete / CanNotDelete is the correct lock type. Microsoft confirms that CanNotDelete prevents deletion but still permits reading and modifying the resource.

Step 4: Verify the lock

Stay on the db1 database page.

Go back to Locks.

Confirm the lock exists with:

Name: PreventDelete-db1

Lock type: Delete

The task is complete once db1 has a Delete lock applied.

PowerShell Method

Use this if the lab provides Azure PowerShell.

New-AzResourceLock `

-LockLevel CanNotDelete `

-LockName " PreventDelete-db1 " `

-LockNotes " Prevent accidental deletion of db1 " `

-ResourceGroupName " < resource-group-name > " `

-ResourceName " < sql-server-name > /db1 " `

-ResourceType " Microsoft.Sql/servers/databases "

Microsoft’s New-AzResourceLock documentation includes an Azure SQL Database example using resource type Microsoft.Sql/servers/databases and resource name format serverName/databaseName.

Example format:

New-AzResourceLock `

-LockLevel CanNotDelete `

-LockName " PreventDelete-db1 " `

-LockNotes " Prevent accidental deletion of db1 " `

-ResourceGroupName " RG1 " `

-ResourceName " sql60152867/db1 " `

-ResourceType " Microsoft.Sql/servers/databases "

Replace RG1 and sql60152867 with the actual resource group and SQL logical server that hosts db1.

Azure CLI Method

Use Azure CLI only if the lab gives Cloud Shell and you know the full resource ID.

First get the database resource ID:

az sql db show \

--resource-group < resource-group-name > \

--server < sql-server-name > \

--name db1 \

--query id \

--output tsv

Then create the lock:

az resource lock create \

--name PreventDelete-db1 \

--lock-type CanNotDelete \

--resource < database-resource-id > \

--notes " Prevent accidental deletion of db1 "

Azure CLI supports resource-level lock creation with --lock-type CanNotDelete or ReadOnly.

SSMS / T-SQL Clarification

SSMS is not the correct tool for this task.

A delete lock is an Azure Resource Manager control-plane setting, not a SQL data-plane setting. SQL Server Management Studio can manage database objects and run T-SQL, but it cannot create Azure portal deletion protection locks for an Azure SQL Database.

Question 22

Which counter should you monitor for real-time processing to meet the technical requirements?

Options:

SU% Utilization

CPU% utilization

Concurrent users

Data Conversion Errors

Answer:

Explanation:

Scenario: Real-time processing must be monitored to ensure that workloads are sized properly based on actual usage patterns.

To monitor the performance of a database in Azure SQL Database and Azure SQL Managed Instance, start by monitoring the CPU and IO resources used by your workload relative to the level of database performance you chose in selecting a particular service tier and performance level.

[Reference:, https://docs.microsoft.com/en-us/azure/azure-sql/database/monitor-tune-overview, , , , , , Basic Concept: This question tests Azure monitoring and performance management, including which metric, log destination, or alerting behavior fits the operational requirement., Why A is Correct: SU% Utilization is the Stream Analytics metric used to determine whether the job has enough streaming units for its workload. This fits the case because the requested outcome is: Which counter should you monitor for real-time processing to meet the technical requirements? The selected feature addresses that outcome directly rather than relying on a workaround., Why B is Wrong: CPU percentage is important for database compute monitoring, but it is not the Stream Analytics sizing metric when the question is about streaming units. 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: Concurrent users 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 D is Wrong: Data Conversion Errors 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., Verification Note: The original listed answer was B; the corrected answer is A because For Azure Stream Analytics workload sizing, SU% Utilization is the service metric used to evaluate whether streaming units are appropriately sized., ]

Question 23

Which windowing function should you use to perform the streaming aggregation of the sales data?

Options:

Sliding

Hopping

Session

Tumbling

Question 24

You need to recommend a solution that will enable remote developers to access DB1 and DB2. The solution must support the planned changes and meet the secunty requirements.

What should you include in the recommendation?

Options:

a public endpoint via a database-level firewall rule

a private endpoint

a public endpoint via a server-level firewall rule

a Point-to-Site (P2S) VPN

Question 25

You need to recommend which service and target endpoint to use when migrating the databases from SVR1 to Instance1. The solution must meet the availability requirements.

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

NOTE Each correct selection is worth one point.

Options:

Question 26

You need to identify the event_flle target for monitonng DB3 after the migration to Azure SQL Database. The solution must meet the management requirements,

What should you use as the event_file target?

Options:

an Azure SQL database

an Azure Blob Storage container

a SQL Server filegroup

an Azure Files share

Question 27

You need to recommend which configuration to perform twice to enable access to the primary and secondary replicas of DB3. The solution must meet the availability requirements.

What should you recommend?

Options:

Configure virtual network service endpoints.

Enable database firewall rules.

Create database-scoped credentials.

Configure connection strings that reference the read-write listener.

Question 28

You need to recommend an authentication solution for App1 access to DB1 and DB2 after their migration to Instance1. The solution must meet the availability requirements.

Which actions should you perform in sequence? To answer, drag the appropriate actions to the correct order. Each action may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.

NOTE: Each correct selection is worth one point.

Options:

Question 29

You need to recommend a process to automate the management of DB3. The solution must meet the management requirements. What should be the first step of the process?

Options:

Configure Microsoft Entra authentication for the logical server that hosts DB3.

Create a database that has database-scoped credentials.

Configure a private endpoint for connectivity to DB3.

Create data base-scoped credentials in DB3.

Question 30

You need to recommend a solution to ensure that the performance of DB3 is optimized after the migration to Azure SQL Database. The solution must meet availability requirements.

What should you include in the recommendation?

Options:

Resource Governor

a custom resource pool

vertical scaling

horizontal scaling

Question 31

You need to identify the event_file target for monitonng DB3 after the migration to Azure SQL Database. The solution must meet the management requirements.

What should you use as the event_file target?

Options:

an Azure SQL database

an Azure Blob Storage container

a SQL Server filegroup

an Azure Files share

Question 32

You need to recommend a backup solution to restore DB3. The solution must meet the availability requirements. Which type of backup should you use?

Options:

transaction log

point-in-time restore (PITR)

differential

long-term retention (LTR)

Question 33

You need to recommend a service tier and a method to offload analytical workloads for the databases migrated from SVR1. The solution must meet the availability and business requirements.

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

NOTE: Each correct selection is worth one point.

Options:

Question 34

You need to recommend a solution to meet the security requirements and the business requirements for DB3. What should you recommend as the first step of the solution?

Options:

Run the sys.5p_cdc_en«ble_db stored procedure.

Run the alter table statement and specify the enable chahgc_tracking clause.

Run the alter database statement and specify the set cmange_trackinc > - on clause.

Run the sp_addarticle stored procedure.

Question 35

You plan to deploy Instance1 by using the following script.

You need to specify the licenseType and storagenedundancy parameters. The deployment must meet the availability requirements and the business requirements for DB1 and DB2.

To what should you set each parameter? To answer, select the appropriate options in the answer area.

Options:

Question 36

You have an Azure subscription that contains a user named user1 and an Azure SQL database named OBI. You configure long-term retention (LTR) for DB1.

You need to ensure that User1 can delete LTR backups of DBl. The solution must follow the principle of least privilege. Which role should you assign to User1?

Options:

SQL Server Contributor

Owner

SQL Security Manager

Contributor

Question 37

You have An Azure SQL managed instance.

You need to configure the SQL Server Agent service to email job notifications.

Which statement should you execute?

Options:

Option A

Option B

Option C

Option D

Question 38

You have SQL Server 2019 on an Azure virtual machine that runs Windows Server 2019. The virtual machine

has 4 vCPUs and 28 GB of memory.

You scale up the virtual machine to 8 vCPUSs and 64 GB of memory.

You need to provide the lowest latency for tempdb.

What is the total number of data files that tempdb should contain?

Options:

Question 39

You plan to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group.

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

• Provides a Service Level Agreement (SLA) of at least 99.95%

• Replicates databases in the same group synchronously

• Minimizes the latency of database writes

What should you recommend?

Options:

Create a proximity group and an availability set. Deploy each virtual machine to the availability set Add both virtual machines to the proximity group.

Create two proximity groups and a single availability set. Deploy both virtual machines to the availability set. Add one virtual machine to each proximity group.

Create two proximity groups and two availability sets. Deploy each virtual machine to a unique availability set. Add one virtual machine to each proximity group.

Create a proximity group and two availability sets. Deploy each virtual machine to a unique availability set. Add both virtual machines to the proximity group.

Answer:

Explanation:

To get VMs as close as possible, achieving the lowest possible latency, you should deploy them within a proximity placement group.

Basic Concept: This question tests high availability and disaster recovery design for Azure SQL, SQL Server on Azure VMs, and regional failure scenarios.

Why A is Correct: Create a proximity group and an availability set. Deploy each virtual machine to the availability set Add both virtual machines to the proximity group. is correct because it is the feature whose normal purpose matches the stated requirement. Create a proximity group and an availability set. Deploy each virtual machine to the availability set Add both virtual machines to the proximity group. 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 scenario wording points to that specific behavior: You need to recommend a deployment solution that meets the following requirements: • Provides a Service Level Agreement (SLA) of at least 99.95% • Replicates databases in the same group synchronously • Minimizes the latency of database writes What should you r

Why B is Wrong: Create two proximity groups and a single availability set. Deploy both virtual machines to the availability set. Add one virtual machine to each proximity group. 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 two proximity groups and two availability sets. Deploy each virtual machine to a unique availability set. Add one virtual machine to each proximity group. 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.

Why D is Wrong: Create a proximity group and two availability sets. Deploy each virtual machine to a unique availability set. Add both virtual machines to the proximity group. 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.

Question 40

You have an Azure virtual machine named VM1 on a virtual network named VNet1. Outbound traffic from VM1 to the internet is blocked.

You have an Azure SQL database named SqlDb1 on a logical server named SqlSrv1.

You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements:

Ensure that all traffic to the public endpoint of SqlSrv1 is blocked.

Minimize the possibility of VM1 exfiltrating data stored in SqlDb1.

What should you create on VNet1?

Options:

a VPN gateway

a service endpoint

a private link

an ExpressRoute gateway

Answer:

Explanation:

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.

[Reference:, https://docs.microsoft.com/en-us/azure/private-link/private-link-overview, , , , , , , 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 C is Correct: a private link is an Azure data-platform feature, but it must match the workload model, service tier, migration path, or deployment constraint described in the scenario. The scenario asks for: You need to implement connectivity between VM1 and SqlDb1 to meet the following requirements: Ensure that all traffic to the public endpoint of SqlSrv1 is blocked. That makes a private link the option that satisfies the required Azure SQL layer and operational outcome., Why A is Wrong: a VPN gateway 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: A service endpoint secures traffic to an Azure service over the Azure backbone but still targets the service public endpoint rather than giving it a private IP in the VNet. 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 D is Wrong: an ExpressRoute gateway 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., ]

Question 41

You have an on-premises Microsoft SQL Server 2022 instance that hosts a database named DB1. You have an Azure subscription that contains an Azure SQL database named SQLDB1. You need to replicate DB1 to SQLDB1. Which type of replication should you use?

Options:

snapshot

peer-to-peer

merge

transactional

Question 42

You plan to deploy two instances of SQL Server on Azure virtual machines in a highly available configuration that will use an Always On availability group.

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

• Provides a Service Level Agreement (SLA) of at least 99.95%

• Replicates databases in the same group synchronously

• Minimizes the latency of database writes

What should you recommend?

Options:

Create a proximity group and an availability set. Deploy each virtual machine to the availability set Add both virtual machines to the proximitygroup.

Create two proximity groups and a single availability set. Deploy both virtual machines to the availability set. Add one virtual machine to each proximity group.

Create two proximity groups and two availability sets. Deploy each virtual machine to a unique availability set. Add one virtual machine to each proximity group.

Create a proximity group and two availability sets. Deploy each virtual machine to a unique availability set. Add both virtual machines to the proximity group.

Answer:

Explanation:

Basic Concept: This question tests high availability and disaster recovery design for Azure SQL, SQL Server on Azure VMs, and regional failure scenarios.

Why A is Correct: Create a proximity group and an availability set. Deploy each virtual machine to the availability set Add both virtual machines to the proximitygroup. is correct because it is the feature whose normal purpose matches the stated requirement. Create a proximity group and an availability set. Deploy each virtual machine to the availability set Add both virtual machines to the proximitygroup. 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 scenario wording points to that specific behavior: You need to recommend a deployment solution that meets the following requirements: • Provides a Service Level Agreement (SLA) of at least 99.95% • Replicates databases in the same group synchronously • Minimizes the latency of database writes What should you r

Why B is Wrong: Create two proximity groups and a single availability set. Deploy both virtual machines to the availability set. Add one virtual machine to each proximity group. 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.

Why C is Wrong: Create two proximity groups and two availability sets. Deploy each virtual machine to a unique availability set. Add one virtual machine to each proximity group. 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 D is Wrong: Create a proximity group and two availability sets. Deploy each virtual machine to a unique availability set. Add both virtual machines to the proximity group. 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.

Question 43

You need to design a data retention solution for the Twitter feed data records. The solution must meet the customer sentiment analytics requirements.

Which Azure Storage functionality should you include in the solution?

Options:

time-based retention

change feed

lifecycle management

soft delete

Answer:

Explanation:

The lifecycle management policy lets you:

Delete blobs, blob versions, and blob snapshots at the end of their lifecycles

[Reference:, https://docs.microsoft.com/en-us/azure/storage/blobs/storage-lifecycle-management-concepts, , , , , , , , Basic Concept: This question tests plan and configure a high availability and disaster recovery (ha/dr) environment in the DP-300 exam context. The correct choice is determined by the exact service boundary and operational requirement stated in the scenario., Why C is Correct: lifecycle management matches the expected DP-300 administration action. lifecycle management 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: You need to design a data retention solution for the Twitter feed data records., Why A is Wrong: time-based retention 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: change feed 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 D is Wrong: soft delete 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., ]

Question 44

You need to design an analytical storage solution for the transactional data. The solution must meet the sales transaction dataset requirements.

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

NOTE: Each correct selection is worth one point.

Options:

Question 45

You need to implement the surrogate key for the retail store table. The solution must meet the sales transaction dataset requirements.

What should you create?

Options:

a table that has a FOREIGN KEY constraint

a table the has an IDENTITY property

a user-defined SEQUENCE object

a system-versioned temporal table

Exam Detail

Vendor: Microsoft

Certification: Microsoft Certified: Azure Database Administrator Associate

Exam Code: DP-300

Exam Name: Administering Relational Databases on Microsoft Azure

Last Update: Jun 11, 2026

DP-300 Question Answers

Summer Certification Sale 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: save70

Free and Premium Microsoft DP-300 Dumps Questions Answers

Administering Relational Databases on Microsoft Azure Questions and Answers

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer:

Explanation:

Options:

Answer: