Exam DP-201 topic 1 question 41 discussion

Actual exam question from Microsoft's DP-201

Question #: 41
Topic #: 1

You are designing a storage solution for streaming data that is processed by Azure Databricks. The solution must meet the following requirements:
✑ The data schema must be fluid.
✑ The source data must have a high throughput.
✑ The data must be available in multiple Azure regions as quickly as possible.
What should you include in the solution to meet the requirements?

A. Azure Cosmos DB
B. Azure Synapse Analytics
C. Azure SQL Database
D. Azure Data Lake Storage

Show Suggested Answer

Suggested Answer: A 🗳️
Azure Cosmos DB is Microsoft's globally distributed, multi-model database. Azure Cosmos DB enables you to elastically and independently scale throughput and storage across any number of Azure's geographic regions. It offers throughput, latency, availability, and consistency guarantees with comprehensive service level agreements (SLAs).
You can read data from and write data to Azure Cosmos DB using Databricks.
Note on fluid schema:
If you are managing data whose structures are constantly changing at a high rate, particularly if transactions can come from external sources where it is difficult to enforce conformity across the database, you may want to consider a more schema-agnostic approach using a managed NoSQL database service like Azure
Cosmos DB.
Reference:
https://docs.databricks.com/data/data-sources/azure/cosmosdb-connector.html https://docs.microsoft.com/en-us/azure/cosmos-db/relational-nosql

by sjain91 at May 1, 2021, 12:51 p.m.

Comments

Submit Cancel

davem0193

3 years, 12 months ago

I guess anywhere a question says 'multi region', the answer has to be cosmosdb :)

upvoted 2 times

...

sjain91

4 years, 1 month ago

Cosmos DB 100%

upvoted 4 times

...