Exam: DP-900: Microsoft Azure Data Fundamentals 0 Likes
You are deploying a software as a service (SaaS) application that (DP-900)
You are deploying a software as a service (SaaS) application that requires a relational database for Online Transaction Processing (OLTP).
Which Azure service should you use to support the application?
A. Azure Cosmos DB
B. Azure HDInsight
C. Azure SQL Database
D. Azure Synapse Analytics
Solution
Correct answer: C. Azure SQL Database.
A. Azure Cosmos DB is a NoSQL database service, which is more suitable for handling unstructured data and not optimized for OLTP workloads.
B. Azure HDInsight is a big data analytics service, which is designed for batch processing and not suitable for OLTP applications.
C. Azure SQL Database is a fully managed relational database service that is optimized for OLTP workloads. It provides features like high availability, scalability, and automatic backups, making it a suitable choice for a SaaS application that requires a relational database.
D. Azure Synapse Analytics is a data warehousing service that is designed for analytical workloads (OLAP) and not for OLTP applications.
Therefore, the best choice for the given scenario is Azure SQL Database.
Category: Identify considerations for relational data on Azure