Pass Microsoft DP-300 exam questions – convert Test Engine to PDF [Q51-Q72]

DP-300 Microsoft

admin -

February 25, 2026

Rate this post

Pass Microsoft DP-300 exam questions – convert Test Engine to PDF

Pass Your DP-300 Exam Easily – Real DP-300 Practice Dump Updated Feb 25, 2026

Microsoft DP-300 certification exam is ideal for IT professionals who are responsible for managing relational databases on Microsoft Azure. Administering Relational Databases on Microsoft Azure certification exam is designed for individuals who have a good understanding of SQL Server and Azure SQL Database concepts. DP-300 exam is also suitable for individuals who have experience in database administration and have a good understanding of database security, backup and restore strategies, and performance tuning.

Microsoft DP-300: Administering Relational Databases on Microsoft Azure is a certification exam designed to test the knowledge and skills of database administrators who work with relational databases on the Microsoft Azure platform. DP-300 exam is part of the Microsoft Certified: Azure Database Administrator Associate certification, which is aimed at professionals who want to demonstrate their expertise in administering Azure SQL databases, Azure SQL Managed Instance, and hybrid SQL Server instances in Azure.

NO.51 You have SQL Server on an Azure virtual machine that contains a database named Db1.
You need to enable automatic tuning for Db1.
How should you complete the statements? To answer, select the appropriate answer in the answer area.
NOTE: Each correct selection is worth one point.

Explanation

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.
Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/automatic-tuning-enable

NO.52 You have an Azure subscription that contains an Azure SQL managed instance, a database named db1, and an Azure web app named Appl. Appl uses db1.
You need to enable Resource Governor for a App1. The solution must meet the following requirements:
App1 must be able to consume all available CPU resources.
App1 must have at least half of the available CPU resources always available.
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 NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.

1 – Create a resource pool that has the following configurations…..
2 – Create a workload group.
3 – Create a classifier function in the master database.

NO.53 You have an Azure SQL database named DB1 that contains a table named Orders. The Orders table contains a row for each sales order. Each sales order includes the name of the user who placed the order.
You need to implement row-level security (RLS). The solution must ensure that the users can view only their respective sales orders.
What should you include in the solution? To answer, select the appropriate options in the answer are a.
NOTE: Each correct selection is worth one point.

NO.54 You have an Azure SQL database. The database contains a table that uses a columnstore index and is accessed infrequently.
You enable columnstore archival compression.
What are two possible results of the configuration? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

Queries that use the index will consume more disk I/O.

Queries that use the index will retrieve fewer data pages.

The index will consume more disk space.

The index will consume more memory.

Queries that use the index will consume more CPU resources.

Section: [none]
Explanation:
For rowstore tables and indexes, use the data compression feature to help reduce the size of the database. In addition to saving space, data compression can help improve performance of I/O intensive workloads because the data is stored in fewer pages and queries need to read fewer pages from disk.
Use columnstore archival compression to further reduce the data size for situations when you can afford extra time and CPU resources to store and retrieve the data.

NO.55 You have an Azure SQL database named db1.
You need to retrieve the resource usage of db1 from the last week.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-resource-stats-azure-sql-database

NO.56 You have a database named db1.
The log for db1 contains the following entry.

You need to ensure That db1 can process transactions.

NO.57 You have an instance of SQL Server on Azure Virtual Machine named SQL1.
You need to monitor SQL1 and query the metrics by using Kusto query language.
The solution must minimize administrative effort.
Where should you store the metrics?

a Log Analytics workspace

Azure Event Hubs

Azure SQL Database

an Azure Blob storage container

Kusto language is used in Log Analytics.
https://learn.microsoft.com/en-us/azure/azure-monitor/logs/log-query-overview

NO.58 You have an Azure Data Lake Storage Gen2 account named account1 that stores logs as shown in the following table.

You do not expect that the logs will be accessed during the retention periods.
You need to recommend a solution for account1 that meets the following requirements:
Automatically deletes the logs at the end of each retention period
Minimizes storage costs
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.

Reference:
https://docs.microsoft.com/en-us/azure/storage/blobs/storage-blob-storage-tiers

NO.59 You have an Azure subscription that contains an Azure SQL database.
The database fails to respond to queries in a timely manner.
You need to identify whether the issue relates to resource_semaphore waits.
How should you complete the Transact-SQL query? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Explanation:

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/monitoring-with-dmvs

NO.60 You have an Azure Synapse Analytics dedicated SQL pool named Pool1 and an Azure Data Lake Storage Gen2 account named Account1.
You plan to access the files in Account1 by using an external table.
You need to create a data source in Pool1 that you can reference when you create the external table.
How should you complete the Transact-SQL statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql/develop-tables-external-tables

NO.61 You have an Azure subscription.
You need to deploy an Azure SQL resource that will support cross database queries by using an Azure Resource Manager (ARM) template.
How should you complete the ARM template? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/managed-instance/create-template-quickstart?tabs=azure-powershell

NO.62 You have a 50-TB Microsoft SQL Server database named DB1.
You need to reduce the time it takes to perform database consistency checks of DB1.
Which Transact-SQL command should you run? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Reference:
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-checkdb-transact-sql?view=sql-server-ver15

NO.63 SIMULATION
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.

To protect your Azure resources, you can use Resource Locks.
To prevent accidental deletion of an Azure database, use the Azure portal to create a “Delete” lock on the database or its parent resources, such as the SQL server or resource group. This lock will prevent any user, including owners, from deleting the database.
Step 1: Navigate to the resource: Go to the Azure portal and locate the Azure SQL database you want to protect. You can do this by searching for “SQL databases” or navigating through your resource groups. [Select db1] Step 2: Open the Locks tab: In the database’s overview, locate the “Locks” tab under the
“Settings” section.
Step 3: Add a new lock: Click the “Add” button to create a new lock.
Step 4: Configure the lock:
Lock Name: Give the lock a descriptive name (e.g., “PreventDeleteLock”).
Lock Type: Select “Delete”.
Level: Set the level to “CanNotDelete”.
Notes (Optional): Add any relevant notes about the lock.
Step 5: Apply the lock: Click “OK” to save the lock.
Reference:
https://techcommunity.microsoft.com/blog/adformysql/preventing-and-recovering-from-accidental- deletion-of-an-azure-database-for-mysq/4388503

NO.64 You have an Azure subscription that contains an Azure SQL database. The database contains a table named tablet.
You execute the following Transact-SQL statements.

You need to reduce the time it takes to perform analytic queries on the database.
Which configuration should you enable?

ROW_ MODE_MEMORY GRANT_FEEDBACK

BATCH MODE_MEMORY GRAIJT_FEEDBACK

BATCH_MODE_ADAPTIVE_TOIMS

BATC H_MODE_ON_ROWSTOR E

NO.65 You have the following Azure Resource Manager template.

For each of the following statements, select Yes if the statement is true. Otherwise, select No.
NOTE: Each correct selection is worth one point.

Explanation:
A screenshot of a computer Description automatically generated with low confidence

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/purchasing-models
https://docs.microsoft.com/en-us/azure/azure-sql/database/single-database-create-arm-template-quickstart

NO.66 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?

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

Reference:
https://docs.microsoft.com/en-us/azure/azure-sql/database/long-term-backup-retention-configure This is a case study. Case studies are not timed separately. You can use as much exam time as you would like to complete each case. However, there may be additional case studies and sections on this exam. You must manage your time to ensure that you are able to complete all questions included on this exam in the time provided.
To answer the questions included in a case study, you will need to reference information that is provided in the case study. Case studies might contain exhibits and other resources that provide more information about the scenario that is described in the case study. Each question is independent of the other questions in this case study.
At the end of this case study, a review screen will appear. This screen allows you to review your answers and to make changes before you move to the next section of the exam. After you begin a new section, you cannot return to this section.

NO.67 You have an Azure SQL database named DB1.
You need to encrypt DB1. The solution must meet the following requirements:
– Encrypt data in motion.
– Support comparison operators.
– Provide randomized encryption.
What should you include in the solution?

Always Encrypted with secure enclaves

Always Encrypted

column-level encryption

Transparent Data Encryption (TDE)

Always Encrypted supports deterministic only for operator comparisons. AE with secure enclaves addresses this limitation.
https://learn.microsoft.com/en-us/sql/relational-databases/security/encryption/always-encrypted-enclaves?view=sql-server-ver16

NO.68 You have a database named db1.
The log for db1 contains the following entry.

You need to ensure That db1 can process transactions.

NO.69 You plan to build a structured streaming solution in Azure Databricks. The solution will count new events in five-minute intervals and report only events that arrive during the interval.
The output will be sent to a Delta Lake table.
Which output mode should you use?

complete

append

update

Append Mode: Only new rows appended in the result table since the last trigger are written to external storage. This is applicable only for the queries where existing rows in the Result Table are not expected to change.
Complete Mode: The entire updated result table is written to external storage. It is up to the storage connector to decide how to handle the writing of the entire table.
Update Mode: Only the rows that were updated in the result table since the last trigger are written to external storage. This is different from Complete Mode in that Update Mode outputs only the rows that have changed since the last trigger. If the query doesn’t contain aggregations, it is equivalent to Append mode.
Reference:
https://docs.databricks.com/getting-started/spark/streaming.html

NO.70 You have an Azure SQL database named DB1 in the General Purpose service tier.
You need to monitor D81 by using SQL insights.
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.

Explanation

NO.71 You have an Azure SQL database named db1.
You need to retrieve the resource usage of db1 from the last week.
How should you complete the statement? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Reference:
https://docs.microsoft.com/en-us/sql/relational-databases/system-catalog-views/sys-resource-stats-azure-sql-database

NO.72 DRAG DROP
You have an Azure SQL Database instance named DatabaseA on a server named Server1.
You plan to add a new user named App1 to DatabaseA and grant App1 db_datareader permissions. App1 will use SQL Server Authentication.
You need to create App1. The solution must ensure that App1 can be given access to other databases by using the same credentials.
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.
Select and Place:

Section: [none]
Explanation:
Step 1: On the master database, run CREATE LOGIN [App1] WITH PASSWORD = ‘p@aaW0rd!’ Logins are server wide login and password pairs, where the login has the same password across all databases.
Here is some sample Transact-SQL that creates a login:
CREATE LOGIN readonlylogin WITH password=’1231!#ASDF!a’;
You must be connected to the master database on SQL Azure with the administrative login (which you get from the SQL Azure portal) to execute the CREATE LOGIN command.
Step 2: On DatabaseA, run CREATE USER [App1] FROM LOGIN [App1]
Users are created per database and are associated with logins. You must be connected to the database in where you want to create the user. In most cases, this is not the master database. Here is some sample Transact-SQL that creates a user:
CREATE USER readonlyuser FROM LOGIN readonlylogin;
Step 3: On DatabaseA run ALTER ROLE db_datareader ADD Member [App1]
Just creating the user does not give them permissions to the database. You have to grant them access. In the Transact-SQL example below the readonlyuser is given read only permissions to the database via the db_datareader role.
EXEC sp_addrolemember ‘db_datareader’, ‘readonlyuser’;
Reference:
https://azure.microsoft.com/en-us/blog/adding-users-to-your-sql-azure-database/

Loading …