Question 1

Streams cannot be created to query change data on which of the following objects? [Select All that Apply]

Options :

A : Standard tables, including shared tables.

B : Views, including secure views

C : Directory tables

D : Query Log Tables

E : External tables

Answer: D

Question 2

In order to improve query perfromance, you can bypass data conversions from the Snowflake internal data type to the native Python data type. Which class in the snowflake.connector.converter_null module do you use for this feature?

Options :

A : SnowflakeNoConverterToPython

B : PythonNoConverterToSnowflake

C : ByPassDataConversion

Answer: A

Question 3

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 4

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

Question 5

Clones can be cloned, with no limitations on the number or iterations of clones that can be created (e.g. you can create a clone of a clone of a clone, and so on), which results in a n-level hierarchy of cloned objects, each with their own portion of shared and independent data storage?

Options :

A : TRUE

B : FALSE

C :

Answer: A

Higher Test Marks with Free Online DEA-C02 Exam Practice

Buying Options: