Get startedGet started for free

Quiz 3 Question 3

A data analyst complains that their queries on a large, multi-year historical sales data table are slow and costly. The queries often filter by the transaction date and group by product category. Which of the following BigQuery features could be used to improve query performance and reduce costs for this specific workload? (Select all that apply)

This exercise is part of the course

Build Streaming Data Pipelines on Google Cloud

View Course

Hands-on interactive exercise

Turn theory into action with one of our interactive exercises

Start Exercise