Question 1

Search optimization is a table-level property and applies to all columns with supported data types

Options :

A : TRUE

B : FALSE

Answer: A

Question 2

Your data transfer takes 48 hours. In this case which data transfer mode will you use with Spark connector?

Options :

A : Internal Transfer

B : External Transfer

C : Both can be used

Answer: B

Question 3

If dataframes are used, the snowflake spark connector does not support the following operations

Options :

A : SELECT

B : SHOW

C : DESC

D : INSERT

Answer: B,C,D

Question 4

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 5

Mark the Correct Statements:Statement 1. Enable failover for a primary database to one or more accounts in your organization using anALTER DATABASE … ENABLE FAILOVER TO ACCOUNTS statement.Statement 2. Enabling failover for a primary database can be done by Data Engineer either before or after areplica of the primary database has been created in a specified account.

Options :

A : Statement 1

B : Statement 2

C : Both are False.

D : Both are Correct.

Answer: D