COF-C03 Practice Questions

A.  

The access to a single table

B.  

The access to data stored in stage objects

C.  

The list of values provided with the VALUES clause

D.  

The records generated using the TABLE (GENERATOR (...)) construct

A.  

It uses a local data repository for all compute nodes in the platform.

B.  

It is a blend of shared-disk and shared-everything database architectures.

C.  

It is a hybrid of traditional shared-disk and shared-nothing database architectures.

D.  

It reorganizes loaded data into internal optimized, compressed, and row-based format.

A.  

Data storage

B.  

Dynamic data masking

C.  

Partition scanning

D.  

User authentication

E.  

Infrastructure management

A.  

The provisioning of new compute resources for the warehouse will begin immediately.

B.  

The warehouse will remain suspended but new resources will be added to the query acceleration service.

C.  

The provisioning of additional compute resources will be in effect when the warehouse is next resumed.

D.  

The warehouse will resume immediately and start to share the compute load with other running virtual warehouses.

A.  

There are multiple SOL UDFs with the same names and the same number of arguments.

B.  

There are multiple SQL UDFs with the same names and the same number of argument types.

C.  

There are multiple SQL UDFs with the same names but with a different number of arguments or argument types.

D.  

There are multiple SQL UDFs with different names but the same number of arguments or argument types.

A.  

File URL

B.  

Scoped URL

C.  

Pre-signed URL

D.  

Scoped file URL

A.  

0 days

B.  

1 day

C.  

7 days

D.  

14 days

A.  

Create an account for an organization.

B.  

Edit the account data for an organization.

C.  

Delete the account data for an organization.

D.  

View usage information for all accounts in an organization.

E.  

Select all the data in tables for all accounts in an organization.

A.  

They are a set of rules that define the network routes within Snowflake.

B.  

They are a set of rules that dictate how Snowflake accounts can be used between multiple users.

C.  

They are a set of rules that define how data can be transferred between different Snowflake accounts within an organization.

D.  

They are a set of rules that control access to Snowflake accounts by specifying the IP addresses or ranges of IP addresses that are allowed to connectto Snowflake.

A.  

GET_STATE_LOCATION

B.  

GET_PRESENT_URL

C.  

BUILD_SCOPED_FILE_URL

D.  

BUILD_STAGE_FILE_URL

A.  

GROUP BY

B.  

LIMIT

C.  

ORDER BY

D.  

PARTITION BY

E.  

UNION ALL

A.  

SHOW TABLES command

B.  

SHOW EXTERNAL TABLES command

C.  

TABLES view

D.  

TABLE STORAGE METRICS view

A.  

COPY INTO

B.  

GET

C.  

INSERT INTO

D.  

PUT

A.  

(12,2)

B.  

(10,4)

C.  

(14,8)

D.  

(15,9)

A.  

Reader account users cannot add new data to the account.

B.  

Reader account users can share data to other reader accounts.

C.  

A single reader account can consume data from multiple provider accounts.

D.  

Data consumers are responsible for reader account setup and data usage costs.

E.  

Reader accounts enable data consumers to access and query data shared by the provider.

A.  

TEXT

B.  

BINARY

C.  

STRING

D.  

VARIANT

A.  

1 hour

B.  

2 hours

C.  

4 hours

D.  

8 hours

A.  

60

B.  

91

C.  

120

D.  

121

A.  

Secure view

B.  

Materialized view

C.  

Temporary table

D.  

Transient table

A.  

Data classification

B.  

Query acceleration service

C.  

Search optimization service

D.  

Tagging