Google Cloud Professional Data Engineer — Question 83

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?

Answer options

• A. Convert all daily log tables into date-partitioned tables
• B. Convert the sharded tables into a single partitioned table
• C. Enable query caching so you can cache data from previous months
• D. Create separate views to cover each month, and query from these views

Correct answer: B

Explanation

The correct answer is B because consolidating the sharded tables into a single partitioned table allows for efficient querying without hitting the 1,000 table limit. Option A, while helpful, does not solve the immediate problem of table limits. Option C does not address the underlying issue of too many tables, and option D would complicate the query process without resolving the limitation.