Objective 4.1
PDEPreparing data for visualization
Objective 4.1 sits in Preparing and using data for analysis, which carries 15% of the Data Engineer exam. The questions below are original, written from the official objective title above, and each explanation cites the Google Cloud page it rests on.
Objective title verbatim from the official objectives. Google Cloud exam page ↗
A worked example
Shown solved, with the whole explanation open: this is what every question here carries.
An analyst reports that a dashboard querying a wildcard table set gets no speedup at all from BI Engine. What accounts for that?
Correct.
Concept
Acceleration applies to a defined set of query shapes. A construct outside that set still runs correctly, but at ordinary cost.
Why C
Queries referencing wildcard tables are not supported by BI Engine and do not benefit from acceleration. External tables, row-level security and non-SQL user-defined functions are unsupported as well.
Source
Google Cloud: Introduction to BI Engine, checked August 2026You use wildcards in your queries : queries referencing wildcard tables aren't supported by BI Engine and don't benefit from acceleration. You require BigQuery features unsupported by BI Engine : while BI Engine supports most SQL functions and operators, unsupported features include external tables, row-level security, and non-SQL user-defined functions.
Now you: objective 4.1 questions
No account needed. The explanation opens when you answer.
Sample question 1 of 3
A company runs dashboards from three projects across two regions and asks how BI Engine memory is allocated between them. How is the allocation scoped?
Sample question 2 of 3
A team uses preferred tables and finds that a dashboard query joining a fact table to a lookup table is never accelerated. What is the likely cause?
Sample question 3 of 3
An engineer adds a materialized view to the BI Engine preferred tables list and queries against it remain slow. What is still missing?
Full Data Engineer question bank coming
We’re writing the complete bank from the official objectives right now. Leave your email and we’ll tell you when it ships, nothing else, ever.
Read the sources
These are the official pages the questions above cite. Reading them is studying the objective from the primary source, which is what the explanations point you toward anyway.