Exam SnowPro Core All QuestionsBrowse all questions from this exam
Go to Exam
Question 641

Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?

    Correct Answer: C

    The correct option is Information_schema.warehouse_load_history. This system view provides specific information on the usage of the virtual warehouse, including the wait times of queries in the queue. It helps evaluate the impact of query queuing on virtual warehouse performance by providing data on warehouse load and usage metrics such as average number of queries queued because the warehouse was overloaded (AVG_QUEUED_LOAD).

Discussion
Valcon_dooOption: B

https://docs.snowflake.com/en/user-guide/warehouses-load-monitoring

pvskbrodOption: C

AVG_QUEUED_LOAD - https://docs.snowflake.com/en/sql-reference/account-usage/warehouse_load_history

Lematthew31Option: C

The user is referring to this in particular: Query History: It keeps a record of all queries executed in your Snowflake account. This allows you to analyze the performance of individual queries, including their execution time, number of rows processed, etc. However, it does not provide specific information on the impact of query queuing on virtual warehouse performance. WAREHOUSE_LOAD_HISTORY: This system view provides specific information on the usage of the virtual warehouse, including the wait times of queries in the queue. This allows you to evaluate the impact of query queuing on virtual warehouse performance by providing data on warehouse load and usage. So, if you want to assess the impact of query queuing on virtual warehouse performance, the WAREHOUSE_LOAD_HISTORY view would be more appropriate. If you want to examine the performance of individual queries as a whole, then Query History would be more relevant

Ram9198Option: C

There is latency - WH Load history is realtime

Ram9198Option: C

Warehouse load history

fellpondOption: C

Query history is to understand queue times at query level. Warehouse load history provides this at Warehouse level. "AVG_QUEUED_LOAD - Query load value for queries queued because the warehouse was overloaded." Since question asks for Warehouse, Answer is C here.

kayuhanbidukOption: C

C is correct. https://community.snowflake.com/s/article/Understanding-Queuing

RajivnbOption: B

QUEUED_OVERLOAD_TIME NUMBER Time (in milliseconds) spent in the warehouse queue, due to the warehouse being overloaded by the current query workload. https://docs.snowflake.com/en/sql-reference/account-usage/query_history

Rajivnb

Even C seems to be correct. But, the Query History provides more information than the Load history. AVG_QUEUED_LOAD. Query load value for queries queued because the warehouse was overloaded. https://docs.snowflake.com/en/sql-reference/account-usage/warehouse_load_history

AmitsnowflakeOption: C

WAREHOUSE_LOAD_HISTORY - C AVG_RUNNING – Average number of queries executed. AVG_QUEUE_LOAD – Average number of queries queued because the warehouse was overloaded. AVG_QUEUE_PROVISION – Average number of queries queued because the warehouse was being provisioned. AVG_BLOCKED – Average number of queries blocked by a transaction lock.

MultiCloudIronManOption: B

https://www.bing.com/search?q=Which+Snowflake+object+helps+evaluate+virtual+warehouse+performance+impacted+by+query+queuing%3F&cvid=74b64bc88a2f446fa70ebdbc1402018b&aqs=edge..69i57j69i11004.4776j0j9&FORM=ANAB01&PC=U531

HeetecOption: B

B correct

romega2Option: B

correct

pvskbrodOption: B

Account_usage.query_history

happykeieiekekOption: B

B Account_usage.query_history