Question 61 of 307
Single answerYou 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?
✓AUse the TABLE_DATE_RANGE function
BUse the WHERE_PARTITIONTIME pseudo column
CUse WHERE date BETWEEN YYYY-MM-DD AND YYYY-MM-DD
DUse SELECT IF.(date >= YYYY-MM-DD AND date <= YYYY-MM-DD
✓
Correct Answer: A
Use the TABLE_DATE_RANGE function
▥
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.