SnowPro-Core Snowflake Exam Questions and Free Practice Test

Question 79

- (Exam Topic 1)
Which of the following objects is not covered by Time Travel?

A. Tables

B. Schemas

C. Databases

D. Stages

Correct Answer:D
Reference: https://docs.snowflake.com/en/user-guide/data-time-travel.html

Question 80

- (Exam Topic 2)
What can be used to view warehouse usage over time? (Select Two).

A. The load HISTORY view

B. The Query history view

C. The show warehouses command

D. The WAREHOUSE_METERING HISTORY View

E. The billing and usage tab in the Snowflake web Ul

Correct Answer:DE

Question 81

- (Exam Topic 3)
What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

A. The explain plan output is available graphically.

B. An explain plan can be used to conduct performance analysis without executing a query.

C. An explain plan will handle queries with temporary tables and the query profiler will not.

D. An explain plan's output will display automatic data skew optimization information.

Correct Answer:B

Question 82

- (Exam Topic 1)
Which of the following statements describes a benefit of Snowflake’s separation of compute and storage?
(Choose all that apply.)

A. Growth of storage and compute are tightly coupled together

B. Storage expands without the requirement to add more compute

C. Compute can be scaled up or down without the requirement to add more storage

D. Multiple compute clusters can access stored data without contention

Correct Answer:BCD
Reference:
https://towardsdatascience.com/why-you-are-throwing-money-away-if-your-cloud-data-warehousedoesnt
separate-storage-and-compute-65d2dffd450f

Question 83

- (Exam Topic 3)
Which statement describes how Snowflake supports reader accounts?

A. A reader account can consume data from the provider account that created it and combine it with its own data.

B. A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

C. The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

D. The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

Correct Answer:C

Question 84

- (Exam Topic 2)
A user has an application that writes a new Tile to a cloud storage location every 5 minutes. What would be the MOST efficient way to get the files into Snowflake?

A. Create a task that runs a copy into operation from an external stage every 5 minutes

B. Create a task that puts the files in an internal stage and automate the data loading wizard

C. Create a task that runs a GET operation to intermittently check for new files

D. Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

Correct Answer:D
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html

START SnowPro-Core EXAM