Which of the following is the Snowflake Account_Usage.Metering_History view used for?

Gathering the hourly credit usage for an account

Compiling an account's average cloud services cost over the previous month

Summarizing the throughput of Snowpipe costs for an account

Calculating the funds left on an account's contract

Which statement describes pruning?

The filtering or disregarding of micro-partitions that are not needed to return a query.

The return of micro-partitions values that overlap with each other to reduce a query's runtime.

A service that is handled by the Snowflake Cloud Services layer to optimize caching.

The ability to allow the result of a query to be accessed as if it were a table.

Use the ALTER VIEW command to update the view

Modify the columns in the underlying table

Use the ALTER VIEW command to update the view

Recreate the view with the required changes

Materialize the view to perform the changes

grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;

grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;

grant USAGE on all tables in schema DB1.SCHEMA to role MYROLE;

grant USAGE on future tables in schema DB1.SCHEMA to role MYROLE;

grant SELECT on all tables in schema DB1.SCHEMA to role MYROLE;

grant SELECT on future tables in schema DB1.SCHEMA to role MYROLE;

grant SELECT on all tables in database DB1 to role MYROLE;

grant SELECT on future tables in database DB1 to role MYROLE;

The shared objects are transferred.

The shared objects become accessible.

The shared objects can be re-shared.

Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

Become a Premium Member for full access