Courseiva
← PDE
Full test
Preparing and Using Data for Analysis →mediumMultiple ChoiceObjective-mapped

PDE Preparing and Using Data for Analysis Practice Question

Your team uses Looker Studio to build dashboards on top of BigQuery. The dashboards are slow when filtering on a high-cardinality dimension (e.g., user ID). You want to improve performance without changing the underlying BigQuery table design. Which action should you take?

Answer choices

Why each option matters

Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.

Correct answer & explanation

✓

Enable BigQuery BI Engine on the project.

BI Engine automatically caches the BigQuery tables in memory for Looker Studio, accelerating queries on any dimension. Enabling BI Engine on the project will improve dashboard performance.

Answer analysis

Option-by-option breakdown

For each option: why learners choose it and why it is or isn't the right answer here.

  • ✗

    Create a clustered table on the user ID column.

    Why it's wrong here

    Clustering helps but requires table redesign; the stem says not to change the underlying table.

  • ✗

    Apply a filter to limit data to the last month only.

    Why it's wrong here

    Filtering reduces data but changes the user experience; not a performance optimization for all cases.

  • ✓

    Enable BigQuery BI Engine on the project.

    Why this is correct

    BI Engine accelerates queries by caching data in memory, improving Looker Studio dashboard performance.

  • ✗

    Use Looker Studio's extract data functionality.

    Why it's wrong here

    Extracts create a static snapshot, which may not be suitable for real-time data and adds maintenance.

About these practice questions

This PDE question is part of Courseiva's 890-question bank — original exam-style content with full explanations and wrong-answer analysis, never real exam questions or exam dumps. Learn why practice questions differ from exam dumps →

How Courseiva writes practice questions · Editorial policy

JA

Written by Johnson Ajibi, MSc IT Security

Senior Network & Security Engineer · founder of Courseiva

This PDE practice question is part of Courseiva's free Google Cloud certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PDE exam.