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

Exam Professional Data Engineer All Questions

View all questions & answers for the Professional Data Engineer exam
Go to Exam

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 🗳️
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 2 years, 2 months ago
None, the actual `bigquery-public-data.noaa_gsod.gsod*` with back ticks at the beginning and at the end.
upvoted 30 times
Davijde13
1 year, 10 months ago
I suspect there has been some typo with copy-paste of the option D
upvoted 10 times
...
jitvimol
11 months 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 2 times
...
...
vaga1
Most Recent 2 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
1 year, 6 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
...
...
rtcpost
2 months 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
...
RT_G
2 months 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
...
ABKR1300
2 months ago
Few might go with the Option B which will be a blunder because of the below reason. While querying the tables or views with the name, it is optional to surround with the backticks. But while querying the list of tables with Wild card character, it is must to surround with the backticks. We can get the Syntax error: Expected end of input but got "*" with the below query SELECT * FROM bigquery-public-data.noaa_gsod.gsod* WHERE _TABLE_SUFFIX = "2024" So, option D might be the correct one, provided if there is a typo.
upvoted 4 times
...
Chintu_573
5 months ago
Selected Answer: B
IN option D, there is differert ' ` on first and last. That's why right option is second.
upvoted 1 times
...
dsyouness
6 months, 1 week ago
Selected Answer: B
bigquery-public-data.noaa_gsod.gsod* also works
upvoted 3 times
...
RT_G
1 year ago
Selected Answer: D
Agree with others - Option D
upvoted 1 times
...
axantroff
1 year ago
Selected Answer: D
D. 'bigquery-public-data.noaa_gsod.gsod*` is the right answer with 1 typo
upvoted 1 times
...
Pavaan
1 year, 6 months 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
1 year, 7 months ago
Selected Answer: B
bigquery-public-data.noaa_gsod.gsod* works
upvoted 2 times
...
hkhnhan
1 year, 8 months ago
Selected Answer: B
should be B, the backtick at D answer is wrong ' instead of `
upvoted 1 times
...
hkhnhan
1 year, 8 months ago
should be B, the backtick at D answer is wrong ' instead of `
upvoted 1 times
...
Zosby
1 year, 9 months ago
D is correct
upvoted 1 times
...
priluft
2 years, 2 months ago
Selected Answer: D
D. 'bigquery-public-data.noaa_gsod.gsod*`
upvoted 2 times
...
AWSandeep
2 years, 2 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