How can a user improve the performance of a single large complex query in Snowflake?

• A.Scale out the virtual warehouse.
• B.Scale up the virtual warehouse.
• C.Enable standard warehouse scaling.
• D.Enable economy warehouse scaling.

Comment: *

Name: *

Email: *

Verification: *

The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

A user needs to extract the dealership information from the JSON.
How can this be accomplished?

• A.select src:dealership from car_sales;
• B.select src.dealership from car_sales;
• C.select src:Dealership from car_sales;
• D.select dealership from car_sales;

Comment: *

Name: *

Email: *

Verification: *

What can be used to process unstructured data?

• A.External tables
• B.The copy into <table> command
• C.External functions
• D.Snowpipe

Comment: *

Name: *

Email: *

Verification: *

What type of account can be used to share data with a consumer who does have a Snowflake account?

• A.Data consumer
• B.Reader
• C.Data provider
• D.Organization

Comment: *

Name: *

Email: *

Verification: *

What service is provided as an integrated Snowflake feature to enhance Multi-Factor Authentication (MFA) support?

• A.Duo Security
• B.Single Sign-On (SSO)
• C.Okta
• D.OAuth

Comment: *

Name: *

Email: *

Verification: *