SOL-C01 · Question #51
SOL-C01 Question #51: Real Exam Question with Answer & Explanation
The correct answer is B: ACCOUNT USAGE.TASK HISTORY. The HISTORY view provides detailed information about the execution of tasks, including their start and end times, warehouse used, and status. This allows you to directly analyze the resource consumption of individual tasks. HISTORY is useful for understanding the overall warehous
Question
You are responsible for managing a Snowflake environment where data loading and transformation are performed. You need to monitor the resource consumption of various tasks and identify potential bottlenecks. Which of the following INFORMATION SCHEMA views or functions would be MOST helpful for identifying the warehouse consumption and execution time of individual tasks?
Options
- AACCOUNT USAGE.WAREHOUSE LOAD HISTORY
- BACCOUNT USAGE.TASK HISTORY
- CACCOUNT_USAGE.QUERY HISTORY and join it with ACCOUNT_USAGE.WAREHOUSE
- DDATABASE STORAGE USAGE HISTORY
- EINFORMATION SCHEMA.TABLES
Explanation
The HISTORY view provides detailed information about the execution of tasks, including their start and end times, warehouse used, and status. This allows you to directly analyze the resource consumption of individual tasks. HISTORY is useful for understanding the overall warehouse utilization, but not necessarily specific to tasks. Combining 'QUERY_HISTORY' and 'WAREHOUSE_EVENTS provides broader query level warehouse usage but is more complex than simply using TASK_HISTORY. is about storage not compute, and TABLES just provides
Topics
Community Discussion
No community discussion yet for this question.