Users report slow BigQuery queries and you suspect queuing or slot contention. How should you investigate slot usage and query performance?

The correct approach is to use BigQuery administrative resource charts, which provide detailed visualizations of slot utilization, query performance, and other resource metrics over time. This allows you to identify bottlenecks and periods of high contention. Additionally, querying INFORMATIONSCHEMA views provides granular details about individual queries, including their execution statistics, slot consumption, and wait times, which is crucial for pinpointing specific slow queries. Using slot reservations (option 1) is a solution to guarantee capacity, but it's not the primary method for investigating existing slot contention. Cloud Monitoring (option 2) can provide some BigQuery metrics, but the administrative resource charts offer more specialized and detailed insights into BigQuery-specific resource usage. Cloud Logging (option 4) is for auditing access and changes, not for analyzing query performance or slot usage.