Exam SnowPro Advanced Architect topic 1 question 94 discussion

Actual exam question from Snowflake's SnowPro Advanced Architect

Question #: 94
Topic #: 1

[All SnowPro Advanced Architect Questions]

The Business Intelligence team reports that when some team members run queries for their dashboards in parallel with others, the query response time is getting significantly slower.

What can a Snowflake Architect do to identify what is occurring and troubleshoot this issue?

A. Use larger warehouses to speed up the queries running in parallel. Identify the queries running in parallel using this query:
B. Increase the size of the warehouse cache to speed up concurrent queries. Identify the concurrent queries using this query:
C. Introduce multi-cluster warehouses to help with concurrent queries. Identify the concurrent queries by running this query:
D. Identify which queries are spilled to remote storage and change the warehouse parameters to address this issue. Identify the issue by running this query: