COF-C02 Practice Questions

A.  

True

B.  

False

A.  

Business Critical Edition

B.  

Standard Edition

C.  

Virtual Private Snowflake (VPS)

D.  

Enterprise Edition

A.  

Local disk caching

B.  

Authentication and access control

C.  

Metadata management

D.  

Query processing

E.  

Database storage

A.  

10-50 MB

B.  

100-250 MB

C.  

300-500 MB

D.  

1000-1500 MB

A.  

Standard

B.  

Enterprise

C.  

Business Critical

D.  

Virtual Private Snowflake

A.  

1 day

B.  

7 days

C.  

12 hours

D.  

0 days

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.  

Tri-Secret Secure

B.  

Time Travel

C.  

Fail-safe

D.  

Data encryption

E.  

External stages

A.  

Data expires from Time Travel

B.  

Data expires from Fail-safe

C.  

Data is deleted from a table

D.  

Data is truncated from a table

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.  

Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).

B.  

All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.

C.  

The ACCOUNTADMIN role must be granted to only one user.

D.  

Assign the ACCOUNTADMIN role to at least two users, but as few as possible.

E.  

All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

A.  

PURGE

B.  

MODIFY

C.  

REMOVE

D.  

DELETE

A.  

To create separate data warehouses to increase query optimization

B.  

To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster

C.  

To eliminate or reduce Queuing of concurrent queries

D.  

To allow the warehouse to resize automatically

A.  

Default Time Travel Retention is set to 0 days.Maximum Time Travel Retention is 30 days.Fail Safe retention time is 1 day.

B.  

Default Time Travel Retention is set to 1 day.Maximum Time Travel Retention is 365 days.Fail Safe retention time is 7 days.

C.  

Default Time Travel Retention is set to 0 days.Maximum Time Travel Retention is 90 days.Fail Safe retention time is 7 days.

D.  

Default Time Travel Retention is set to 1 day.Maximum Time Travel Retention is 90 days.Fail Safe retention time is 7 days.

E.  

Default Time Travel Retention is set to 7 days.Maximum Time Travel Retention is 1 day.Fail Safe retention time is 90 days.

F.  

Default Time Travel Retention is set to 90 days.Maximum Time Travel Retention is 7 days.Fail Safe retention time is 356 days.

A.  

parse_json()

B.  

json_extract_path_text()

C.  

object_construct()

D.  

flatten

A.  

Protegrity

B.  

Tableau

C.  

DBeaver

D.  

SAP

A.  

COPY WAREHOUSE FROM < < config file > > ;

B.  

SET WAREHOUSE = < < warehouse name > > ;

C.  

USE WAREHOUSE < < warehouse name > > ;

D.  

USE VIRTUAL_WAREHOUSE < < warehouse name > > ;

A.  

SELECT SUM (ORDER_AMT) FROM SALES;

B.  

SELECT AVG(ORDER_QTY) FROM SALES;

C.  

SELECT MIN(ORDER_AMT) FROM SALES;

D.  

SELECT ORDER_AMT * ORDER_QTY FROM SALES;

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.  

XML

B.  

JSON

C.  

Parquet

D.  

ORC

E.  

AVRO

F.  

CSV