Google
PROFESSIONAL-DATA-ENGINEER · Question #143
You launched a new gaming app almost three years ago. You have been uploading log files from the previous day to a separate Google BigQuery table with the table name format LOGS_yyyymmdd. You have bee
The correct answer is B. Convert the sharded tables into a single partitioned table. Explanation/Reference: https://cloud.google.com/bigquery/docs/creating-partitioned-tables#converting_date-sharded_tables_into_ingestion-time_partitioned_tables
Submitted by joshua94· Mar 30, 2026Building and operationalizing data processing systems
Question
You launched a new gaming app almost three years ago. You have been uploading log files from the previous day to a separate Google BigQuery table with the table name format LOGS_yyyymmdd. You have been using table wildcard functions to generate daily and monthly reports for all time ranges. Recently, you discovered that some queries that cover long date ranges are exceeding the limit of 1,000 tables and failing. How can you resolve this issue?
Options
- AConvert all daily log tables into date-partitioned tables
- BConvert the sharded tables into a single partitioned table
- CEnable query caching so you can cache data from previous months
- DCreate separate views to cover each month, and query from these views
How the community answered
(20 responses)- A5% (1)
- B75% (15)
- C5% (1)
- D15% (3)
Explanation
Explanation/Reference: https://cloud.google.com/bigquery/docs/creating-partitioned-tables#converting_date-sharded_tables_into_ingestion-time_partitioned_tables
Topics
#BigQuery#date partitioning#table sharding#wildcard tables
Community Discussion
No community discussion yet for this question.