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?

• A.TRUE
• B.FALSE

Comment: *

Name: *

Email: *

Verification: *

Which ones are the false statements about Materialized Views?

• A.Snowflake does not allow standard DML (e.g. INSERT, UPDATE, DELETE) on ma-terialized views.
• B.Snowflake does not allow users to truncate materialized views.
• C.Materialized views are first-class account objects.
• D.A materialized view can also be used as the data source for a subquery.
• E.Materialized views can be secure views.
• F.Clustering a subset of the materialized views on a table tends to be more cost-effective than clustering the table itself.

Comment: *

Name: *

Email: *

Verification: *

Which are the two ways to access elements in a JSON object?

• A.Use dot notation to traverse a path in a JSON object:
  <col-umn>:<level1_element>.<level2_element>.<level3_element>.
• B.Use SemiColon notation to traverse a path in a JSON object:
  <col-umn>:<level1_element>;<level2_element>;<level3_element>.
• C.use Curly bracket notation to traverse the path in an object:
  <col-umn>{'<level1_element>'}{'<level2_element>'}.
• D.use bracket notation to traverse the path in an object:
  <col-umn>['<level1_element>']['<level2_element>'].

Comment: *

Name: *

Email: *

Verification: *

Ron, Snowflake Developer needs to capture change data (insert only) on the source views, for that he follows the below steps:
Enable change tracking on the source views & its underlying tables.
Inserted the data via Scripts scheduled with the help of Tasks.
then simply run the below Select statements.
1.select *
2.from test_table
3.changes(information => append_only)
4.at(timestamp => (select current_timestamp()));
Select the Correct Query Execution Output option below:

• A.Developer missed to create stream on the source table which can further query to cap-ture DML records.
• B.Select query will fail with error: 'SQL compilation error-Incorrect Keyword "Chang-es()" found'
• C.No Error reported, select command gives Changed records with Metadata columns as change tracking enabled on the Source views & its underlying tables.
• D.Select statement complied but gives erroneous results.

Comment: *

Name: *

Email: *

Verification: *

Data Engineer looking out for quick tool for understanding the mechanics of queries & need to know more about the performance or behaviour of a particular query.
He should go to which feature of snowflake which can help him to spot typical mistakes in SQL query expressions to identify potential performance bottlenecks and improvement opportunities?

• A.Query Optimizer
• B.Performance Metadata table
• C.Query Profile
• D.Query Designer

Comment: *

Name: *

Email: *

Verification: *