Answer-first summary for fast verification
Answer: Create an ingestion-time partitioned table with daily partitioning type.
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.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
No comments yet.
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.
A
Create an ingestion-time partitioned table with daily partitioning type.
B
Create an ingestion-time partitioned table with yearly partitioning type.
C
Create an integer-range partitioned table
D
Create a time-unit column-partitioned table with yearly partitioning type.