Microsoft Azure Data Engineer Associate - DP-203
Get started today
Ultimate access to all questions.
Comments
Loading comments...
Ultimate access to all questions.
In the context of a large-scale data warehousing project using Azure Synapse Analytics, you are tasked with implementing a partition strategy for optimizing query performance. Describe the steps you would take to implement a partition strategy for files in Azure Data Lake Storage Gen2, and explain how this would benefit analytical workloads.
A
Create a partition key based on the file size and use it to distribute the data across multiple storage containers.
B
Implement a partition strategy by creating a partition key based on the date and time of data ingestion, allowing for efficient querying of data within specific time ranges.
C
Use a hash-based partitioning method to distribute the data evenly across multiple partitions without considering the data's characteristics.
D
Do not implement any partition strategy, as it is not necessary for optimizing query performance in Azure Synapse Analytics.