COF-C02 Question 75

Community Discussion

Written by other learners. Comments can disagree with the marked answer — check the official documentation when in doubt.

• Chose ACD1

  B talks about refrequent single row DMLs, which goes against columnar principle

• Chose ACD4

  A. VARIANT “null” values are not the same as SQL NULL values: In Snowflake, a VARIANT type can store semi-structured data like JSON. A JSON null is distinct from an SQL NULL. JSON null is treated as a valid value in Snowflake, while SQL NULL represents the absence of a value. B. It is recommended to do frequent, single row DMLs: This is false. Snowflake is optimized for bulk operations, and frequent single-row DMLs (e.g., INSERT, UPDATE, DELETE) are not recommended as they can lead to inefficiencies and higher costs. C. It is recommended to validate the data before loading into the Snowflake target table: This is true. Validating data before loading ensures data quality and avoids errors or inconsistencies in the target table. D. It is recommended to use staging tables to manage MERGE statements: This is true. Staging tables are often used to prepare and validate data before applying MERGE operations, which helps ensure data integrity and efficiency. Correct Choices: A, C, D

• 1

  ACD are correct