COF-C03 Practice Questions

A.  

When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

B.  

When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.

C.  

When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

D.  

When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.

A.  

list @bronzestage;

B.  

select * from directory(@bronzestage);

C.  

select metadata$filename from @bronzestage;

D.  

select * from table(information_schema.stage_directory_file_registration_history(stage name= > ' bronzestage1));

A.  

A logical grouping of objects that belongs to a single database

B.  

A logical grouping of objects that belongs to multiple databases

C.  

A named Snowflake object that includes all the information required to share a database

D.  

A uniquely identified Snowflake account within a business entity

A.  

There is minimal cost associated with running the query.

B.  

The query consumes many compute resources every time it runs.

C.  

The base table gets updated frequently.

D.  

The query is highly optimized and does not consume many compute resources.

E.  

The results of the query do not change often and are used frequently.

A.  

Directory

B.  

File

C.  

Pre-signed

D.  

Scoped

A.  

Range Partitioning

B.  

Search Optimization Service

C.  

Automatic Clustering

D.  

Horizontal Partitioning

A.  

External tables

B.  

Secure views

C.  

Materialized views

D.  

User-Defined Functions (UDFs)

A.  

Enable the data sharing feature in the account and validate the view.

B.  

Use the CURRENT_ROLE and CURRENT_USER functions to validate secure views.

C.  

Use the CURRENT_ function to authorize users from a specific account to access rows in a base table.

D.  

Set the SIMULATED DATA SHARING CONSUMER session parameter to the name of the consumer account for which access is being simulated.

A.  

Indefinitely

B.  

Until the result_cache expires

C.  

Until the retention_time is met

D.  

Until the expiration time is exceeded

A.  

CHECK_OPTION

B.  

IS_SECURE

C.  

IS_UPDATEABLE

D.  

TABLE_NAME

A.  

Data storage

B.  

Dynamic data masking

C.  

Partition scanning

D.  

User authentication

E.  

Infrastructure management

A.  

One

B.  

Two

C.  

Three

D.  

Unlimited

A.  

When the data cache clears.

B.  

When the persisted query result period ends.

C.  

The encoded URL access is permanent.

D.  

The length of time is specified in the expiration_time argument.

A.  

Coordinates activities in the Snowflake account

B.  

Executes queries submitted by the Snowflake account users

C.  

Manages quotas on the Snowflake account storage

D.  

Manages the virtual warehouse cache to speed up queries

A.  

Virtual Private Snowflake

B.  

Business Critical

C.  

Enterprise

D.  

Standard

A.  

Cloud services layer

B.  

Compute layer

C.  

Storage layer

D.  

Cloud agnostic layer

A.  

ORGADMIN

B.  

USERADMIN

C.  

SYSADMIN

D.  

SECURITYADMIN

A.  

A reader account can consume data from the provider account that created it and combine it with its own data.

B.  

A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

C.  

The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

D.  

The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

A.  

Table definition

B.  

Stage definition

C.  

Session level

D.  

COPY INTO TABLE statement

A.  

Contacts

B.  

Sharing settings

C.  

Copy History

D.  

Query History

E.  

Automatic Clustering History