ExamDumpster

Free ADP sample questions

These free ADP sample questions each come with the correct answer and an explanation. They cover BigQuery analysis, Looker dashboards and simple pipelines. Use them to find the Google Cloud data skills you should build next.

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

Showing 10 of 20 free sample questions.

Question 1Choose one

A media company stores large video files in a Multi-Regional Cloud Storage bucket with Standard storage class. These files are accessed frequently for the first 30 days. After 30 days, access becomes rare, but the files must be kept for five years for compliance. After five years, they should be deleted. You need to implement a cost-effective lifecycle management policy. What should the lifecycle rule contain?

Question 2Choose one

You are analyzing a dataset of customer transactions in a Colab Enterprise notebook. The data is stored in a BigQuery table. You need to identify the top 5 customers by total spending. The BigQuery table is named `project.dataset.transactions` and has columns `customer_id` and `purchase_amount`. You have already authenticated and initialized the BigQuery client in your notebook. Which Python code snippet using the BigQuery client library should you use?

Question 3Choose one

A startup is building an event-driven data processing system. When a new JSON file is uploaded to a Cloud Storage bucket, a lightweight data validation check needs to be performed. If the file is valid, a message should be sent to a Pub/Sub topic for downstream processing. The solution must be serverless, cost-effective for infrequent uploads, and require minimal infrastructure management. Which combination of services should be used to build this system? sequenceDiagram participant User participant GCS as Cloud Storage participant Trigger participant Processor participant PubSub as Pub/Sub User->>GCS: Upload JSON file GCS->>Trigger: Event: object.finalize Trigger->>Processor: Invoke with event data Processor->>Processor: Validate JSON Processor->>PubSub: Publish message

Question 4Choose one

During a data quality audit, you discover that a critical `customers` table in BigQuery contains duplicate rows based on the `customer_id` column. You need to create a new table, `customers_deduped`, that contains only the unique customer records. For duplicates, you must keep the record that was most recently updated, based on the `last_modified_ts` timestamp column. Which SQL query should you use?

Question 5Choose 2

A gaming company is designing a high-availability and disaster recovery (HA/DR) strategy for its player profile data, which is stored in Cloud SQL for PostgreSQL. The primary business requirements are to ensure data durability against regional failures and to provide a read-only endpoint for analytics that does not impact the primary instance's performance. Which Cloud SQL features should be configured to meet these requirements? (Select TWO)

Question 6Choose one

Case Study: Global Logistics Co. **Company Background:** Global Logistics Co. is a multinational shipping company that tracks millions of packages daily. They have a massive on-premises data infrastructure that they are migrating to Google Cloud to improve scalability and analytics capabilities. **Current Situation:** They currently receive real-time package status updates from their fleet of trucks and planes. These updates are small JSON messages sent to an on-premises message queue. A legacy Java application processes these messages, enriches them with data from a PostgreSQL database, and stores the results in a local data warehouse. This system is struggling to keep up with the increasing volume of data, leading to delays in package tracking visibility for customers. **Technical Requirements:** 1. The new cloud-native pipeline must process messages in near real-time with low latency. 2. The solution must be serverless and auto-scaling to handle unpredictable spikes in message volume. 3. The pipeline needs to perform a stateful enrichment: for each package, it must look up the package's origin and destination from a reference table. 4. The final, enriched data must be written to a BigQuery table for real-time analytics and a Cloud Storage bucket for archival. Which combination of Google Cloud services provides the most suitable architecture for this new pipeline?

Question 7Choose one

You are joining a project that uses Looker for its business intelligence. You are given a link to a dashboard, but you need to understand how the metrics are calculated. Specifically, you want to see the underlying data model, including the table joins and dimension/measure definitions. Where in the Looker interface would you navigate to find this information?

Question 8Choose one

A data practitioner needs to load a 500 MB CSV file from a local machine into a new BigQuery table named `campaign_results`. Which `bq` command-line tool invocation is the correct way to accomplish this?

Question 9Choose one

True or False: When using Analytics Hub to share a BigQuery dataset with another organization, a complete copy of the data is replicated into the subscriber's Google Cloud project, potentially incurring high storage costs for the subscriber.

Question 10Choose one

You need to create a simple, scheduled workflow that runs a BigQuery query every morning at 9 AM, and if the query is successful, sends a notification to a Pub/Sub topic. The workflow has no complex dependencies or branching logic. You want to use a serverless, managed orchestration service that requires defining the workflow in YAML or JSON. Which service is the best fit for this requirement?

10 more free samples are waiting

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

Create account