Question 1

Which system table will you use to get the total credit consumption over a specific time period?

Options :

A : WAREHOUSE_METERING_HISTORY

B : WAREHOUSE_CREDIT_USAGE_HISTORY

C : WAREHOUSE_USAGE_HISTORY

Answer: A

Question 2

David, a Lead Data engineer with XYZ company looking out to improve query performance & oth-er benefits

while working with Tables, Regular Views, MVs and Cached Results.

Which one of the following does not shows key similarities and differences between tables, regular views,

cached query results, and materialized views while choosing any of them by David?

Options :

A : Regular views do not cache data, and therefore cannot improve performance by cach-ing.

B : As with non-materialized views, a materialized view automatically inherits the privileges of its base table.

C : Cached Query Results: Used only if data has not changed and if query only uses de-terministic functions (e.g. not CURRENT_DATE).

D : Materialized views are faster than tables because of their “cache” (i.e. the query results for the view); in addition, if data has changed, they can use their “cache” for data that hasn’t changed and use the base table for any data that has changed.

E : Both materialized views and regular views enhance data security by allowing data to be exposed or hidden at the row level or column level.

Answer: B

Question 3

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 4

Which of the below statement is true when search access path hasn’t been updated yet by search optimization?

Options :

A : Queries might run slower but will always return up-to-date results.

B : There will be no impact on performance but queries might return stale data

C : Queries will fail when the access path is getting updated

Answer: A

Question 5

Which is the non-supportable JavaScript UDF data types?

Options :

A : Integers

B : Integers

C : Binary

D : Double

Answer: A

Confidently Practice Online with Free DEA-C02 Exam Cram

Buying Options: