- (Exam Topic 3)
Which command can be used to load data files into a Snowflake stage?

1. A. JOIN
2. B. COPY INTO
3. C. PUT
4. D. GET

Correct Answer: C

- (Exam Topic 3)
Which parameter can be used to instruct a COPY command to verify data files instead of loading them into a specified table?

1. A. STRIP_NULL_VALUES
2. B. SKIP_BYTE_ORDER_MARK
3. C. REPLACE_INVALID_CHARACTERS
4. D. VALIDATION_MODE

Correct Answer: D
https://docs.snowflake.com/en/sql-reference/sql/copy-into-table.html
VALIDATION_MODE = RETURnN__ROWS | RETURN_ERRORS | RETURN_ALL_ERRORS
String (constant) that instructs the COPY command to validate the data files instead
of loading them into the
specified table; i.e. the COPY command tests the files for errors but does not load them. The command validates the data to be loaded and returns results based on the validation option specified:

- (Exam Topic 1)
Which of the following are common use cases for zero-copy cloning? Choose 3 answers

1. A. Quick provisioning of Dev and Test/QA environments
2. B. Data backups
3. C. Point in time snapshots
4. D. Performance optimization

Correct Answer: ABC
Reference: https://community.snowflake.com/s/question/0D50Z00009C3VlMSAV/zero-copy-cloning

- (Exam Topic 2)
Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

1. A. SCIM
2. B. Federated authentication
3. C. TLS 1.2
4. D. Key-pair authentication
5. E. OAuth
6. F. OCSP authentication

Correct Answer: BDE

- (Exam Topic 3)
What file formats does Snowflake support for loading semi-structured data? (Choose three.)

1. A. TSV
2. B. JSON
3. C. PDF
4. D. Avro
5. E. Parquet
6. F. JPEG

Correct Answer: BDE