Google Cloud Professional Data Engineer PDE — Topic 1 Question 9

Question

Your company is using WILDCARD tables to query data across multiple tables with similar names. The SQL statement is currently failing with the following error: Which table name will make the SQL statement work correctly?

Accepted Answer

Correct answer: D. The correct answer is D. Option D: 'bigquery-public-data.noaa_gsod.gsod*` BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage.

Google Cloud Professional Data Engineer PDE — Question 9