COF-C03 Practice Questions

A.  

Column compression

B.  

Data clustering

C.  

Micro-partitioning

D.  

Metadata management

A.  

A single data type, with one or more conditions, and one or more masking functions

B.  

A single data type, with only one condition, and only one masking function

C.  

Multiple data types, with only one condition, and one or more masking functions

D.  

Multiple data types, with one or more conditions, and one or more masking functions

A.  

Secure view

B.  

Materialized view

C.  

Temporary table

D.  

Transient table

A.  

A separate database object that is used to store file-level metadata

B.  

An object layered on a stage that is used to store file-level metadata

C.  

A database object with grantable privileges for unstructured data tasks

D.  

A Snowflake table specifically designed for storing unstructured files

A.  

Send an alert notification to all account users who have notifications enabled.

B.  

Send an alert notification to all virtual warehouse users when thresholds over 100% have been met.

C.  

Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses after all statements being executed by the warehouses have completed.

D.  

Send a notification to all account administrators who have notifications enabled, and suspend all assigned warehouses immediately, canceling any statements being executed by the warehouses.

A.  

Enable Time Travel.

B.  

Clone the dropped stage.

C.  

Execute the UNDROP command.

D.  

Recreate the dropped stage.

A.  

Access history

B.  

Data classification

C.  

Dynamic Data Masking

D.  

Object tagging

A.  

1 hour

B.  

2 hours

C.  

4 hours

D.  

8 hours

A.  

Casts the values of the flattened data

B.  

Extracts the path of the flattened data

C.  

Joins information outside the object with the flattened data

D.  

Retrieves a single instance of a repeating element in the flattened data

A.  

The objects are dropped.

B.  

The objects enter the Fail-safe period.

C.  

The objects enter the Time Travel period.

D.  

The objects are immediately moved to the provider account.

A.  

GET_PRESIGNED_URL

B.  

GET_ABSOLUTE_PATH

C.  

BUILD_STAGE_FILE_URL

D.  

BUILD SCOPED FILE URL

A.  

All child objects will retain data for the new retention period.

B.  

All child objects that do not have an explicit retention period will automatically inherit the new retention period.

C.  

All child objects with an explicit retention period will be overridden with the new retention period.

D.  

All explicit child object retention periods will remain unchanged.

A.  

MONITOR

B.  

OPERATE

C.  

OWNERSHIP

D.  

ALL

A.  

Account

B.  

Database

C.  

Schema

D.  

Table

A.  

FOR

B.  

LOOP

C.  

REPEAT

D.  

WHILE

A.  

ARRAY

B.  

OBJECT

C.  

VARCHAR

D.  

VARIANT

A.  

Directory

B.  

External

C.  

Temporary

D.  

Transient

A.  

CSV

B.  

JSON

C.  

ORC

D.  

Parquet

A.  

When users will be using compute at different times throughout a 24/7 period

B.  

When managing a steady workload

C.  

When the compute must be available with no delay or lag time

D.  

When the user does not want to have to manually turn on the warehouse each time it is needed

E.  

When the warehouse is shared across different teams

A.  

A materialized view can query only a single table.

B.  

Data accessed through materialized views can be stale.

C.  

Materialized view refreshes need to be maintained by the user.

D.  

Querying a materialized view is slower than executing a query against the base table of the view.