🔥 3-day streak
Microsoft Azure Data Fundamentals93 / 150
Question 93 of 150

A data engineering team stores billions of rows of sales history in a data lake. Analysts primarily run queries that aggregate a small number of columns (such as SUM of revenue by region) across the entire dataset, rarely retrieving full rows. The team wants to minimize the amount of data scanned per query to reduce cost and improve performance. Which file format characteristic best supports this requirement?

Reviewed for accuracy · Report an issueNext question