Google Cloud Professional Data Engineer Exam

How can you resolve the issue of excessive concurrent queries when running reports and interactive queries on BigQuery?

1. Run all queries in interactive mode.

2. Create a yearly reservation of BigQuery slots.

3. Run the report generation queries in batch mode.

4. Create a view to run the queries.

The correct answer is: Run the report generation queries in batch mode.

Running report generation queries in batch mode is a beneficial approach to managing excessive concurrent queries in BigQuery. When a query is executed in batch mode, it is optimized for higher efficiency and lower priority, which enables it to run without competing for resources with interactive queries. This helps reduce the load on BigQuery during peak usage times and allows interactive queries to run more smoothly since they are prioritized. Batch queries are generally processed sequentially, which means they can effectively utilize the available resources over time without overwhelming the system at any moment. This mode is particularly useful for report generation tasks that do not require immediate results, as it allows for better resource management and reduces the likelihood of experiencing query bottlenecks. Utilizing batch mode for report generation also aligns well with the typical use cases of reports that can be run at scheduled intervals rather than needing real-time results, making it a practical solution for organizations that need to balance multiple querying needs.