Ultimate access to all questions.
Upgrade Now 🚀
Sign in to unlock AI tutor
To analyze data from the past 30 days using Firebase Analytics integration with Google BigQuery, where daily tables are automatically created in the format app_events_YYYYMMDD, and the query must use legacy SQL, which method should you employ?
app_events_YYYYMMDD
A
Utilize the WHERE_PARTITIONTIME pseudo column for filtering.
WHERE_PARTITIONTIME
B
Apply the TABLE_DATE_RANGE function to specify the date range.
TABLE_DATE_RANGE
C
Filter data using a WHERE clause with date BETWEEN YYYY-MM-DD AND YYYY-MM-DD.
WHERE
date BETWEEN YYYY-MM-DD AND YYYY-MM-DD
D
Use a SELECT IF statement to check if the date falls within the specified range.
SELECT IF
