Exam DP-201 topic 1 question 40 discussion

Actual exam question from Microsoft's DP-201

Question #: 40
Topic #: 1

You are designing a serving layer for data. The design must meet the following requirements:
✑ Authenticate users by using Azure Active Directory (Azure AD).
✑ Serve as a hot path for data.
✑ Support query scale out.
✑ Support SQL queries.
What should you include in the design?

A. Azure Data Lake Storage
B. Azure Cosmos DB
C. Azure Blob storage
D. Azure Synapse Analytics

Show Suggested Answer

Suggested Answer: B 🗳️
Do you need serving storage that can serve as a hot path for your data? If yes, narrow your options to those that are optimized for a speed serving layer. This would be Cosmos DB among the options given in this question.
Note: Analytical data stores that support querying of both hot-path and cold-path data are collectively referred to as the serving layer, or data serving storage.
There are several options for data serving storage in Azure, depending on your needs:
✑ Azure Synapse Analytics
✑ Azure Cosmos DB
✑ Azure Data Explorer

Azure SQL Database -

✑ SQL Server in Azure VM
✑ HBase/Phoenix on HDInsight
✑ Hive LLAP on HDInsight
✑ Azure Analysis Services
Incorrect Answers:
A, C: Azure Data Lake Storage & Azure Blob storage are not data serving storage in Azure.
Reference:
https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/analytical-data-stores

by Geo_Barros at March 15, 2021, 11:29 a.m.

Comments

Submit Cancel

suman13

Highly Voted 4 years, 2 months ago

scaleout+hotspot = cosmosdb hotspot = azuresqldb scaleout = azure synapse

upvoted 19 times

...

tamil1006

Most Recent 4 years ago

Cosmos db is correct one because ( speed servicing not possible in azure Synapse)https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/analytical-data-stores

upvoted 1 times

tamil1006

4 years ago

Do you need serving storage that can serve as a hot path for your data? If yes, narrow your options to those that are optimized for a speed serving layer --> in this way speed serving layer supports by cosmos db and not by synapse

upvoted 1 times

...

Geo_Barros

4 years, 2 months ago

I think that Azure Synapse Analytics could also be an answer for this question.

upvoted 2 times

szpinat

4 years, 2 months ago

Synapse is note optimized for speed serving layer.

upvoted 11 times

cadio30

4 years ago

Agree on this

upvoted 1 times

...