SOL-C01 practice question 15 of 30

What information can be obtained by describing a table in Snowflake? (Choose any 3 options)

Full set: 214 questions
Answer options
A: Column names and data types Correct answer
B: Table constraints Correct answer
C: Table Origin
D: Indexes and keys
Correct Answer:
A. Column names and data types; B. Table constraints
Explanation

The DESCRIBE TABLE command in Snowflake returns column-level metadata including column names, data types, nullable constraints, default values, primary/unique key indicators, and comments. While it shows constraint information like NOT NULL and key designations, Snowflake doesn't maintain traditional indexes as it uses automatic micro-partitioning. Table origin or lineage information requires different commands like GETDDL or query history.

Why Incorrect

C. Table Origin - DESCRIBE doesn't show table creation source or lineage information; this requires other commands.
D. Indexes and keys - Snowflake doesn't use traditional indexes; only key constraints are shown, not indexes.

References

1. Snowflake Documentation - SQL Command Reference, DESCRIBE TABLE section, Tables and Views chapter

2. Snowflake Documentation - Key Concepts & Architecture, Micro-partitions & Data Clustering section

3. Snowflake Documentation - Working with Tables, Table Structures and Data Types chapter

Scroll to Top