DP-300: Azure Database Administrator Associate Exam Guide
The **DP-300** certification validates skills for administering SQL Server relational databases on Azure (SQL Database, Managed Instance).
What is the key difference between Azure SQL DB and SQL Managed Instance (MI)?
Answer : Managed Instance offers near 100% compatibility with on-premises SQL Server (e.g., SQL Agent).
MI is better for lift-and-shift migrations, while SQL DB is fully Cloud Native.
How is local high availability ensured in Azure SQL Database?
Answer : Through built-in service tier architecture.
Premium and Business Critical tiers automatically use AlwaysOn availability groups.
Which tool monitors performance and recommends query optimizations?
Answer : Query Performance Insight.
Analyzes heavy queries and suggests concrete improvements like new indexes.
Which Azure SQL encryption method protects data 'at rest'?
Answer : Transparent Data Encryption (TDE).
Encrypts database files, logs, and backups at the storage layer.
What is a 'Failover Group'?
Answer : A feature for replicating databases to another Azure region for disaster recovery.
Manages group-level failover (automatic or manual) across regions.
Related Certifications