Administering Relational Databases on Microsoft Azure
DP-300
Money Back Guarantee
98% Success Rate
Real Questions
1
Plan and implement data platform resources 22%
1.1
Implement a secure environment (15–20%)
Learning Objectives
- Implement implement a secure environment (15–20%)
1.2
Monitor, configure, and optimize database resources (20–25%)
Learning Objectives
- Implement monitor, configure, and optimize database resources (20–25%)
1.3
Configure and manage automation of tasks (15–20%)
Learning Objectives
- Implement configure and manage automation of tasks (15–20%)
1.4
Plan and configure a high availability and disaster recovery (HA/DR)
Learning Objectives
- Implement plan and configure a high availability and disaster recovery (ha/dr)
1.5
Deploy database offerings on selected platforms
Learning Objectives
- Implement deploy database offerings on selected platforms
1.6
Understand automated deployment
Learning Objectives
- Implement understand automated deployment
1.7
Apply patches and updates for hybrid and infrastructure as a service
Learning Objectives
- Implement apply patches and updates for hybrid and infrastructure as a service
1.8
Deploy hybrid SQL Server solutions
Learning Objectives
- Implement deploy hybrid sql server solutions
1.9
Recommend an appropriate database offering based on specific
Learning Objectives
- Implement recommend an appropriate database offering based on specific
1.10
Evaluate the security aspects of the possible database offering
Learning Objectives
- Implement evaluate the security aspects of the possible database offering
1.11
Recommend a table partitioning solution
Learning Objectives
- Implement recommend a table partitioning solution
1.12
Recommend a database sharding solution
Learning Objectives
- Implement recommend a database sharding solution
1.13
Configure Azure SQL Database for scale and performance
Learning Objectives
- Implement configure azure sql database for scale and performance
1.14
Configure Azure SQL Managed Instance for scale and performance
Learning Objectives
- Implement configure azure sql managed instance for scale and performance
1.15
Configure SQL Server on Azure Virtual Machines for scale and
Learning Objectives
- Implement configure sql server on azure virtual machines for scale and
1.16
Configure table partitioning
Learning Objectives
- Implement configure table partitioning
1.17
Configure data compression
Learning Objectives
- Implement configure data compression
1.18
Evaluate requirements for the migration
Learning Objectives
- Implement evaluate requirements for the migration
1.19
Evaluate offline or online migration strategies
Learning Objectives
- Implement evaluate offline or online migration strategies
1.20
Implement an online migration strategy
Learning Objectives
- Implement implement an online migration strategy
1.21
Implement an offline migration strategy
Learning Objectives
- Implement implement an offline migration strategy
1.22
Perform post migration validations
Learning Objectives
- Implement perform post migration validations
1.23
Troubleshoot a migration
Learning Objectives
- Implement troubleshoot a migration
1.24
Set up SQL Data Sync for Azure
Learning Objectives
- Implement set up sql data sync for azure
1.25
Implement a migration to Azure
Learning Objectives
- Implement implement a migration to azure
1.26
Implement a migration between Azure SQL services
Learning Objectives
- Implement implement a migration between azure sql services
1.27
Implement Azure SQL Managed Instance database copy and move
Learning Objectives
- Implement implement azure sql managed instance database copy and move
1.28
Configure authentication by using Active Directory and Microsoft Entra
Learning Objectives
- Implement configure authentication by using active directory and microsoft entra
1.29
Create users from Microsoft Entra identities
Learning Objectives
- Implement create users from microsoft entra identities
1.30
Configure security principals
Learning Objectives
- Implement configure security principals
1.31
Configure database and object-level permissions using graphical tools
Learning Objectives
- Implement configure database and object-level permissions using graphical tools
1.32
Apply the principle of least privilege for all securables
Learning Objectives
- Implement apply the principle of least privilege for all securables
1.33
Troubleshoot authentication and authorization issues
Learning Objectives
- Implement troubleshoot authentication and authorization issues
1.34
Manage authentication and authorization by using T-SQL
Learning Objectives
- Implement manage authentication and authorization by using t-sql
1.35
Implement transparent data encryption (TDE)
Learning Objectives
- Implement implement transparent data encryption (tde)
1.36
Implement object-level encryption
Learning Objectives
- Implement implement object-level encryption
1.37
Configure server- and database-level firewall rules
Learning Objectives
- Implement configure server- and database-level firewall rules
1.38
Implement Always Encrypted
Learning Objectives
- Implement implement always encrypted
1.39
Implement Always Encrypted with VBS enclaves
Learning Objectives
- Implement implement always encrypted with vbs enclaves
1.40
Configure secure access
Learning Objectives
- Implement configure secure access
1.41
Configure Transport Layer Security (TLS)
Learning Objectives
- Implement configure transport layer security (tls)
1.42
Apply a data classification strategy
Learning Objectives
- Implement apply a data classification strategy
1.43
Configure server and database audits
Learning Objectives
- Implement configure server and database audits
1.44
Implement data change tracking
Learning Objectives
- Implement implement data change tracking
1.45
Implement dynamic data masking
Learning Objectives
- Implement implement dynamic data masking
1.46
Manage database resources by using Microsoft Purview
Learning Objectives
- Implement manage database resources by using microsoft purview
1.47
Implement database ledger in Azure SQL
Learning Objectives
- Implement implement database ledger in azure sql
1.48
Implement row-level security
Learning Objectives
- Implement implement row-level security
1.49
Configure Microsoft Defender for Azure SQL
Learning Objectives
- Implement configure microsoft defender for azure sql
1.50
Prepare an operational performance baseline
Learning Objectives
- Implement prepare an operational performance baseline
1.51
Determine sources for performance metrics
Learning Objectives
- Implement determine sources for performance metrics
1.52
Interpret performance metrics
Learning Objectives
- Implement interpret performance metrics
1.53
Configure and monitor activity and performance
Learning Objectives
- Implement configure and monitor activity and performance
1.54
Monitor by using SQL Insights
Learning Objectives
- Implement monitor by using sql insights
1.55
Monitor by using database watcher
Learning Objectives
- Implement monitor by using database watcher
1.56
Monitor by using Extended Events
Learning Objectives
- Implement monitor by using extended events
1.57
Configure Query Store
Learning Objectives
- Implement configure query store
1.58
Monitor by using Query Store
Learning Objectives
- Implement monitor by using query store
1.59
Identify sessions that cause blocking
Learning Objectives
- Implement identify sessions that cause blocking
1.60
Identify performance issues using dynamic management views (DMVs)
Learning Objectives
- Implement identify performance issues using dynamic management views (dmvs)
1.61
Identify and implement index changes for queries
Learning Objectives
- Implement identify and implement index changes for queries
1.62
Recommend query construct modifications based on resource usage
Learning Objectives
- Implement recommend query construct modifications based on resource usage
1.63
Assess the use of query hints for query performance
Learning Objectives
- Implement assess the use of query hints for query performance
1.64
Review execution plans
Learning Objectives
- Implement review execution plans
1.65
Monitor by using Intelligent Insights
Learning Objectives
- Implement monitor by using intelligent insights
1.66
Implement index maintenance tasks
Learning Objectives
- Implement implement index maintenance tasks
1.67
Implement statistics maintenance tasks
Learning Objectives
- Implement implement statistics maintenance tasks
1.68
Implement database integrity checks
Learning Objectives
- Implement implement database integrity checks
1.69
Configure database automatic tuning
Learning Objectives
- Implement configure database automatic tuning
1.70
Configure server settings for performance
Learning Objectives
- Implement configure server settings for performance
1.71
Configure Resource Governor for performance
Learning Objectives
- Implement configure resource governor for performance
1.72
Implement database-scoped configuration
Learning Objectives
- Implement implement database-scoped configuration
1.73
Configure compute and storage resources for scaling
Learning Objectives
- Implement configure compute and storage resources for scaling
1.74
Configure intelligent query processing (IQP)
Learning Objectives
- Implement configure intelligent query processing (iqp)
1.75
Manage schedules for regular maintenance jobs
Learning Objectives
- Implement manage schedules for regular maintenance jobs
1.76
Configure job alerts and notifications
Learning Objectives
- Implement configure job alerts and notifications
1.77
Troubleshoot SQL Server Agent jobs
Learning Objectives
- Implement troubleshoot sql server agent jobs
1.78
Automate deployment by using Azure Resource Manager (ARM) and Bicep
Learning Objectives
- Implement automate deployment by using azure resource manager (arm) and bicep
1.79
Automate deployment by using PowerShell
Learning Objectives
- Implement automate deployment by using powershell
1.80
Automate deployment by using Azure CLI
Learning Objectives
- Implement automate deployment by using azure cli
1.81
Monitor and troubleshoot deployments
Learning Objectives
- Implement monitor and troubleshoot deployments
1.82
Create and configure elastic jobs
Learning Objectives
- Implement create and configure elastic jobs
1.83
Create and configure database tasks by using automation
Learning Objectives
- Implement create and configure database tasks by using automation
1.84
Configure alerts and notifications on database tasks
Learning Objectives
- Implement configure alerts and notifications on database tasks
1.85
Troubleshoot automated database tasks
Learning Objectives
- Implement troubleshoot automated database tasks
1.86
Recommend HA/DR strategy based on Recovery Point Objective/Recovery
Learning Objectives
- Implement recommend ha/dr strategy based on recovery point objective/recovery
1.87
Evaluate HA/DR for hybrid deployments
Learning Objectives
- Implement evaluate ha/dr for hybrid deployments
1.88
Evaluate Azure-specific HA/DR solutions
Learning Objectives
- Implement evaluate azure-specific ha/dr solutions
1.89
Recommend a testing procedure for an HA/DR solution
Learning Objectives
- Implement recommend a testing procedure for an ha/dr solution
1.90
Recommend a database backup and restore strategy
Learning Objectives
- Implement recommend a database backup and restore strategy
1.91
Perform a database backup by using database tools
Learning Objectives
- Implement perform a database backup by using database tools
1.92
Perform a database restore by using database tools
Learning Objectives
- Implement perform a database restore by using database tools
1.93
Perform a database restore to a point in time
Learning Objectives
- Implement perform a database restore to a point in time
1.94
Configure long-term backup retention
Learning Objectives
- Implement configure long-term backup retention
1.95
Backup and restore a database by using T-SQL
Learning Objectives
- Implement backup and restore a database by using t-sql
1.96
Backup and restore to and from cloud storage
Learning Objectives
- Implement backup and restore to and from cloud storage
1.97
Configure active geo-replication
Learning Objectives
- Implement configure active geo-replication
1.98
Configure an Always On availability group on Azure virtual machines
Learning Objectives
- Implement configure an always on availability group on azure virtual machines
1.99
Configure failover groups
Learning Objectives
- Implement configure failover groups
1.100
Configure quorum options for a Windows Server Failover Cluster
Learning Objectives
- Implement configure quorum options for a windows server failover cluster
1.101
Configure Always On Failover Cluster Instances on Azure virtual
Learning Objectives
- Implement configure always on failover cluster instances on azure virtual
1.102
Configure log shipping
Learning Objectives
- Implement configure log shipping
1.103
Monitor an HA/DR solution
Learning Objectives
- Implement monitor an ha/dr solution
1.104
Troubleshoot an HA/DR solution
Learning Objectives
- Implement troubleshoot an ha/dr solution
Domain Hands-on Skills
Deploy Azure SQL DatabaseConfigure SQL Managed InstanceSet up networking and firewall rules
Common Mistakes to Avoid
- Incorrect service tier selection
- Missing configuration prerequisites
2
Monitor, configure, and optimize database resources 22%
3
Configure and manage automation of tasks 17%
4