Free SnowPro-Core Exam Dumps

No Installation Required, Instantly Prepare for the SnowPro-Core exam and please click the below link to start the SnowPro-Core Exam Simulator with a real SnowPro-Core practice exam questions.
Use directly our on-line SnowPro-Core exam dumps materials and try our Testing Engine to pass the SnowPro-Core which is always updated.

Exam Code: SnowPro-Core
Exam Title: SnowPro Core Certification Exam
Vendor: Snowflake
Exam Questions: 337
Last Updated: September 28th,2024

Question 1

- (Exam Topic 2)
What is the default File Format used in the COPY command if one is not specified?

A. CSV
B. JSON
C. Parquet
D. XML

Correct Answer:A
Reference: https://docs.snowflake.com/en/sql-reference/sql/copy-into-location.html

Question 2

- (Exam Topic 3)
When cloning a database, what is cloned with the database? (Choose two.)

A. Privileges on the database
B. Existing child objects within the database
C. Future child objects within the database
D. Privileges on the schemas within the database
E. Only schemas and tables within the database

Correct Answer:BE

Question 3

- (Exam Topic 3)
What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?

A. The warehouse size does not change until all queries currently running in the warehouse have completed.
B. The warehouse size does not change until all queries currently in the warehouse queue have completed.
C. The warehouse size does not change until the warehouse is suspended and restarted.
D. It does not return from the command until the warehouse has finished changing its size.

Correct Answer:D

Question 4

- (Exam Topic 3)
What is true about sharing data in Snowflake? (Choose two.)

A. The Data Consumer pays for data storage as well as for data computing.
B. The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.
C. A Snowflake account can both provide and consume shared data.
D. The Provider is charged for compute resources used by the Data Consumer to query the shared data.
E. The Data Consumer pays only for compute resources to query the shared data.

Correct Answer:BC

Question 5

- (Exam Topic 2)
True or False: It is possible for a user to run a query against the query result cache without requiring an active Warehouse.

A. True
B. False

Correct Answer:A
Query result cache is all about fetching the data from cloud services layer and saving the cost by not running the virtual warehouse.