COF-C03 Practice Questions

A.  

Standard

B.  

Enterprise

C.  

Business Critical

D.  

Virtual Private Snowflake

A.  

Use data encryption.

B.  

Use dynamic data masking.

C.  

Use secure materialized views.

D.  

Revoke all roles for functional managers and end users.

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.  

Compute resources

B.  

Query execution

C.  

Authentication

D.  

Data storage

E.  

Metadata

A.  

COPY WAREHOUSE FROM < < config file > > ;

B.  

SET WAREHOUSE = < < warehouse name > > ;

C.  

USE WAREHOUSE < < warehouse name > > ;

D.  

USE VIRTUAL_WAREHOUSE < < warehouse name > > ;

A.  

Use the DROP < file > command after the load completes.

B.  

Specify the TEMPORARY option when creating the file format.

C.  

Specify the PURGE copy option in the COPY INTO < table > command.

D.  

Use the REMOVE command after the load completes.

E.  

Use the DELETE LOAD HISTORY command after the load completes.

A.  

Privileges on the database

B.  

Existing child objects within the database

C.  

Future child objects within the database

D.  

Privileges on the schemas within the database

E.  

Only schemas and tables within the database

A.  

10-50 MB

B.  

100-250 MB

C.  

300-500 MB

D.  

1000-1500 MB

A.  

Within the policy DDL

B.  

Within the create table or create view DDL

C.  

By future APPLY for all objects in a schema

D.  

Within a control table

E.  

Using the command ALTER < object > ADD ROW ACCESS POLICY < policy > ;

A.  

A task can be called using a CALL statement to run a set of predefined SQL commands.

B.  

A task allows a user to execute a single SQL statement/command using a predefined schedule.

C.  

A task allows a user to execute a set of SQL commands on a predefined schedule.

D.  

A task can be executed using a SELECT statement to run a predefined SQL command.

A.  

When it is unknown how much compute power is needed

B.  

If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)

C.  

If the runtime of the executed query is very slow

D.  

When a large number of concurrent queries are run on the same warehouse

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.

A.  

NOTIF

B.  

NOTIFY_USERS

C.  

SUSPEND

D.  

SUSPEND_IMMEDIATE

A.  

Schemas

B.  

Databases

C.  

Masking policies

D.  

External functions

E.  

Virtual warehouses

A.  

Snowflake tables arc logical representation of underlying physical data.

B.  

Snowflake tables are the physical instantiation of data loaded into Snowflake.

C.  

Snowflake tables require that clustering keys be defined lo perform optimally.

D.  

Snowflake tables are owned by a use.

A.  

It increases the default selectivity of any filter parameters when the query is accelerated.

B.  

It is used when there are not enough partitions in a table to accelerate the query.

C.  

It controls costs by setting an upper bound on the amount of compute resources a warehouse can use for query acceleration.

D.  

It is a concurrency control tool used to avoid unnecessary scaling up when the query is accelerated and the warehouse is running in Maximized mode.

A.  

Data provider

B.  

Data consumer

C.  

Reader

D.  

Organization

A.  

By setting up network policies with IPv4 IP addresses

B.  

By putting the Snowflake URL on the allowed list for get method responses

C.  

By manually setting up vulnerability patch management policies

D.  

By manually setting up an Intrusion Prevention System (IPS) on each account

A.  

Convert the virtual warehouse to Maximized mode.

B.  

Increase the size of the virtual warehouse.

C.  

Increase the auto suspend time in the virtual warehouse.

D.  

Increase the number of clusters in the virtual warehouse.

A.  

CONTINUE

B.  

SKIP_FILE

C.  

SKIP_FILE_ < num >

D.  

ABORT_STATEMENT