Given the following data:

This SELECT statement is executed:

What will be the result?

• A.200
• B.2.0
• C.1.84
• D.1.8

Comment: *

Name: *

Email: *

Verification: *

You have a Snowflake environment where different data analysts run a variety of ad-hoc queries against the same set of tables. You've noticed inconsistent query performance, with some queries running quickly and others taking much longer despite having similar logic. To better manage costs and optimize performance, which of the following strategies would be MOST effective in leveraging virtual warehouse caching and resource management in Snowflake? (Select TWO)

• A.Implement a single, large virtual warehouse shared by all data analysts to maximize resource utilization and caching benefits.
• B.Create separate virtual warehouses for different groups of analysts or types of queries to isolate workloads and prevent resource contention.
• C.Configure the 'AUTO SUSPEND parameter on all virtual warehouses to be a very short duration (e.g., 60 seconds) to minimize costs when the warehouse is idle.
• D.Use resource monitors to limit the credit usage of individual virtual warehouses or user groups to control costs and prevent runaway queries.
• E.Disable result caching globally at the account level to ensure that all queries always retrieve the most up-to-date data.

Comment: *

Name: *

Email: *

Verification: *

You have a Snowsight dashboard that visualizes daily sales trends. Business users complain that the dashboard takes too long to load, especially when filtering by specific product categories. The underlying data resides in a large table partitioned by 'sale date'. Which of the following actions would BEST improve the dashboard's performance, assuming the filters are appropriately configured in the dashboard and the virtual warehouse size is already appropriately sized?

• A.Create a materialized view that pre-aggregates the data used by the dashboard, including the dimensions used in the filters.
• B.Increase the virtual warehouse size used by Snowsight.
• C.Convert the dashboard into a Streamlit application for improved rendering performance.
• D.Use query acceleration on the base table to improve the speed of underlying queries when the filter are being applied by users.
• E.Implement result caching by setting = TRUE at the session level.

Comment: *

Name: *

Email: *

Verification: *

Which aggregate functions can be used to provide values for a given bucket in Snowsight charts? (Select THREE).

• A.Any Value
• B.Average
• C.Standard Deviation
• D.Mode
• E.HLL
• F.Max

Comment: *

Name: *

Email: *

Verification: *

A Data Analyst created two functions and one procedures:
The Analyst then runs this query:

The Analyst then runs this query:

What will be the output?

• A.Null
• B.10
• C.20
• D.30

Comment: *

Name: *

Email: *

Verification: *