MENU
You need to recommend a data store service that meets the following requirements:
Native SQL API access
Configurable indexes
What should you recommend?
Suggested Answer: D
Get Premium DP-900 Questions
as Interactive Web-Based Practice Test or PDF
Real Exam Format
Detailed Explanations
Instant Access
Get Your Practice Test
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
13 comments · newest first
KE
Kenny
12 months ago
Wait, can Cosmos DB really handle SQL queries? Sounds too good to be true!
ZA
Zachary
1 year ago
I think Cosmos DB is the best choice here.
DI
Dick
1 year ago
Azure Files? Really? That doesn’t fit the SQL requirement.
MY
Myra
1 year ago
Definitely not Azure Table storage, it lacks SQL support.
FA
Fausto
1 year ago
I’d go with Azure Cosmos DB for sure.
MA
Margart
1 year 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.
RI
Rikki
1 year 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.
DO
Donette
1 year 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.
SH
Sharan
1 year 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.
CO
Colette
1 year ago
Hmm, I'm a bit confused on the differences between the SNMP versions. I'll have to review that topic again.
ME
Merrilee
1 year 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.
TH
Thora
1 year ago
This seems like a straightforward question about security features in newer iOS versions. I'll focus on identifying the key security improvements mentioned.
IS
Isreal
1 year 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.