Question 1

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 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

If using a JavaScript UDF in a masking policy, Data Engineer needs to ensure the data type of the column, UDF, and masking policy match irrespective of case-sensitivity?

Options :

A : TRUE

B : FALSE

Answer: B

Question 4

Which is the non-supportable JavaScript UDF data types?

Options :

A : Integers

B : Integers

C : Binary

D : Double

Answer: A

Question 5

Let us say you have List of 50 Source files, which needs to be loaded into Snowflake internal stage. All these Source system files are already Brotli-compressed files. Which statement is correct with respect to Compression of Staged Files?

Options :

A : Even though Source files are already compressed, Snowflake do apply default gzip2 Compression to optimize the storage cost.

B : Snowflake automatically detect Brotli Compression, will skip further compression of all 50 files.

C : Auto-detection is not yet supported for Brotli-compressed files; when staging or loading Brotli-compressed files, you must explicitly specify the compression method that was used

D : When staging 50 compressed files in a Snowflake stage, the files are automatically com-pressed using gzip.

Answer: C

Confidently Practice Online with Free DEA-C02 Exam Cram

Buying Options: