Ultimate access to all questions.
A data engineer is tasked with creating a Delta Lake table to store user activities from a website. The schema includes: user_id LONG
, page STRING
, activity_type LONG
, ip_address STRING
, activity_time TIMESTAMP
, and activity_date DATE
. Which column would be the most suitable for partitioning the Delta Table?