Microsoft Azure Data Fundamentals — Question 55

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?

Answer options

• A. Azure Cosmos DB
• B. Azure HDInsight
• C. Azure SQL Database
• D. Azure Synapse Analytics

Correct answer: C

Explanation

Azure SQL Database is specifically designed for relational database operations, making it the ideal choice for OLTP scenarios. Azure Cosmos DB is a NoSQL database and not optimized for relational data, while Azure HDInsight is focused on big data analytics and Azure Synapse Analytics is more suited for data warehousing rather than transactional processing.