SnowPro-Core Free Practice Test

- (Exam Topic 1)
What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement? Select one.

1. A. INITTIALLY_SUSPENDED = TRUE/FALSE
2. B. START_AFTCR_CREATE = TRUE/FALSE
3. C. START_TTIME = 60 // (seconds from now)
4. D. START.TIME = CURRENT.DATE()

Correct Answer: A

- (Exam Topic 2)
What Snowflake role must be granted for a user to create and manage accounts?

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

Correct Answer: A
https://docs.snowflake.com/en/user-guide/security-access-control-considerations.html

- (Exam Topic 3)
Which statement describes how Snowflake supports reader accounts?

1. A. A reader account can consume data from the provider account that created it and combine it with its own data.
2. B. A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.
3. C. The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.
4. D. The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

Correct Answer: C

- (Exam Topic 2)
Which of the following conditions must be met in order to return results from the results cache? (Select TWO).

1. A. The user has the appropriate privileges on the objects associated with the query
2. B. Micro-partitions have been reclustered since the query was last run
3. C. The new query is run using the same virtual warehouse as the previous query
4. D. The query includes a User Defined Function (UDF)
5. E. The query has been run within 24 hours of the previously-run query

Correct Answer: AE

- (Exam Topic 2)
Which cache type is used to cache data output from SQL queries?

1. A. Metadata cache
2. B. Result cache
3. C. Remote cache
4. D. Local file cache

Correct Answer: B
https://community.snowflake.com/s/article/Caching-in-Snowflake-Data-Warehouse