ExpertEasy1 markMultiple Choice
AZ-900 · Question 21 · Domain 2.6: Azure Database and Analytics Services
A company wants to migrate their on-premises Microsoft SQL Server database to Azure without managing the underlying operating system or database software updates. Which service should they choose?
A company wants to migrate their on-premises Microsoft SQL Server database to Azure without managing the underlying operating system or database software updates. Which service should they choose?
Answer options:
A.
SQL Server on Azure Virtual Machines
B.
Azure Cosmos DB
C.
Azure SQL Database
D.
Azure Table Storage
How to approach this question
Look for the managed PaaS version of SQL Server.
Full Answer
C.Azure SQL Database✓ Correct
Azure SQL Database
Azure SQL Database is a fully managed platform as a service (PaaS) database engine that handles most of the database management functions such as upgrading, patching, backups, and monitoring without user involvement.
Common mistakes
Choosing SQL Server on VMs, which requires OS management.
Practice the full Azure Fundamentals AZ-900 Practice Exam 6
60 questions · hints · full answers · grading
More questions from this exam
Q01What is the best definition of cloud computing?EasyQ02According to the shared responsibility model, which of the following is ALWAYS the responsibility...EasyQ03Which cloud benefit ensures that an application remains accessible and operational even if a loca...EasyQ04A company wants to move away from purchasing physical servers and instead pay monthly for the com...EasyQ05Which cloud service model provides the highest level of control and flexibility over the operatin...Easy