DP-203 · Question #100
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 the data is read from disk. Which two actions…
The correct answer is D. Register the query acceleration feature. E. Create a storage policy that is scoped to a container prefix filter. To filter data at the time it is read from disk, you need to use the query acceleration feature of Azure Data Lake Storage Gen2. To enable this feature, you need to register the query acceleration feature in your Azure subscription. In addition, you can use storage policies…
Question
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 the data 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.
Options
- AReregister the Microsoft Data Lake Store resource provider.
- BReregister the Azure Storage resource provider.
- CCreate a storage policy that is scoped to a container.
- DRegister the query acceleration feature.
- ECreate a storage policy that is scoped to a container prefix filter.
How the community answered
(50 responses)- A16% (8)
- B6% (3)
- C4% (2)
- D74% (37)
Explanation
To filter data at the time it is read from disk, you need to use the query acceleration feature of Azure Data Lake Storage Gen2. To enable this feature, you need to register the query acceleration feature in your Azure subscription. In addition, you can use storage policies scoped to a container prefix filter to specify which files and directories in a container should be eligible for query acceleration. This can be used to optimize the performance of the queries by only considering a subset of the data in the container.
Topics
Community Discussion
No community discussion yet for this question.