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).
Reference:
To know various data formats used by ADLS Gen2 and their naming convention, please visit the below-given link:
https://docs.streamsets.com/portal/#transformer/latest/help/transformer/Destinations/ADLS-G2-D.html