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

Local Testing

Careers

preload
preload
preload
preload
preload
preload