Which data types does Snowflake support when querying semi-structured data? (Select TWO)

• A.VARIANT
• B.ARRAY
• C.VARCHAR
• D.XML
• E.BLOB

Comment: *

Name: *

Email: *

Verification: *

True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

• A.A single join node uses more than 50% of the query time
• B.Partitions scanned is equal to partitions total
• C.An AggregateOperacor node is present
• D.The query is spilling to remote storage

Comment: *

Name: *

Email: *

Verification: *

How can a data provider ensure that a data consumer is going to have access to the required objects?

• A.Enable the data sharing feature in the account and validate the view.
• B.Set the SIMULATED DATA SHARING CONSUMER session parameter to the name of the consumer account for which access is being simulated.
• C.Use the CURRENT_ROLE and CURRENT_USER functions to validate secure views.
• D.Use the CURRENT_ function to authorize users from a specific account to access rows in a base table.

Comment: *

Name: *

Email: *

Verification: *

A user has semi-structured data to load into Snowflake but is not sure what types of operations will need to be performed on the data. Based on this situation, what type of column does Snowflake recommend be used?

• A.ARRAY
• B.OBJECT
• C.TEXT
• D.VARIANT

Comment: *

Name: *

Email: *

Verification: *