DP-300 · Question #445
Hotspot Question You have the projects shown in the following table. You need to recommend an Azure database solution for each project. The solution must meet the following requirements: - Project2…
The correct answer is For Project1, the recommended Azure database solution is Azure Cosmos DB. = Yes; For Project2, the recommended Azure database solution is Azure SQL Managed Instance. = Yes; For Project3, the recommended Azure database solution is SQL Server on Azure VM. = Yes. Azure Cosmos DB is the correct choice for Project1 as it is a fully managed NoSQL database service ideal for globally distributed, multi-model workloads with minimal administrative overhead. Azure SQL Managed Instance is correct for Project2 because it is a PaaS offering where…
Question
Exhibits
Answer Area
- For Project1, the recommended Azure database solution is Azure Cosmos DB.Yes
- For Project2, the recommended Azure database solution is Azure SQL Managed Instance.Yes
- For Project3, the recommended Azure database solution is SQL Server on Azure VM.Yes
Explanation
Azure Cosmos DB is the correct choice for Project1 as it is a fully managed NoSQL database service ideal for globally distributed, multi-model workloads with minimal administrative overhead. Azure SQL Managed Instance is correct for Project2 because it is a PaaS offering where Microsoft manages the underlying OS, eliminating exposure to OS-level malware threats while still providing near-complete SQL Server compatibility - unlike SQL Server on Azure VM where the customer manages the OS. SQL Server on Azure VM is appropriate for Project3 when full OS-level control or specific configurations are required that cannot be met by PaaS options, though it requires more administrative effort.
Topics
Community Discussion
No community discussion yet for this question.