SnowPro Core Certification — Question 634

A Snowflake user has two tables that contain numeric values and is trying to find out which values are present in both tables.

Which set operator should be used?

Answer options

• A. INTERSECT
• B. MERGE
• C. MINUS
• D. UNION

Correct answer: A

Explanation

The INTERSECT operator is used to return the common values between two tables, making it the correct choice. MERGE is for combining data from two sources, MINUS is for finding values in one table that are not in another, and UNION combines all values from both tables without filtering for commonality.