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 1)
In which layer of its architecture does Snowflake store its metadata statistics? Select one.

1. A. Storage Layer
2. B. Compute Layer
3. C. Database Layer
4. D. Cloud Service Layer

Correct Answer: D
Reference: https://hevodata.com/blog/snowflake-architecture-cloud-data-warehouse/

- (Exam Topic 3)
What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

1. A. Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
2. B. All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.
3. C. The ACCOUNTADMIN role must be granted to only one user.
4. D. Assign the ACCOUNTADMIN role to at least two users, but as few as possible.
5. E. All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

Correct Answer: AD

- (Exam Topic 1)
Which of the following are best practices for users with the SYSADMIN/ACCOUNTADMIN roles? Choose 3 answers

1. A. Their default role should be set to SYSTEMADMIN (the lower of the two)
2. B. They should not set up multi_Factor Authentication (MFA)—as administrator they may need to change the MFA settings and those enrolled in MFA are unable to do so
3. C. They should only access and 'step into' the ACCOUNTADMIN role temporarily, as needed to complete a specific operation
4. D. They should ensure all database objects in the account are owned by the ACCOUNTADMIN role
5. E. They should use the SYSADMIN role to perform administrative work on database objects

Correct Answer: ACE

- (Exam Topic 2)
The fail-safe retention period is how many days?

1. A. 1 day
2. B. 7 days
3. C. 45 days
4. D. 90 days

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