PROFESSIONAL-DATA-ENGINEER · Question #54
PROFESSIONAL-DATA-ENGINEER Question #54: Real Exam Question with Answer & Explanation
Sign in or unlock PROFESSIONAL-DATA-ENGINEER to reveal the answer and full explanation for question #54. The question stem and answer options stay visible for context.
Question
Suppose you have a table that includes a nested column called "city" inside a column called "person", but when you try to submit the following query in BigQuery, it gives you an error. SELECT person FROM `project1.example.table1` WHERE city = "London" How would you correct the error?
Options
- AAdd ", UNNEST(person)" before the WHERE clause.
- BChange "person" to "person.city".
- CChange "person" to "city.person".
- DAdd ", UNNEST(city)" before the WHERE clause.
Unlock PROFESSIONAL-DATA-ENGINEER to see the answer
You've previewed enough free PROFESSIONAL-DATA-ENGINEER questions. Unlock PROFESSIONAL-DATA-ENGINEER for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.