You Launched a New Gaming App Almost Three Years Ago

question 60

Multiple Choice

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?

• 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

---

Definitions:

Means-End Analysis

A problem-solving method that involves identifying the difference between the current state and the goal state, then creating and taking steps to reduce the difference.

Current State

The existing condition or situation of a system, organization, or individual at a particular time.

Eventual Goal

The ultimate aim or objective that is intended to be achieved in the long term, following the completion of all interim steps or phases.

Mixed Numeral

A number made up of a whole number and a fraction, such as 3 1/2.