nerdexam
Microsoft

DP-900 · Question #117

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…

The correct answer is D. Azure SQL Database. Azure SQL Database is relational database and a managed service. Incorrect Answers: A, C: Cosmos DB, HDInsight are non-relational databases. B: Azure Synapse Analytics is for data warehousing, not for Online Transaction Processing…

Submitted by ricky.ec· Mar 30, 2026Identify considerations for relational data on Azure

Question

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?

Options

  • AAzure Cosmos DB
  • BAzure Synapse Analytics
  • CAzure HDInsight
  • DAzure SQL Database

How the community answered

(38 responses)
  • A
    3% (1)
  • B
    3% (1)
  • C
    5% (2)
  • D
    89% (34)

Explanation

Azure SQL Database is relational database and a managed service. Incorrect Answers: A, C: Cosmos DB, HDInsight are non-relational databases. B: Azure Synapse Analytics is for data warehousing, not for Online Transaction Processing. https://cloud.netapp.com/blog/azure-cvo-blg-azure-database-review-your-guide-for-database-

Topics

#OLTP#Azure SQL Database#SaaS#relational database selection

Community Discussion

No community discussion yet for this question.

Full DP-900 Practice