COF-C03 Practice Questions

A.  

Copy data into files.

B.  

Manage different databases and schemas.

C.  

Troubleshoot network connections to Snowflake.

D.  

Write SELECT queries to retrieve data from external tables.

A.  

INTEGER

B.  

OBJECT

C.  

VARIANT

D.  

VARCHAR

E.  

LIST

A.  

To store actual data from external stages

B.  

To automatically expire file URLs for security

C.  

To manage user privileges and access control

D.  

To store file-level metadata about data files in a stage

A.  

ACCESS_HISTORY

B.  

DATA_TRANSFER_HISTORY

C.  

WAREHOUSE_METERING_HISTORY

D.  

MONETIZED_USAGE_DAILY

E.  

LISTING TELEMETRY DAILY

A.  

Views

B.  

Materialized views

C.  

Tables

D.  

External tables

E.  

Future grants

A.  

It removes null values from all columns in the data.

B.  

It converts null values to empty strings during loading.

C.  

It skips rows with null values during the loading process.

D.  

It removes object or array elements containing null values.

A.  

To count the number of characters in a string

B.  

To split a string into an array of sub-strings

C.  

To split a string and flatten the results into rows

D.  

To split a string and flatten the results into columns

A.  

A user with an USERADMIN or higher role

B.  

A user with a SECURITYADMIN or higher role

C.  

A role that has been granted the ATTACH POLICY privilege

D.  

A role that has the NETWORK_POLlCY account parameter set

E.  

A role that has the ownership of the network policy

A.  

When creating a table

B.  

When loading data into a table

C.  

When unloading data from a table

D.  

When executing a show command

E.  

When executing a list command

A.  

Queries without filters or aggregation

B.  

Queries with large scans and selective filters

C.  

Queries where the GROUP BY has high cardinality

D.  

Queries of tables that have search optimization service enabled

A.  

Column reordering

B.  

Column omission

C.  

JOIN function

D.  

FLATTEN function

E.  

GROUP BY function

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.

A.  

Temporary tables

B.  

Permanent tables

C.  

Transient tables

D.  

External tables

E.  

User-Defined Table Functions (UDTFs)

A.  

ARRAY

B.  

BLOB

C.  

CLOB

D.  

JSON

E.  

VARIANT

A.  

OAuth

B.  

Network policies

C.  

Single Sign-On (SSO)

D.  

Multi-Factor Authentication (MFA)

A.  

CREATE STAGE

B.  

COPY INTO < table >

C.  

COPY INTO < location >

D.  

CREATE PIPE

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.  

INSERT

B.  

JOIN

C.  

RENAME

D.  

ALTER

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.  

USERADMIN

B.  

ORGADMIN

C.  

SYSADMIN

D.  

SECURITYADMIN