Google Cloud Professional Data Engineer — Question 245

Your company uses Looker Studio connected to BigQuery for reporting. Users are experiencing slow dashboard load times due to complex queries on a large table. The queries involve aggregations and filtering on several columns. You need to optimize query performance to decrease the dashboard load times. What should you do?

Answer options

• A. Configure Looker Studio to use a shorter data refresh interval to ensure fresh data is always displayed.
• B. Create a materialized view in BigQuery that pre-calculates the aggregations and filters used in the Looker Studio dashboards.
• C. Implement row-level security in BigQuery to restrict data access and reduce the amount of data processed by the queries.
• D. Use BigQuery BI Engine to accelerate query performance by caching frequently accessed data.

Correct answer: B, D

Explanation

Creating a materialized view in BigQuery is effective because it pre-calculates the necessary aggregations and filters, thereby speeding up query execution for Looker Studio dashboards. While using BI Engine can also enhance performance, the materialized view specifically addresses the complex queries directly by optimizing them. The other options either do not directly improve query performance or focus on different aspects of data management rather than optimizing the queries themselves.