Exam Professional Data Engineer topic 1 question 56 discussion

A. is correct according to this link: https://cloud.google.com/bigquery/docs/reference/legacy-sql

https://cloud.google.com/bigquery/docs/reference/legacy-sql#table-date-range

We don’t have TABLE DATE RANGE function in legacy SQL. Answer should be B

The recommended action is to use the TABLE_DATE_RANGE function (option A). This function allows you to specify a range of dates to query across multiple tables.

The TABLE_DATE_RANGE function in BigQuery is a table wildcard function that can be used to query a range of daily tables. It takes two arguments: a table prefix and a date range. The table prefix is the beginning of the table names, and the date range is the start and end dates of the tables to be queried. The TABLE_DATE_RANGE function will expand to cover all tables in the dataset that match the table prefix and are within the date range. For example, if you have a dataset that contains daily tables named my_table_20230804, my_table_20230805, and my_table_20230806, you could use the TABLE_DATE_RANGE function to query all of the tables in the dataset between August 4, 2023 and August 6, 2023 as follows: SELECT * FROM TABLE_DATE_RANGE('my_table_', '2023-08-04', '2023-08-06');

A Is correct. TABLE_DATE_RANGE() : Queries multiple daily tables that span a date range.

https://cloud.google.com/bigquery/docs/reference/legacy-sql TABLE_DATE_RANGE() Queries multiple daily tables that span a date range.

A. is Correct... from...https://cloud.google.com/blog/products/management-tools/using-bigquery-and-firebase-analytics-to-understand-your-mobile-app SELECT user_dim.app_info.app_platform as appPlatform, user_dim.device_info.device_category as deviceType, COUNT(user_dim.device_info.device_category) AS device_type_count FROM TABLE_DATE_RANGE([firebase-analytics-sample-data:android_dataset.app_events_], DATE_ADD('2016-06-07', -7, 'DAY'), CURRENT_TIMESTAMP()), TABLE_DATE_RANGE([firebase-analytics-sample-data:ios_dataset.app_events_], DATE_ADD('2016-06-07', -7, 'DAY'), CURRENT_TIMESTAMP()) GROUP BY 1,2 ORDER BY device_type_count DESC