Microsoft Certified Azure Data Engineer Associate · Free Practice Question Easy
Question 35
Which technology is typically used as a staging area in a modern data warehousing architecture?
-
A
Azure Synapse SQL Lakes
-
B
Azure Data Lake
-
C
Azure Synapse Spark Pools
-
D
Azure Synapse Spark Lakes
-
E
Azure Synapse SQL Pools
-
F
Azure Data Pools
Reveal correct answer
Correct answer: B
Explanation
Azure Data Lake Store Gen 2 is the technology that will be used to stage data before loading it into the various components of Azure Synapse Analytics.
Azure Data Lake Storage Gen2 is a set of capabilities dedicated to big data analytics, built on Azure Blob storage.
Data Lake Storage Gen2 converges the capabilities of Azure Data Lake Storage Gen1 with Azure Blob storage. For example, Data Lake Storage Gen2 provides file system semantics, file-level security, and scale. Because these capabilities are built on Blob storage, you'll also get low-cost, tiered storage, with high availability/disaster recovery capabilities.
A. Azure Synapse SQL Lakes do not exist as a specific Azure service. Therefore, they are not typically used as a staging area in a modern data warehousing architecture.
B. Azure Data Lake is typically used as a staging area in a modern data warehousing architecture due to its ability to store large amounts of structured and unstructured data in its native format. It provides a cost-effective solution for data storage and processing before loading it into a data warehouse.
C. Azure Synapse Spark Pools are used for big data processing and analytics, not as a staging area in a data warehousing architecture. They are more focused on running Apache Spark jobs for data processing and analysis.
D. Azure Synapse Spark Lakes do not exist as a specific Azure service. Therefore, they are not typically used as a staging area in a modern data warehousing architecture.
E. Azure Synapse SQL Pools are primarily used for data warehousing and analytics, not as a staging area. While they can store and query large datasets, they are not specifically designed for temporary data storage before loading into a data warehouse.
F. Azure Data Pools do not exist as a specific Azure service. Therefore, they are not typically used as a staging area in a modern data warehousing architecture.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
