You Have Enabled the Free Integration Between Firebase Analytics and Google

question 139

Multiple Choice

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

---

Definitions:

Inferior Good

is a type of good whose demand decreases when the income of consumers increases, contrary to what is observed with normal goods.

Cross-price Elasticity

A measure of how the demand for one good responds to a change in the price of another good, indicating their substitutability or complementarity.

Complements

Goods or services that are used together, where an increase in demand for one leads to an increase in demand for the other.

Income Elasticity

A measure of how much the demand for a good or service changes in response to a change in consumers’ income.