Google Cloud Associate Data Practitioner (GCP-ADP) GCP-ADP practice test

When reviewing a Looker dashboard, which icon do you click to reload the data?

A colleague has shared a Vertex AI Workbench notebook with you. How can you run it?

You need to export query results from BigQuery to a Google Sheet. What is the easiest way to do this?

You are building a Looker model and want to create a measure that calculates the count of distinct customers. Which type of measure should you use?

You have a Data Catalog taxonomy that you want to share across multiple projects. How do you achieve this?

Which THREE of the following are common administrative tasks when managing a Dataplex Lake? (Choose three)

Which THREE features does Looker offer to support data governance?

What is the benefit of using 'Scheduled Reports' in Looker?

You have a dashboard in Looker Studio and you want to allow users to dynamically change the date range without editing the report. What should you add?

Which service is the primary tool for managing and running Jupyter notebooks in a managed environment within Google Cloud?

Which console menu would you navigate to in order to access Dataplex?

Which component of Cloud Composer acts as the primary interface for managing and triggering DAGs manually?

You need to set up an alert when a GCS bucket exceeds a certain size. Which tool do you use?

You are using Dataflow to read from Pub/Sub. The pipeline is failing due to malformed messages. How can you handle these without crashing?

You want to automate the export of a BigQuery table to Cloud Storage on a daily basis. What should you use?

You need to run a task in Cloud Composer only if the previous task failed. Which Trigger Rule should you use?

A user is running a query on a BigQuery table with nested data (JSON). How do you access a field named 'city' inside a record field named 'address'?

When setting up a Dataplex Lake, you chose the 'Multi-region' location type. What is the implication of this choice?

You have a Looker dashboard that loads slowly. What is the first thing you should check in the 'Looker System Activity' or 'Query History'?

A team is migrating to Dataplex. Which TWO of the following are prerequisites for adding a BigQuery dataset as an asset to a Lake? (Choose two)

You want to share a BigQuery dataset with a partner who uses a different Google Cloud project. What is the most secure way to grant them access?

You are deploying a Cloud Composer 2 environment and need to ensure that the DAG files are automatically synchronized to all workers. Where should you store these files?

You need to track who accessed which GCS bucket. Which service provides this audit trail?

Which GCP tool provides a managed way to run Apache Airflow workflows?