Scenario: Your company runs a multi-region analytics platform using BigQuery as the data warehouse. The platform ingests real-time streaming data from multiple sources using Pub/Sub and Dataflow. Business stakeholders require: - Low-latency query performance for dashboards. - Cost optimization while handling large-scale queries. - Efficient partitioning and clustering to improve query performance. Question: How should you optimize BigQuery to meet these business requirements?