Snow15

What is the default value in the Snowflake Web Interface (UI) for auto suspending a Virtual Warehouse?

• • 1 minute

• • 5 minutes

• • 10 minutes

• • 15 minutes

What is a feature of a stored procedure in Snowflake?

• • They can be created as secure and hide the underlying metadata from all users.

• • They can access tables from a single database.

• • They can only contain a single SQL statement.

• • They can be created to run with a caller's rights or an owner's rights.

Which statement accurately describes a characteristic of a materialized view?

• A materialized view can query only a single table.

• Data accessed through materialized views can be stale.

• Materialized view refreshes need to be maintained by the user.

• Querying a materialized view is slower than executing a query against the base table of the view.

What is the maximum compressed row size in Snowflake?

• • 8KB

• • 16MB

• • 50MB

• • 4000GB

What is the impact of increasing the number of concurrent users on a Snowflake virtual warehouse?

• Improved performance for small, simple queries

• Improved performance for large, complex queries

• Decreased performance for large, complex queries

• Decreased consumption of Snowflake credits

When does a materialized view get suspended in Snowflake?

• When a column is added to the base table

• When a column is dropped from the base table

• When a DML operation is run on the base table

• When the base table is reclustered

Which role has the ability to create and manage users and roles?

• • ORGADMIN

• • USERADMIN

• • SYSADMIN

• • SECURITYADMIN

Which function is used to profile warehouse credit usage?

• AUTOMATIC_CLUSTERING_HISTORY

• MATERIALIZED_VIEW_REFRESH_HISTORY

• WAREHOUSE_LOAD_HISTORY

• WAREHOUSE_METERING_HISTORY

When a data share is created in a provider account, who can access it?

• All the users in the provider account

• All the users in the consumer account

• Only the users with the SYSADMIN role in the provider account

• Only the users with IMPORTED PRIVILEGES granted on the share

What will happen to new queries when all the resources of a virtual warehouse are fully utilized?

• All queries will terminate when the resources are maximized.

• The warehouse will scale out automatically.

• The warehouse will move to a suspended state.

• New queries will be queued and executed when capacity is available.