Suppose You Have a Table That Includes a Nested Column

question 235

Multiple Choice

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?

• A) Add ", UNNEST(person)" before the WHERE clause.
• B) Change "person" to "person.city".
• C) Change "person" to "city.person".
• D) Add ", UNNEST(city)" before the WHERE clause.