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.
Correct Answer:
Verified
Correct Answer:
Verified
Q230: You are building a model to predict
Q231: Flowlogistic Case Study Company Overview Flowlogistic is
Q232: You work for a global shipping company.
Q233: When creating a new Cloud Dataproc cluster
Q234: You are developing an application that uses
Q236: You are building an application to share
Q237: You are building a new data pipeline
Q238: You are creating a new pipeline in
Q239: You are using Google BigQuery as your
Q240: You need to create a new transaction