New Year Sale 2026! 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 6 Question 39 Discussion

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

You need to recommend a data store service that meets the following requirements:

Native SQL API access

Configurable indexes

What should you recommend?

Show Suggested Answer Hide Answer
Suggested Answer: D

Azure Cosmos DB comes with native Core (SQL) API support.

In Azure Cosmos DB, data is indexed following indexing policies that are defined for each container. The default indexing policy for newly created containers enforces range indexes for any string or number. This policy can be overridden with your own custom indexing policy.


https://docs.microsoft.com/en-us/azure/cosmos-db/sql/how-to-manage-indexing-policy

by Leslie at May 09, 2022, 11:48 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
Kenny
4 months ago
Wait, can Cosmos DB really handle SQL queries? Sounds too good to be true!
upvoted 0 times
...
Zachary
4 months ago
I think Cosmos DB is the best choice here.
upvoted 0 times
...
Dick
5 months ago
Azure Files? Really? That doesn’t fit the SQL requirement.
upvoted 0 times
...
Myra
5 months ago
Definitely not Azure Table storage, it lacks SQL support.
upvoted 0 times
...
Fausto
5 months ago
I’d go with Azure Cosmos DB for sure.
upvoted 0 times
...
Margart
5 months ago
I’m torn between Azure Cosmos DB and Azure Files. I know Cosmos DB has the SQL API, but I can't recall if Azure Files has any indexing features.
upvoted 0 times
...
Rikki
5 months ago
I remember practicing a question like this, and I think Azure Table storage doesn't really fit the SQL API requirement, so it’s probably not the answer.
upvoted 0 times
...
Donette
5 months ago
I think Azure Cosmos DB might be the right choice since it supports SQL API access and has configurable indexes, but I'm not completely sure.
upvoted 0 times
...
Sharan
5 months ago
I feel like Azure Blob storage is definitely not the answer here, but I can't remember if Azure Cosmos DB is the only one that meets both requirements.
upvoted 0 times
...
Colette
5 months ago
Hmm, I'm a bit confused on the differences between the SNMP versions. I'll have to review that topic again.
upvoted 0 times
...
Merrilee
5 months ago
Okay, let's think this through. We want to decrease round-trip latency, so that rules out option C. And ECMP keying is more about load balancing, so that's probably not the best solution here. I'm leaning towards option A, but I'll double-check the details just to be sure.
upvoted 0 times
...
Thora
5 months ago
This seems like a straightforward question about security features in newer iOS versions. I'll focus on identifying the key security improvements mentioned.
upvoted 0 times
...
Isreal
5 months ago
IKEv2 is definitely the way to go here. It's the latest and most secure VPN protocol, and it's specifically recommended for Azure Site-to-Site VPNs. I'm confident that's the right answer.
upvoted 0 times
...

Save Cancel