SnowPro Core Sample Exam Questions with Detailed Verified Answers

Page | 1



SnowPro Core Sample Exam Questions
with Detailed Verified Answers

Question:Snowflake supports which of the following file formats for data
loading? Select all that apply.


Parquet
ORC
CSV
PDF


Ans: Parquet


ORC


CSV


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


Database Replication
ELT
ETL
Streaming

, Page | 2

Ans: ELT


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


TRUE
FALSE


Ans: TRUE


Question: 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


Ans: Warehouse caching


Metadata caching


Query result caching


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