COF-C03 Practice Questions

A.  

To profile how many times a particular query was executed and analyze its u^age statistics over time.

B.  

To profile a particular query to understand the mechanics of the query, its behavior, and performance.

C.  

To profile the user and/or executing role of a query and all privileges and policies applied on the objects within the query.

D.  

To profile which queries are running in each warehouse and identify proper warehouse utilization and sizing for better performance and cost balancing.

A.  

The user will be unable to enter a password.

B.  

The user will encounter an error, and will not be able to log in.

C.  

The user will be able to log into Snowflake successfully.

D.  

After entering the username and password, the user will be redirected to an Identity Provider (IdP) login page.

A.  

MONITOR

B.  

OPERATE

C.  

OWNERSHIP

D.  

ALL

A.  

INTEGER

B.  

OBJECT

C.  

VARIANT

D.  

VARCHAR

E.  

LIST

A.  

FOR

B.  

LOOP

C.  

REPEAT

D.  

WHILE

A.  

FLATTEN

B.  

GET_PATH

C.  

CHECK_JSON

D.  

PARSE JSON

A.  

The database owner

B.  

The object owner

C.  

The schema owner

D.  

The Snowflake user ' s role

A.  

A user with an USERADMIN or higher role

B.  

A user with a SECURITYADMIN or higher role

C.  

A role that has been granted the ATTACH POLICY privilege

D.  

A role that has the NETWORK_POLlCY account parameter set

E.  

A role that has the ownership of the network policy

A.  

Column reordering

B.  

Column omission

C.  

JOIN function

D.  

FLATTEN function

E.  

GROUP BY function

A.  

GET_PRESIGNED_URL

B.  

GET_ABSOLUTE_PATH

C.  

BUILD_STAGE_FILE_URL

D.  

BUILD SCOPED FILE URL

A.  

CREATE SESSION POLICY

B.  

CREATE NETWORK RULE

C.  

CREATE SECURITY INTEGRATION

D.  

CREATE PASSWORD POLICY

A.  

To store actual data from external stages

B.  

To automatically expire file URLs for security

C.  

To manage user privileges and access control

D.  

To store file-level metadata about data files in a stage

A.  

Range of values

B.  

Distinct values

C.  

Index values

D.  

Sorted values

E.  

Null values

A.  

To count the number of characters in a string

B.  

To split a string into an array of sub-strings

C.  

To split a string and flatten the results into rows

D.  

To split a string and flatten the results into columns

A.  

Warehouses that are multi-cluster can have nodes of different sizes.

B.  

Warehouses can be started and stopped at any time.

C.  

Warehouses can be resized at any time, even while running.

D.  

Warehouses are billed on a per-minute usage basis.

E.  

Warehouses can only be used for querying and cannot be used for data loading.

A.  

Column compression

B.  

Data clustering

C.  

Micro-partitioning

D.  

Metadata management

A.  

USAGE_VIEWER

B.  

GOVERNANCE_VIEWER

C.  

OBJECT_VIEWER

D.  

SECURITY_VIEWER

A.  

A separate database object that is used to store file-level metadata

B.  

An object layered on a stage that is used to store file-level metadata

C.  

A database object with grantable privileges for unstructured data tasks

D.  

A Snowflake table specifically designed for storing unstructured files

A.  

Queries without filters or aggregation

B.  

Queries with large scans and selective filters

C.  

Queries where the GROUP BY has high cardinality

D.  

Queries of tables that have search optimization service enabled

A.  

It removes null values from all columns in the data.

B.  

It converts null values to empty strings during loading.

C.  

It skips rows with null values during the loading process.

D.  

It removes object or array elements containing null values.