ADLS (Azure Data Lake Storage) Gen2 destination writes data depending upon the specified data format and makes a separate file for each partition.From the below given list, choose the format(s) that can't be used by ADLS Gen2 destination? (Select all the applicable options)
Click on the arrows to vote for the correct answer
A. B. C. D. E.Correct Answer: E
The destination can write using all the given data formats like Avro, Delimited, ORC, JSON, Text, Parquet, and XML.
Option A is incorrect.
An Avro file is written by destination for every partition.
Also, Avro schema is included in every file.
Option B is incorrect.
For every partition, a delimited file is written by the destination.
Option C is incorrect.
For every partition, an ORC file is written by the destination.
Option D is incorrect.
For each partition, the destination writes an XML file.
Option E is correct.
The destination can write using all the given data formats (Avro, Delimited, ORC, and XML).
To know various data formats used by ADLS Gen2 and their naming convention, please visit the below-given link:
ADLS Gen2 supports multiple data formats for writing data including Avro, Delimited, ORC, and XML. However, there are some limitations to using certain formats with ADLS Gen2 destination.
Avro is a data serialization system that supports rich data structures and dynamic schema evolution. ADLS Gen2 supports writing data in Avro format, so Option A is not correct.
Delimited data formats like CSV (comma-separated values) and TSV (tab-separated values) are also supported by ADLS Gen2 destination. Therefore, Option B is not correct.
ORC (Optimized Row Columnar) is another columnar storage format that is optimized for Hadoop workloads. ADLS Gen2 destination supports ORC format, so Option C is not correct.
XML is a markup language that is widely used for data exchange. However, ADLS Gen2 does not support writing data in XML format. Therefore, Option D is correct.
To summarize, the correct answer is Option D. ADLS Gen2 destination does not support writing data in XML format. All the other options (A, B, C) are incorrect since ADLS Gen2 supports writing data in Avro, Delimited, and ORC formats.