SnowPro Core Certification — Question 101

Which of the following statements are true of Snowflake data loading? (Choose three.)

Answer options

• A. VARIANT ג€nullג€ values are not the same as SQL NULL values
• B. It is recommended to do frequent, single row DMLs
• C. It is recommended to validate the data before loading into the Snowflake target table
• D. It is recommended to use staging tables to manage MERGE statements

Correct answer: A, C, D

Explanation

Option A is correct because VARIANT ג€nullג€ values are treated differently than SQL NULL values in Snowflake. Option C is valid as it emphasizes the importance of validating data before loading, which ensures data quality. Option D is also correct since using staging tables can simplify the management of MERGE operations. Option B is incorrect; frequent single row DMLs are generally not recommended as they can lead to inefficiencies.