Question 1

- (Exam Topic 1)
Select the three types of tables that exist within Snowflake. Choose 3 answers

Accepted Answer

Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default

Question 2

- (Exam Topic 1)
Which of the following are options when creating a Virtual Warehouse?

Accepted Answer

Correct answer: AB

Question 3

- (Exam Topic 1)
True or False: Snowflake charges a premium for storing semi-structured data.

Accepted Answer

Reference:
https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/does-snowflakecharges- premium-for-storing-semi-structured-data

Question 4

- (Exam Topic 1)
What services does Snowflake automatically provide for customer that they may have been responsible for with their on premise system? Select all the below that
apply.

Accepted Answer

Correct answer: ABD

Question 5

- (Exam Topic 1)
What is the most granular object that the Time Travel retention period can be defined on? Select one.

Accepted Answer

Reference: https://docs.snowflake.com/en/user-guide/data-time-travel.html#data-retention-period

Question 6

- (Exam Topic 1)
True or False: When active, a pipe requires a dedicated Virtual Warehouse to execute.

Accepted Answer

Correct answer: B

Question 7

(337 New Questions)
- (Exam Topic 1)
Which of the following are true of multi-cluster Warehouses? Select all that apply below.

Accepted Answer

Correct answer: ABCD

Question 8

- (Exam Topic 1)
True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

Accepted Answer

Reference: https://blog.ippon.tech/innovative-snowflake-features-caching/

Question 9

- (Exam Topic 1)
Which of the following statement is true of Snowflake? Select one.

Accepted Answer

Correct answer: A

Question 10

- (Exam Topic 1)
Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

Accepted Answer

https://docs.snowflake.com/en/user-guide/credits.html#virtual-warehouse-credit-usage "Snowflake credits are charged based on the number of virtual warehouses
you use, how long they run, and their size."