Question 1

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

Question 2

Which of the following objects are automatically created by the KAFKA connector?

Options :

A : One internal stage to temporarily store data files for each topic.

B : One pipe to ingest the data files for each topic partition.

C : One table for each topic

D : One external stage to temporarily store data files for each topic.

Answer: A,B,C

Question 3

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

Question 4

Does sensitive data in Snowflake is modified in an existing table while applying Masking policies?

Options :

A : YES

B : NO

Answer: B

Question 5

What can you infer from the below query profile?

Options :

A : Less number of bytes of data are read from the cloud storage

B : More bytes are read from the cloud storage

C : The query did a good partition pruning

Answer: A

Higher Test Marks with Free Online DEA-C02 Exam Practice

Buying Options: