Free SnowPro-Core Exam Dumps

Question 46

- (Exam Topic 3)
Files have been uploaded to a Snowflake internal stage. The files now need to be deleted. Which SQL command should be used to delete the files?

A. PURGE
B. MODIFY
C. REMOVE
D. DELETE

Correct Answer:D
Reference:
https://www.simplilearn.com/tutorials/sql-tutorial/delete-in-sql#:~:text=The Delete command in

Question 47

- (Exam Topic 3)
Snowflake supports the use of external stages with which cloud platforms? (Choose three.)

A. Amazon Web Services
B. Docker
C. IBM Cloud
D. Microsoft Azure Cloud
E. Google Cloud Platform
F. Oracle Cloud

Correct Answer:BDE

Question 48

- (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

Question 49

- (Exam Topic 2)
The fail-safe retention period is how many days?

A. 1 day
B. 7 days
C. 45 days
D. 90 days

Correct Answer:B
Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html

Question 50

- (Exam Topic 3)
How would a user run a multi-cluster warehouse in maximized mode?

A. Configure the maximum clusters setting to "Maximum."
B. Turn on the additional clusters manually after starting the warehouse.
C. Set the minimum Clusters and maximum Clusters settings to the same value.
D. Set the minimum clusters and maximum clusters settings to different values.

Correct Answer:D