COF-C03 Practice Questions

A.  

The Data Consumer pays for data storage as well as for data computing.

B.  

The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

C.  

A Snowflake account can both provide and consume shared data.

D.  

The Provider is charged for compute resources used by the Data Consumer to query the shared data.

E.  

The Data Consumer pays only for compute resources to query the shared data.

A.  

VIEWS_HISTORY

B.  

OBJECT_HISTORY

C.  

ACCESS_HISTORY

D.  

LOGIN_HISTORY

A.  

SINGLE=TRUE

B.  

MULTIPLE=TRUE

C.  

MULTIPLE=FALSE

D.  

SINGLE=FALSE

A.  

True

B.  

False

A.  

30 days

B.  

7 days

C.  

48 hours

D.  

24 hours

A.  

SYSADMIN

B.  

ORGADMIN

C.  

ACCOUNTADMIN

D.  

SECURITYADMIN

A.  

Queries against large tables where frequent DML occurs

B.  

Queries against tables larger than 1 TB

C.  

Selective point lookup queries

D.  

Queries against a subset of columns in a table

A.  

Clustering

B.  

Materialized Views

C.  

Zero-copy Cloning

D.  

Search Optimization Service

A.  

The data is cloned into a historical object.

B.  

The data moves to Fail-safe

C.  

Time Travel on the historical data is dropped.

D.  

The object containing the historical data is dropped.

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.  

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.  

Configure the warehouse to a size larger than generally required

B.  

Set the minimum and maximum clusters to autoscale

C.  

Use the standard warehouse scaling policy

D.  

Use the economy warehouse scaling policy

A.  

Role

B.  

Stream

C.  

Warehouse

D.  

External table

E.  

User

F.  

Share

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.  

Create transient tables and periodically copy them to permanent tables.

B.  

Create temporary tables and periodically copy them to permanent tables

C.  

Create regular tables with extended Time Travel and Fail-safe settings.

D.  

Create regular tables with default Time Travel and Fail-safe settings

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.  

To enhance data security and privacy

B.  

To provide real-lime monitoring of user activities

C.  

To separate user authentication from user access

D.  

To enable direct integration with external databases

A.  

Materialized view

B.  

Table clustering

C.  

Query acceleration service

D.  

Search optimization service

A.  

A query that uses only disjunction (i.e., OR) predicates

B.  

A query that includes analytical expressions

C.  

A query that uses equality predicates or predicates that use IN

D.  

A query that filters on semi-structured data types

A.  

Standard

B.  

Enterprise

C.  

Business Critical

D.  

Virtual Private Snowflake