Question 1

You can execute zero, one, or more transactions inside a stored procedure?

Options :

A : TRUE

B : FALSE

Answer: A

Question 2

Which of the following statements is/are incorrect regarding Fail-safe data recovery?

Options :

A : Data stored in temporary tables is not recoverable after the table is dropped as they do not have fail-safe.

B : Historical data in transient tables can be recovered by Snowflake due to Operation fail-ure after the Time Travel retention period ends using Fail-safe.

C : Long-lived tables, such as fact tables, should always be defined as permanent to ensure they are fully protected by Fail-safe.

D : Short-lived tables (i.e. <1 day), such as ETL work tables, can be defined as transient to eliminate Fail-safe costs.

E : If downtime and the time required to reload lost data are factors, permanent tables, even with their added Fail-safe costs, may offer a better overall solution than transient tables.

Answer: B

Question 3

While using kafka connector, what charges are applied to your account?

Options :

A : Snowpipe processing time

B : Data storage

C : Kafka connector usage

Answer: A,B

Question 4

For a business group, you need to create a table with customer demography data in snowflake. Business users will need to do both range and equality searches on the table. Which of the below techniques will you use to speed up the queries.

Options :

A : Create a materialized view on the table and create the required clustering key

B : Turn on search optimization for the table

C : Create a secure view for each of the search access patterns

Answer: A

Question 5

Snowflake charges a per-byte fee when users transfer data from your snowflake account into cloud storages in another region on the same cloud platform or into cloud storage in another cloud platform

Options :

A : TRUE

B : FALSE

Answer: A

Free DEA-C02 Mock Exam – Practice Online Confidently

Buying Options: