ExamDumpster

Free GCP-ADP sample questions

Try these free GCP-ADP sample questions, each with the right answer and an explanation. They cover data loading, Cloud Storage lifecycle rules and BigQuery analysis. Use them to see which data tasks you can already handle.

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

Showing 6 of 12 free sample questions.

Question 1Choose one

A data analyst needs to create an ad-hoc report to visualize sales performance for a specific region. The report is for a one-time presentation and does not require complex data modeling or version control. Which tool is most appropriate for this task?

Question 2Choose one

You are setting up a new BigQuery dataset that will contain highly sensitive PII data. You need to ensure that only a specific group of Data Scientists can run queries against this dataset, while another group of Auditors can only view the metadata (table schemas) but not the data itself. Which IAM roles should you assign to each group for this dataset?

Question 3Choose one

You are designing a data pipeline that uses Cloud Dataflow to process streaming data from Pub/Sub and write it to BigQuery. You notice that the pipeline is experiencing high latency and the system lag is increasing. You inspect the logs and see many 'Hot Key' warnings. What is the most likely cause?

Question 4Choose one

You need to automate a daily data transformation workflow. The workflow involves executing a SQL query in BigQuery, checking the results, and then triggering a Cloud Function if the data quality check passes. You prefer a serverless, low-code orchestration solution. Which service should you use?

Question 5Choose one

A global retail company wants to use machine learning to predict customer churn. They have petabytes of transaction data stored in BigQuery. The data science team is proficient in SQL but has limited experience with Python or R. Which solution allows them to build and deploy a churn prediction model directly within their data warehouse?

Question 6Choose one

You are migrating an existing Hadoop and Spark workload from an on-premises cluster to Google Cloud. You want to minimize changes to the existing jobs and leverage a managed service that allows you to scale clusters up and down as needed. Which service is best suited for this migration?

6 more free samples are waiting

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

Create account