Which of the following statements are true of Snowflake data loading? (Choose three.)
Which of the following statements are true of Snowflake data loading? (Choose three.)
VARIANT 'null' values in Snowflake are not the same as SQL NULL values; they are handled differently in storage and retrieval, which is important to understand when working with semi-structured data. It is recommended to validate the data before loading it into the Snowflake target table to ensure data integrity, consistency, and to avoid potential errors during the load process. Using staging tables to manage MERGE statements is also recommended because it allows for intermediate processing and the handling of data updates effectively, optimizing performance and resource usage.
Frequent single row DML? Hell nah. ACD is the way to go.
Frequent Single rows on any MPP like Snowflake has always been a no no! Function of an OLTP DB
ACD are correct
ACD, Correct
Variant NULL values: https://docs.snowflake.com/en/user-guide/semistructured-considerations#label-variant-null
ACD are correct
The result must be deterministic for merge so source can be any reference data source only constraint it should create/modify unique rows
ACD is correct answer.
ACD are correct
ACD are correct