Microsoft Exam DP-900 Topic 5 Question 93 Discussion

Actual exam question for Microsoft's DP-900 exam

Question #: 93
Topic #: 5

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?

AAzure Cosmos DB

BAzure Synapse Analytics

CAzure HDInsight

DAzure SQL Database

Show Suggested Answer

Suggested Answer: A, C, F

by Ligia at Sep 14, 2024, 11:20 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

2 days ago

Azure Synapse Analytics is more of a data warehousing and analytics service, not really suitable for OLTP. I'd go with Azure SQL Database.

upvoted 0 times

...

13 days ago

Hmm, I'm not sure about Azure Cosmos DB. Isn't that a NoSQL database? I don't think that's the right fit for an OLTP application.

upvoted 0 times

...

17 days ago

Azure SQL Database seems like the obvious choice here. It's a fully managed relational database service, perfect for OLTP workloads.

upvoted 0 times

...

23 days ago

I'm not sure, but Azure Cosmos DB also supports OLTP. Maybe we should consider that too.

upvoted 0 times

...

25 days ago

I agree with Marlon, Azure SQL Database is designed for OLTP workloads.

upvoted 0 times

...

26 days ago

I think we should use Azure SQL Database for OLTP.

upvoted 0 times

...