What happens when a virtual warehouse is resized?

When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected

When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

Users who are trying to use the warehouse will receive an error message until the resizing is complete

What tasks can be completed using the copy command? (Select TWO)

Columns can be joined with an existing table

Data can be loaded without the need to spin up a virtual warehouse

Which of the following can be executed/called with Snowpipe?

A single insert__into statement

When unloading to a stage, which of the following is a recommended practice or approach?

Define an individual file format

Set SINGLE: = true for larger files

Use OBJECT_CONSTRUCT ( * ) when using Parquet

Avoid the use of the CAST function

Define an individual file format

When is the result set cache no longer available? (Select TWO)

When the underlying data has changed

When it has been 24 hours since the last query

When another warehouse is used to execute the query

When another user executes the query

When the underlying data has changed

When the warehouse used to execute the query is suspended

When it has been 24 hours since the last query

Which of the following describes external functions in Snowflake?

They are a type of User-defined Function (UDF).

They contain their own SQL code.

They call code that is stored inside of Snowflake.

They can return multiple rows for each row received

What are ways to create and manage data shares in Snowflake? (Select TWO)

Through the Snowflake web interface (Ul)

Through the DATA_SHARE=TRUE parameter

Through the enable__share=true parameter

Using the CREATE SHARE AS SELECT * TABLE command

A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?

SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.LOGIN_HISTORY;

SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME FROM ACCOUNT_USAGE.USERS;

SELECT EVENT_TIMESTAMP, USER_NAME FROM table(information_schema.login_history_by_user())

SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.ACCESS_HISTORY;

SELECT EVENT_TIMESTAMP, USER_NAME FROM ACCOUNT_USAGE.LOGIN_HISTORY;

What is the purpose of an External Function?

To call code that executes outside of Snowflake

To run a function in another Snowflake database

To share data in Snowflake with external parties

To ingest data from on-premises data sources

A user created a new worksheet within the Snowsight Ul and wants to share this with teammatesHow can this worksheet be shared?

Share the worksheet with teammates within Snowsight

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

What is the purpose of multi-cluster virtual warehouses?

To eliminate or reduce Queuing of concurrent queries

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

Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),

Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage

All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform

Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

Snowflake data and services are deployed in a single availability zone within a cloud provider's region.

Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.

Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage

Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage

All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform

Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

A user is preparing to load data from an external stageWhich practice will provide the MOST efficient loading performance?

Organize files into logical paths

Store the files on the external stage to ensure caching is maintained

Use pattern matching for regular expression execution

Load the data in one large file

Which command sets the Virtual Warehouse for a session?

USE WAREHOUSE <<warehouse name>>;

COPY WAREHOUSE FROM <<config file>>;

SET WAREHOUSE = <<warehouse name>>;

USE WAREHOUSE <<warehouse name>>;

USE VIRTUAL_WAREHOUSE <<warehouse name>>;

What occurs when a pipe is recreated using the CREATE OR REPLACE PIPE command?

The Pipe load history is reset to empty.

The REFRESH command is executed.

The destination table is truncated.

Which of the following are best practices for loading data into Snowflake? (Choose three.)

Aim to produce data files that are between 100 MB and 250 MB in size, compressed.

Enclose fields that contain delimiter characters in single or double quotes.

Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.

Aim to produce data files that are between 100 MB and 250 MB in size, compressed.

Load data from files in a cloud storage service in a different region or cloud platform from the service or region containing the Snowflake account, to save on cost.

Enclose fields that contain delimiter characters in single or double quotes.

Split large files into a greater number of smaller files to distribute the load among the compute resources in an active warehouse.

When planning which warehouse(s) to use for data loading, start with the largest warehouse possible.

Partition the staged data into large folders with random paths, allowing Snowflake to determine the best way to load each file.

What do the terms scale up and scale out refer to in Snowflake? (Choose two.)

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

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

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.

When cloning a database, what is cloned with the database? (Choose two.)

Existing child objects within the database

Future child objects within the database

Privileges on the schemas within the database

Only schemas and tables within the database

Which of the following describes the Snowflake Cloud Services layer?

Coordinates activities in the Snowflake account

Executes queries submitted by the Snowflake account users

Manages quotas on the Snowflake account storage

Manages the virtual warehouse cache to speed up queries

What type of query benefits the MOST from search optimization?

A query that uses equality predicates or predicates that use IN

A query that uses only disjunction (i.e., OR) predicates

A query that includes analytical expressions

A query that uses equality predicates or predicates that use IN

A query that filters on semi-structured data types

Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.

The default virtual warehouse size can be changed at any time.

Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.

The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.

SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.

A user cannot specify a default warehouse when using the ODBC driver.

The default virtual warehouse size can be changed at any time.

The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

Authentication and access control

When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

The listing is replicated into all selected regions automatically, the data is not.

The user must have the ORGADMIN role available in at least one account to link accounts for replication.

There is no need to have a Snowflake account in the target region, a share will be created for each user.

The listing is replicated into all selected regions automatically, the data is not.

The user must have the ORGADMIN role available in at least one account to link accounts for replication.

Shares attached to listings in remote regions can be viewed from any account in an organization.

For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.

Snowflake COF-C02 Practice Test 3 - Free Online Exam Prep & Questions

What is a responsibility of Snowflake's virtual warehouses?

A.

Infrastructure management

B.

Metadata management

C.

Query execution

D.

Query parsing and optimization

E.

Management of the storage layer

Snowflake COF-C02 Practice Test 3

Question

Snowflake COF-C02 Practice Tests

Practice Tests