Answer-first summary for fast verification
Answer: Create a storage policy that is scoped to a container prefix filter., Register the query acceleration feature.
To enable workloads to use filter predicates and column projections for filtering data at read time in Azure Data Lake Storage Gen2, the following two actions are required: **E. Register the query acceleration feature** - This is the foundational step as query acceleration is the Azure Data Lake Storage Gen2 feature that enables predicate pushdown and column projection capabilities. Query acceleration allows filtering and projection operations to occur at the storage layer rather than transferring all data to the compute layer, significantly improving performance by reducing data transfer and processing overhead. **D. Create a storage policy that is scoped to a container prefix filter** - After enabling query acceleration, storage policies with prefix filters allow you to specify which files and directories within a container should be eligible for query acceleration optimization. This granular control ensures that only relevant data subsets benefit from the performance optimizations, making the solution more efficient and cost-effective. **Why other options are not suitable:** - **A. Reregister the Azure Storage resource provider** - This is an administrative task for subscription management issues and has no bearing on enabling specific data filtering capabilities within Data Lake Storage. - **B. Create a storage policy that is scoped to a container** - While container-scoped policies exist, they don't provide the granular control needed for optimizing specific data subsets with query acceleration features. - **C. Reregister the Microsoft Data Lake Store resource provider** - Similar to option A, this addresses subscription-level administrative issues rather than enabling specific data processing features within the storage service. The combination of registering query acceleration and implementing prefix-filtered storage policies provides the complete solution for enabling efficient data filtering at read time in Azure Data Lake Storage Gen2.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
You use Azure Data Lake Storage Gen2. You need to ensure that workloads can use filter predicates and column projections to filter data at the time it is read from disk. Which two actions should you perform? Each correct answer presents part of the solution. NOTE: Each correct selection is worth one point.
A
Reregister the Azure Storage resource provider.
B
Create a storage policy that is scoped to a container.
C
Reregister the Microsoft Data Lake Store resource provider.
D
Create a storage policy that is scoped to a container prefix filter.
E
Register the query acceleration feature.
No comments yet.