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 enable__share=true parameter

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_NAMEFROM ACCOUNT_USAGE.LOGIN_HISTORY;

SELECT LAST_SUCCESS_LOGIN, LOGIN_NAMEFROM ACCOUNT_USAGE.USERS;

SELECT EVENT_TIMESTAMP, USER_NAMEFROM table(information_schema.login_history_by_user())

SELECT EVENT_TIMESTAMP, USER_NAMEFROM ACCOUNT_USAGE.ACCESS_HISTORY;

SELECT EVENT_TIMESTAMP, USER_NAMEFROM 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 teammates How 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?

Load the data in one large file

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 REFRESH command is executed.

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.)

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.

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

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

Only schemas and tables within the database

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.)

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.)

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

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.

Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

User-Defined Table Functions (UDTF)

What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

Physical storage of micro-partitions

How long is the Fail-safe period for temporary and transient tables?

There is no Fail-safe period for these tables.

How does Snowflake Fail-safe protect data in a permanent table?

Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.

Fail-safe makes data available up to 1 day, recoverable by user operations.

Fail-safe makes data available for 7 days, recoverable by user operations.

Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.

Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

A virtual warehouse is created using the following command:Create warehouse my_WH withwarehouse_size = MEDIUMmin_cluster_count = 1max_cluster_count = 1auto_suspend = 60auto_resume = true;The image below is a graphical representation of the warehouse utilization across two days. What action should be taken to address this situation?

Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

Increase the warehouse size from Medium to 2XL.

Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

Configure the warehouse to a multi-cluster warehouse.

Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

Snowflake COF-R02 Practice Test 5 - Free Online Exam Prep & Questions

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

A.

When another warehouse is used to execute the query

B.

When another user executes the query

C.

When the underlying data has changed

D.

When the warehouse used to execute the query is suspended

E.

When it has been 24 hours since the last query

Snowflake COF-R02 Practice Test 5

Question

Snowflake COF-R02 Practice Tests

Practice Tests