How can a Data Exchange Administrator provide a user with account access to a Data Exchange?

• A.Grant the user the USERADMIN role.
• B.Add the user to the Data Exchange.
• C.Create a new database for the Data Exchange and provide access to the user.
• D.Enable the IMPORT SHARE privilege and grant this privilege to the user.

Comment: *

Name: *

Email: *

Verification: *

What metadata can be accessed through the INFORMATION_SCHEMA? (Select TWO).

• A.A query ID from the query plan.
• B.The micro-partition pruning efficiency of a table.
• C.The clustering status of a table.
• D.A table's credit consumption.
• E.The date a database was created.

Comment: *

Name: *

Email: *

Verification: *

When used with a select statement in the copy into <location> command, what statement will unload data from a table as JSON?

• A.TO_OBJECT
• B.TO_JSON
• C.PARSE_JSON
• D.OBJECT CONSTRUCT

Comment: *

Name: *

Email: *

Verification: *

How long is a query visible in the Query History page in the Snowflake Web Interface (Ul)?

• A.14 days
• B.24 hours
• C.60 minutes
• D.30 days

Comment: *

Name: *

Email: *

Verification: *

What does a table with a clustering depth of 1 mean in Snowflake?

• A.The table has only 1 micro-partition.
• B.The table has 1 overlapping micro-partition.
• C.The table has no overlapping micro-partitions.
• D.The table has no micro-partitions.

Comment: *

Name: *

Email: *

Verification: *