SnowPro-Core Free Practice Test

- (Exam Topic 3)
Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

1. A. USAGE
2. B. OPERATE
3. C. MONITOR
4. D. MODIFY

Correct Answer: B
Reference:
https://community.snowflake.com/s/question/0D50Z00008yHYdqSAG/auto-resume-operate-warehouse-privileg

- (Exam Topic 2)
What is a best practice after creating a custom role?

1. A. Create the custom role using the SYSADMIN role.
2. B. Assign the custom role to the SYSADMIN role
3. C. Assign the custom role to the PUBLIC role
4. D. Add__CUSTOM to all custom role names

Correct Answer: B
When creating roles that will serve as the owners of securable objects in the system, Snowflake recommends creating a hierarchy of custom roles, with the top-most custom role assigned to the system role SYSADMIN. This role structure allows system administrators to manage all objects in the account, such as warehouses and database objects, while restricting management of users and roles to the USERADMIN role.

- (Exam Topic 1)
Which are true of Snowflake roles?

1. A. All grants to objects are given to roles, and never to users
2. B. In order to do DML/DOL, a user needs to have selected a single role that has that specific access to the object and operation
3. C. The public role controls at other roles
4. D. Roles are a subset of users and users own objects In Snowflake

Correct Answer: AB

- (Exam Topic 3)
A running virtual warehouse is suspended.
What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

1. A. 1 second
2. B. 60 seconds
3. C. 5 minutes
4. D. 60 minutes

Correct Answer: B

- (Exam Topic 1)
Which of the following DML commands isn’t supported by Snowflake?

1. A. UPSERT
2. B. MERGE
3. C. UPDATE
4. D. TRUNCATE TABLE

Correct Answer: A
Reference: https://docs.snowflake.com/en/sql-reference/sql-dml.html