Which semi-structured data function returns an OBJECT constructed from the arguments.

• A.OBJECT_ARRAY
• B.OBJECT_CONSTRUCT
• C.OBJECT_INSPECT

Comment: *

Name: *

Email: *

Verification: *

What built-in Snowflake features make use of the change tracking metadata for a table? (Choose two.)

• A.Thee CHANGE_DATA_CAPTURE command
• B.The UPSERT command
• C.A STREAM object
• D.The MERGE command
• E.The CHANGES clause

Comment: *

Name: *

Email: *

Verification: *

The Business Intelligence team reports that when some team members run queries for their dashboards in parallel with others, the query response time is getting significantly slower What can a Snowflake Architect do to identify what is occurring and troubleshoot this issue?

• A.
• B.
• C.
• D.

Comment: *

Name: *

Email: *

Verification: *

How can the Snowpipe REST API be used to keep a log of data load history?

• A.Call insertReport every 20 minutes, fetching the last 10,000 entries.
• B.Call loadHistoryScan every 10 minutes for a 15-minute time range.
• C.Call insertReport every 8 minutes for a 10-minute time range.
• D.Call loadHistoryScan every minute for the maximum time range.

Comment: *

Name: *

Email: *

Verification: *

A user needs access to create materialized view on a shema mydb.myschema.
What is the appropriate command to provide the access?

• A.GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;
• B.GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;
• C.GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

Comment: *

Name: *

Email: *

Verification: *