최신Snowflake SnowPro Core Certification - COF-C02무료샘플문제

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

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

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

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

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

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

A. Replication

B. Snowflake Marketplace

C. Snowpipe

D. Data Exchange

A. ISO-8859-1

B. UTF-16

C. UTF-8

D. WINDOWS-1253

A. An error will occur, as views with qualified references cannot be cloned.

B. The stored procedures and views will refer to tables in the source database.

C. An error will occur, as stored objects cannot be cloned.

D. The cloned views and the stored procedures will reference the cloned tables in the cloned database.

A. Cloning a database

B. Caching query results

C. Running COPY commands

D. Running a custom query

E. Running EXPLAIN and SHOW commands

A. The entire virtual warehouse

B. The primary cluster in the virtual warehouse

C. The Queries currently being run on the virtual warehouse

D. The database in which the virtual warehouse resides

A. DROP STREM

B. DESCRIBE STREAM

C. ALTER STREAM

D. CREATE OR REPLACE STREAM

A. By identifying where column-level values are located in each micro-partition

B. By creating an up-to-date catalog of all of the tables in a database

C. By generating a real-time index for all data in a database

D. By listing all of the queries that have been executed on the table data

A. Only the data provider who published the data

B. Only the users that the data provider has invited to the Data Exchange

C. Any Snowflake user, regardless of their role or permissions

D. Any user who has been provided with a unique Data Exchange URL

A. GOVERNANCE_VIEWER

B. OBJECT_VIEWER

C. SECURITY_VIEWER

D. USAGE_VIEWER

A. A file in a stage

B. A view

C. An individual column

D. An individual row

A. Schemas

B. External functions

C. Databases

D. Masking policies

E. Virtual warehouses

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

B. They can only access tables from a single database.

C. They can be created as secure and hide the underlying metadata from the user.

D. They can contain only a single SQL statement.

A. Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.

B. SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.

C. The default virtual warehouse size can be changed at any time.

D. The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.

E. A user cannot specify a default warehouse when using the ODBC driver.