You have enabled the free integration between Firebase Analytics and Google BigQuery. Firebase now automatically creates a new table daily in BigQuery in the format app_events_YYYYMMDD. You want to query all of the tables for the past 30 days in legacy SQL. What should you do? A) Use the TABLE_DATE_RANGE function Use the TABLE_DATE_RANGE function B) Use the WHERE_PARTITIONTIME pseudo column WHERE_PARTITIONTIME pseudo column C) Use WHERE date BETWEEN YYYY-MM-DD AND YYYY-MM-DD D) Use SELECT IF.(date = YYYY-MM-DD AND date

Question

You have enabled the free integration between Firebase Analytics and Google BigQuery. Firebase now automatically creates a new table daily in BigQuery in the format app_events_YYYYMMDD. You want to query all of the tables for the past 30 days in legacy SQL. What should you do?
A) Use the TABLE_DATE_RANGE function Use the TABLE_DATE_RANGE function
B) Use the WHERE_PARTITIONTIME pseudo column WHERE_PARTITIONTIME pseudo column
C) Use WHERE date BETWEEN YYYY-MM-DD AND YYYY-MM-DD
D) Use SELECT IF.(date >= YYYY-MM-DD AND date <= YYYY-MM-DD

Quizplus · Accepted Answer

The TABLE_DATE_RANGE function in legacy SQL is used to query a range of tables that follow a date suffix pattern, such as app_events_YYYYMMDD, which is suitable for querying tables created daily for the past 30 days.

You Have Enabled the Free Integration Between Firebase Analytics and Google