COF-C03 Practice Questions

A.  

Aggregate

B.  

Scalar

C.  

Table

D.  

Window

A.  

Hierarchical key model

B.  

Client-side encryption

C.  

Tri-secret secure encryption

D.  

Key pair authentication

A.  

Disjuncts (OR) in join predicates

B.  

LIKE/ILIKE/RLIKE join predicates

C.  

Join predicates on VARIANT columns

D.  

Conjunctions (AND) of multiple equality predicates

A.  

ALTER ROLE

B.  

REVOKE ROLE

C.  

USE ROLE

D.  

USE SECONDARY ROLES

A.  

LIST

B.  

ALTER FILE FORMAT

C.  

DESCRIBE FILE FORMAT

D.  

SHOW FILE FORMATS

A.  

If a role was specified as part of the connection and that role has been granted to the Snowflake user, the specified role becomes the current role.

B.  

If no role was specified as part of the connection and a default role has been defined for the Snowflake user, that role becomes the current role.

C.  

If no role was specified as part of the connection and a default role has not been set for the Snowflake user, the session will not be initiated and the log in will fail.

D.  

If a role was specified as part of the connection and that role has not been granted to the Snowflake user, it will be ignored and the default role will become the current role.

E.  

If a role was specified as part of the connection and that role has not been granted to the Snowflake user, the role is automatically granted and it becomes the current role.

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.  

Caching

B.  

Cluster depth

C.  

Query pruning

D.  

Retrieval optimization

A.  

Temporary tables

B.  

Permanent tables

C.  

Transient tables

D.  

External tables

E.  

User-Defined Table Functions (UDTFs)

A.  

Using a larger virtual warehouse

B.  

Increasing the virtual warehouse maximum timeout limit

C.  

Increasing the amount of remote storage for the virtual warehouse

D.  

Using a common table expression (CTE) instead of a temporary table

A.  

SELECT

B.  

OWNERSHIP

C.  

MONITOR

D.  

MODIFY

E.  

USAGE

A.  

OAuth

B.  

Network policies

C.  

Single Sign-On (SSO)

D.  

Multi-Factor Authentication (MFA)

A.  

Account

B.  

Database

C.  

Schema

D.  

Table

A.  

DATABASE_STORAGE_USAGE_HISTORY

B.  

TABLE_STORAGE_METRICS

C.  

STORAGE_DAILY_HISTORY

D.  

STAGE STORAGE USAGE HISTORY

A.  

1 hour

B.  

2 hours

C.  

4 hours

D.  

8 hours

A.  

Review the granted privileges to the database object.

B.  

Review the row access policy for the database object.

C.  

Query the ACCESS_HlSTORY view in the ACCOUNT_USAGE schema.

D.  

Query the REPLICATION USAGE HISTORY view in the ORGANIZATION USAGE schema.

A.  

Use COPY INTO < external stage > followed by a GET command to download the file.

B.  

Use COPY INTO < internal stage > followed by a put command to download the file.

C.  

Use COPY INTO < internal stage > with SINGLE = TRUE followed by a GET command to download the file.

D.  

Use COPY INTO < external stage > with SINGLE = TRUE followed by a PUT command to download the file.

A.  

ARRAY

B.  

BLOB

C.  

CLOB

D.  

JSON

E.  

VARIANT

A.  

Tags

B.  

Comments

C.  

Internal tokenization

D.  

Row access policies

A.  

SQL functions like the GET command can be used to copy the unstructured data to a location on the client.

B.  

SQL functions can be used to create different types of URLs pointing to the unstructured data. These URLs can be used to download the data to a client.

C.  

SQL functions can be used to retrieve the data from the query results cache. When the query results are output to a client, the unstructured data will be output to the client as files.

D.  

SQL functions can call on different web extensions designed to display different types of files as a web page. The web extensions will allow the files to be downloaded to the client.