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

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
4 months ago
Azure HDInsight is more for big data, not OLTP.
upvoted 0 times
...
Anissa
4 months ago
Surprised Azure Synapse isn't the answer here.
upvoted 0 times
...
Mica
4 months ago
No way, it's Azure SQL Database all the way!
upvoted 0 times
...
Virgie
4 months ago
I thought Azure Cosmos DB could handle that too?
upvoted 0 times
...
Josephine
5 months ago
Definitely Azure SQL Database for OLTP!
upvoted 0 times
...
Phil
5 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
5 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
5 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
5 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
5 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
5 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
5 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
6 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
6 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
10 months 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
9 months ago
Azure Synapse Analytics might be a bit overkill for an OLTP application, don't you think?
upvoted 0 times
...
Malcolm
9 months ago
I think Azure Cosmos DB could also be a good option for supporting the application.
upvoted 0 times
...
Lindsey
10 months ago
I agree, Azure SQL Database is the perfect choice for OLTP applications.
upvoted 0 times
...
...
Lynda
10 months 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
9 months ago
Azure Synapse Analytics is for big data analytics, not OLTP.
upvoted 0 times
...
Leontine
9 months ago
Azure Cosmos DB is more suited for NoSQL workloads, not relational databases.
upvoted 0 times
...
Iesha
10 months ago
I agree, Azure SQL Database is the best choice for OLTP applications.
upvoted 0 times
...
...
Delisa
11 months 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
10 months ago
I've used Azure SQL Database for OLTP before, it's a reliable choice for supporting the application.
upvoted 0 times
...
Beckie
10 months ago
Azure SQL Database is designed for OLTP workloads, so it's the most suitable option for the SaaS application.
upvoted 0 times
...
Von
10 months 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
11 months 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
9 months ago
Yes, Azure SQL Database is the right fit for an OLTP application.
upvoted 0 times
...
Vinnie
10 months ago
D) Azure SQL Database
upvoted 0 times
...
Elin
10 months ago
No, Azure Cosmos DB is a NoSQL database.
upvoted 0 times
...
Ciara
10 months ago
A) Azure Cosmos DB
upvoted 0 times
...
Kayleigh
11 months ago
User 2: We should use Azure SQL Database for OLTP applications.
upvoted 0 times
...
Anglea
11 months ago
User 1: You're right, Azure Cosmos DB is a NoSQL database.
upvoted 0 times
...
...
Aleta
11 months 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
11 months ago
I'm not sure, but Azure Cosmos DB also supports OLTP. Maybe we should consider that too.
upvoted 0 times
...
Valda
12 months ago
I agree with Marlon, Azure SQL Database is designed for OLTP workloads.
upvoted 0 times
...
Marlon
12 months ago
I think we should use Azure SQL Database for OLTP.
upvoted 0 times
...

Save Cancel