SnowPro Core Certification — Question 1156

Which Snowflake keywords help retrieve data without the need to completely scan a table? (Choose two.)

Answer options

• A. TOP [n]
• B. LIMIT
• C. FETCH
• D. SAMPLE
• E. TABLESAMPLE

Correct answer: D, E

Explanation

The correct answers, D (SAMPLE) and E (TABLESAMPLE), refer to methods that allow sampling of data from a table, which avoids the need for a full table scan. Options A (TOP [n]), B (LIMIT), and C (FETCH) are used to restrict the number of rows returned but do not provide sampling capabilities.