SnowPro Core Sample Exam Questions and Answers 100% Correct

SnowPro Core Sample Exam Questions
and Answers 100% Correct
Snowflake supports which of the following file formats for data loading? Select all that apply.


Parquet
ORC
CSV
PDF - 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 - ANSWER - ELT


Which of the following best describes Snowflake's processing engine?


Leverages Apache Spark
Based on Map Reduce
A derivative of Presto
Native SQL - ANSWER - Native SQL


True or false: You can point Snowflake at any S3 bucket to directly query the files in that bucket
as long as the files are in Parquet or ORC format.

, TRUE
FALSE - ANSWER - FALSE


Which role in Snowflake allows a user to administer users and manage all database objects?


SYSADMIN
SECURITYADMIN
ACCOUNTADMIN
ROOT - ANSWER - ACCOUNTADMIN


Which of the following is not a layer in Snowflake's Architecture?


Storage
Cloud Services
Data Catalog
Virtual Warehouses - ANSWER - Data Catalog


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


TRUE
FALSE - 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