Free Preparation Discussions
MENU
Microsoft DP-300 Exam Questions
- Topic 1: Plan and implement data platform resources: This topic equips Microsoft Database Administrators to strategically plan and deploy Azure SQL solutions, ensuring alignment with organizational needs. It emphasizes configuring resources for optimal scale and performance, which is crucial for handling varying workloads effectively. Additionally, it covers creating a robust migration strategy to transition data platforms with minimal disruption, reinforcing knowledge of cloud-based resource management.
- Topic 2: Implement a secure environment: This topic enables administrators to safeguard database integrity by configuring database authentication and authorization, ensuring only authorized access. It emphasizes implementing security measures for data both at rest and in transit, addressing potential vulnerabilities. Finally, it highlights the importance of compliance controls to protect sensitive data and adhere to regulatory standards, fostering a secure database ecosystem.
- Topic 3: Monitor, configure, and optimize database resources: This topic focuses on enhancing database performance through monitoring resource activity and performance, providing insights into usage trends. Administrators will learn techniques to monitor and optimize query performance, streamlining data retrieval processes. It also explores configuring databases for optimal performance, ensuring seamless operations even under demanding conditions.
- Topic 4: Configure and manage automation of tasks: This topic emphasizes operational efficiency by guiding administrators on how to create and manage SQL Server Agent jobs for routine task automation. It includes automating the deployment of database resources, reducing manual intervention. Moreover, it covers managing database tasks within Azure, ensuring streamlined workflows and consistent system management.
- Topic 5: Plan and configure a high availability and disaster recovery (HA/DR) environment: This topic prepares administrators to recommend effective HA/DR strategies for various database scenarios, minimizing downtime. It involves planning and performing backups and restores, ensuring data availability during unexpected events. Additionally, configuring HA/DR solutions reinforces the ability to maintain business continuity and safeguard critical data systems.
Free Microsoft DP-300 Exam Actual Questions
Note: Premium Questions for DP-300 were last updated On Jun. 20, 2025 (see below)
You have an Azure SQL database.
You discover that the plan cache is full of compiled plans that were used only once.
You run the select * from sys.database_scoped_configurations Transact-SQL command and receive the results shown in the following table.
You need relieve the memory pressure.
What should you configure?
OPTIMIZE_FOR_AD_HOC_WORKLOADS = { ON | OFF }
Enables or disables a compiled plan stub to be stored in cache when a batch is compiled for the first time. The default is OFF. Once the database scoped configuration OPTIMIZE_FOR_AD_HOC_WORKLOADS is enabled for a database, a compiled plan stub will be stored in cache when a batch is compiled for the first time. Plan stubs have a smaller memory footprint compared to the size of the full compiled plan.
Incorrect Answers:
A: LEGACY_CARDINALITY_ESTIMATION = { ON | OFF | PRIMARY }
Enables you to set the query optimizer cardinality estimation model to the SQL Server 2012 and earlier version independent of the compatibility level of the database. The default is OFF, which sets the query optimizer cardinality estimation model based on the compatibility level of the database.
B: QUERY_OPTIMIZER_HOTFIXES = { ON | OFF | PRIMARY }
Enables or disables query optimization hotfixes regardless of the compatibility level of the database. The default is OFF, which disables query optimization hotfixes that were released after the highest available compatibility level was introduced for a specific version (post-RTM).
You have an Azure SQL database named sqldb1.
You need to minimize the possibility of Query Store transitioning to a read-only state.
What should you do?
The Max Size (MB) limit isn't strictly enforced. Storage size is checked only when Query Store writes data to
disk. This interval is set by the Data Flush Interval (Minutes) option. If Query Store has breached the maximum
size limit between storage size checks, it transitions to read-only mode.
Incorrect Answers:
C: Statistics Collection Interval: Defines the level of granularity for the collected runtime statistic, expressed in
minutes. The default is 60 minutes. Consider using a lower value if you require finer granularity or less time to
detect and mitigate issues. Keep in mind that the value directly affects the size of Query Store data.
You are designing a date dimension table in an Azure Synapse Analytics dedicated SQL pool. The date
dimension table will be used by all the fact tables.
Which distribution type should you recommend to minimize data movement?
A replicated table has a full copy of the table available on every Compute node. Queries run fast on replicated tables since joins on replicated tables don't require data movement. Replication requires extra storage, though, and isn't practical for large tables.
Incorrect Answers:
C: A round-robin distributed table distributes table rows evenly across all distributions. The assignment of rows to distributions is random. Unlike hash-distributed tables, rows with equal values are not guaranteed to be assigned to the same distribution.
As a result, the system sometimes needs to invoke a data movement operation to better organize your data before it can resolve a query.
You have an Azure SQL database named DB1. DB1 has a table named Table1 that contains the following columns.
You plan to enable Always Encrypted for Table1.
Which two columns support encryption? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point
You have 25 Azure SQL databases.
You need to implement a centralized database management solution that uses Transact-SQL What should you include in the solution?
- Select Question Types you want
- Set your Desired Pass Percentage
- Allocate Time (Hours : Minutes)
- Create Multiple Practice tests with Limited Questions
- Customer Support
Daniel
13 days agoLashaunda
2 months agoParis
3 months agoBeula
4 months agoElbert
5 months agoVi
5 months agoAshlee
6 months agoMerilyn
6 months agoWendell
7 months agoKayleigh
7 months agoHannah
7 months agoLeonora
8 months agoAshlee
8 months agoKenny
8 months agoCharlene
9 months agoGussie
9 months agoFelicidad
9 months agoGeorgeanna
10 months agoDierdre
10 months agoOdette
10 months agoDulce
11 months agoVernice
11 months agoArt
12 months agoGeraldo
1 years agoLindsey
1 years agoJannette
1 years ago