SnowPro-Core Free Practice Test

- (Exam Topic 1)
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

1. A. The validation_mode option is used when creating an Internal Stage
2. B. validation_mode=return_all_errors is a parameter of the copy command
3. C. The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error
4. D. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors

Correct Answer: BD
Reference: https://docs.snowflake.com/en/user-guide/data-load-bulk-ts.html

- (Exam Topic 3)
Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

1. A. Files
2. B. External tables
3. C. Secure User-Defined Functions (UDFs)
4. D. Sequences
5. E. Streams

Correct Answer: BC

- (Exam Topic 1)
What privileges are required to execute a task?

1. A. To execute a task, you need the EXECUTE TASK.
2. B. A task is an account-level object and can only be executed by the Account Admin role.
3. C. Tasks run automatically and do run under any rote.
4. D. Tasks are stored in a special database called the utility database and require EXECUTE TASK privilege in the utility database.

Correct Answer: A

- (Exam Topic 2)
What happens when a virtual warehouse is resized?

1. A. When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected
2. B. When reducing the size of a warehouse the compute resources are removed only when they are nolonger being used to execute any current statements.
3. C. The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.
4. D. Users who are trying to use the warehouse will receive an error message until the resizing is complete

Correct Answer: B

- (Exam Topic 2)
Which copy INTO command outputs the data into one file?

1. A. SINGLE=TRUE
2. B. MAX_FILE_NUMBER=1
3. C. FILE_NUMBER=1
4. D. MULTIPLE=FAISE

Correct Answer: A