What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

Default Time Travel Retention is set to 1 day.Maximum Time Travel Retention is 90 days.Fail Safe retention time is 7 days.

Default Time Travel Retention is set to 0 days.Maximum Time Travel Retention is 30 days.Fail Safe retention time is 1 day.

Default Time Travel Retention is set to 1 day.Maximum Time Travel Retention is 365 days.Fail Safe retention time is 7 days.

Default Time Travel Retention is set to 0 days.Maximum Time Travel Retention is 90 days.Fail Safe retention time is 7 days.

Default Time Travel Retention is set to 1 day.Maximum Time Travel Retention is 90 days.Fail Safe retention time is 7 days.

Default Time Travel Retention is set to 7 days.Maximum Time Travel Retention is 1 day.Fail Safe retention time is 90 days.

Default Time Travel Retention is set to 90 days.Maximum Time Travel Retention is 7 days.Fail Safe retention time is 356 days.

Which of the following statements describe features of Snowflake data caching? (Choose two.)

When the data cache is full, the least-recently used data will be cleared to make room.

A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.

When a virtual warehouse is suspended, the data cache is saved on the remote storage layer.

When the data cache is full, the least-recently used data will be cleared to make room.

A user can only access their own queries from the query result cache.

A user must set USE_METADATA_CACHE to TRUE to use the metadata cache in queries.

The RESULT_SCAN table function can access and filter the contents of the query result cache.

A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)The load failed with this error:Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.How can this issue be resolved?

Compress the file and load the compressed file.

Split the file into multiple files in the recommended size range (100 MB - 250 MB).

Set STRIP_OUTER_ARRAY=TRUE in the COPY INTO command.

Which of the following describes a Snowflake stored procedure?

They can be created as secure and hide the underlying metadata from the user.

They can only access tables from a single database.

They can contain only a single SQL statement.

They can be created to run with a caller's rights or an owner's rights.

How are serverless features billed?

Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

Per second multiplied by an automatic sizing for the job

Per minute multiplied by an automatic sizing for the job, with a minimum of one minute

Per second multiplied by the size, as determined by the SERVERLESS_FEATURES_SIZE account parameter

Serverless features are not billed, unless the total cost for the month exceeds 10% of the warehouse credits, on the account

Which SQL commands, when committed, will consume a stream and advance the stream offset?(Choose two.)

INSERT INTO TABLE SELECT FROM STREAM

ALTER TABLE AS SELECT FROM STREAM

INSERT INTO TABLE SELECT FROM STREAM

ALTER TABLE AS SELECT FROM STREAM

Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

Specify the PURGE copy option in the COPY INTO <table> command.

Use the REMOVE command after the load completes.

Use the DROP <file> command after the load completes.

Specify the TEMPORARY option when creating the file format.

Specify the PURGE copy option in the COPY INTO <table> command.

Use the REMOVE command after the load completes.

Use the DELETE LOAD HISTORY command after the load completes.

What is an advantage of using an explain plan instead of the query profiler to evaluate the performance of a query?

An explain plan can be used to conduct performance analysis without executing a query.

The explain plan output is available graphically.

An explain plan can be used to conduct performance analysis without executing a query.

An explain plan will handle queries with temporary tables and the query profiler will not.

An explain plan's output will display automatic data skew optimization information.

Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

Allows optimization of parallel operations

Optimizes the virtual warehouse size and multi-cluster setting to economy mode

Allows a user to import the files in a sequential order

Increases the latency staging and accuracy when loading the data

Allows optimization of parallel operations

Which of the following features are available with the Snowflake Enterprise edition? (Choose two.)

Database replication and failover

Customer managed keys (Tri-secret secure)

Native support for geospatial data

A Snowflake Administrator needs to ensure that sensitive corporate data in Snowflake tables is not visible to end users, but is partially visible to functional managers.How can this requirement be met?

Revoke all roles for functional managers and end users.

What affects whether the query results cache can be used?

If the virtual warehouse has been suspended

If the query contains a deterministic function

If the virtual warehouse has been suspended

If the referenced data in the table has changed

If multiple users are using the same virtual warehouse

Which of the following is an example of an operation that can be completed without requiring compute, assuming no queries have been executed previously?

SELECT AVG(ORDER_QTY) FROM SALES;

SELECT SUM (ORDER_AMT) FROM SALES;

SELECT AVG(ORDER_QTY) FROM SALES;

SELECT MIN(ORDER_AMT) FROM SALES;

SELECT ORDER_AMT * ORDER_QTY FROM SALES;

How can a row access policy be applied to a table or a view? (Choose two.)

Within the create table or create view DDL

By future APPLY for all objects in a schema

Using the command ALTER <object> ADD ROW ACCESS POLICY <policy>;

When should a multi-cluster warehouse be used in auto-scaling mode?

When a large number of concurrent queries are run on the same warehouse

When it is unknown how much compute power is needed

If the select statement contains a large number of temporary tables or Common Table Expressions (CTEs)

If the runtime of the executed query is very slow

When a large number of concurrent queries are run on the same warehouse

In the Snowflake access control model, which entity owns an object by default?

The role used to create the object

The user who created the object

Ownership depends on the type of object

The role used to create the object

What is the minimum Snowflake edition required to use Dynamic Data Masking?

Virtual Private Snowflake (VPC)

What is true about sharing data in Snowflake? (Choose two.)

The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

A Snowflake account can both provide and consume shared data.

The Data Consumer pays for data storage as well as for data computing.

The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.

A Snowflake account can both provide and consume shared data.

The Provider is charged for compute resources used by the Data Consumer to query the shared data.

The Data Consumer pays only for compute resources to query the shared data.

The following JSON is stored in a VARIANT column called src of the CAR_SALES table: A user needs to extract the dealership information from the JSON.How can this be accomplished?

select src:dealership from car_sales;

select src.dealership from car_sales;

select src:Dealership from car_sales;

select dealership from car_sales;

Snowflake COF-R02 Practice Test 6 - Free Online Exam Questions 201-240

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 6

Question

Snowflake COF-R02 Practice Tests

Practice Tests