Exam SOL-C01 Topic 2 Question 2 Discussion

Actual exam question for Snowflake's SOL-C01 exam
Question #: 2
Topic #: 2

You are responsible for managing a Snowflake environment where data is loaded from various external sources. You want to use Snowsight to quickly identify all tables within a specific database and schema that have not been loaded in the last 7 days. Which of the following methods, or combination of methods, provides the most efficient and accurate way to achieve this using Snowsight features?

A. Use the Snowsight Search functionality to search for tables within the database and schema.
Then, manually inspect each table's 'Last Modified' timestamp in the table details panel. B. Query the Snowflake Information Schema using the Snowsight SQL Worksheet to retrieve the
'TABLES' view and filter by 'last_altered' column. Then navigate to the table in Snowsight to verify. C. Use the Snowsight Data > Databases navigation to select the database and schema. Filter the table list by 'Last Modified' date using the built-in filter options. If filter is not avaialbe manually inspect each table by scrolling table by table. D. Execute a 'SHOW TABLES' command in the Snowsight SQL Worksheet and manually inspect the
'last_altered' column in the results. E. Use the Snowsight Data > Databases navigation to select the database and schema. Then, use the Snowsight SQL Worksheet to create a custom dashboard displaying a table with columns for
'table_name' and 'last_altered' by querying the Information Schema 'TABLES' view and filter by the last_altered within the last 7 days.

Suggested Answer: B,E Vote an answer

Options B and E offer the most efficient and accurate solutions. Option B utilizes the Information Schema, a built-in Snowflake resource, and a SQL query within Snowsight to directly retrieve the required information. Filtering by the 'last_altered' column provides a precise list of tables not loaded in the last 7 days. Option E is the correct and more convenient. Creating a custom dashboard using the Information Schema within Snowsight is the most convenient way of monitoring data. Option A requires manual inspection, which is inefficient. Option C doesn't provide precise filtering. Option D will retrieve the 'last_altered' value but then manual filtering required.

by Afra at Feb 24, 2026, 12:44 AM

Limited Time Offer

15%

Off

Get Premium SOL-C01 Questions as Interactive Self Test Engine or PDF

Comments

0 Satisfied Customers

0 Shares

0 Demo Downloads

10 Years in Business