COF-C03 Practice Questions

A.  

INSERT

B.  

PUT

C.  

GET

D.  

COPY

A.  

Schema

B.  

View

C.  

Internal stage

D.  

Table

E.  

User

F.  

Role

A.  

Authentication

B.  

Resource management

C.  

Virtual warehouse caching

D.  

Query parsing and optimization

E.  

Query execution

F.  

Physical storage of micro-partitions

A.  

PUT

B.  

GET

C.  

COPY

D.  

SELECT

A.  

select src:dealership from car_sales;

B.  

select src.dealership from car_sales;

C.  

select src:Dealership from car_sales;

D.  

select dealership from car_sales;

A.  

Per second multiplied by an automatic sizing for the job

B.  

Per minute multiplied by an automatic sizing for the job, with a minimum of one minute

C.  

Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter

D.  

Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

A.  

Role

B.  

Schema

C.  

User

D.  

Database

E.  

Account

F.  

Tables

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.  

Compress the file and load the compressed file.

B.  

Split the file into multiple files in the recommended size range (100 MB - 250 MB).

C.  

Use a larger-sized warehouse.

D.  

Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.

A.  

4

B.  

8

C.  

16

D.  

32

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.  

CONTENT

B.  

PATH

C.  

BYTE_SIZE

D.  

INDEX

E.  

DATATYPE

A.  

Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.

B.  

Scaling out adds clusters of varying sizes to a virtual warehouse.

C.  

Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.

D.  

Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.

E.  

Scaling up resizes a virtual warehouse so it can handle more complex workloads.

F.  

Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

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.  

JOIN

B.  

COPY INTO

C.  

PUT

D.  

GET

A.  

If the query contains a deterministic function

B.  

If the virtual warehouse has been suspended

C.  

If the referenced data in the table has changed

D.  

If multiple users are using the same virtual warehouse

A.  

Tables, secure views, and secure UDFs can be shared

B.  

Shares can be shared

C.  

Data consumers can clone a new table from a share

D.  

Access to a share cannot be revoked once granted

A.  

Protegrity

B.  

Tableau

C.  

DBeaver

D.  

SAP

A.  

XML

B.  

JSON

C.  

Parquet

D.  

ORC

E.  

AVRO

F.  

CSV

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