SnowPro-Core Free Practice Test

- (Exam Topic 3)
User INQUISITIVE_PERSON has been granted the role DATA_SCIENCE. The role DATA_SCIENCE has privileges OWNERSHIP on the schema MARKETING of the database ANALYTICS_DW.
Which command will show all privileges granted to that schema?

1. A. SHOW GRANTS ON ROLE DATA_SCIENCE
2. B. SHOW GRANTS ON SCHEMA ANALYTICS_DW.MARKETING
3. C. SHOW GRANTS TO USER INQUISITIVE_PERSON
4. D. SHOW GRANTS OF ROLE DATA_SCIENCE

Correct Answer: B

- (Exam Topic 1)
True or False: It is possible to query data from an Internal or named External stage without loading the data into Snowflake.

1. A. True
2. B. False

Correct Answer: A

- (Exam Topic 1)
Which of the following objects is not covered by Time Travel?

1. A. Tables
2. B. Schemas
3. C. Databases
4. D. Stages

Correct Answer: D
Reference: https://docs.snowflake.com/en/user-guide/data-time-travel.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 1)
Which of the following terms best describes Snowflake’s database architecture?

1. A. Columnar shared nothing
2. B. Shared disk
3. C. Multi-cluster, shared data
4. D. Cloud-native shared memory

Correct Answer: C
https://www.snowflake.com/product/architecture/
Built from the ground up for the cloud, Snowflake’s unique multi-cluster shared data architecture delivers the performance, scale, elasticity, and concurrency today’s organizations require.