Question 1

Which of the below statements are true about search optimization?

Options :

A : The search optimization service does not directly improve the performance of joins.

B : It can improve the performance of filtering rows from either table prior to the join, if the table has search optimization enabled and the predicate is selective

C : Search optimization supports external tables

D : Search optimization can improve range searches

Answer: A,B

Question 2

Changing the retention period for your account or individual objects changes the value for all lower-level objects that do not have a retention period explicitly set?

Options :

A : TRUE

B : FALSE

Answer: A

Question 3

Snowflake computes and adds partitions based on the defined partition column expressions when an external table metadata is refreshed. What are the Correct Statements to configure Partition metadata refresh in case of External Tables?

Options :

A : By default, the metadata is refreshed automatically when the object is created.

B : The object owner can configure the metadata to refresh automatically when new or updated data files are available in the external stage.

C : Metadata refresh is not required as its Managed implicitly by Snowflake.

D : Partitions of External tables is managed by External Stage Cloud provider.

E : There is nothing like adding partitions on External tables.

Answer: A,B

Question 4

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 5

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

Free DEA-C02 Mock Exam – Practice Online Confidently

Buying Options: