SnowPro-Core Free Practice Test

- (Exam Topic 3)
A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?

1. A. Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
2. B. The transient table version cannot be retrieved after 24 hours.
3. C. Contact Snowflake Support to have the data retrieved from Fail-safe storage.
4. D. Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

Correct Answer: B

- (Exam Topic 2)
What is the MOST performant file format for loading data in Snowflake?

1. A. CSV (Unzipped)
2. B. Parquet
3. C. CSV (Gzipped)
4. D. ORC

Correct Answer: A

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