Question 65 of 307
Single answerYou 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?
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
✓
Correct Answer: B
Convert the sharded tables into a single partitioned table
▥
Explanation
The correct answer is highlighted above. Review the wording carefully, then use the next question to continue building your understanding of Google certification topics.