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

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 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 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 = 80 Credits Cloud Services = 5

Compute Credits = 120 Credits Cloud Services = 10

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

What is a responsibility of Snowflake's virtual warehouses?

Management of the storage layer

What happens when a virtual warehouse is resized?

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.

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

A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked dat a. Will the developer be able to modify the table to read the masked data?

Yes, because a table owner has full control and can unset masking policies.

Yes, because masking policies only apply to cloned tables.

No, because masking policies must always reference specific access roles.

No, because ownership of a table does not include the ability to change masking policies

Which of the following describes how clustering keys work in Snowflake?

Clustering keys sort the designated columns over time, without blocking DML operations

Clustering keys update the micro-partitions in place with a full sort, and impact the DML operations.

Clustering keys sort the designated columns over time, without blocking DML operations

Clustering keys create a distributed, parallel data structure of pointers to a table's rows and columns

Clustering keys establish a hashed key on each node of a virtual warehouse to optimize joins at run-time

Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?

An FTP server with TLS encryption

A Windows server file share on Azure

What can be used to view warehouse usage over time? (Select Two).

The WAREHOUSE_METERING__HISTORY View

The billing and usage tab in the Snowflake web Ul

The WAREHOUSE_METERING__HISTORY View

The billing and usage tab in the Snowflake web Ul

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?

Avoid the use of the CAST function

Set SINGLE: = true for larger files

Use OBJECT_CONSTRUCT ( * ) when using Parquet

Avoid the use of the CAST function

Define an individual file format

Snowflake COF-R02 Practice Test 4 - Free Online Exam Questions 121-160

Spam

Selling illegal goods, money scams etc.

Hate Speech

Serious attack on a group.

Harassment and bullying

Harassing an individual (including doxing)

Harmful activities

Threatening or glorifying violence or serious harm, including self-harm

Adult content (Consensual)

Nudity/Sexual content

Sexual exploitation and abuse (child safety)

Sexually explicit or suggestive imagery or writing involving minors

Sexual exploitation and abuse (adults and animals)

Sexually explicit or suggestive imagery or writing involving non-consenting adults or non-humans

Plagiarism

Reusing content without attribution (link and blockquotes)

Poorly written

Not in English or has very bad formatting, grammar, and spelling

Inappropriate credential

Author's credential is offensive, spam, or impersonation

Other

Ex. Illegal content, incomplete question...

Snowflake COF-R02 Practice Test 4

Question

Snowflake COF-R02 Practice Tests

Practice Tests