SnowPro-Core Free Practice Test

- (Exam Topic 2)
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

1. A. Via the Snowflake Web Interface (Ul)
2. B. Via the data_share=true parameter
3. C. Via SQL commands
4. D. Via Virtual Warehouses

Correct Answer: AC
Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html

- (Exam Topic 3)
What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

1. A. Default Time Travel Retention is set to 0 days.Maximum Time Travel Retention is 30 day
2. B. Fail Safe retention time is 1 day.
3. C. Default Time Travel Retention is set to 1 day.Maximum Time Travel Retention is 365 day
4. D. Fail Safe retention time is 7 days.
5. E. Default Time Travel Retention is set to 0 days.Maximum Time Travel Retention is 90 day
6. F. Fail Safe retention time is 7 days.
7. G. Default Time Travel Retention is set to 1 day.Maximum Time Travel Retention is 90 day
8. H. Fail Safe retention time is 7 days.
9. I. Default Time Travel Retention is set to 7 days.Maximum Time Travel Retention is 1 da
10. J. Fail Safe retention time is 90 days.
11. K. Default Time Travel Retention is set to 90 days.Maximum Time Travel Retention is 7 day
12. L. Fail Safe retention time is 356 days.

Correct Answer: D

- (Exam Topic 3)
Which data type can store more than one type of data structure?

1. A. JSON
2. B. BINARY
3. C. VARCHAR
4. D. VARIANT

Correct Answer: D

- (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 3)
What is the following SQL command used for? Select * from table(validate(t1, job_id => '_last'));

1. A. To validate external table files in table t1 across all sessions
2. B. To validate task SQL statements against table t1 in the last 14 days
3. C. To validate a file for errors before it gets executed using a COPY command
4. D. To return errors from the last executed COPY command into table t1 in the current session

Correct Answer: D