easy5 pts · first answer countsperformancedata-modeling

Partitioning a big table

An events table has 5 years of data and most queries filter on the last 7 days. What is the main benefit of partitioning it by event date?

A.Queries can skip partitions outside the date filter, scanning far less dataB.It removes duplicate rows automaticallyC.It makes every query return results in sorted orderD.It compresses the data into one single file

← When streaming is needed Row count of a LEFT JOIN →