MENU
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?
Suggested Answer: A, C, F
Get Premium DP-900 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
37 comments · newest first
TA
Taryn
11 months ago
Azure HDInsight is more for big data, not OLTP.
AN
Anissa
11 months ago
Surprised Azure Synapse isn't the answer here.
MI
Mica
11 months ago
No way, it's Azure SQL Database all the way!
VI
Virgie
12 months ago
I thought Azure Cosmos DB could handle that too?
JO
Josephine
12 months ago
Definitely Azure SQL Database for OLTP!
PH
Phil
1 year ago
I feel like Azure SQL Database is the go-to option for this kind of application, especially for transaction-heavy scenarios.
CH
Chu
1 year 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.
AR
Arletta
1 year 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.
VI
Viki
1 year 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.
NO
Nobuko
1 year 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.
LU
Luisa
1 year 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.
TA
Tamra
1 year 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.
EU
Eun
1 year 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.
BR
Brendan
1 year 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.
GE
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!
JE
Jess
1 year ago
Azure Synapse Analytics might be a bit overkill for an OLTP application, don't you think?
MA
Malcolm
1 year ago
I think Azure Cosmos DB could also be a good option for supporting the application.
LI
Lindsey
1 year ago
I agree, Azure SQL Database is the perfect choice for OLTP applications.
LY
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.
LA
Lai
1 year ago
Azure Synapse Analytics is for big data analytics, not OLTP.
LE
Leontine
1 year ago
Azure Cosmos DB is more suited for NoSQL workloads, not relational databases.
IE
Iesha
1 year ago
I agree, Azure SQL Database is the best choice for OLTP applications.
DE
Delisa
2 years 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.
JA
Jackie
1 year ago
I've used Azure SQL Database for OLTP before, it's a reliable choice for supporting the application.
BE
Beckie
1 year ago
Azure SQL Database is designed for OLTP workloads, so it's the most suitable option for the SaaS application.
VO
Von
1 year ago
I agree, Azure Synapse Analytics is not the best choice for OLTP. Azure SQL Database is the way to go.
RE
Regenia
2 years 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.
AL
Alison
1 year ago
Yes, Azure SQL Database is the right fit for an OLTP application.
VI
Vinnie
1 year ago
D) Azure SQL Database
EL
Elin
1 year ago
No, Azure Cosmos DB is a NoSQL database.
CI
Ciara
1 year ago
A) Azure Cosmos DB
KA
Kayleigh
1 year ago
User 2: We should use Azure SQL Database for OLTP applications.
AN
Anglea
2 years ago
User 1: You're right, Azure Cosmos DB is a NoSQL database.
AL
Aleta
2 years ago
Azure SQL Database seems like the obvious choice here. It's a fully managed relational database service, perfect for OLTP workloads.
RY
Ryan
2 years ago
I'm not sure, but Azure Cosmos DB also supports OLTP. Maybe we should consider that too.
VA
Valda
2 years ago
I agree with Marlon, Azure SQL Database is designed for OLTP workloads.
MA
Marlon
2 years ago
I think we should use Azure SQL Database for OLTP.