Welcome to ExamTopics
ExamTopics Logo
- Expert Verified, Online, Free.
Mail Us [email protected]
Menu

Unlimited Access

Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Google Discussions

Exam Professional Data Engineer topic 1 question 9 discussion

Actual exam question from Google's Professional Data Engineer
Question #: 9
Topic #: 1
[All Professional Data Engineer Questions]

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?

  • A. 'bigquery-public-data.noaa_gsod.gsod'
  • B. bigquery-public-data.noaa_gsod.gsod*
  • C. 'bigquery-public-data.noaa_gsod.gsod'*
  • D. 'bigquery-public-data.noaa_gsod.gsod*`
Show Suggested Answer Hide Answer
Suggested Answer: D 🗳️
Reference:
https://cloud.google.com/bigquery/docs/wildcard-tables
by AWSandeep at Sept. 3, 2022, 6:48 a.m.

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Submit Cancel
Ender_H
Highly Voted 1 year, 6 months ago
None, the actual `bigquery-public-data.noaa_gsod.gsod*` with back ticks at the beginning and at the end.
upvoted 25 times
Davijde13
1 year, 3 months ago
I suspect there has been some typo with copy-paste of the option D
upvoted 7 times
...
Jasar
1 year, 5 months ago
yes it was the same , i hope im the real test we dont face any wrrors like that
upvoted 1 times
...
jitvimol
3 months, 3 weeks ago
yes, I see from another source that actually ans D has to be backtick. Probably a problem when this web do data ingestion.
upvoted 1 times
...
...
RT_G
Most Recent 5 months, 1 week ago
Selected Answer: D
Reference: https://cloud.google.com/bigquery/docs/querying-wildcard-tables The wildcard table name contains the special character (*), which means that you must enclose the wildcard table name in backtick (`) characters. For example, the following query is valid because it uses backticks: #standardSQL /* Valid SQL query */ SELECT max FROM `bigquery-public-data.noaa_gsod.gsod*` WHERE max != 9999.9 # code for missing data AND _TABLE_SUFFIX = '1929' ORDER BY max DESC
upvoted 1 times
...
RT_G
5 months, 1 week ago
Selected Answer: D
Agree with others - Option D
upvoted 1 times
...
axantroff
5 months, 3 weeks ago
Selected Answer: D
D. 'bigquery-public-data.noaa_gsod.gsod*` is the right answer with 1 typo
upvoted 1 times
...
rtcpost
5 months, 4 weeks ago
Selected Answer: D
Option D (assuming to have backticks) Refer: https://cloud.google.com/bigquery/docs/querying-wildcard-tables The following query is NOT valid because it isn't properly quoted with backticks: ``` #standardSQL /* Syntax error: Expected end of statement but got "-" at [4:11] */ SELECT max FROM # missing backticks bigquery-public-data.noaa_gsod.gsod* WHERE max != 9999.9 # code for missing data AND _TABLE_SUFFIX = '1929' ORDER BY max DESC ```
upvoted 1 times
...
vaga1
11 months ago
Selected Answer: D
let's forget the fact that in BQ is used ` instead than ' which retrieves an error in any case. ` is called backquote, backtick, or left quote while ' is simply an apostrophe. Let's consider ' to be ` in every answer, since moderators could have not been aware of such when they had received the question.
upvoted 1 times
vaga1
11 months ago
Who used BQ knows that the backquote is necessary only for the project name, while it can be used for the whole string, and necessary only when the project name contains special (special in this specific context) characters. - is a special character. so `bigquery-public-data`.noaa_gsod.gsod1940 would have worked too. The question now turns out to be `bigquery-public-data`.noaa_gsod.gsod* still works or due to the * presence we need to write `bigquery-public-data.noaa_gsod.gsod*` ? I personally do not remember, and I do not have a BQ at my disposal at the moment. But I know for sure that `bigquery-public-data.noaa_gsod.gsod*` works while `bigquery-public-data`.noaa_gsod.gsod* is not in the options.
upvoted 1 times
...
...
Pavaan
11 months, 1 week ago
Answer is 'D' Reference : https://cloud.google.com/bigquery/docs/wildcard-table-reference Enclose table names with wildcards in backticks The wildcard table name contains the special character (*), which means that you must enclose the wildcard table name in backtick (`) characters.
upvoted 3 times
...
Melampos
11 months, 3 weeks ago
Selected Answer: B
bigquery-public-data.noaa_gsod.gsod* works
upvoted 2 times
...
hkhnhan
1 year ago
Selected Answer: B
should be B, the backtick at D answer is wrong ' instead of `
upvoted 1 times
...
hkhnhan
1 year ago
should be B, the backtick at D answer is wrong ' instead of `
upvoted 1 times
...
Zosby
1 year, 1 month ago
D is correct
upvoted 1 times
...
priluft
1 year, 7 months ago
Selected Answer: D
D. 'bigquery-public-data.noaa_gsod.gsod*`
upvoted 2 times
...
AWSandeep
1 year, 7 months ago
Selected Answer: D
D. 'bigquery-public-data.noaa_gsod.gsod*`
upvoted 2 times
...

Get IT Certification

Unlock free, top-quality video courses on ExamTopics with a simple registration. Elevate your learning journey with our expertly curated content. Register now to access a diverse range of educational resources designed for your success. Start learning today with ExamTopics!

Start Learning for free
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel