SnowPro-Core Free Practice Test

- (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

- (Exam Topic 3)
A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?

1. A. Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
2. B. The transient table version cannot be retrieved after 24 hours.
3. C. Contact Snowflake Support to have the data retrieved from Fail-safe storage.
4. D. Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

Correct Answer: B

- (Exam Topic 2)
What is the MOST performant file format for loading data in Snowflake?

1. A. CSV (Unzipped)
2. B. Parquet
3. C. CSV (Gzipped)
4. D. ORC

Correct Answer: A