nerdexam
MicrosoftMicrosoft

DP-300 · Question #445

DP-300 Question #445: Real Exam Question with Answer & 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 Mi

Submitted by ricky.ec· Mar 6, 2026Design Data Storage Solutions - Recommend appropriate Azure database services based on workload requirements, security constraints, and administrative overhead considerations (AZ-305 / Azure Solutions Architect)

Question

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 must minimize malware threats to the underlying operating system that hosts the migrated database. - Administrative effort must be minimized where possible. What should you recommend using for each project? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Answer:

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

#Azure SQL Managed Instance#Azure Cosmos DB#SQL Server on Azure VM#PaaS vs IaaS

Community Discussion

No community discussion yet for this question.

Full DP-300 PracticeBrowse All DP-300 Questions