CompTIA
Checkpoint
ISC
HP
Dell
EC-Council
EXIN
Fortinet
ITIL®
Juniper
PMI
Microsoft
VMware
Avaya
Google
Salesforce
Amazon
Palo Alto Networks
Certiport
ISC2
All Vendors
  2. Home
  3. Exams
  4. Google
  5. Professional Data Engineer

Free Professional Data Engineer Exam Braindumps (page: 27)

Page 27 of 68
PDF with 371 Questions

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?

  1. Add ", UNNEST(person)" before the WHERE clause.
  2. Change "person" to "person.city".
  3. Change "person" to "city.person".
  4. Add ", UNNEST(city)" before the WHERE clause.

Answer(s): A

Explanation:

To access the person.city column, you need to "UNNEST(person)" and JOIN it to table1 using a comma.


Reference:

https://cloud.google.com/bigquery/docs/reference/standard-sql/migrating-from-legacy- sql#nested_repeated_results



Which of these statements about BigQuery caching is true?

  1. By default, a query's results are not cached.
  2. BigQuery caches query results for 48 hours.
  3. Query results are cached even if you specify a destination table.
  4. There is no charge for a query that retrieves its results from cache.

Answer(s): D

Explanation:

When query results are retrieved from a cached results table, you are not charged for the query.
BigQuery caches query results for 24 hours, not 48 hours. Query results are not cached if you specify a destination table. A query's results are always cached except under certain conditions, such as if you specify a destination table.


Reference:

https://cloud.google.com/bigquery/querying-data#query-caching



Which Google Cloud Platform service is an alternative to Hadoop with Hive?

  1. Cloud Dataflow
  2. Cloud Bigtable
  3. BigQuery
  4. Cloud Datastore

Answer(s): C

Explanation:

Apache Hive is a data warehouse software project built on top of Apache Hadoop for providing data summarization, query, and analysis. Google BigQuery is an enterprise data warehouse.


Reference:

https://en.wikipedia.org/wiki/Apache_Hive



What are all of the BigQuery operations that Google charges for?

  1. Storage, queries, and streaming inserts
  2. Storage, queries, and loading data from a file
  3. Storage, queries, and exporting data
  4. Queries and streaming inserts

Answer(s): A

Explanation:

Google charges for storage, queries, and streaming inserts. Loading data from a file and exporting data are free operations.


Reference:

https://cloud.google.com/bigquery/pricing



Page 27 of 68



Post your Comments and Discuss Google Professional Data Engineer exam with other Community members:

madhan commented on June 16, 2023
next question
EUROPEAN UNION
upvote