COF-C02 Practice Questions

A.  

Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

B.  

Yes. because the compute resource is replaced in its entirety with a new compute resource.

C.  

No. because the size of the cache is independent from the warehouse size

D.  

Yes. became the new compute resource will no longer have access to the cache encryption key

A.  

Create a task that runs a copy into operation from an external stage every 5 minutes

B.  

Create a task that puts the files in an internal stage and automate the data loading wizard

C.  

Create a task that runs a GET operation to intermittently check for new files

D.  

Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

A.  

Use the Snowflake Marketplace

B.  

Use a stream

C.  

Use a Data Exchange

D.  

Use a direct share

A.  

GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYD

B.  

B.  

GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYD

B.  

C.  

GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYD

B.  

D.  

GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYD

B.  

A.  

UPDATE TABLE FROM STREAM

B.  

SELECT FROM STREAM

C.  

INSERT INTO TABLE SELECT FROM STREAM

D.  

ALTER TABLE AS SELECT FROM STREAM

E.  

BEGIN COMMIT

A.  

5 MB

B.  

8 GB

C.  

16 MB

D.  

32 MB

A.  

B.  

C.  

D.  

A.  

The data is cloned into a historical object.

B.  

The data moves to Fail-safe

C.  

Time Travel on the historical data is dropped.

D.  

The object containing the historical data is dropped.

A.  

The explain plan output is available graphically.

B.  

An explain plan can be used to conduct performance analysis without executing a query.

C.  

An explain plan will handle queries with temporary tables and the query profiler will not.

D.  

An explain plan ' s output will display automatic data skew optimization information.

A.  

ORGADMIN

B.  

SECURITYADMIN

C.  

SHAREADMIN

D.  

ACCOUNTADMIN

A.  

30 days

B.  

7 days

C.  

48 hours

D.  

24 hours

A.  

External Tokenization

B.  

External Tables

C.  

Materialized Views

D.  

User-Defined Table Functions (UDTF)

A.  

Organize files into logical paths

B.  

Store the files on the external stage to ensure caching is maintained

C.  

Use pattern matching for regular expression execution

D.  

Load the data in one large file

A.  

Role

B.  

Schema

C.  

User

D.  

Database

E.  

Account

F.  

Tables

A.  

Database replication and failover

B.  

Automated index management

C.  

Customer managed keys (Tri-secret secure)

D.  

Extended time travel

E.  

Native support for geospatial data

A.  

When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.

B.  

When the data cache is full, the least-recently used data will be cleared to make room.

C.  

A user can only access their own queries from the query result cache.

D.  

A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.

E.  

The RESULT_SCAN table function can access and filter the contents of the query result cache.

A.  

The user who created the object

B.  

The SYSADMIN role

C.  

Ownership depends on the type of object

D.  

The role used to create the object

A.  

Into single files with 100-250 MB of compressed data per file

B.  

Into single files with 1-100 MB of compressed data per file

C.  

Into files of maximum size of 1 GB of compressed data per file

D.  

Into files of maximum size of 4 GB of compressed data per file

A.  

Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.

B.  

The transient table version cannot be retrieved after 24 hours.

C.  

Contact Snowflake Support to have the data retrieved from Fail-safe storage.

D.  

Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.

A.  

Privileges on the database

B.  

Existing child objects within the database

C.  

Future child objects within the database

D.  

Privileges on the schemas within the database

E.  

Only schemas and tables within the database