Discover the two file types that support query acceleration in Azure Data Lake Storage Gen2. Optimize your data queries with the right file format.
Table of Contents
Question
You have an Azure Data Lake Storage Gen2 account named storage1.
You plan to implement query acceleration for storage1.
Which two file types support query acceleration? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.
A. JSON
B. Apache Parquet
C. XML
D. CSV
E. Avro
Answer
B. Apache Parquet
E. Avro
Explanation
Query acceleration in Azure Data Lake Storage Gen2 is supported by the following two file types:
B. Apache Parquet
E. Avro
Apache Parquet is a columnar storage format that provides efficient compression and encoding schemes. It is designed for fast query performance and is well-suited for query acceleration in Azure Data Lake Storage Gen2.
Avro is a row-based storage format that uses JSON for defining data types and protocols. It also supports schema evolution, making it flexible for query acceleration scenarios.
JSON, XML, and CSV file types do not natively support query acceleration in Azure Data Lake Storage Gen2.
Data Engineering on Microsoft Azure DP-203 certification exam practice question and answer (Q&A) dump with detail explanation and reference available free, helpful to pass the Data Engineering on Microsoft Azure DP-203 exam and earn Data Engineering on Microsoft Azure DP-203 certification.