Google Professional Data Engineer
Get started today
Ultimate access to all questions.
Ultimate access to all questions.
You are ingesting data that is spread out over a wide range of dates into BigQuery at a fast rate. You need to partition the table to make queries performant.
Explanation:
Feedback: A. Correct. A daily partition type is the most suitable given the volume of the data and the range of dates. B. Incorrect. A yearly partition type has too much data per partition, which makes queries inefficient. C. Incorrect. An integer-range partition type is not appropriate given that the data is defined by dates. D. Incorrect. A yearly partition type has too much data per partition, which makes queries inefficient.