SNOWPRO CORE SAMPLE EXAM QUESTIONS AND ANSWERS

SNOWPRO CORE SAMPLE EXAM QUESTIONS AND ANSWERS
Snowflake supports which of the following file formats for data loading? Select all that apply.



Parquet

ORC

CSV

PDF - CORRECT ANSWER✅✅Parquet

ORC

CSV



Which type of Data Integration tools leverage Snowflake's scalable compute for data transformation?
Select the best answer.



Database Replication

ELT

ETL

Streaming - CORRECT ANSWER✅✅ELT



True or false: Snowflake caches are automatically invalidated if the underlying data changes.



TRUE

FALSE - CORRECT ANSWER✅✅TRUE



Question 4 of 30

100 pts

Which of the following are types of caching use by Snowflake? Select all that apply.



Warehouse caching

, Index Caching

Metadata caching

Query result caching - CORRECT ANSWER✅✅Warehouse caching

Metadata caching

Query result caching



The following factors affect data load rates: (select all that apply)



Physical location of the Stage

RAM on the Virtual Warehouse

Gzip compression efficiency

Thread size - CORRECT ANSWER✅✅Physical location of the Stage.

Gzip compression efficiency.



Which of the following terms best describes Snowflake's database architecture?



Columnar shared nothing

Shared disk

Multi-cluster shared data

Cloud-native shared memory - CORRECT ANSWER✅✅Multi-cluster shared data



Which of the following are true about the variant data type in Snowflake? Select all that apply.



Optimized storage based on repeated elements

Stored in a separate file format from structured data

Can be queried using JSON path notation

Requires a custom mapping for each record type - CORRECT ANSWER✅✅Optimized storage based on
repeated elements.

Can be queried using JSON path notation.