ExamDumpster

Free PDE sample questions

Each free PDE sample question below includes the answer and an explanation. You will meet pipeline design, storage choices and data preparation for analysis. Use them as a quick check on your Google Cloud data skills.

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

Showing 10 of 20 free sample questions.

Question 1Choose one

Your company is streaming real-time sensor data from their factory floor into Bigtable and they have noticed extremely poor performance. How should the row key be redesigned to improve Bigtable performance on queries that populate real-time dashboards?

Question 2Choose one

You work for a shipping company that has distribution centers where packages move on delivery lines to route them properly. The company wants to add cameras to the delivery lines to detect and track any visual damage to the packages in transit. You need to create a way to automate the detection of damaged packages and flag them for human review in real time while the packages are in transit. Which solution should you choose?

Question 3Choose one

Your company uses a proprietary system to send inventory data every 6 hours to a data ingestion service in the cloud. Transmitted data includes a payload of several fields and the timestamp of the transmission. If there are any concerns about a transmission, the system re-transmits the data. How should you deduplicate the data most efficiency?

Question 4Choose one

You currently have a single on-premises Kafka cluster in a data center in the us-east region that is responsible for ingesting messages from loT devices globally. Because large parts of globe have poor internet connectivity, messages sometimes batch at the edge, come in all at once, and cause a spike in load on your Kafka cluster. This is becoming difficult to manage and prohibitively expensive. What is the Google-recommended cloud native architecture for this scenario?

Question 5Choose one

You work for a global shipping company. You want to train a model on 40 TB of data to predict which ships in each geographic region are likely to cause delivery delays on any given day. The model will be based on multiple attributes collected from multiple sources. Telemetry data, including location in GeoJSON format, will be pulled from each ship and loaded every hour. You want to have a dashboard that shows how many and which ships are likely to cause delays within a region. You want to use a storage solution that has native functionality for prediction and geospatial processing. Which storage solution should you use?

Question 6Choose one

Your company is using WILDCARD tables to query data across multiple tables with similar names. The SQL statement is currently failing with the following error: # Syntax error: Expected end of statement but got at [4:11] SELECT age FROM bigquery-public-data.noaa_gsod.gsod WHERE age != 99 AND_TABLE_SUFFIX = ‘1929’ ORDER BY age DESC Which table name will make the SQL statement work correctly?

Question 7Choose one

You work on a regression problem in a natural language processing domain, and you have 100M labeled exmaples in your dataset. You have randomly shuffled your data and split your dataset into train and test samples (in a 90/10 ratio). After you trained the neural network and evaluated your model on a test set, you discover that the root-mean-squared error (RMSE) of your model is twice as high on the train set as on the test set. How should you improve the performance of your model?

Question 8Choose one

You need to create a new transaction table in Cloud Spanner that stores product sales data. You are deciding what to use as a primary key. From a performance perspective, which strategy should you choose?

Question 9Choose one

You need to copy millions of sensitive patient records from a relational database to BigQuery. The total size of the database is 10 TB. You need to design a solution that is secure and time-efficient. What should you do?

Question 10Choose one

An e-commerce platform uses Cloud Composer to orchestrate a complex daily data processing workflow. The workflow involves several Dataproc jobs, BigQuery queries, and data validation checks. The platform team wants to implement a CI/CD process to automatically deploy changes to their Airflow DAGs from a GitHub repository to the Composer environment. Which of the following approaches is the recommended best practice for achieving this? graph TD A[Developer pushes to main branch] --> B{GitHub Actions}; B --> C[Sync DAGs to Composer GCS Bucket]; C --> D[Cloud Composer picks up new DAG];

10 more free samples are waiting

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

Create account