Real IT Certification Exams Questions & Dumps | Get Certified with CertQuestionsBank.com

Latest DP-300 Exam Practice Questions

The practice questions for DP-300 exam was last updated on 2026-02-24 .

Viewing page 1 out of 9 pages.

Viewing questions 1 out of 48 questions.

Question#1

You have 50 Azure SQL databases.
You need to notify the database owner when the database settings, such as the database size and pricing tier, are modified in Azure.
What should you do?

A. Create a diagnostic setting for the activity log that has the Security log enabled.

B. For the database, create a diagnostic setting that has the Instance And App Advanced metric enabled.

C. Create an alert rule that uses a Metric signal type.

D. Create an alert rule that uses an Activity Log signal type.

Explanation:
Activity log events - An alert can trigger on every event, or, only when a certain number of events occur.
Reference: https://docs.microsoft.com/en-us/azure/azure-sql/database/alerts-insights-configure-portal

Question#2

SIMULATION
Task 2
You need to configure your user account as the Azure AD admin for the server named sql3700689S.

A. To configure your user account as the Azure AD admin for the server named sql3700689S, you can use the Azure portal or the Azure CLI. Here are the steps for both methods:
Using the Azure portal:
Go to the Azure portal and select SQL Server C Azure Arc.
Select the server named sql3700689S and click on Active Directory admin.
Click on Set admin and choose your user account from the list of Azure AD users.
Click on Select and then Save to confirm the change.
You can verify the Azure AD admin by clicking on Active Directory admin again and checking the current admin.
Using the Azure CLI:
Install the Azure CLI and log in with your Azure account.
Run the following command to get the object ID of your user account: az ad user show --id <your-user-name> --query objectId -o tsv
Run the following command to set your user account as the Azure AD admin for the server: az sql server ad-admin create --server sql3700689S --object-id <your-object-id> --display-name <your-user-name>
You can verify the Azure AD admin by running the following command: az sql server ad-admin show - -server sql3700689S
These are the steps to configure your user account as the Azure AD admin for the server named sql3700689S.

Question#3

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

A. SU% Utilization

B. CPU% utilization

C. Concurrent users

D. Data Conversion Errors

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

Question#4

HOTSPOT
You are designing an enterprise data warehouse in Azure Synapse Analytics that will store website traffic analytics in a star schema.
You plan to have a fact table for website visits. The table will be approximately 5 GB.
You need to recommend which distribution type and index type to use for the table. The solution must provide the fastest query performance.
What should you recommend? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Explanation:
Box 1: Hash
Consider using a hash-distributed table when:
The table size on disk is more than 2 GB.
The table has frequent insert, update, and delete operations.
Box 2: Clustered columnstore
Clustered columnstore tables offer both the highest level of data compression and the best overall query performance.
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-distribute
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/sql-data-warehouse-tables-index

Question#5

HOTSPOT
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

Disclaimer

This page is for educational and exam preparation reference only. It is not affiliated with Microsoft, Microsoft Certified: Azure Database Administrator Associate, or the official exam provider. Candidates should refer to official documentation and training for authoritative information.

Exam Code: DP-300Q & A: 366 Q&AsUpdated: 2026-02-24

Get All DP-300 Q&As

DP-300 Online Practice Questions

Question#1

Question#2

Question#3

Question#4

Question#5

Top 20 Exams

Important Links

Know Us

Follow Us

Payment Methods