SOL-C01 Question #153: Real Exam Question with Answer & Explanation

Question

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?

Options

• AUse the Snowsight Search functionality to search for tables within the database and schema.
• BQuery the Snowflake Information Schema using the Snowsight SQL Worksheet to retrieve the
• CUse the Snowsight Data > Databases navigation to select the database and schema. Filter the
• DExecute a 'SHOW TABLES' command in the Snowsight SQL Worksheet and manually inspect the
• EUse the Snowsight Data > Databases navigation to select the database and schema. Then, use

Explanation

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

No community discussion yet for this question.