Question 60
A data architect recommends this approach: Choose a column-oriented analytical file format such as Parquet. Which situation most clearly calls for that approach?
Explanation
Correct Answer
This situation calls for Parquet columnar file. Columnar storage can reduce unnecessary column reads in analytical scans.
Incorrect Answers
The other situation is better matched to Classify the JSON payloads as semi-structured data rather than a fixed table. Keys provide organization while records may have different optional attributes.
The other situation is better matched to Identify CSV as a delimited tabular file format. Each line corresponds to a record with positions defined by the header and delimiter.
The other situation is better matched to Model the measurements as structured time-series records with timestamps. Readings can be filtered and aggregated by device and time interval.