Google Cloud Professional Data Engineer PDE — Topic 1 Question 320

Question

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?

Accepted Answer

Correct answer: D. The correct answer is D. Option D: Use BigQuery BI Engine to accelerate query performance by caching frequently accessed data. BigQuery BI Engine accelerates dashboards with an in-memory analysis layer. BigQuery is a serverless, petabyte-scale data warehouse for fast SQL analytics with no infrastructure to manage.

Google Cloud Professional Data Engineer PDE — Question 320