Google Cloud Professional Data Engineer PDE — Topic 1 Question 56

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?

Accepted Answer

Correct answer: A. The correct answer is A. Option A: Use the TABLE_DATE_RANGE function.

Google Cloud Professional Data Engineer PDE — Question 56