SnowPro-Core Free Practice Test

- (Exam Topic 3)
Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

1. A. Files
2. B. External tables
3. C. Secure User-Defined Functions (UDFs)
4. D. Sequences
5. E. Streams

Correct Answer: BC

- (Exam Topic 1)
Which of the following connectors are available in the Downloads section of the Snowflake web Interface (UI)?
Choose 2 answers

1. A. SnowSQL
2. B. ODBC
3. C. R
4. D. HIVE

Correct Answer: AB
Reference: https://docs.snowflake.com/en/user-guide/connecting.html

- (Exam Topic 3)
What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

1. A. The clone always stays in sync with the original table.
2. B. The clone has better query performance.
3. C. The clone is created almost instantly.
4. D. The clone will have time travel history from the original table.
5. E. The clone saves space by not duplicating storage.

Correct Answer: CE

- (Exam Topic 1)
Snowflake recommends, as a minimize, that all users with the following roles(s) should be enrolled in Multi-Factor Authentication (MFA):
Select one:

1. A. SECURITYADMIN, ACCOUNTADMIN, PUBLIC, SYSADMIN
2. B. SECURITYADMIN ACCOUNTADMIN, SYSADMIN
3. C. SECURITYADMIN, ACCOUNTADMIN
4. D. ACCOUNTADMIN

Correct Answer: D
Reference: https://docs.snowflake.com/en/user-guide/security-mfa.html

- (Exam Topic 3)
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

1. A. Enterprise
2. B. Business Critical
3. C. Standard
4. D. Virtual Private Snowflake

Correct Answer: B
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html#business-critical-edition