GCP-ADP Timed Practice Test 1 — 10 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.