What type of query will benefit from the query acceleration service?

• A.Queries without filters or aggregation
• B.Queries with large scans and selective filters
• C.Queries where the GROUP BY has high cardinality
• D.Queries of tables that have search optimization service enabled

Comment: *

Name: *

Email: *

Verification: *

Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

• A.USAGE
• B.OPERATE
• C.MONITOR
• D.MODIFY

Comment: *

Name: *

Email: *

Verification: *

When is a DataFrame processed in Snowpark?

• A.When the DataFrame is created
• B.When a collect() action is triggered
• C.When there is sufficient memory available in the virtual warehouse
• D.When a new transformation is applied on the DataFrame

Comment: *

Name: *

Email: *

Verification: *

A user manages a 2 TB sales table clustered by order_date. Multiple teams query this data, but one specific team repeatedly filters on the region column, retrieving only a few thousand rows per query across hundreds of daily requests. The table is refreshed weekly, and no other teams report performance problems. Which action should be taken to optimize query performance for this specific team?

• A.Enable clustering on region.
• B.Use the Search Optimization Service.
• C.Use a materialized view with region as clustering key.
• D.Use a standard view with GROUP BY region.

Comment: *

Name: *

Email: *

Verification: *

Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

• A.Data is live, ready-to-query, and can be personalized.
• B.Data needs to be loaded into a cloud provider as a consumer account.
• C.Data is not available for copying or moving to an individual Snowflake account.
• D.Data is available without copying or moving.
• E.Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.

Comment: *

Name: *

Email: *

Verification: *