COF-C03 Practice Questions

A.  

Local disk caching

B.  

Authentication and access control

C.  

Metadata management

D.  

Query processing

E.  

Database storage

A.  

Compute resources

B.  

Query execution

C.  

Authentication

D.  

Data storage

E.  

Metadata

A.  

Whether or not it is also a secure view

B.  

How often the underlying base table is queried

C.  

How often the base table changes

D.  

Whether the materialized view has a cluster key defined

E.  

How often the materialized view is queried

A.  

Protegrity

B.  

Tableau

C.  

DBeaver

D.  

SAP

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.  

Avro

B.  

JSON

C.  

ORC

D.  

XML

E.  

Delimited (CSV, TSV, etc.)

A.  

Aim to produce data files that are between 100 MB and 250 MB in size, compressed.

B.  

Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.

C.  

Enclose fields that contain delimiter characters in single or double quotes.

D.  

Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.

E.  

When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.

F.  

Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.

A.  

Management of metadata

B.  

Computing the data

C.  

Maintaining Availability Zones

D.  

Infrastructure security

E.  

Parsing and optimizing queries

A.  

Standard

B.  

Enterprise

C.  

Business Critical

D.  

Virtual Private Snowflake

A.  

90 days

B.  

1 day

C.  

7 days

D.  

45 days

A.  

Snowflake leverages a Role-Based Access Control (RBAC) model.

B.  

Snowflake requires a user to configure an IAM user to connect to the database.

C.  

All data in Snowflake is encrypted.

D.  

Snowflake can run within a user ' s own Virtual Private Cloud (VPC).

E.  

All data in Snowflake is compressed.

A.  

Standard

B.  

Enterprise

C.  

Business Critical

D.  

Virtual Private Snowflake

A.  

Data expires from Time Travel

B.  

Data expires from Fail-safe

C.  

Data is deleted from a table

D.  

Data is truncated from a table

A.  

Business Critical Edition

B.  

Standard Edition

C.  

Virtual Private Snowflake (VPS)

D.  

Enterprise Edition

A.  

Schema

B.  

View

C.  

Internal stage

D.  

Table

E.  

User

F.  

Role

A.  

Row access policies

B.  

Data masking policies

C.  

Data encryption

D.  

Role based access control

A.  

Role

B.  

Schema

C.  

User

D.  

Database

E.  

Account

F.  

Tables

A.  

Compute

B.  

Data storage

C.  

Cloud services

D.  

Cloud provider

A.  

Create a zero-copy clone of the worksheet and grant permissions to teammates

B.  

Create a private Data Exchange so that any teammate can use the worksheet

C.  

Share the worksheet with teammates within Snowsight

D.  

Create a database and grant all permissions to teammates

A.  

The cloned views and the stored procedures will reference the cloned tables in the cloned database.

B.  

An error will occur, as views with qualified references cannot be cloned.

C.  

An error will occur, as stored objects cannot be cloned.

D.  

The stored procedures and views will refer to tables in the source database.