A company uses Looker to build interactive dashboards on BigQuery. The dashboards run the same queries repeatedly, and the team wants to reduce latency and cost. They have already enabled BigQuery BI Engine, but some queries still take several seconds. What is the most likely reason and the best next step?

The Looker dashboards are not using the BI Engine API; switch to the BigQuery Storage API.

The queries are not eligible for BI Engine acceleration because they use non-deterministic functions; rewrite them to use deterministic functions.

The BI Engine capacity is too small; increase the BI Engine reservation size.

The queries are using JOINs that are not supported by BI Engine; use a materialized view instead.

Which of the following is a benefit of precalculating fields for visualization?

Increases the number of rows returned to the visualization tool

Eliminates the need for data governance

Reduces query complexity and improves performance

Automatically updates the underlying source data

Which tool or feature in BigQuery provides detailed information about query execution steps, such as the amount of data shuffled and the time spent in each stage?

Query execution details in the BigQuery console

The BigQuery CLI with the --dry-run flag

The INFORMATION_SCHEMA.JOBS_BY_PROJECT view

What is the primary purpose of BigQuery BI Engine?

To provide a data visualization interface within BigQuery

To automatically create materialized views for all tables

To accelerate sub-second query response times for interactive dashboards

To replace BigQuery for large analytical workloads

Google CloudProfessional Data Engineer

Domain 4Objective 1

4.1 Preparing Data for Visualization PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 2)

Part of the Preparing and using data for analysis domain, which accounts for ~15% of the PROFESSIONAL-DATA-ENGINEER exam. Google Cloud does not publish an official question count, but from its 120-minute exam (~50–80 total, ~8–12 in this domain), expect 3–4 from this objective — we provide 24 practice questions to prepare you well beyond it. (estimate)

24questions here

5free pages

7concepts

~15%of the exam

Questions 6–10

6application · medium
A company uses Looker to build interactive dashboards on BigQuery. The dashboards run the same queries repeatedly, and the team wants to reduce latency and cost. They have already enabled BigQuery BI Engine, but some queries still take several seconds. What is the most likely reason and the best next step?
Select an answer first
7foundation · easy
Which of the following is a benefit of precalculating fields for visualization?
Select an answer first
8foundation · easy
Which tool or feature in BigQuery provides detailed information about query execution steps, such as the amount of data shuffled and the time spent in each stage?
Select an answer first
9foundation · easy
What is the primary purpose of BigQuery BI Engine?
Select an answer first
10foundation · easy
A data engineer wants to precalculate a complex revenue calculation so that dashboard users can query it directly without repeating the SQL logic. Which BigQuery object should they create?
Select an answer first

Finished these 5 questions?

Review the revealed explanations, or continue through the curriculum.

Next 5 questions →Back to PROFESSIONAL-DATA-ENGINEER

Free Basic Practice is a study aid with revealable answers — not a scored exam. Examers.io is independent and not affiliated with or endorsed by Google Cloud. “PROFESSIONAL-DATA-ENGINEER” is a trademark of its owner, used for identification only.

4.1 Preparing Data for Visualization PROFESSIONAL-DATA-ENGINEER Practice Questions (Page 2)

Questions 6–10

Which of the following is a benefit of precalculating fields for visualization?

Which tool or feature in BigQuery provides detailed information about query execution steps, such as the amount of data shuffled and the time spent in each stage?

What is the primary purpose of BigQuery BI Engine?

A data engineer wants to precalculate a complex revenue calculation so that dashboard users can query it directly without repeating the SQL logic. Which BigQuery object should they create?

Keep studying — Preparing and using data for analysis