ExamDumpster

Free GCP-PDE sample questions

The free GCP-PDE sample questions on this page each include the answer and an explanation. Topics range from pipeline design to warehouse storage and data preparation for AI. Go through them slowly and note any service you need to read about.

Try them in the simulator Same questions, with study, timed and flashcard modes.

Showing 6 of 12 free sample questions.

Question 1Choose one

You are managing a Dataflow pipeline that processes streaming data from Pub/Sub. You notice that the pipeline's system lag is increasing effectively unbounded. Upon investigation, you see that the CPU utilization on the worker nodes is consistently near 100%. Which action should you take to resolve this performance issue?

Question 2Choose one

Your company needs to share a 2 PB dataset residing in BigQuery with a partner organization. The partner also uses Google Cloud. You need to share the data securely without copying it, and the partner will pay for their own query costs. Which solution should you implement?

Question 3Choose one

You are designing a data pipeline that uses Cloud Composer (Apache Airflow) to orchestrate a sequence of BigQuery jobs. One specific task waits for a file to arrive in a Cloud Storage bucket before triggering the next step. The file arrival time is unpredictable, ranging from 1 minute to 12 hours after the previous task. Which Airflow operator or sensor strategy is best for cost and performance?

Question 4Choose one

Case Study Scenario: A retail giant 'ShopSmart' is migrating its on-premises Oracle Exadata warehouse to Google Cloud. They have 2 PB of historical data and generate 5 TB of new transactional data daily. Requirements: 1. The migration must be completed within 2 months. 2. The cloud data warehouse must support standard SQL and scale to petabytes. 3. Business Intelligence users currently use Looker and need sub-second response times for dashboards. 4. Data sovereignty laws require that customer data from Europe stays in the `europe-west3` region. Which storage and migration strategy meets these needs?

Question 5Choose one

You are designing a solution to replicate data from an on-premises MySQL database to BigQuery for real-time analytics. The solution must capture data changes (Inserts, Updates, Deletes) with minimal latency and minimal impact on the source database performance. Which Google Cloud service combination is best suited for this task?

Question 6Choose one

Your startup app uses Cloud Firestore for its mobile backend. You need to perform complex analytical queries on this data, joining it with marketing data stored in CSV files on Cloud Storage. You want to minimize the engineering effort required to move or transform data. What is the most efficient solution?

6 more free samples are waiting

Create a free account to unlock the whole GCP-PDE sample bank, or get full access to all 531 practice questions in the simulator.

Create account