SnowPro-Core Free Practice Test

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

- (Exam Topic 1)
Which of the following are options when creating a Virtual Warehouse?

1. A. Auto-suspend
2. B. Auto-resume
3. C. Local SSD size
4. D. User count

Correct Answer: AB

- (Exam Topic 1)
As a best practice, clustering keys should only be defined on tables of which minimum size?

1. A. Multi-Kilobyte (KB) Range
2. B. Multi-Megabyte (MB) Range
3. C. Multi-Gigabyte (GB) Range
4. D. Multi-Terabyte (TB) Range

Correct Answer: D
Reference: https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html