COF-C02 Practice Questions

A.  

Querying data-related objects that were created within the past 365 days

B.  

Restoring data-related objects that have been deleted within the past 90 days

C.  

Conducting point-in-time analysis for Bl reporting

D.  

Analyzing data usage/manipulation over all periods of time

A.  

Data is hashed by the cluster key to facilitate fast searches for common data values

B.  

Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

C.  

Smaller micro-partitions are created for common data values to allow for more parallelism

D.  

Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

A.  

A single join node uses more than 50% of the query time

B.  

Partitions scanned is equal to partitions total

C.  

An AggregateOperacor node is present

D.  

The query is spilling to remote storage

A.  

Standard

B.  

Premium

C.  

Enterprise

D.  

Business Critical

A.  

Columns can be aggregated

B.  

Columns can be joined with an existing table

C.  

Columns can be reordered

D.  

Columns can be omitted

E.  

Data can be loaded without the need to spin up a virtual warehouse

A.  

30 Days

B.  

60 Days

C.  

90 Days

D.  

365 Days

A.  

True

B.  

False

A.  

Bytes scanned

B.  

Bytes sent over the network

C.  

Number of partitions scanned

D.  

Percentage scanned from cache

E.  

External bytes scanned

A.  

Metadata cache

B.  

Result cache

C.  

Remote cache

D.  

Local file cache

A.  

Time Travel - 1 day. Fail-safe - 1 day

B.  

Time Travel - 0 days. Fail-safe - 1 day

C.  

Time Travel - 1 day. Fail-safe - 0 days

D.  

Transient tables are retained in neither Fail-safe nor Time Travel

A.  

TABLES

B.  

TABLE_STORAGE_METRICS

C.  

STORAGE_DAILY_HISTORY

D.  

STORAGE USAGE

A.  

Add or remove users from a worksheet.

B.  

Move a worksheet to a folder or a dashboard.

C.  

Combine multiple worksheets into a single worksheet.

D.  

Tag frequently accessed worksheets for ease of access.

A.  

The access to a single table

B.  

The access to data stored in stage objects

C.  

The list of values provided with the VALUES clause

D.  

The records generated using the TABLE (GENERATOR (...)) construct

A.  

It uses a local data repository for all compute nodes in the platform.

B.  

It is a blend of shared-disk and shared-everything database architectures.

C.  

It is a hybrid of traditional shared-disk and shared-nothing database architectures.

D.  

It reorganizes loaded data into internal optimized, compressed, and row-based format.

A.  

SHOW GRANTS ON ROLE

B.  

SHOW ROLES

C.  

SHOW GRANTS TO ROLE

D.  

SHOW GRANTS FOR ROLE

A.  

File URL

B.  

Scoped URL

C.  

Pre-signed URL

D.  

Scoped file URL

A.  

Data classification

B.  

Query acceleration service

C.  

Search optimization service

D.  

Tagging

A.  

Cloud services

B.  

Query processing

C.  

Elastic memory

D.  

Database storage

A.  

ARRAY_AGG

B.  

OBJECT_AGG

C.  

ARRAY_CONSTRUCT

D.  

OBJECT_CONSTRUCT

A.  

A single executable statement can call only two stored procedures. In contrast, a single SQL statement can call multiple UDFs.

B.  

A single executable statement can call only one stored procedure. In contrast, a single SQL statement can call multiple UDFs.

C.  

A single executable statement can call multiple stored procedures. In contrast, multiple SQL statements can call the same UDFs.

D.  

Multiple executable statements can call more than one stored procedure. In contrast, a single SQL statement can call multiple UDFs.