SnowPro-Core Free Practice Test

- (Exam Topic 2)
Which of the following are benefits of micro-partitioning? (Select TWO)

1. A. Micro-partitions cannot overlap in their range of values
2. B. Micro-partitions are immutable objects that support the use of Time Travel.
3. C. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
4. D. Rows are automatically stored in sorted order within micro-partitions
5. E. Micro-partitions can be defined on a schema-by-schema basis

Correct Answer: AD
https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html

- (Exam Topic 2)
Will data cached in a warehouse be lost when the warehouse is resized?

1. A. Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
2. B. Ye
3. C. because the compute resource is replaced in its entirety with a new compute resource.
4. D. N
5. E. because the size of the cache is independent from the warehouse size
6. F. Ye
7. G. became the new compute resource will no longer have access to the cache encryption key

Correct Answer: A

- (Exam Topic 2)
Which semi-structured file formats are supported when unloading data from a table? (Select TWO).

1. A. ORC
2. B. XML
3. C. Avro
4. D. Parquet
5. E. JSON

Correct Answer: DE
Semi-structured JSON, Parquet
https://docs.snowflake.com/en/user-guide/data-unload-prepare.html#:~:text=Supported File Formats,-Th

- (Exam Topic 2)
Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

1. A. Materialized views
2. B. Sequences
3. C. Procedures
4. D. Tables
5. E. Secure User Defined Functions (UDFs)

Correct Answer: DE
Secure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:
Tables
External tables
Secure views
Secure materialized views
Secure UDFs
https://docs.snowflake.com/en/user-guide/data-sharing-intro.html

- (Exam Topic 3)
What impacts the credit consumption of maintaining a materialized view? (Choose two.)

1. A. Whether or not it is also a secure view
2. B. How often the underlying base table is queried
3. C. How often the base table changes
4. D. Whether the materialized view has a cluster key defined
5. E. How often the materialized view is queried

Correct Answer: DE