Administering Microsoft Azure SQL Solutions
Practice questions and flashcards for the DP-300: Administering Microsoft Azure SQL Solutions exam. Covers planning and implementing data platform resources (Azure SQL DB, MI, VMs), security (TDE, Always Encrypted, auditing), monitoring and optimization (Query Store, DMVs, IQP), automation (SQL Agent, ARM/Bicep), and HA/DR (geo-replication, availability groups, failover).
A company needs to copy a production Azure SQL Managed Instance to a development environment daily. The development instance is in the same region. Which automated approach is most efficient?
| Domain | Weight | Items | Coverage |
|---|---|---|---|
Plan and implement data platform resources | 18% | 90 items | |
Implement a secure environment | 23% | 90 items | |
Monitor, configure, and optimize database resources | 23% | 90 items | |
Configure and manage automation of tasks | 18% | 85 items | |
Plan and configure a high availability and disaster recovery environment | 23% | 90 items |
Invest in your career with this comprehensive study pack