Crucial Exams

GCP Professional Data Engineer Practice Question

A retail analytics team builds a Looker Studio dashboard on BigQuery. They create a materialized view that aggregates daily sales, enable BI Engine capacity, protect PII columns with policy-tag column security and dynamic masking, and grant analysts access only through an authorized view that selects non-PII columns. When analysts refresh the dashboard, how will BigQuery handle query acceleration and security?

  • BI Engine ignores materialized views and always scans the base tables, so the dashboard gains no performance benefit.

  • BI Engine returns unmasked PII data because its cache is populated before security policies are applied.

  • BI Engine caches and accelerates the authorized view, automatically leveraging the materialized view while honoring column-level security and data masking.

  • BI Engine must be disabled because policy tags or dynamic masking prevent it from caching results.

GCP Professional Data Engineer
Preparing and using data for analysis
Your Score:
Settings & Objectives
Random Mixed
Questions are selected randomly from all chosen topics, with a preference for those you haven’t seen before. You may see several questions from the same objective or domain in a row.
Rotate by Objective
Questions cycle through each objective or domain in turn, helping you avoid long streaks of questions from the same area. You may see some repeat questions, but the distribution will be more balanced across topics.

Check or uncheck an objective to set which questions you will receive.

Wipe Score
Bash, the Crucial Exams Chat Bot
AI Bot