1. Home
  2. Microsoft
  3. DP-300 Exam Syllabus

Microsoft DP-300 Exam Topics

Microsoft DP-300 Exam

Administering Microsoft Azure SQL Solutions

Total Questions: 311

What is Included in the Microsoft DP-300 Exam?

Authentic information about the syllabus is essential to go through the Microsoft DP-300 exam in the first attempt. Study4Exam provides you with comprehensive information about Microsoft DP-300 exam topics listed in the official syllabus. You should get this information at the start of your preparation because it helps you make an effective study plan. We have designed this Microsoft Azure Database Administrator Associate certification exam preparation guide to give the exam overview, practice questions, practice test, prerequisites, and information about exam topics that help to go through the Microsoft Administering Microsoft Azure SQL Solutions exam. We recommend you use our preparation material to cover the entire Microsoft DP-300 exam syllabus. Study4Exam offers 3 formats of Microsoft DP-300 exam preparation material. Each format provides new practice questions in PDF format, web-based and desktop practice exams to get passing marks in the first attempt.

Microsoft DP-300 Exam Overview :

Exam Name Administering Microsoft Azure SQL Solutions
Exam Code DP-300
Actual Exam Duration 120 minutes
Expected no. of Questions in Actual Exam 60
Exam Registration Price $165
Official Information https://docs.microsoft.com/en-us/learn/certifications/exams/dp-300
See Expected Questions Microsoft DP-300 Expected Questions in Actual Exam
Take Self-Assessment Use Microsoft DP-300 Practice Test to Assess your preparation - Save Time and Reduce Chances of Failure

Microsoft DP-300 Exam Topics :

Section Weight Objectives
Configure resources for scale and performance 15-20% - configure Azure SQL database/elastic pools for scale and performance
- configure Azure SQL managed instances for scale and performance
- configure SQL Server in Azure VMs for scale and performance
- calculate resource requirements
- evaluate database partitioning techniques, such as database sharding
- set up SQL Data Sync
Recommend an appropriate database offering based on specific requirements 15-20% - evaluate requirements for the deployment
- evaluate the functional benefits/impact of possible database offerings
- evaluate the scalability of the possible database offering
- evaluate the HA/DR of the possible database offering
- evaluate the security aspects of the possible database offering
Deploy resources by using manual methods 15-20% - deploy database offerings on selected platforms
- configure customized deployment templates
- apply patches and updates for hybrid and IaaS deployment
Evaluate a strategy for moving to Azure 15-20% - evaluate requirements for the migration
- evaluate offline or online migration strategies
- evaluate requirements for the upgrade
- evaluate offline or online upgrade strategies
Implement a migration or upgrade strategy for moving to Azure 15-20% - implement an online migration strategy
- implement an offline migration strategy
- implement an online upgrade strategy
- implement an offline upgrade strategy
Configure database authentication by using platform and database tools 15-20% - configure Azure AD authentication
- create users from Azure AD identities
- configure security principals
Configure database authorization by using platform and database tools 15-20% - configure database and object-level permissions using graphical tools
- apply principle of least privilege for all securables
Implement security for data at rest 15-20% - implement Transparent Data Encryption (TDE)
- implement object-level encryption
- implement Dynamic Data Masking
- implement Azure Key Vault and disk encryption for Azure VMs
Implement security for data in transit 15-20% - configure server and database-level firewall rules
- implement Always Encrypted
Implement compliance controls for sensitive data 15-20% - apply a data classification strategy
- configure server and database audits
- implement data change tracking
- perform a vulnerability assessment
Monitor activity and performance 15-20% - prepare an operational performance baseline
- determine sources for performance metrics
- interpret performance metrics
- assess database performance by using Intelligent Insights for Azure SQL Database and Managed Instance
- configure and monitor activity and performance at the infrastructure, server, service, and database levels
Implement performance-related maintenance tasks 15-20% - implement index maintenance tasks
- implement statistics maintenance tasks
- configure database auto-tuning
- automate database maintenance tasks
- manage storage capacity
Identify performance-related issues 15-20% - configure Query Store to collect performance data
- identify sessions that cause blocking
- assess growth/fragmentation of databases and logs
- assess performance-related database configuration parameters
Configure resources for optimal performance 15-20% - configure storage and infrastructure resources
- configure server and service account settings for performance
- configure Resource Governor for performance
Configure a user database for optimal performance 15-20% - implement database-scoped configuration
- configure compute resources for scaling
- configure Intelligent Query Processing (IQP)
Review query plans 5-10% - determine the appropriate type of execution plan
- identify problem areas in execution plans
- extract query plans from the Query Store
Evaluate performance improvements 5-10% - determine the appropriate Dynamic Management Views (DMVs) to gather query performance information
- identify performance issues using DMVs
- identify and implement index changes for queries
- recommend query construct modifications based on resource usage
- assess the use of hints for query performance
Review database table and index design 5-10% - identify data quality issues with duplication of data
- identify normal form of database tables
- assess index design for performance
- validate data types defined for columns
- recommend table and index storage including filegroups
- evaluate table partitioning strategy
- evaluate the use of compression for tables and indexes
Create scheduled tasks 10-15% - manage schedules for regular maintenance jobs
- configure multi-server automation
- configure notifications for task success/failure/non-completion
Evaluate and implement an alert and notification strategy 10-15% - create event notifications based on metrics
- create event notifications for Azure resources
- create alerts for server configuration changes
- create tasks that respond to event notifications
Manage and automate tasks in Azure 10-15% - perform automated deployment methods for resources
- automate backups
- automate performance tuning and patching
- implement policies by using automated evaluation modes
Recommend an HADR strategy for a data platform solution 15-20% - recommend HADR strategy based on RPO/RTO requirements
- evaluate HADR for hybrid deployments
- evaluate Azure-specific HADR solutions
- identify resources for HADR solutions
Test an HADR strategy by using platform, OS, and database tools 15-20% - test HA by using failover
- test DR by using failover or restore
Perform backup and restore a database by using database tools 15-20% - perform a database backup with options
- perform a database restore with options
- perform a database restore to a point in time
- configure long-term backup retention
Configure HA/DR by using OS, platform, and database tools 15-20% - configure replication
- create an Availability Group
- configure auto-failover groups
- integrate a database into an Availability Group
- configure quorum options for a Windows Server Failover Cluster
- configure an Availability Group listener
Examine system health 10-15% - evaluate database health using DMVs
- evaluate server health using DMVs
- perform database consistency checks by using DBCC
Monitor database configuration by using T-SQL 10-15% - assess proper database autogrowth configuration
- report on database free space
- review database configuration options
Perform backup and restore a database by using T-SQL 10-15% - prepare databases for Always On Availability Groups
- perform transaction log backup
- perform restore of user databases
- perform database backups with options
Manage authentication by using T-SQL 10-15% - manage certificates
- manage security principals
Manage authorization by using T-SQL 10-15% - configure permissions for users to access database objects
- configure permissions by using custom roles

Updates in the Microsoft DP-300 Exam Topics:

Microsoft DP-300 exam questions and practice test are the best ways to get fully prepared. Study4exam's trusted preparation material consists of both practice questions and practice test. To pass the actual Azure Database Administrator Associate DP-300 exam on the first attempt, you need to put in hard work on these questions as they cover all updated Microsoft DP-300 exam topics included in the official syllabus. Besides studying actual questions, you should take the Microsoft DP-300 practice test for self-assessment and actual exam simulation. Revise actual exam questions and remove your mistakes with the Administering Microsoft Azure SQL Solutions DP-300 exam practice test. Online and Windows-based formats of the DP-300 exam practice test are available for self-assessment.