Free SnowPro-Core Exam Dumps

Question 66

- (Exam Topic 1)
True or False: Snowflake charges additional fees to Data providers for each share they create.

A. True
B. False

Correct Answer:B
"The costs for sharing data with Snowflake are minimal and straightforward. Data providers simply pay Snowflake for the data they store, and data consumers pay for the compute resources their queries consume."

Question 67

- (Exam Topic 2)
What is a key feature of Snowflake architecture?

A. Zero-copy cloning creates a mirror copy of a database that updates with the original
B. Software updates are automatically applied on a quarterly basis
C. Snowflake eliminates resource contention with its virtual warehouse implementation
D. Multi-cluster warehouses allow users to run a query that spans across multiple clusters
E. Snowflake automatically sorts DATE columns during ingest for fast retrieval by date

Correct Answer:D

Question 68

- (Exam Topic 2)
What tasks can be completed using the copy command? (Select TWO)

A. Columns can be aggregated
B. Columns can be joined with an existing table
C. Columns can be reordered
D. Columns can be omitted
E. Data can be loaded without the need to spin up a virtual warehouse

Correct Answer:CD

Question 69

- (Exam Topic 3)
Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)

A. Schema Stage
B. User Stage
C. Database Stage
D. Table Stage
E. External Named Stage
F. Internal Named Stage

Correct Answer:AEF

Question 70

- (Exam Topic 3)
Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

A. Bytes sent over network
B. Percentage scanned from cache
C. Partitions total
D. Bytes spilled to local storage
E. Partitions scanned

Correct Answer:BE