SnowPro-Core Snowflake Exam Questions and Free Practice Test

Question 115

- (Exam Topic 3)
What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)

A. The clone always stays in sync with the original table.

B. The clone has better query performance.

C. The clone is created almost instantly.

D. The clone will have time travel history from the original table.

E. The clone saves space by not duplicating storage.

Correct Answer:CE

Question 116

- (Exam Topic 1)
True or False: Snowflake allows its customers to directly access the micro-partition files that make up its tables.

A. True

B. False

Correct Answer:B

Question 117

- (Exam Topic 3)
Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

A. Optimizes the virtual warehouse size and multi-cluster setting to economy mode

B. Allows a user to import the files in a sequential order

C. Increases the latency staging and accuracy when loading the data

D. Allows optimization of parallel operations

Correct Answer:D

Question 118

- (Exam Topic 2)
Which Snowflake partner specializes in data catalog solutions?

A. Alation

B. DataRobot

C. dbt

D. Tableau

Correct Answer:A
Alation provides Data Cataloging functionality. They state they are the 'One Place to Find, Understand, & Govern Data Across an Enterprise.
https://docs.snowflake.com/en/user-guide/ecosystem-all.html

Question 119

- (Exam Topic 3)
Which of the following are best practices for loading data into Snowflake? (Choose three.)

A. Aim to produce data files that are between 100 MB and 250 MB in size, compressed.

B. Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.

C. Enclose fields that contain delimiter characters in single or double quotes.

D. Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.

E. When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.

F. Partition the staged data into large folders with random paths, allowing Snowflake to determine the bestway to load each file.

Correct Answer:BCE

START SnowPro-Core EXAM