Home Microsoft Exams Google Cloud Exams

Loading page

Curious about new developments and updates? Follow our social media.

Get a free certification question every week.

Microsoft Exams

AZ-104 Administrator
AZ-204 Developer
AZ-900 Fundamentals
All Microsoft Exams

Google Cloud Exams

Associate Data Practitioner
All Google Cloud Exams

Terms Privacy Cookies About Pricing

© 2026 StudyCerts. All rights reserved.

StudyCerts is an independent service and is not affiliated with, endorsed by, or sponsored by any certification body or cloud provider.

Loading page

Home
Google Cloud Exams
Professional Cloud Data Engineer
BigQuery features for business intelligence (e.g., BI Engine, materialized views)
A retail company uses Looker to provide interactive executiv…

Professional Cloud Data Engineer

professional-cloud-data-engineer

Advanced

Prepare and test your skills

Description
Sample Question
Free Trial
Practice Test

Advanced

Prepare and test your skills

Description
Sample Question
Free Trial
Practice Test

Select Bi Engine Acceleration Strategy Dashboards

Section: BigQuery features for business intelligence (e.g., BI Engine, materialized views)

Worked example. The correct answer is already marked and every option is explained below, so there is nothing to select here. To answer questions yourself, start the free trial.

...

...

...

...

...

Explanations

...

View source documentation

Related questions

Keep the momentum going with these hand-picked practice scenarios

AdvancedProfessional Cloud Data Engineer

A business intelligence team uses Looker Studio to query a 600 GB partitioned and clustered sales dataset stored in BigQuery. Users report that interactive dashboard filters on recent summary metrics (last 30 days, totaling ~20 GB) perform with sub-second response times, but ad-hoc multi-year queries spanning the full 600 GB dataset experience significant latency due to queries partially falling back to standard BigQuery slot execution. You have a 30 GB BigQuery BI Engine reservation provisioned in the project. You need to ensure consistent, sub-second query performance across both dashboard filters and broader historical aggregation queries while minimizing BI Engine reservation costs. What should you do?

BigQuery features for business intelligence (e.g., BI Engine, materialized views)

AdvancedProfessional Cloud Data Engineer

A data engineering team manages a real-time analytics web application deployed on a Managed Instance Group (MIG) behind an external Application Load Balancer. During periods of heavy data ingestion, some virtual machines become temporarily busy and are slow to respond to requests. The current configuration uses a single, aggressive health check for both the load balancer and the MIG's autohealing policy. As a result, the autohealer mistakes these busy instances for failed instances and prematurely recreates them, which reduces overall system availability and causes cascading failures. What should you do to ensure the system gracefully handles temporary load spikes while still automatically recovering from true application failures?

Designing system for fault tolerance and managing restarts

AdvancedProfessional Cloud Data Engineer

An enterprise is designing a cost-effective data lakehouse architecture on Google Cloud. Several petabytes of structured analytical data are maintained in open columnar formats (such as Parquet) across Cloud Storage buckets and external cloud object stores. The security team requires that analysts query the data using standard BigQuery SQL and authorized views with fine-grained access controls, while strictly prohibiting granting end users direct object read permissions (storage.objects.get) to the underlying storage buckets. Which architecture should you implement to meet these requirements?

Choosing managed services (e.g., BigQuery, BigLake, AlloyDB, Bigtable, Spanner, Cloud SQL, Cloud Storage, Firestore, Memorystore)

AdvancedProfessional Cloud Data Engineer

An enterprise is implementing a federated data governance model on Google Cloud to support decentralized domain teams. A strategic business domain requires specialized data infrastructure components that are not currently available on the central self-service data platform's roadmap. The domain team wants to build and operate its own custom platform components without delaying its data product deliverables, while the organization's governance board requires consistent security, metadata standards, and policy enforcement across all domains. Which operating and accountability framework should the organization implement?

Building a federated governance model for distributed data systems

AdvancedProfessional Cloud Data Engineer

An enterprise data architect is designing an automated de-identification pipeline using Sensitive Data Protection before ingesting a sensitive dataset into BigQuery. The source dataset contains four key fields with distinct compliance, system, and analytical constraints: account_number: A fixed 10-digit numeric string that must be ingested by a legacy downstream application requiring strict 10-digit numeric format preservation, while also supporting two-way re-identification by security administrators. user_id: A customer identifier required for multi-table analytical joins across historical datasets; it requires two-way re-identification and maximum cryptographic security without character set or length preservation constraints. user_age: A quasi-identifier that must be generalized into discrete intervals (such as 20–29, 30–39) to reduce re-identification risk under k-anonymity requirements while retaining demographic utility. user_pin: A 4-digit secret that must never be reversible under any circumstances, but must maintain referential integrity across analytical queries. Which combination of Sensitive Data Protection transformational methods should the architect select for each respective column?

Privacy (e.g., strategies to handle personally identifiable information)

IntermediateProfessional Cloud Architect

A financial services organization is implementing customer-managed encryption keys (CMEK) using Cloud Key Management Service (Cloud KMS) to protect data across several Cloud Storage buckets. The compliance team requires a strict separation of duties and the enforcement of least privilege across cryptographic assets: Key administrators must create, rotate, and manage keys and permissions, but must be prevented from encrypting or decrypting data payloads. The Cloud Storage service agent must be capable of encrypting and decrypting data using the cryptographic keys, but must have no administrative privileges over key configurations. Access should be scoped to the minimal necessary resource level. Which IAM role configuration should you implement to satisfy these requirements?

Managing customer-managed encryption keys with Cloud Key Management Service (Cloud KMS)

Want more questions like this?

Get a free certification question every week.

Last updated August 27, 2026

Are you ready for the Professional Cloud Data Engineer?

50 questions in the full practice test

More BigQuery features for business intelligence (e.g., BI Engine, materialized views) practice questions

Get a free certification question with a full explanation every week.

Professional Cloud Data Engineer

Provider: Google Cloud
Passing score: 70%
Questions: 50
Duration: 90 minutes

Other sections in this exam

Designing data processing systems
Ingesting and processing the data
Storing the data
Preparing and using data for analysis
Maintaining and automating data workloads

Ask Scout

Still curious? Scout, our AI tutor, can explain this concept further and answer your follow-up questions.

A retail company uses Looker to provide interactive executive dashboards over a large BigQuery dataset that receives continuous real-time transaction updates. Business analysts frequently explore the data by applying diverse, dynamic filters and aggregations across various combinations of store locations, product categories, and transaction timestamps.

The engineering team must meet the following requirements:

Deliver sub-second query response times for interactive, ad-hoc dashboard exploration without requiring fixed pre-aggregated views.
Ensure query results reflect incoming real-time streaming data with zero manual pipeline maintenance.
Minimize query execution slot utilization during peak dashboard usage.

Which acceleration strategy should the data engineering team implement?

Rely on BigQuery query result caching and configure Looker to reuse cached query results for 24 hours.

Create a set of BigQuery Materialized Views covering all possible combinations of store, product, and timestamp dimensions.

Configure Looker Persistent Derived Tables (PDTs) to pre-aggregate transaction metrics on an hourly cron schedule.

Provision a BigQuery BI Engine reservation in the dataset location and optionally specify the transaction table as a preferred table.

Rely on BigQuery query result caching and configure Looker to reuse cached query results for 24 hours.

Create a set of BigQuery Materialized Views covering all possible combinations of store, product, and timestamp dimensions.

Configure Looker Persistent Derived Tables (PDTs) to pre-aggregate transaction metrics on an hourly cron schedule.

Provision a BigQuery BI Engine reservation in the dataset location and optionally specify the transaction table as a preferred table.

What BigQuery BI Engine Is

BigQuery BI Engine is a built-in, distributed in-memory analysis service that accelerates SQL queries by caching frequently accessed data in memory and using an optimized execution engine designed specifically for business intelligence (BI) and dashboard workloads.

How BI Engine Meets the Scenario Requirements

Sub-Second Interactive Queries: BI Engine stores working table partitions in vectorized, in-memory representations, enabling ultra-low latency execution for dynamic aggregations, filters, and multi-dimensional slice-and-dice queries.
Real-Time Data Freshness: BI Engine seamlessly handles table modifications and streaming inserts, ensuring that dashboard users query the latest transaction records without needing batch rebuilds or manual cache invalidations.
Slot Optimization: BI Engine processes accelerated input stages in memory without consuming standard BigQuery reservation slots, directly reducing slot contention during high-concurrency peak usage hours.
No Pipeline Overhead: It requires zero changes to underlying data pipelines or SQL models, unlike static pre-aggregation layers.

Key Advantages and Capabilities

Seamless BI Integration: Natively integrates with Looker and other visualization tools via standard BigQuery SQL.
Dynamic Acceleration Modes: Supports FULL_QUERY, FULL_INPUT, and PARTIAL_INPUT acceleration modes to optimize subquery execution automatically.
Configurable Resource Allocation: Supports preferred table assignments and granular capacity reservations (from 1 GB up to hundreds of GBs).

Why This Is Optimal

Compared to static caching or manual materialized aggregates, BI Engine excels at handling arbitrary filter combinations on streaming data while significantly reducing slot resource consumption.