Each incremental increase in Virtual Warehouse size (e,g. Medium to Large) generally results in what?Select one.

Double the numbers of servers In the compute duster

Which of the following statement is true of Snowflake?Select one.

It was built specifically for the cloud

it was built as an on-premises solution and then potted to the cloud

It was designed as a hybrid database to allow customers to store data either on premises or in the cloud

It was built for Hadoop architecture

It's based on an Oracle Architecture

The number of queries that a Virtual Warehouse can concurrently process is determined by:Choose 2 answers

The size of the data required for each query

The CONCURRENT_QUERY_UMIT parameter set on the Snowflake account

The size of the data required for each query

The tool that s executing the query

Which of the following statements would be used to export/unload data from Snowflake?

EXPORT_TO_STAGE(stage = > @Wage, select = > 'select * from t1);

Which of the following are true of multi-cluster Warehouses? Select all that apply below.

A multi-cluster Warehouse can add clusters automatically based on query activity

A multi-cluster Warehouse can automatically turn itself off after a period of inactivity

A multi-cluster Warehouse can scale down when query activity slows

A multi-cluster Warehouse can automatically turn itself on when a query is executed against it

A multi-cluster Warehouse can add clusters automatically based on query activity

A multi-cluster Warehouse can automatically turn itself off after a period of inactivity

A multi-cluster Warehouse can scale down when query activity slows

A multi-cluster Warehouse can automatically turn itself on when a query is executed against it

Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

# of clusters for the Warehouse

Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

To accommodate a more complex workload

To accommodate fluctuations in workload

To accommodate a more complex workload

Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?(Choose all that apply.)

PythonD18912E1457D5D1DDCBD40AB3BF70D5D

Which of the following statements describes a benefit of Snowflake’s separation of compute and storage?(Choose all that apply.)

Storage expands without the requirement to add more compute

Compute can be scaled up or down without the requirement to add more storage

Multiple compute clusters can access stored data without contention

Growth of storage and compute are tightly coupled together

Storage expands without the requirement to add more compute

Compute can be scaled up or down without the requirement to add more storage

Multiple compute clusters can access stored data without contention

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

Customers can change the size of the Warehouse after creation

A Warehouse can be resized while running

A Warehouse can be configured to suspend after a period of inactivity

A Warehouse can be configured to auto-resume when new queries are submitted

Customers can change the size of the Warehouse after creation

A Warehouse can be resized while running

A Warehouse can be configured to suspend after a period of inactivity

A Warehouse can be configured to auto-resume when new queries are submitted

The PUT command: (Choose two.)

Automatically compresses files using Gzip

Automatically creates a File Format object

Automatically uses the last Stage created

Automatically compresses files using Gzip

Which interfaces can be used to create and/or manage Virtual Warehouses?

The Snowflake Web Interface (UI)

When a Pipe is recreated using the CREATE OR REPLACE PIPE command:

The Pipe load history is reset to empty

The REFRESH parameter is set to TRUE

Previously loaded files will be ignored

Which of the following statements are true of Snowflake releases: (Choose two.)

They happen approximately weekly

During a release, new customer requests/queries/connections transparently move over to the newer version

They happen approximately weekly

They roll up and release approximately monthly, but customers can request early release application

During a release, new customer requests/queries/connections transparently move over to the newer version

A customer is assigned a 30 minute window (that can be moved anytime within a week) during which the system will be unavailable and customer is upgraded

Snowflake COF-R02 Practice Test 1 - Free Online Exam Questions 1-40

True or False: The user has to specify which cluster a query will run on in multi-clustering Warehouse.

True

False

Comment (0)

Snowflake COF-R02 Practice Test 1

Question

Snowflake COF-R02 Practice Tests

Practice Tests