COF-C03 Practice Questions

A.  

The data from the permanent table.

B.  

The data from the temporary table.

C.  

An error stating that the view could not be compiled.

D.  

An error stating that the referenced object could not be uniquely identified.

A.  

It does not retain any privileges granted on the source object.

B.  

It replicates all granted privileges on the corresponding source objects.

C.  

It replicates all granted privileges on the corresponding child objects.

D.  

It replicates all granted privileges on the corresponding child schema objects.

A.  

Create objects with ACCOUNTADMIN and do not reassign ownership.

B.  

Create objects with SYSADMIN.

C.  

Create objects with SECURITYADMIN to ease granting of privileges later.

D.  

Create objects with a custom role and grant this role to SYSADMIN.

E.  

Use only MANAGED ACCESS SCHEMAS for66 objects owned by ACCOUNTADMIN.

A.  

Account and user authentication is only available with the Snowflake Business Critical edition.

B.  

Support for HIPAA and GDPR compliance is available for UI Snowflake editions.

C.  

Periodic rekeying of encrypted data is available with the Snowflake Enterprise edition and higher

D.  

Private communication to internal stages is allowed in the Snowflake Enterprise edition and higher.

A.  

Account

B.  

Database

C.  

Organization

D.  

Schema

E.  

Virtual warehouse

A.  

Include the SQL statements in the body of the task CREATE TASK mytask .. AS INSERT INTO target1 SELECT .. FROM stream_s1 WHERE .. INSERT INTO target2 SELECT .. FROM stream_s1WHERE ..

B.  

A stored procedure can have only one DML statement per stored procedure invocation and therefore the user should sequence stored procedure calls in the taskdefinition CREATE TASK mytask .... AScall stored_proc1(); call stored_proc2();

C.  

Use a stored procedure executing multiple SQL statements and invoke the stored procedure from the task. CREATE TASK mytask .... AS call stored_proc_multiple_statements_inside();

D.  

Create a task for each SQL statement (e.g. resulting in task1, task2, etc.) and string the series of SQL statements by having a control task calling task1, task2, etc. sequentially.

A.  

CHECK_JSON

B.  

TO_JSON

C.  

FLATTEN

D.  

PARSE_JSON

A.  

Analyze query performance.

B.  

Write queries and execute them.

C.  

Provide an overview of the listings in the Snowflake Marketplace.

D.  

Connect to Snowflake partners to explore extended functionality.

A.  

When using a paid listing on the Snowflake Marketplace

B.  

When using a private listing on the Snowflake Marketplace

C.  

When using a personalized listing on the Snowflake Marketplace

D.  

When using a Direct Share with another account

A.  

Infrastructure management

B.  

Metadata management

C.  

Query execution

D.  

Query parsing and optimization

E.  

Permanent storage of micro-partitions

A.  

Files

B.  

External tables

C.  

Secure User-Defined Functions (UDFs)

D.  

Sequences

E.  

Streams

A.  

SnowCLI

B.  

SnowUI

C.  

SnowSQL

D.  

SnowCD

A.  

Java

B.  

Javascript

C.  

Scala

D.  

Python

E.  

SQL

A.  

Enterprise

B.  

Business Critical

C.  

Standard

D.  

Virtual Private Snowflake

A.  

Modify the columns in the underlying table

B.  

Use the ALTER VIEW command to update the view

C.  

Recreate the view with the required changes

D.  

Materialize the view to perform the changes

A.  

CREATE_SHARE on the account

B.  

SHARE on databases and schemas

C.  

SELECT on tables used by the secure view

D.  

REFERENCE_USAGE on databases

A.  

The filtering or disregarding of micro-partitions that are not needed to return a query.

B.  

The return of micro-partitions values that overlap with each other to reduce a query ' s runtime.

C.  

A service that is handled by the Snowflake Cloud Services layer to optimize caching.

D.  

The ability to allow the result of a query to be accessed as if it were a table.

A.  

Append-only

B.  

External

C.  

Insert-only

D.  

Standard

A.  

Auto-scale mode

B.  

Maximized mode

C.  

Economy scaling policy

D.  

Standard scaling policy

A.  

ARRAY

B.  

OBJECT

C.  

VARCHAR

D.  

VARIANT