PROFESSIONAL-DATA-ENGINEER · Question #143
PROFESSIONAL-DATA-ENGINEER Question #143: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #143. The question stem and answer options stay visible for context.
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
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.