Exam DP-201 topic 1 question 39 discussion

Actual exam question from Microsoft's DP-201

Question #: 39
Topic #: 1

You are planning a solution that combines log data from multiple systems. The log data will be downloaded from an API and stored in a data store.
You plan to keep a copy of the raw data as well as some transformed versions of the data. You expect that there will be at least 2 TB of log files. The data will be used by data scientists and applications.
You need to recommend a solution to store the data in Azure. The solution must minimize costs.
What storage solution should you recommend?

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

Show Suggested Answer

Suggested Answer: A 🗳️
To land the data in Azure storage, you can move it to Azure Blob storage or Azure Data Lake Store Gen2. In either location, the data should be stored in text files.
PolyBase and the COPY statement can load from either location.
Incorrect Answers:
B: Azure Synapse Analytics, uses distributed query processing architecture that takes advantage of the scalability and flexibility of compute and storage resources. Use Azure Synapse Analytics transform and move the data.
Reference:
https://docs.microsoft.com/en-us/azure/synapse-analytics/sql-data-warehouse/design-elt-data-loading

by Ysandee at June 26, 2021, 3:21 a.m.

Comments

Submit Cancel

ArunMonika

3 years, 5 months ago

Given answer is correct

upvoted 1 times

...

Ysandee

3 years, 11 months ago

Agree with the answer provided.

upvoted 3 times

...