Two users share a virtual warehouse named wh dev 01. When one of the users loads data, the other one experiences performance issues while querying data.
How does Snowflake recommend resolving this issue?

• A.Create separate warehouses for each user.
• B.Scale up the existing warehouse.
• C.Stop loading and querying data at the same time.
• D.Create separate warehouses for each workload.

Comment: *

Name: *

Email: *

Verification: *

For a multi-cluster Warehouse, the number of credits billed is calculated on:

• A.The size of the Warehouse and the number of clusters that ran within a given time period.
• B.The number of users who accessed the Warehouse.
• C.The number of queries that ran using the Warehouse.
• D.The sue of the Warehouse and the maximum number of clusters configured for the Warehouse.

Comment: *

Name: *

Email: *

Verification: *

True or False: A Virtual Warehouse consumes Snowflake credits even when inactive.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

When should a multi-cluster warehouse be used in auto-scaling mode?

• A.If the runtime of the executed query is very slow
• B.When it is unknown how much compute power is needed
• C.If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)
• D.When a large number of concurrent queries are run on the same warehouse

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 dealership from car_sales;
• C.select src:Dealership from car_sales;
• D.select src.dealership from car_sales;

Comment: *

Name: *

Email: *

Verification: *