SnowPro-Core Free Practice Test

- (Exam Topic 1)
Which statements are true of micro-partitions? Choose 2 answers

1. A. They are approximately 16MB in size
2. B. They are stored compressed only if COMPRESS=TRUE on Table
3. C. They are Immutable
4. D. They are only encrypted in the Enterprise edition and above

Correct Answer: AC
Reference: https://medium.com/weareservian/seeing-snow-for-the-first-time-snowflake-adventures-part-1- 731ddc983c69

- (Exam Topic 3)
Which data types are supported by Snowflake when using semi-structured data? (Choose two.)

1. A. VARIANT
2. B. VARRAY
3. C. STRUCT
4. D. ARRAY
5. E. QUEUE

Correct Answer: AD

- (Exam Topic 1)
Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

1. A. Is available to all Snowflake Editions
2. B. Is only available to customers with Business Critical Edition
3. C. Restricts or enables access to specific IP addresses
4. D. Is activated using an “ALTER DATABASE” command

Correct Answer: AC
Reference: https://docs.snowflake.com/en/sql-reference/sql/create-network-policy.html

- (Exam Topic 1)
The Query History in the Snowflake Web Interface (UI) is kept for approximately:

1. A. 60 minutes
2. B. 24 hours
3. C. 14 days
4. D. 30 days
5. E. 1 year

Correct Answer: C
Reference: https://docs.snowflake.com/en/sql-reference/account-usage/query_history.html

- (Exam Topic 3)
How does Snowflake allow a data provider with an Azure account in central Canada to share data with a data consumer on AWS in Australia?

1. A. The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.
2. B. The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.
3. C. The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.
4. D. The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer's account.

Correct Answer: C