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

Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

• A.SHOW STORAGE BY TABLE;
• B.SHOW TABLES;
• C.Information Schema -> TABLE_HISTORY
• D.Information Schema -> TABLE_FUNCTION
• E.Information Schema -> TABLE_STORAGE_METRICS

Comment: *

Name: *

Email: *

Verification: *

What are valid sub-clauses to the OVER clause for a window function? (Select TWO).

• A.GROUP BY
• B.LIMIT
• C.ORDER BY
• D.PARTITION BY
• E.UNION ALL

Comment: *

Name: *

Email: *

Verification: *

What step must be taken to ensure that a user can only access Snowsight from a specific location, or when working from home?

• A.Use a company Virtual Private Network (VPN) connection.
• B.Use Multi-Factor Authentication (MFA)
• C.Use Single Sign-On (SSO).
• D.Add the user's IP address to the network policy allowed list.

Comment: *

Name: *

Email: *

Verification: *

What is cached during a query on a virtual warehouse?

• A.The columns in the result set of the query
• B.All columns in a micro-partition
• C.All rows accessed during the query
• D.Any columns accessed during the query

Comment: *

Name: *

Email: *

Verification: *