COF-C03 Practice Questions

A.  

Grant the OWNERSHIP privilege on the schema.

B.  

Grant the OWNERSHIP privilege on the database.

C.  

Grant the MANAGE GRANTS global privilege.

D.  

Grant ALL privileges on the schema.

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.  

Cloud services layer

B.  

Compute layer

C.  

Storage layer

D.  

Cloud agnostic layer

A.  

Bytes spilled to local cache.

B.  

Bytes spilled to local storage.

C.  

Bytes spilled to remote cache.

D.  

Bytes spilled to remote storage.

E.  

Bytes spilled to remote metastore.

A.  

Account

B.  

Database

C.  

Schema

D.  

Table

E.  

Virtual warehouse

A.  

External tables

B.  

Secure views

C.  

Materialized views

D.  

User-Defined Functions (UDFs)

A.  

Authy

B.  

Duo Security

C.  

One Login

D.  

RSA SecurlD Access

A.  

Security

B.  

Data storage

C.  

Data visualization

D.  

Query computation

E.  

Metadata management

A.  

The reader account will automatically use the Standard edition of Snowflake.

B.  

The reader account compute will be billed to the provider account.

C.  

The reader account can clone data the provider has shared, but cannot re-share it.

D.  

The reader account can create a copy of the shared data using CREATE TABLE AS...

A.  

@

B.  

&

C.  

$

D.  

#

A.  

1 minute

B.  

2 minutes

C.  

6 minutes

D.  

8 minutes

A.  

Duo Security

B.  

OAuth

C.  

Okta

D.  

Single Sign-On (SSO)

A.  

When users will be using compute at different times throughout a 24/7 period

B.  

When managing a steady workload

C.  

When the compute must be available with no delay or lag time

D.  

When the user does not want to have to manually turn on the warehouse each time it is needed

E.  

When the warehouse is shared across different teams

A.  

1 GB

B.  

5 GB

C.  

10 GB

D.  

16 GB

A.  

Query execution

B.  

Data loading

C.  

Time Travel data

D.  

Security

E.  

Authentication and access control

A.  

Pre-signed URL

B.  

Scoped URL

C.  

Signed URL

D.  

File URL

A.  

Within the data files

B.  

In the virtual warehouse layer

C.  

In the cloud services layer

D.  

In the remote storage layer

A.  

The data provider in Azure Central Canada can create a direct share to AWS Asia Pacific, if they are both in the same organization.

B.  

The data consumer and data provider can form a Data Exchange within the same organization to create a share from Azure Central Canada to AWS Asia Pacific.

C.  

The data provider uses the GET DATA workflow in the Snowflake Data Marketplace to create a share between Azure Central Canada and AWS Asia Pacific.

D.  

The data provider must replicate the database to a secondary account in AWS Asia Pacific within the same organization then create a share to the data consumer ' s account.

A.  

The columns that are queried in the select clause.

B.  

The columns with very high cardinality.

C.  

The columns with many different values.

D.  

The columns most actively used in the select filters.

A.  

A materialized view can query only a single table.

B.  

Data accessed through materialized views can be stale.

C.  

Materialized view refreshes need to be maintained by the user.

D.  

Querying a materialized view is slower than executing a query against the base table of the view.