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

Question

You are exploring a large dataset in Snowflake with millions of rows. You want to get a quick overview of the data types and basic statistics for each column in a table named 'ORDERS in the 'SALES SCHEMA' schema of the 'RETAIL DB' database. Which of the following methods provides the most efficient and comprehensive overview of the data without requiring you to write complex SQL queries?

Options

• AUse the DESCRIBE TABLE command to display the column definitions.
• BUse the Snowflake web interface to navigate to the table and view the 'Columns' tab.
• CUse the `SELECT FROM LIMIT 10;' command followed by manually inspecting the data types.
• DUse the `SELECT column_name, data_type FROM INFORMATION SCHEMA.COLUMNS
• EUse Snowflake's data profiling features within Snowsight, selecting the 'Orders' table and viewing

Explanation

Snowsight's data profiling feature automatically provides data types, statistics (min, max, average, etc.), and histograms without requiring any SQL. 'DESCRIBE TABLE only gives column definitions, not statistics. Viewing the 'Columns' tab in the web interface gives column definitions. 'SELECT LIMIT Iff only shows sample data, not data types of all columns. Using the 'INFORMATION_SCHEMR provides only the data types but not any statistics. Snowflake's data profiling within Snowsight gives both. So, 'E' is the correct answer.

No community discussion yet for this question.