Free SnowPro-Core Exam Dumps

Question 26

- (Exam Topic 1)
Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously?
Choose 3 answers

A. MIN(< < column value>>)
B. COPY
C. SUM(<< column>>)
D. UPDATE

Correct Answer:BCD

Question 27

- (Exam Topic 3)
Which of the following describes the Snowflake Cloud Services layer?

A. Coordinates activities in the Snowflake account
B. Executes queries submitted by the Snowflake account users
C. Manages quotas on the Snowflake account storage
D. Manages the virtual warehouse cache to speed up queries

Correct Answer:A

Question 28

- (Exam Topic 3)
Which of the following statements describe features of Snowflake data caching? (Choose two.)

A. When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.
B. When the data cache is full, the least-recently used data will be cleared to make room.
C. A user can only access their own queries from the query result cache.
D. A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.
E. The RESULT_SCAN table function can access and filter the contents of the query result cache.

Correct Answer:BD

Question 29

- (Exam Topic 3)
What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

A. The shared objects are transferred.
B. The shared objects are copied.
C. The shared objects become accessible.
D. The shared objects can be re-shared.

Correct Answer:B

Question 30

- (Exam Topic 1)
Which item in the Data Warehouse migration process does not apply in Snowflake? (Select two)

A. Migrate Users
B. Migrate Schemas
C. Migrate Indexes
D. Build the Data pipeline

Correct Answer:CD