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.
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?
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?
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?
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?
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.