Exam: DP-900: Microsoft Azure Data Fundamentals 0 Likes
Your company needs to implement a relational database in Azure. The... (DP-900)
Your company needs to implement a relational database in Azure. The solution must minimize ongoing maintenance.
Which Azure service should you use?
A. Azure HDInsight
B. Azure SQL Database
C. Azure Cosmos DB
D. SQL Server on Azure Virtual Machines
Solution
Correct answer: B. Azure SQL Database.
Here's why:
Fully managed: Azure SQL Database is a fully managed service, meaning Microsoft handles most of the administrative tasks like patching, backups, and performance tuning.
High availability: It offers built-in high availability and disaster recovery features, ensuring your data is always accessible.
Scalability: You can easily scale your database up or down to meet changing needs.
Cost-effective: It provides a pay-as-you-go pricing model and offers various performance tiers to suit different budgets.
While Azure HDInsight, Azure Cosmos DB, and SQL Server on Azure Virtual Machines can also be used for relational databases, they require more ongoing management and maintenance compared to Azure SQL Database.
Category: Identify considerations for relational data on Azure