exam questions

Exam DP-201 All Questions

View all questions & answers for the DP-201 exam

Exam DP-201 topic 22 question 1 discussion

Actual exam question from Microsoft's DP-201
Question #: 1
Topic #: 22
[All DP-201 Questions]

Which Azure service should you recommend for the analytical data store so that the business analysts and data scientists can execute ad hoc queries as quickly as possible?

  • A. Azure Data Lake Storage Gen2
  • B. Azure Cosmos DB
  • C. Azure Stream Analytics
  • D. Azure Synapse Analytics
Show Suggested Answer Hide Answer
Suggested Answer: A 🗳️
There are several differences between a data lake and a data warehouse. Data structure, ideal users, processing methods, and the overall purpose of the data are the key differentiators.

Scenario: Litware employs business analysts who prefer to analyze data by using Microsoft Power BI, and data scientists who prefer analyzing data in Azure
Databricks notebooks.
Note: Azure Synapse Analytics formerly known as Azure SQL Data Warehouse.
Design Azure data storage solutions

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Makar
Highly Voted 4 years, 2 months ago
Azure Synapse Analytics - right answer
upvoted 26 times
...
chirag1234
Highly Voted 4 years, 1 month ago
Azure synapse is the right answer, we can't execute query on ADLS
upvoted 6 times
maciejt
4 years, 1 month ago
you have U-SQL for querying ADLS
upvoted 1 times
...
...
DirectX
Most Recent 4 years, 1 month ago
"Stage inventory data in Azure Data Lake Storage Gen2 before loading the data into the analytical data store". So, I guess that Analytical data store <> ADLS2. I would go for Synapse.
upvoted 5 times
...
davita8
4 years, 1 month ago
D. Azure Synapse Analytics
upvoted 5 times
...
anamaster
4 years, 1 month ago
https://docs.microsoft.com/en-us/azure/architecture/data-guide/technology-choices/analytical-data-stores#what-are-your-options-when-choosing-an-analytical-data-store
upvoted 3 times
...
david112sdsf
4 years, 2 months ago
It is ADLS.
upvoted 3 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
Loading ...