GCP-ADP Exam Simulation — 200 Questions

Question 1

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

Accepted Answer

The refresh icon.. Looker dashboards have a refresh icon (circular arrow) that reloads the data based on current cache settings.

Answer

The edit icon.

Answer

The share icon.

Answer

The filter icon.

Question 2

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

Accepted Answer

Open the notebook in a managed instance and click 'Run'.. You can open it in a managed instance and run the cells directly in the browser interface.

Answer

Copy the code into a BigQuery query window.

Answer

Paste it into the Cloud Shell terminal.

Answer

Deploy it to App Engine.

Question 3

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

Accepted Answer

Use the 'Save results' option and select 'Google Sheets'.. BigQuery has a built-in 'Save Results' option that allows exporting directly to Google Sheets.

Answer

Use the BigQuery Data Transfer Service.

Answer

Export to a CSV file and manually upload to Sheets.

Answer

Write a Python script to call the Google Sheets API.

Question 4

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?

Accepted Answer

type: count_distinct. The `count_distinct` type is specifically designed for calculating unique occurrences in LookML.

Answer

type: count

Answer

type: average_distinct

Answer

type: sum_distinct

Question 5

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

Accepted Answer

Define it in a central project and share access. You create the taxonomy in a central host project and grant permissions to other projects to use it.

Answer

Move the taxonomy to the Organization node

Answer

Duplicate the taxonomy in each project

Answer

Use Cloud Resource Manager to link them

Question 6

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

Accepted Answer

Adding and removing data assets. Admins handle access, assets, and task scheduling.

Answer

Manually editing individual data files

Answer

Rebuilding the physical database indexes

Question 7

Which THREE features does Looker offer to support data governance?

Accepted Answer

Centralized LookML modeling. Governance is supported by central modeling, user permissions, and audit logs.

Answer

Automated email subject line generation

Answer

Custom chart color themes

Question 8

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

Accepted Answer

To automatically email reports to stakeholders.. Scheduled reports automatically deliver data to users via email, ensuring stakeholders get insights without logging in.

Answer

To increase the BigQuery slot limit.

Answer

To optimize the database performance.

Answer

To change the dashboard color.

Question 9

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?

Accepted Answer

Date range control.. A 'Date range control' allows end users to filter the entire report by a specific timeframe.

Answer

Parameter.

Answer

Calculated field.

Answer

Chart interaction filter.

Question 10

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

Accepted Answer

Vertex AI Workbench.. Vertex AI Workbench is the managed service for running Jupyter notebook instances.

Answer

Cloud Run.

Answer

Dataflow.

Answer

BigQuery Studio.

Question 11

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

Accepted Answer

Analytics. Dataplex is found under the 'Analytics' section in the Google Cloud console.

Answer

Compute Engine

Answer

Operations

Answer

Storage

Question 12

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

Accepted Answer

Airflow Web Interface. The Airflow Web Interface is the primary UI for managing DAGs and viewing execution history.

Answer

Cloud Storage Browser

Answer

Cloud Shell

Answer

BigQuery Console

Question 13

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

Accepted Answer

Cloud Monitoring. Cloud Monitoring allows you to set up alerts based on GCS bucket metrics like byte count.

Answer

Cloud Build

Answer

IAM

Answer

Cloud Logging

Question 14

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

Accepted Answer

Use a Dead Letter Queue (DLQ). Using a Dead Letter Queue (DLQ) pattern allows you to route unprocessable messages to a separate destination for inspection.

Answer

Ignore errors

Answer

Increase memory

Answer

Restart the pipeline

Question 15

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

Accepted Answer

BigQuery Data Transfer Service.. BigQuery Data Transfer Service allows for scheduled exports and imports.

Answer

Cloud Monitoring alerts.

Answer

Looker studio refresh.

Answer

A manual SQL query.

Question 16

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

Accepted Answer

one_failed. The 'one_failed' trigger rule allows a task to execute if at least one parent task has failed.

Answer

none_failed

Answer

always

Answer

all_success

Question 17

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

Accepted Answer

address.city. Standard SQL uses the dot notation (dot-walk) to access fields within a STRUCT.

Answer

address->city

Answer

address[city]

Answer

JSON_EXTRACT(address, '$.city')

Question 18

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

Accepted Answer

It improves data availability and durability. Multi-region deployment increases availability and ensures data is replicated across multiple regions within the same geography.

Answer

It restricts access to users in a single region

Answer

It prevents the use of BigQuery datasets

Answer

It reduces the cost of storing data

Question 19

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

Accepted Answer

Check the Query History to see execution time and SQL complexity.. Checking the query history helps identify if the underlying database is slow or if the Looker model is generating inefficient SQL.

Answer

Restart the Looker instance.

Answer

Delete all existing users.

Answer

Change the Looker instance color theme.

Question 20

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)

Accepted Answer

The user needs BigQuery permissions on the dataset. The user needs proper IAM permissions on the project and the dataset to register it as an asset.

Answer

The dataset must be public

Answer

The dataset must exist in the same project as the Lake

Answer

The dataset must contain at least one table