Cisco
CompTIA
ISC
EC-Council
EXIN
Fortinet
ITIL
Juniper
Microsoft
VMware
Avaya
SAP
Google
NVIDIA
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk
ServiceNow
All Vendors
  2. Home
  3. Exams
  4. Google
  5. Google Cloud Data Engineer Professional

Google Google Cloud Data Engineer Professional Exam Questions
Google Cloud Data Engineer Professional (Page 13 )

Updated On: 16-Mar-2026
Page 13 of 78
PDF with 384 Questions

Which of these statements about exporting data from BigQuery is false?

  1. To export more than 1 GB of data, you need to put a wildcard in the destination filename.
  2. The only supported export destination is Google Cloud Storage.
  3. Data can only be exported in JSON or Avro format.
  4. The only compression option available is GZIP.

Answer(s): C

Explanation:

Data can be exported in CSV, JSON, or Avro format. If you are exporting nested or repeated data, then CSV format is not supported.


Reference:

https://cloud.google.com/bigquery/docs/exporting-data



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



Which of the following is not possible using primitive roles?

  1. Give a user viewer access to BigQuery and owner access to Google Compute Engine instances.
  2. Give UserA owner access and UserB editor access for all datasets in a project.
  3. Give a user access to view all datasets in a project, but not run queries on them.
  4. Give GroupA owner access and GroupB editor access for all datasets in a project.

Answer(s): C

Explanation:

Primitive roles can be used to give owner, editor, or viewer access to a user or group, but they can't be used to separate data access permissions from job-running permissions.


Reference:

https://cloud.google.com/bigquery/docs/access-control#primitive_iam_roles



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 of these sources can you not load data into BigQuery from?

  1. File upload
  2. Google Drive
  3. Google Cloud Storage
  4. Google Cloud SQL

Answer(s): D

Explanation:

You can load data into BigQuery from a file upload, Google Cloud Storage, Google Drive, or Google Cloud Bigtable. It is not possible to load data into BigQuery directly from Google Cloud SQL. One way to get data from Cloud SQL to BigQuery would be to export data from Cloud SQL to Cloud Storage and then load it from there.


Reference:

https://cloud.google.com/bigquery/loading-data



Viewing page 13 of 78
Viewing questions 61 - 65 out of 384 questions



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

Google Cloud Data Engineer Professional Exam Discussions & Posts

AI Tutor 👋 I’m here to help!