Free Google GCP-DE Practice Test & Real Exam Questions

Exam Code/Number: GCP-DE
Exam Name/Title: Data Engineer
Certification Provider: Google
Corresponding Certification: Google Cloud Certified

Exam Questions: 77
Updated On: Jul 05, 2026

Question #9

You receive data files in CSV format monthly from a third party. You need to cleanse this data, but every third month the schema of the files changes. Your requirements for implementing these transformations include:
Executing the transformations on a schedule
Enabling non-developer analysts to modify transformations
Providing a graphical tool for designing transformations
What should you do?

A. Use Apache Spark on Cloud Dataproc to infer the schema of the CSV file before creating a Dataframe.Then implement the transformations in Spark SQL before writing the data out to Cloud Storage and loading into BigQuery

B. Load each month's CSV data into BigQuery, and write a SQL query to transform the data to a standard scheme

C. Use Cloud Dataprep to build and maintain the transformation recipes, and execute them on a scheduled basis

D. The Python code should be stored in a revision control system and modified as the incoming data's schema changes

E. Merge the transformed tables together with a SQL query

F. Help the analysts write a Cloud Dataflow pipeline in Python to perform the transformatio

Discussion 0

Correct Answer: F Vote an answer

Question #10

You need to create a data pipeline that copies time-series transaction data so that it can be queried from within BigQuery by your data science team for analysis. Every hour, thousands of transactions are updated with a new status. The size of the intitial dataset is 1.5 PB, and it will grow by 3 TB per day. The data is heavily structured, and your data science team will build machine learning models based on this dat a. You want to maximize performance and usability for your data science team. Which two strategies should you adopt? Choose 2 answers.

A. Develop a data pipeline where status updates are appended to BigQuery instead of updated.

B. Denormalize the data as must as possible.

C. Preserve the structure of the data as much as possible.

D. Copy a daily snapshot of transaction data to Cloud Storage and store it as an Avro fil

E. Use BigQuery UPDATE to further reduce the size of the dataset.

F. Use BigQuery'ssupport for external data sources to query.

Discussion 0

Correct Answer: A,D Vote an answer

Question #12

Which of the following is NOT true about Dataflow pipelines?

A. Dataflow pipelines can be programmed in Java

B. Dataflow pipelines can consume data from other Google Cloud services

C. Dataflow pipelines are tied to Dataflow, and cannot be run on any other runner

D. Dataflow pipelines use a unified programming model, so can work both with streaming and batch data sources

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #13

You need to deploy additional dependencies to all of a Cloud Dataproc cluster at startup using an existing initialization action. Company security policies require that Cloud Dataproc nodes do not have access to the Internet so public initialization actions cannot fetch resources. What should you do?

A. Deploy the Cloud SQL Proxy on the Cloud Dataproc master

B. Use Resource Manager to add the service account used by the Cloud Dataproc cluster to the Network User role

C. Use an SSH tunnel to give the Cloud Dataproc cluster access to the Internet

D. Copy all dependencies to a Cloud Storage bucket within your VPC security perimeter

Discussion 0

Correct Answer: B Vote an answer

Question #14

Which of these is not a supported method of putting data into a partitioned table?

A. Run a query to get the records for a specific day from an existing table and for the destination table, specify a partitioned table ending with the day in the format "$YYYYMMDD".

B. Create a partitioned table and stream new records to it every day.

C. Use ORDER BY to put a table's rows into chronological order and then change the table's type to "Partitioned".

D. If you have existing data in a separate file for each day, then create a partitioned table and upload each file into the appropriate partition.

Discussion 0

Correct Answer: C Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #15

Which of these rules apply when you add preemptible workers to a Dataproc cluster (select 2 answers)?

A. Preemptible workers cannot use persistent disk.

B. A Dataproc cluster cannot have only preemptible workers.

C. If a preemptible worker is reclaimed, then a replacement worker must be added manually.

D. Preemptible workers cannot store data.

Discussion 0

Correct Answer: B,D Vote an answer

Explanation: Only visible for Pass4Leader members. You can sign-up / login (it's free).

Question #16

You are integrating one of your internal IT applications and Google BigQuery, so users can query BigQuery from the application's interface. You do not want individual users to authenticate to BigQuery and you do not want to give them access to the dataset. You need to securely access BigQuery from your IT application.
What should you do?

A. Integrate with a single sign-on (SSO) platform, and pass each user's credentials along with the query request

B. Create groups for your users and give those groups access to the dataset

C. Use the service account's private key to access the dataset

D. Create a dummy user and grant dataset access to that use

E. Store the username and password for that user in a file on the files system, and use those credentials to access the BigQuery dataset

F. Create a service account and grant dataset access to that accoun

Discussion 0

Correct Answer: F Vote an answer

Download Free Google GCP-DE Demo

Simply submit your e-mail address below to get started with our free demo of your Google GCP-DE exam.