COF-C03 Practice Questions

A.  

Time spent reading from the result cache.

B.  

Time spent reading from the virtual warehouse cache.

C.  

Time when the query processing was blocked by remote disk access.

D.  

The level of network activity between the Cloud Services layer and the virtual warehouse.

A.  

Range searches

B.  

Equality searches

C.  

Substring searches

D.  

Queries with IN predicates

E.  

Queries with aggregation

A.  

Allows regular views to be shared.

B.  

Sensitive data is automatically masked.

C.  

Data is not transferred between accounts.

D.  

Consumer account will incur compute costs.

E.  

Source data can be edited by users with reader accounts.

A.  

INSERT

B.  

UPDATE

C.  

DELETE

D.  

TRUNCATE

E.  

UPSERT

A.  

OBJECT_VIEWER

B.  

USAGE_VIEWER

C.  

GOVERNANCE_VIEWER

D.  

SECURITY_VIEWER

A.  

The data provider incurs costs for the data storage costs, and the data consumer incurs compute costs.

B.  

The data provider incurs costs for compute, and the data consumer incurs costs for data storage.

C.  

The data provider does not incur costs when sharing data; the data consumer incurs costs for data storage and compute.

D.  

The data consumer does not incur costs when accessing shared data; the data provider incurs costs for data storage and compute.

A.  

Bytes read from result and Bytes written to result

B.  

Partitions scanned and Partitions total

C.  

Bytes spilled to local storage and Bytes spilled to remote storage

D.  

Number of rows inserted and Number of rows updated

A.  

Views

B.  

Materialized views

C.  

Temporary schemas

D.  

Permanent tables

E.  

External tables

A.  

ACCESS_HISTORY

B.  

LOAD_HISTORY

C.  

QUERY_HISTORY

D.  

REST EVENT HISTORY

A.  

The accuracy of the data

B.  

The uniqueness of the data

C.  

The freshness of the data

D.  

The volume of the data

A.  

NOT NULL

B.  

PRIMARY KEY

C.  

FOREIGN KEY

D.  

UNIQUE

A.  

USERADMIN

B.  

SYSADMIN

C.  

SECURITYADMIN

D.  

PUBLIC

E.  

ORGADMIN

A.  

The role will retain all privileges until a new session is started.

B.  

The role will lose access to objects that are not granted to the updated role.

C.  

The user will have to reinstate the role using the USE ROLE command after the change.

D.  

Any users who are actively using the role will have their current session terminated.

A.  

The DATA_RETENTI0N_TIME_IN_DAYS parameter in the consumer account is set to 0.

B.  

The consumer account runs the GRANT IMPORTED PRIVILEGES command on the data share every 24 hours.

C.  

The objects in the data share are being deleted and the grant pattern is not re-applied systematically.

D.  

The consumer account acquires the data share through a private data exchange.

A.  

They can be set for any Snowflake Edition.

B.  

They can be applied to roles.

C.  

They restrict or enable access to specific IP addresses.

D.  

They are activated using ALTER DATABASE SQL commands.

E.  

They can only be managed using the ORGADMIN role.

A.  

Standard

B.  

Enterprise

C.  

Business Critical

D.  

Virtual Private Snowflake (VPS)

A.  

copy_into < location > command

B.  

Data replication

C.  

Snowpipe

D.  

Direct share

A.  

Select LAST_QUERY_ID(-2)

B.  

Select LAST_QUERY_ID(2)

C.  

Select LAST_QUERY_ID(1)

D.  

Select LAST_QUERY_ID(2)

A.  

Directory

B.  

Transient

C.  

Temporary

D.  

Permanent

A.  

Setting up a multi-cluster virtual warehouse

B.  

Resizing the virtual warehouse to a larger size

C.  

Automating the virtual warehouse suspension and resumption settings

D.  

Increasing the maximum cluster count parameter for a multi-cluster virtual warehouse