Free COF-C02 Exam braindumps download (COF-C02 exam dumps Free)

QUESTION: 306

What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

The shared objects are transferred.
The shared objects are copied.
The shared objects become accessible.
The shared objects can be re-shared.

Answer(s): C

Show Answer Next Question

QUESTION: 307

Using variables in Snowflake is denoted by using which SQL character?

Answer(s): C

Show Answer Next Question

QUESTION: 308

Which commands should be used to grant the privilege allowing a role to select data from all current tables and any tables that will be created later in a schema? (Choose two.)

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;

Answer(s): C,D

Show Answer Next Question

QUESTION: 309

How can a user change which columns are referenced in a 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

Answer(s): C

Show Answer Next Question

QUESTION: 310

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.

Answer(s): A

Show Answer Next Question

Free COF-C02 Exam Braindumps SnowPro Core Questions 306–310 (page: 63)

QUESTION: 306

QUESTION: 307

QUESTION: 308

QUESTION: 309

QUESTION: 310

Free COF-C02 Exam Braindumps
SnowPro Core Questions 306–310 (page: 63)