COF-C03 Practice Questions

A.  

When it is unknown how much compute power is needed

B.  

If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)

C.  

If the runtime of the executed query is very slow

D.  

When a large number of concurrent queries are run on the same warehouse

A.  

1 second

B.  

60 seconds

C.  

5 minutes

D.  

60 minutes

A.  

VARIANT

B.  

VARRAY

C.  

STRUCT

D.  

ARRAY

E.  

QUEUE

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.  

view @my_stage

B.  

list @my_stage

C.  

show @my_stage

D.  

display @my_stage

A.  

Fail-safe makes data available up to 1 day, recoverable by user operations.

B.  

Fail-safe makes data available for 7 days, recoverable by user operations.

C.  

Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.

D.  

Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

A.  

1 day

B.  

7 days

C.  

12 hours

D.  

0 days

A.  

Clustering

B.  

Materialized Views

C.  

Zero-copy Cloning

D.  

Search Optimization Service

A.  

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

B.  

They can only access tables from a single database.

C.  

They can contain only a single SQL statement.

D.  

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

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.  

Within the policy DDL

B.  

Within the create table or create view DDL

C.  

By future APPLY for all objects in a schema

D.  

Within a control table

E.  

Using the command ALTER < object > ADD ROW ACCESS POLICY < policy > ;

A.  

B.  

C.  

D.  

A.  

Data is live, ready-to-query, and can be personalized.

B.  

Data needs to be loaded into a cloud provider as a consumer account.

C.  

Data is not available for copying or moving to an individual Snowflake account.

D.  

Data is available without copying or moving.

E.  

Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.

A.  

The Pipe load history is reset to empty.

B.  

The REFRESH command is executed.

C.  

The stage will be purged.

D.  

The destination table is truncated.

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.  

There is no need to have a Snowflake account in the target region, a share will be created for each user.

B.  

The listing is replicated into all selected regions automatically, the data is not.

C.  

The user must have the ORGADMIN role available in at least one account to link accounts for replication.

D.  

Shares attached to listings in remote regions can be viewed from any account in an organization.

E.  

For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.

A.  

4

B.  

8

C.  

16

D.  

32

A.  

There is no Fail-safe period for these tables.

B.  

1 day

C.  

7 days

D.  

31 days

E.  

90 days

A.  

The USERS view in ACCOUNT_USAGE

B.  

The LOGIN_HISTORY view in ACCOUNT_USAGE

C.  

The ACCESS_HISTORY view in ACCOUNT_USAGE

D.  

The SESSIONS view in ACCOUNT_USAGE

A.  

4 minutes

B.  

10 minutes

C.  

14 minutes

D.  

24 minutes