What Snowflake features allow virtual warehouses to handle high concurrency workloads? (Select TWO)

The ability to scale up warehouses

The ability to resize warehouses

When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouseAccording to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

Use multi-clustered warehousing to scale out warehouse capacity.

Scale up the warehouse size to allow Queries to execute faster.

Use multi-clustered warehousing to scale out warehouse capacity.

Scale up the warehouse size to allow Queries to execute faster.

Stop and start the warehouse to clear the queued queries

Migrate some queries to a new warehouse to reduce load

Limit user access to the warehouse so fewer queries are run against it.

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

Automatic encryption of all data

Customer-managed encryption keys through Tri-Secret Secure

Automatic encryption of all data

Up to 90 days of data recovery through Time Travel

Column-level security to apply data masking policies to tables and views

A user has an application that writes a new Tile to a cloud storage location every 5 minutes.What would be the MOST efficient way to get the files into Snowflake?

Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

Create a task that runs a copy into operation from an external stage every 5 minutes

Create a task that puts the files in an internal stage and automate the data loading wizard

Create a task that runs a GET operation to intermittently check for new files

Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).

Load files that are approximately 100-250 MB (or larger)

Avoid using embedded characters such as commas for numeric data types

Load files that are approximately 25 MB or smaller.

Remove all dates and timestamps.

Load files that are approximately 100-250 MB (or larger)

Avoid using embedded characters such as commas for numeric data types

Remove semi-structured data types

A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:COPY INTO my__table FROM @my__stage;The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.If the user runs the same copy into command what will happen?

All data from all of the files on the stage will be appended to the table

Only data about new customers from the new files will be appended to the table

The operation will fail with the error uncertain files in stage.

All data from only the newly-added files will be appended to the table.

What happens when a cloned table is replicated to a secondary database? (Select TWO)

The physical data is replicated

Metadata pointers to cloned tables are replicated

A read-only copy of the cloned tables is stored.

The replication will not be successful.

The physical data is replicated

Additional costs for storage are charged to a secondary account

Metadata pointers to cloned tables are replicated

Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

Secure User Defined Functions (UDFs)

Will data cached in a warehouse be lost when the warehouse is resized?

No. because the size of the cache is independent from the warehouse size

Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.

Yes. because the compute resource is replaced in its entirety with a new compute resource.

No. because the size of the cache is independent from the warehouse size

Yes. became the new compute resource will no longer have access to the cache encryption key

Where would a Snowflake user find information about query activity from 90 days ago?

account__usage.query__history__archive View

account__usage . query history view

account__usage.query__history__archive View

information__schema . cruery_history view

information__schema - query history_by_ses s i on view

What happens when an external or an internal stage is dropped? (Select TWO).

When dropping an external stage, the files are not removed and only the stage is dropped

When dropping an internal stage, the files are deleted with the stage and the files are not recoverable

When dropping an external stage, the files are not removed and only the stage is dropped

When dropping an external stage, both the stage and the files within the stage are removed

When dropping an internal stage, the files are deleted with the stage and the files are recoverable

When dropping an internal stage, the files are deleted with the stage and the files are not recoverable

When dropping an internal stage, only selected files are deleted with the stage and are not recoverable

How long is Snowpipe data load history retained?

As configured in the create pipe settings

In which use cases does Snowflake apply egress charges?

Data sharing within a specific region

A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.Which of the following statements will accommodate this request?

GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;

GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;

GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING;

When reviewing a query profile, what is a symptom that a query is too large to fit into the memory?

The query is spilling to remote storage

A single join node uses more than 50% of the query time

Partitions scanned is equal to partitions total

An AggregateOperacor node is present

The query is spilling to remote storage

Which command can be used to stage local files from which Snowflake interface?

Snowflake classic web interface (Ul)

What is the recommended file sizing for data loading using Snowpipe?

A compressed file size greater than 10 MB, and up to 100 MB

A compressed file size greater than 100 MB, and up to 250 MB

A compressed file size greater than 100 GB, and up to 250 GB

A compressed file size greater than 10 MB, and up to 100 MB

A compressed file size greater than 1 GB, and up to 2 GB

What data is stored in the Snowflake storage layer? (Select TWO).

Standard and secure view results

In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

Compute Credits = 50 Credits Cloud Services = 10

Compute Credits = 200 Credits Cloud Services = 26

Compute Credits = 50 Credits Cloud Services = 10

Compute Credits = 80 Credits Cloud Services = 5

Compute Credits = 10 Credits Cloud Services = 9

Compute Credits = 120 Credits Cloud Services = 10

Compute Credits = 200 Credits Cloud Services = 26

What transformations are supported in a CREATE PIPE ... AS COPY ... FROM (....) statement? (Select TWO.)

Data can be filtered by an optional where clause

Incoming data can be joined with other tables

Row level access can be defined

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

Comment (0)

Snowflake COF-C02 Practice Test 2

Question

Snowflake COF-C02 Practice Tests

Practice Tests