Deal of The Day! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25
Welcome to Pass4Success

- Free Preparation Discussions
Mail Us support@pass4success.com
Location US
Mob_nav_barsMENU

Microsoft DP-900 Exam - Topic 5 Question 93 Discussion

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 and C) Azure HDInsight
B) Azure Synapse Analytics
D) Azure SQL Database

Microsoft DP-900 Exam - Topic 5 Question 93 Discussion

Actual exam question for Microsoft's DP-900 exam
Question #: 93
Topic #: 5
[All DP-900 Questions]

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?

Show Suggested Answer Hide Answer
Suggested Answer: A, C, F

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

Limited Time Offer

25%

Off

Get Premium DP-900 Questions as Interactive Web-Based Practice Test or PDF

Contribute your Thoughts:

0/2000 characters
Submit Cancel
Taryn
8 months ago
Azure HDInsight is more for big data, not OLTP.
upvoted 0 times
...
Anissa
8 months ago
Surprised Azure Synapse isn't the answer here.
upvoted 0 times
...
Mica
8 months ago
No way, it's Azure SQL Database all the way!
upvoted 0 times
...
Virgie
9 months ago
I thought Azure Cosmos DB could handle that too?
upvoted 0 times
...
Josephine
9 months ago
Definitely Azure SQL Database for OLTP!
upvoted 0 times
...
Phil
9 months ago
I feel like Azure SQL Database is the go-to option for this kind of application, especially for transaction-heavy scenarios.
upvoted 0 times
...
Chu
9 months ago
I’m a bit confused about Azure Synapse Analytics; I know it’s for analytics but not sure if it can handle OLTP workloads effectively.
upvoted 0 times
...
Arletta
9 months ago
I remember practicing a similar question, and I think Azure Cosmos DB is more for NoSQL scenarios, so it probably wouldn’t fit here.
upvoted 0 times
...
Viki
10 months ago
I think Azure SQL Database is the right choice for OLTP since it’s designed for relational data and transactions, but I’m not completely sure.
upvoted 0 times
...
Nobuko
10 months ago
I think Azure SQL Database is the correct answer. The question specifically calls for a relational database for OLTP, and SQL Database is Azure's fully-managed relational database service, which seems like the best fit.
upvoted 0 times
...
Luisa
10 months ago
Azure Synapse Analytics and HDInsight are more for big data and analytics, so I don't think those are the right choices here. I'm leaning towards Azure SQL Database, but I'll need to double-check the differences between the database services to be sure.
upvoted 0 times
...
Tamra
10 months ago
Hmm, I'm a bit unsure about this one. The question mentions a SaaS application, so I'm wondering if Cosmos DB might be a better fit since it's a NoSQL database. But the OLTP requirement makes me think SQL Database is the way to go.
upvoted 0 times
...
Eun
10 months ago
This looks like a straightforward question about Azure database services. I think Azure SQL Database is the best choice here since the question specifically mentions a relational database for OLTP.
upvoted 0 times
...
Brendan
10 months ago
Okay, let me think this through step-by-step. The question says the table is partitioned by (p1 string, p2 string), so I need to include those partition columns in the upload command. I'm pretty sure option B is the correct syntax, but I'll double-check the other options just to be sure.
upvoted 0 times
...
Gearldine
1 year ago
Azure SQL Database is the database service I'd use to support an OLTP application. It's like the Goldilocks of Azure databases - not too big, not too small, just right!
upvoted 0 times
Jess
1 year ago
Azure Synapse Analytics might be a bit overkill for an OLTP application, don't you think?
upvoted 0 times
...
Malcolm
1 year ago
I think Azure Cosmos DB could also be a good option for supporting the application.
upvoted 0 times
...
Lindsey
1 year ago
I agree, Azure SQL Database is the perfect choice for OLTP applications.
upvoted 0 times
...
...
Lynda
1 year ago
Azure HDInsight is for big data and Apache Hadoop workloads. That's completely overkill for a simple OLTP application. Azure SQL Database is the way to go.
upvoted 0 times
Lai
1 year ago
Azure Synapse Analytics is for big data analytics, not OLTP.
upvoted 0 times
...
Leontine
1 year ago
Azure Cosmos DB is more suited for NoSQL workloads, not relational databases.
upvoted 0 times
...
Iesha
1 year ago
I agree, Azure SQL Database is the best choice for OLTP applications.
upvoted 0 times
...
...
Delisa
1 year 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
Jackie
1 year ago
I've used Azure SQL Database for OLTP before, it's a reliable choice for supporting the application.
upvoted 0 times
...
Beckie
1 year ago
Azure SQL Database is designed for OLTP workloads, so it's the most suitable option for the SaaS application.
upvoted 0 times
...
Von
1 year ago
I agree, Azure Synapse Analytics is not the best choice for OLTP. Azure SQL Database is the way to go.
upvoted 0 times
...
...
Regenia
1 year 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
Alison
1 year ago
Yes, Azure SQL Database is the right fit for an OLTP application.
upvoted 0 times
...
Vinnie
1 year ago
D) Azure SQL Database
upvoted 0 times
...
Elin
1 year ago
No, Azure Cosmos DB is a NoSQL database.
upvoted 0 times
...
Ciara
1 year ago
A) Azure Cosmos DB
upvoted 0 times
...
Kayleigh
1 year ago
User 2: We should use Azure SQL Database for OLTP applications.
upvoted 0 times
...
Anglea
1 year ago
User 1: You're right, Azure Cosmos DB is a NoSQL database.
upvoted 0 times
...
...
Aleta
1 year 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
...
Ryan
1 year ago
I'm not sure, but Azure Cosmos DB also supports OLTP. Maybe we should consider that too.
upvoted 0 times
...
Valda
1 year ago
I agree with Marlon, Azure SQL Database is designed for OLTP workloads.
upvoted 0 times
...
Marlon
1 year ago
I think we should use Azure SQL Database for OLTP.
upvoted 0 times
...

Save Cancel