Data Engineers (with Accurate Solutions)

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 `1` WHERE city = "London" How would you correct the error? A. Add ", UNNEST(person)" before the WHERE clause. B. Change "person" to "". C. Change "person" to "n". D. Add ", UNNEST(city)" before the WHERE clause. correct answers A What are two of the benefits of using denormalized data structures in BigQuery? A. Reduces the amount of data processed, reduces the amount of storage required B. Increases query speed, makes queries simpler C. Reduces the amount of storage required, increases query speed D. Reduces the amount of data processed, increases query speed correct answers B Which of these statements about exporting data from BigQuery is false? A. To export more than 1 GB of data, you need to put a wildcard in the destination filename. B. The only supported export destination is Google Cloud Storage. C. Data can only be exported in JSON or Avro format. D. The only compression option available is GZIP. correct answers C What are all of the BigQuery operations that Google charges for? A. Storage, queries, and streaming inserts B. Storage, queries, and loading data from a file C. Storage, queries, and exporting data D. Queries and streaming inserts correct answers A Which of the following is not possible using primitive roles? A. Give a user viewer access to BigQuery and owner access to Google Compute Engine instances. B. Give UserA owner access and UserB editor access for all datasets in a project. C. Give a user access to view all datasets in a project, but not run queries on them. D. Give GroupA owner access and GroupB editor access for all datasets in a project. correct answers C Which of these statements about BigQuery caching is true? A. By default, a query's results are not cached. B. BigQuery caches query results for 48 hours. C. Query results are cached even if you specify a destination table. D. There is no charge for a query that retrieves its results from cache. correct answers D