Which Scenario Data engineer decide Materialized views are not useful. Select All that apply.

• A.Query results contain a small number of rows and/or columns relative to the base table (the table on which the view is defined).
• B.Query results contain results that require significant processing.
• C.The query is on an external table (i.e. data sets stored in files in an external stage), which might have slower performance compared to querying native database tables.
• D.The view's base table change frequently.

Comment: *

Name: *

Email: *

Verification: *

A Data Engineer is investigating a query that is taking a long time to return The Query Profile shows the following:

What step should the Engineer take to increase the query performance?

• A.Add additional virtual warehouses.
• B.increasethe size of the virtual warehouse.
• C.Rewrite the query using Common Table Expressions (CTEs)
• D.Change the order of the joins and start with smaller tables first

Comment: *

Name: *

Email: *

Verification: *

To troubleshoot data load failure in one of your Copy Statement, Data Engineer have Executed a COPY statement with the VALIDATION_MODE copy option set to RETURN_ALL_ERRORS with reference to the set of files he had attempted to load. Which below function can facilitate analysis of the problematic records on top of the Results produced? [Select 2]

• A.RESULT_SCAN
• B.LAST_QUERY_ID
• C.Rejected_record
• D.LOAD_ERROR

Comment: *

Name: *

Email: *

Verification: *

What is a characteristic of the use of binding variables in JavaScript stored procedures in Snowflake?

• A.All types of JavaScript variables can be bound
• B.All Snowflake first-class objects can be bound
• C.Only JavaScript variables of type number, string and sf Date can be bound
• D.Users are restricted from binding JavaScript variables because they create SQL injection attack vulnerabilities

Comment: *

Name: *

Email: *

Verification: *

When using the CURRENT_ROLE and CURRENT_USER functions with secure UDFs that will be shared with Snowflake accounts, Snowflake returns a NULL value for these functions?

• A.TRUE
• B.FALSE

Comment: *

Name: *

Email: *

Verification: *