nerdexam
Snowflake

SOL-C01 · Question #153

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 sch

Sign in or unlock SOL-C01 to reveal the answer and full explanation for question #153. The question stem and answer options stay visible for context.

Data Loading and Unloading

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

Unlock SOL-C01 to see the answer

You've previewed enough free SOL-C01 questions. Unlock SOL-C01 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.

Topics

#Snowsight SQL Worksheet#INFORMATION_SCHEMA#Table activity tracking#Data load monitoring
Full SOL-C01 Practice