Logo ExamsQA
Exit
Official Bank 0/384

Professional Data Engineer Exam (Professional-Data-Engineer) - Google Cloud Exam Questions

Last updated on June 20, 2026

97% Exam Compliance
384 Total Questions
1
Question
You currently have transactional data stored on-premises in a PostgreSQL database. To modernize your data environment, you want to run transactional workloads and support analytics needs with a single database. You need to move to Google Cloud without changing database management systems, and minimize cost and complexity. What should you do?
Options
A Migrate to BigQuery to optimize analytics.
B Migrate and modernize your database with Cloud Spanner.
C Migrate your workloads to AlloyDB for PostgreSQL.
D Migrate your PostgreSQL database to Cloud SQL for PostgreSQL.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

2
Question
Which action can a Cloud Dataproc Viewer perform?
Options
A Create a cluster.
B Delete a cluster.
C Submit a job.
D List the jobs.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

3
Question
To give a user read permission for only the first three columns of a table, which access control method would you use?
Options
A Predefined role
B Authorized view
C Primitive role
D It's not possible to give access to only the first three columns of a table.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

4
Question
You are designing a messaging system by using Pub/Sub to process clickstream data with an event- driven consumer app that relies on a push subscription. You need to configure the messaging system that is reliable enough to handle temporary downtime of the consumer app. You also need the messaging system to store the input messages that cannot be consumed by the subscriber. The system needs to retry failed messages gradually, avoiding overloading the consumer app, and store the failed messages after a maximum of 10 retries in a topic. How should you configure the Pub/Sub subscription?
Options
A Use immediate redelivery as the subscription retry policy, and configure dead lettering to a different topic with maximum delivery attempts set to 10.
B Use exponential backoff as the subscription retry policy, and configure dead lettering to the same source topic with maximum delivery attempts set to 10.
C Increase the acknowledgement deadline to 10 minutes.
D Use exponential backoff as the subscription retry policy, and configure dead lettering to a different topic with maximum delivery attempts set to 10.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

5
Question
You are working on a sensitive project involving private user dat
Options
A Grant the consultant the Cloud Dataflow Developer role on the project.
B Create a service account and allow the consultant to log on with it.
C Grant the consultant the Viewer role on the project.
D Create an anonymized sample of the data for the consultant to work with in a different project.
Discussion (0 comments)

to join the discussion

Community Discussion

No discussions yet. Be the first to ask!

Finish Practice?

Are you sure you want to finish? This will end your practice session.