<< Prev Question Next Question >>

Question 7/38

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?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (38q)
Question 1: What Dataflow concept determines when a Window's contents sh...
Question 2: What are two methods that can be used to denormalize tables ...
Question 3: You want to process payment transactions in a point-of-sale ...
Question 4: You are building a new data pipeline to share data between t...
Question 5: You used Cloud Dataprep to create a recipe on a sample of da...
Question 6: You have enabled the free integration between Firebase Analy...
Question 7: Suppose you have a table that includes a nested column calle...
Question 8: Which of the following statements is NOT true regarding Bigt...
Question 9: You are integrating one of your internal IT applications and...
Question 10: You are operating a Cloud Dataflow streaming pipeline. The p...
Question 11: You work for a manufacturing company that sources up to 750 ...
Question 12: You are selecting services to write and transform JSON messa...
Question 13: Which Cloud Dataflow / Beam feature should you use to aggreg...
Question 14: Which of these sources can you not load data into BigQuery f...
Question 15: The YARN ResourceManager and the HDFS NameNode interfaces ar...
Question 16: You are a retailer that wants to integrate your online sales...
Question 17: You are building a model to predict whether or not it will r...
Question 18: Which of the following is NOT one of the three main types of...
Question 19: What are all of the BigQuery operations that Google charges ...
Question 20: You launched a new gaming app almost three years ago. You ha...
Question 21: You are designing the database schema for a machine learning...
Question 22: You work for a shipping company that uses handheld scanners ...
Question 23: Your company produces 20,000 files every hour. Each data fil...
Question 24: Which Google Cloud Platform service is an alternative to Had...
Question 25: MJTelco needs you to create a schema in Google Bigtable that...
Question 26: You architect a system to analyze seismic dat a. Your extrac...
Question 27: You work for a mid-sized enterprise that needs to move its o...
Question 28: You are creating a new pipeline in Google Cloud to stream Io...
Question 29: You need to create a data pipeline that copies time-series t...
Question 30: By default, which of the following windowing behavior does D...
Question 31: Your company is loading comma-separated values (CSV) files i...
Question 32: You have a data stored in BigQuery. The data in the BigQuery...
Question 33: All Google Cloud Bigtable client requests go through a front...
Question 34: You are running a pipeline in Cloud Dataflow that receives m...
Question 35: Flowlogistic's CEO wants to gain rapid insight into their cu...
Question 36: Suppose you have a dataset of images that are each labeled a...
Question 37: You want to automate execution of a multi-step data pipeline...
Question 38: Which of these is not a supported method of putting data int...