COF-C03 Practice Questions

A.  

Faster query performance and increased storage consumption

B.  

Slower query performance and increased storage consumption

C.  

Faster query performance and decreased storage consumption

D.  

Slower query performance and decreased storage consumption

A.  

Secure view

B.  

Materialized view

C.  

Temporary table

D.  

Transient table

A.  

MODIFY

B.  

READ

C.  

SELECT

D.  

USAGE

A.  

A single-cluster shared data architecture using a central data repository and massively parallel processing (MPP)

B.  

A multi-duster shared nothing architecture using a soloed data repository and massively parallel processing (MPP)

C.  

A single-cluster shared nothing architecture using a sliced data repository and symmetric multiprocessing (SMP)

D.  

A multi-cluster shared nothing architecture using a siloed data repository and symmetric multiprocessing (SMP)

A.  

Hierarchical key model

B.  

Client-side encryption

C.  

Tri-secret secure encryption

D.  

Key pair authentication

A.  

FLATTEN

B.  

CHECK_JSON

C.  

PARSE_JSON

D.  

TO_VARIANT

A.  

To create separate data warehouses to increase query optimization

B.  

To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster

C.  

To eliminate or reduce Queuing of concurrent queries

D.  

To allow the warehouse to resize automatically

A.  

ACCOUNTADMIN

B.  

SECURITYADMIN

C.  

SYSADMIN

D.  

ORGADMIN

A.  

Binary format

B.  

Columnar format

C.  

Compressed format

D.  

Raw format

E.  

Zipped format

A.  

Aggregate

B.  

Scalar

C.  

Table

D.  

Window

A.  

Snowflake will resolve them according to the SEARCH_PATH parameter.

B.  

Snowflake will only check the schema the UDF belongs to.

C.  

Snowflake will first check the current schema, and then the schema the previous query used

D.  

Snowflake will first check the current schema, and them the PUBLIC schema of the current database.

A.  

1

B.  

5

C.  

10

D.  

100

A.  

ACCOUNTADMIN

B.  

SECURITYADMIN

C.  

SYSADMIN

D.  

ORGADMIN

A.  

When the system has enough load for 2 minutes

B.  

When the system has enough load for 6 minutes

C.  

When the system has enough load for 8 minutes

D.  

When the system has enough load for 10 minutes

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.  

Avro

B.  

CSV

C.  

JSON

D.  

Parquet

A.  

1 day

B.  

7 days

C.  

14 days

D.  

64 days

A.  

Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.

B.  

The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.

C.  

SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.

D.  

A user cannot specify a default warehouse when using the ODBC driver.

E.  

The default virtual warehouse size can be changed at any time.

A.  

They can be created as secure and hide the underlying metadata from the user.

B.  

They can only access tables from a single database.

C.  

They can contain only a single SQL statement.

D.  

They can be created to run with a caller ' s rights or an owner ' s rights.

A.  

Snowflake data and services are deployed in a single availability zone within a cloud provider ' s region.

B.  

Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.

C.  

Snowflake can be deployed in a customer ' s private cloud using the customer ' s own compute and storage resources for Snowflake compute and storage

D.  

Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage

E.  

All three layers of Snowflake ' s architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform

F.  

Snowflake data and services are deployed in at least three availability zones within a cloud provider ' s region