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 SCH

Question

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

• A
  20% (7)
• B
  6% (2)
• C
  3% (1)
• D
  9% (3)
• E
  63% (22)

Explanation

Option E is correct because Snowflake's Snowsight data profiling feature provides an automatic, visual summary of column data types, null counts, distinct values, min/max, and distribution histograms - all without writing a single SQL query, making it the most efficient and comprehensive approach for a quick overview.

Why the distractors fall short:

• A (DESCRIBE TABLE) shows column names and data types but gives no statistics (nulls, ranges, distributions).
• B (Columns tab in web UI) displays schema metadata similar to DESCRIBE - structural info only, no statistical summary.
• C (SELECT ... LIMIT 10) gives a tiny sample requiring manual inspection, which is neither efficient nor comprehensive for millions of rows.
• D (INFORMATION_SCHEMA.COLUMNS) retrieves metadata about column definitions but requires query writing and returns no statistical profiling data.

Memory tip: Think of the letters E = Explore - Snowsight's profiling is the Explorer's tool, giving you the full map (statistics + types + distributions) automatically, while the other options give you only a street sign (schema info) or a small window (LIMIT 10).

No community discussion yet for this question.