Microsoft DP-900 Exam - Topic 2 Question 12 Discussion

Actual exam question for Microsoft's DP-900 exam

Question #: 12
Topic #: 2

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 D3

BAzure Synapse Analytics

CAzure HCMmtghi

DAzure SQL Database

Show Suggested Answer

Suggested Answer: D

Azure SQL Database is relational database and a managed service.

https://cloud.netapp.com/blog/azure-cvo-blg-azure-database-review-your-guide-for-database-assessment

by Maile at May 09, 2022, 06:27 PM

Limited Time Offer

25%

Off

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

Contribute your Thoughts:

Submit Cancel

Noah

4 months ago

Wait, is Azure HCMmtghi even a real service?

upvoted 0 times

...

Jennifer

4 months ago

100% agree, SQL Database is the way to go!

upvoted 0 times

...

Page

4 months ago

Azure Synapse is more for analytics, not OLTP.

upvoted 0 times

...

Marlon

5 months ago

I thought Azure Cosmos DB was better for transactions?

upvoted 0 times

...

Rosendo

5 months ago

Definitely Azure SQL Database for OLTP!

upvoted 0 times

...

Bettyann

5 months ago

I'm leaning towards Azure SQL Database, but I wish I had reviewed the differences between all these services more thoroughly.

upvoted 0 times

...

Leanna

5 months ago

I feel like Azure Cosmos DB is more for NoSQL scenarios, so it might not be the right choice here.

upvoted 0 times

...

Burma

5 months ago

I remember practicing a question about Azure services, and I think Azure Synapse Analytics was more for data warehousing, not OLTP.

upvoted 0 times

...

Mabel

5 months ago

I think we discussed Azure SQL Database for OLTP in class, but I'm not completely sure if it's the only option.

upvoted 0 times

...

Arlene

5 months ago

I'm a little confused by the different port modes mentioned in the options. I'll need to double-check my understanding of trunk, dynamic auto, and dynamic desirable configurations.

upvoted 0 times

...

Providencia

5 months ago

Setting the virtual machine restart priority could be a good solution, but I'll need to understand how that interacts with the HA configuration.

upvoted 0 times

...

Audry

5 months ago

Ah, I think I've got it - the 'top' command should give me that real-time process view I need. I'm pretty confident that's the right answer.

upvoted 0 times

...

Anika

5 months ago

I've worked with Cisco ISE before, so I think I've got a good handle on this. The platform configuration and monitoring REST APIs are definitely the two correct options here.

upvoted 0 times

...

Clarinda

5 months ago

Hmm, I'm not sure about that. I was thinking the ability to store data in a distributed repository might be more important, since that allows for scalability and redundancy.

upvoted 0 times

...