Free Snowflake COF-C02 Practice Exam with Questions & Answers | Set: 13

If the query contains a deterministic function

If the virtual warehouse has been suspended

If the referenced data in the table has changed

If multiple users are using the same virtual warehouse

To create separate data warehouses to increase query optimization

To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster

To eliminate or reduce Queuing of concurrent queries

To allow the warehouse to resize automatically

Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.

Scaling out adds clusters of varying sizes to a virtual warehouse.

Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.

Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.

Scaling up resizes a virtual warehouse so it can handle more complex workloads.

Scaling up adds additional database servers to an existing running cluster to handle larger workloads.

parse_json()

json_extract_path_text()

object_construct()

flatten

The explain plan output is available graphically.

An explain plan can be used to conduct performance analysis without executing a query.

An explain plan will handle queries with temporary tables and the query profiler will not.

An explain plan's output will display automatic data skew optimization information.

External Tokenization

External Tables

Materialized Views

User-Defined Table Functions (UDTF)

Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).

All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.

The ACCOUNTADMIN role must be granted to only one user.

Assign the ACCOUNTADMIN role to at least two users, but as few as possible.

All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.

Create a zero-copy clone of the worksheet and grant permissions to teammates

Create a private Data Exchange so that any teammate can use the worksheet

Share the worksheet with teammates within Snowsight

Create a database and grant all permissions to teammates

Amazon Web Services

Docker

IBM Cloud

Microsoft Azure Cloud

Google Cloud Platform

Oracle Cloud

Queries against large tables where frequent DML occurs

Queries against tables larger than 1 TB

Selective point lookup queries

Queries against a subset of columns in a table

Whether or not it is also a secure view

How often the underlying base table is queried

How often the base table changes

Whether the materialized view has a cluster key defined

How often the materialized view is queried

Row level access policies

Data masking policies

Data encryption

Time Travel

External tokenization

Standard

Enterprise

Business Critical

Virtual Private Snowflake

Business Critical Edition

Standard Edition

Virtual Private Snowflake (VPS)

Enterprise Edition

PUT

GET

COPY

SELECT

Removing a column from the query SELECT list

Stopping the virtual warehouse that the query is running against

Clustering of the data used by the query

Executing the RESULTS_SCAN() table function

Changing a column that is not in the cached query

The cloned views and the stored procedures will reference the cloned tables in the cloned database.

An error will occur, as views with qualified references cannot be cloned.

An error will occur, as stored objects cannot be cloned.

The stored procedures and views will refer to tables in the source database.

10-50 MB

100-250 MB

300-500 MB

1000-1500 MB

Within the policy DDL

Within the create table or create view DDL

By future APPLY for all objects in a schema

Within a control table

Using the command ALTER