GCP-ADP Data Analysis And Presentation Practice Test 5 — 15 Questions

Question 1

Which THREE items can be added to a Looker Studio report to enhance interactivity?

Accepted Answer

Drop-down filter. A drop-down filter is correct because it is an interactive control that lets report viewers select one or more dimension values to filter the charts and tables on the page. A slider control is correct because it provides an interactive numeric range selector that viewers can drag to filter data bound to a metric or parameter. A date range control is correct because it lets viewers interactively change the time period applied to the report's charts, driving the displayed data. The company logo and text block are not correct because they are static presentation elements used for branding or descriptive copy and do not provide any interactive filtering or data selection capability.

Answer

Company logo

Answer

Text block

Question 2

Which THREE features does Looker offer to support data governance?

Accepted Answer

Centralized LookML modeling. Looker supports data governance through centralized LookML modeling (C), because defining dimensions, measures, and business logic once in LookML creates a single source of truth that enforces consistent metric definitions across all Explores and dashboards. Content access controls (D) are correct because Looker provides role-based permissions, groups, and folder/content-level access settings that restrict who can view, edit, or manage data and dashboards. Audit logs for tracking activity (E) are correct because Looker's audit and system activity logs record user actions, queries, and content access, which is essential for compliance, monitoring, and accountability. Automated email subject line generation (A) and custom chart color themes (B) are merely presentation or scheduling conveniences and have no bearing on governing data definitions, access, or usage tracking.

Answer

Automated email subject line generation

Answer

Custom chart color themes

Question 3

Which THREE of these are valid ways to monitor or analyze BigQuery performance?

Accepted Answer

Query Plan explanation. Option A (Query Plan explanation) is correct because BigQuery's query execution plan, viewable in the Cloud Console or via the EXPLAIN statement, shows the stages, steps, and timing of a query so you can identify performance bottlenecks such as shuffles or expensive joins. Option B (INFORMATION_SCHEMA.JOBS_BY_PROJECT) is correct because this view exposes job metadata including query text, total bytes processed, slot milliseconds, and elapsed time, enabling historical performance analysis and cost attribution. Option E (BigQuery Monitoring dashboard in Cloud Console) is correct because it surfaces Cloud Monitoring metrics such as query execution time, slot usage, bytes processed, and concurrent jobs, giving real-time visibility into workload performance. Option C (Editing the table schema) is not a monitoring or analysis method; schema changes affect data structure and can influence performance but do not themselves observe or analyze it. Option D (Changing the project billing currency) is purely a billing configuration action and has no bearing on query performance monitoring or analysis.

Answer

Editing the table schema

Answer

Changing the project billing currency

Question 4

What is the primary function of a Looker Explore?

Accepted Answer

To allow users to explore and visualize data.. A Looker Explore is the primary interface where users drag and drop dimensions and measures to query data, apply filters, and visualize results. It provides a governed, self-service environment built on LookML models, allowing business users to explore data without writing SQL. The Explore is not a database backup, email client, or data deletion tool.

Answer

To automatically delete old data.

Answer

To act as a database backup.

Answer

To act as an email client.

Question 5

Which of the following describes the purpose of 'BigQuery ML'?

Accepted Answer

To run machine learning models using SQL.. BigQuery ML enables users to create and execute machine learning models directly in BigQuery using SQL queries. It allows data analysts to build models without needing to export data or use separate ML frameworks. This makes it accessible for SQL users to perform predictive analytics.

Answer

To create dashboard charts.

Answer

To compress table data.

Answer

To manage IAM permissions.

Question 6

You have a large table in BigQuery that is updated constantly. You need to perform a query that is consistent. What should you use?

Accepted Answer

Time travel / Table snapshots.. BigQuery time travel lets you query a table as it existed at any point within the last seven days, and table snapshots preserve a consistent view of the data at a specific moment. Because the table is constantly updated, querying the live table can return rows from different micro-batches; time travel or a snapshot gives you a point-in-time consistent read.

Answer

A stored procedure.

Answer

An external table.

Answer

A materialized view.

Question 7

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

Accepted Answer

To automatically email reports to stakeholders.. Scheduled Reports in Looker allow users to automate the delivery of dashboards, Looks, or visualizations via email or other destinations on a recurring schedule. This ensures stakeholders receive timely updates without manual intervention.

Answer

To increase the BigQuery slot limit.

Answer

To optimize the database performance.

Answer

To change the dashboard color.

Question 8

You notice your Looker dashboard is showing duplicate data. What is the most likely cause?

Accepted Answer

Fan-out due to a join without correctly defined primary keys.. Duplicate data in a Looker dashboard is most commonly caused by fan-out, which occurs when a join is performed without correctly defined primary keys, leading to multiple rows for each original row. This results in inflated counts and duplicate records in the visualization. Ensuring proper primary key definitions in LookML prevents this.

Answer

The data is cached in the browser.

Answer

The user is logged in twice.

Answer

The BigQuery table is corrupted.

Question 9

When creating a dashboard in Looker Studio, which connector type allows you to connect to an arbitrary SQL query?

Accepted Answer

Custom query.. The Custom Query connector in Looker Studio lets you paste an arbitrary SQL statement and use its result set as a data source, which is exactly what is needed when no single table or view provides the required shape. It supports parameters and works against BigQuery, Cloud SQL, and other SQL-backed sources.

Answer

Direct table link.

Answer

LookML model connector.

Answer

Spreadsheet connector.

Question 10

You are writing a complex BigQuery query and need to define a temporary table to use later in the same query. What is the most efficient syntax?

Accepted Answer

WITH clause (CTE).. The WITH clause, also known as a Common Table Expression (CTE), defines a temporary named result set that can be referenced later in the same query. It is the most efficient and readable syntax for complex queries because it avoids repeating subqueries and allows modular composition without persisting data.

Answer

Nested subqueries.

Answer

Variable declaration.

Answer

CREATE TABLE AS SELECT.

Question 11

You have a Looker Studio report connected to a BigQuery table that contains millions of rows. The report takes a long time to load and often times out. You need to improve performance without changing the underlying data. What should you do?

Accepted Answer

Enable BigQuery BI Engine and set up a reservation for the dataset used by the report.. BI Engine provides an in-memory cache that accelerates queries from Looker Studio, reducing latency and preventing timeouts. It integrates seamlessly with BigQuery and requires no data duplication. The other options either do not improve performance or introduce impractical workarounds that fail with large datasets.

Answer

Set the Looker Studio report to use 'Extract data' with a refresh schedule of every 15 minutes.

Answer

Increase the number of Looker Studio data sources by adding duplicate connections to the same table.

Answer

Schedule a daily extract of the BigQuery table into a Google Sheet and connect Looker Studio to the Sheet.

Question 12

A data analyst needs to create a Looker Studio report that shows sales data filtered by region. The report must allow users to select one or more regions from a drop-down menu, and the selection should update all charts on the page. Which control should be added to the report?

Accepted Answer

A filter control with the region dimension as the control field.. A filter control is designed for interactive filtering by dimension values and applies to all charts on the page that share the same data source. Using the region dimension allows multi-select and dynamically updates visualizations, directly fulfilling the requirement for a drop-down that filters all charts.

Answer

A data control that allows users to switch between different data sources.

Answer

A date range control with a custom date dimension.

Answer

A chart-level filter applied to each chart individually.

Question 13

You need to create a visualization in Looker Studio that shows the proportion of total sales by product category. Which chart type is most appropriate?

Accepted Answer

Pie chart. A pie chart is specifically designed to show parts of a whole, with each slice representing a category's contribution to the total. When configured with product category as the dimension and sales as the metric, it visually communicates the proportion of total sales for each category, which is exactly what the scenario requires.

Answer

Scorecard

Answer

Time series chart

Answer

Geo chart

Question 14

You are building a Looker Studio report and need to display a calculated field that shows the profit margin as a percentage. The data source contains fields for revenue and cost. Which expression should you use for the calculated field?

Accepted Answer

(SUM(revenue) - SUM(cost)) / SUM(revenue). To calculate profit margin as a percentage, you need to aggregate revenue and cost separately, then compute (total revenue - total cost) / total revenue. This ensures the result reflects the overall profitability across all rows, not an average of per-row margins. The expression using SUM for both revenue and cost correctly implements this.

Answer

SUM(revenue - cost) / SUM(revenue)

Answer

SUM(revenue) / SUM(cost) - 1

Answer

AVG(revenue - cost) / AVG(revenue)

Question 15

Your team stores customer feedback in a BigQuery table with a column `feedback_text`. You need to count how many times each of the words 'fast', 'slow', and 'broken' appears across all feedback rows. You want to run this as a single SQL query in BigQuery. Which approach should you use?

Accepted Answer

Use the `REGEXP_EXTRACT_ALL` function with a pattern that matches each target word, then unnest the resulting array and group by the extracted word.. To count every occurrence of specific words across all feedback rows, you need a method that extracts each match individually and then aggregates. REGEXP_EXTRACT_ALL with a pattern matching any of the target words returns an array of all matches per row; unnesting and grouping by the extracted word gives the total count per word. This handles multiple occurrences per row and punctuation correctly.

Answer

Use the `ML.NGRAMS` function from BigQuery ML to tokenize the text and then count the n-grams.

Answer

Use the `SPLIT` function on each feedback_text row with a space delimiter, then use `UNNEST` and filter with a `WHERE` clause for the three words.

Answer

Use `COUNTIF` with three separate conditions in a single SELECT statement, such as `COUNTIF(feedback_text LIKE '%fast%')`.