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

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

Comment: *

Name: *

Email: *

Verification: *

Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

• A.PUT
• B.COPY
• C.GET
• D.SELECT

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: *

Which of the following are options when creating a virtual Warehouse? Choose 2 answers

• A.Auto-resume
• B.Auto-drop
• C.Auto-suspend
• D.Auto resize

Comment: *

Name: *

Email: *

Verification: *

Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

• A.Compute layer
• B.Storage layer
• C.Cloud infrastructure layer
• D.Cloud services layer

Comment: *

Name: *

Email: *

Verification: *