SnowPro-Core Free Practice Test

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

1. A. The global privilege create task is required to create a new task.
2. B. Tasks are created at the Application level and can only be created by the Account Admin role.
3. C. Many Snowflake DDLs are metadata operations only, and create task DDL can be executed without virtual warehouse requirement or task specific grants.
4. D. The role must have access to the target schema and the create task privilege on the schema itself.

Correct Answer: D
All tasks in a simple tree must have the same task owner (i.e. a single role must have the OWNERSHIP privilege on all of the tasks in the tree). All tasks in a simple tree must exist in the same schema.
https://docs.snowflake.com/en/user-guide/tasks-intro.html#creating-tasks

- (Exam Topic 3)
How does Snowflake Fail-safe protect data in a permanent table?

1. A. Fail-safe makes data available up to 1 day, recoverable by user operations.
2. B. Fail-safe makes data available for 7 days, recoverable by user operations.
3. C. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
4. D. Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

Correct Answer: C

- (Exam Topic 1)
True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

1. A. True
2. B. False

Correct Answer: B
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html

- (Exam Topic 3)
Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

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

Correct Answer: B
Reference: https://docs.snowflake.com/en/sql-reference/sql/get.html

- (Exam Topic 1)
What happens when a Data Provider revokes privileges to a Share on an object in their source database?

1. A. The object immediately becomes unavailable for all Data Consumers
2. B. Any additional data arriving after this point in time will not be visible to Data Consumers
3. C. The Data Consumers stop seeing data updates and become responsible for storage charges for the object
4. D. A static copy of the object at the time the privilege was revoked is created In the Data Consumers' accounts

Correct Answer: A