HOTSPOT - You need to output files from Azure Data Factory. Which file format should you use for each type of output? To answer, select the appropriate options in the answer area. NOTE: Each correct selection is worth one point. Hot Area:
Suggested Answer:
Box 1: Parquet - Parquet stores data in columns, while Avro stores data in a row-based format. By their very nature, column-oriented data stores are optimized for read-heavy analytical workloads, while row-based databases are best for write-heavy transactional workloads.
Box 2: Avro - An Avro schema is created using JSON format. AVRO supports timestamps. Note: Azure Data Factory supports the following file formats (not GZip or TXT).
Avro format - ✑ Binary format ✑ Delimited text format ✑ Excel format ✑ JSON format ✑ ORC format ✑ Parquet format ✑ XML format Reference: https://www.datanami.com/2018/05/16/big-data-file-formats-demystified
1: PARQUET
Because Parquet is a columnar file format.
2: AVRO
Because Avro is a row-based file format (as JSON) which is connected to logical timestamp.
1: PARQUET
Because Parquet is a columnar file format.
2: AVRO
Because Avro is a row-based file format (as JSON) which is connected to logical timestamp.
GZIP file format is one of supported Binary format by ADF.
https://docs.microsoft.com/en-us/azure/data-factory/connector-file-system?tabs=data-factory#file-system-as-sink
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Mahesh_mm
Highly Voted 1 year, 11 months agoh4y
Most Recent 1 day, 1 hour agohassexat
3 months agokkk5566
3 months, 2 weeks agorocky48
7 months, 2 weeks agobubby248
10 months, 1 week agovigilante89
12 months agosppdw
1 year, 3 months agoDeeksha1234
1 year, 4 months agoRaza12
1 year, 4 months agoDothy
1 year, 7 months agoRalphLiang
1 year, 9 months agoPallaviPatel
1 year, 10 months agoSkyrocket
1 year, 10 months agoedba
1 year, 11 months agobad_atitude
1 year, 12 months agoalexleonvalencia
2 years ago