Which of the following conditions must be met in order to return results from the results cache?(Select TWO).

The user has the appropriate privileges on the objects associated with the query

The query has been run within 24 hours of the previously-run query

The user has the appropriate privileges on the objects associated with the query

Micro-partitions have been reclustered since the query was last run

The new query is run using the same virtual warehouse as the previous query

The query includes a User Defined Function (UDF)

The query has been run within 24 hours of the previously-run query

Which of the following are benefits of micro-partitioning? (Select TWO)

Micro-partitions cannot overlap in their range of values

Rows are automatically stored in sorted order within micro-partitions

Micro-partitions cannot overlap in their range of values

Micro-partitions are immutable objects that support the use of Time Travel.

Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses

Rows are automatically stored in sorted order within micro-partitions

Micro-partitions can be defined on a schema-by-schema basis

What is the minimum Snowflake edition required to create a materialized view?

Virtual Private Snowflake Edition

What happens to the underlying table data when a CLUSTER BY clause is added to a Snowflake table?

Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

Data is hashed by the cluster key to facilitate fast searches for common data values

Larger micro-partitions are created for common data values to reduce the number of partitions that must be scanned

Smaller micro-partitions are created for common data values to allow for more parallelism

Data may be colocated by the cluster key within the micro-partitions to improve pruning performance

Which feature is only available in the Enterprise or higher editions of Snowflake?

Multi-factor Authentication (MFA)

During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?

STATEMENT_QUEUED_TIMEOUT_IN_SECONDS

Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).

The table contains a column that has very low cardinality

The clustering depth for the table is large

The table contains a column that has very low cardinality

DML statements that are being issued against the table are blocked

The table has a small number of micro-partitions

Queries on the table are running slower than expected

The clustering depth for the table is large

A user needs to create a materialized view in the schema MYDB.MYSCHEMA.Which statements will provide this access?

GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO ROLE MYROLE;

GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER USER1;

GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO USER1;

GRANT ROLE MYROLE TO USER USER1;CREATE MATERIALIZED VIEW ON SCHEMA MYDB.MYSCHEMA TO MYROLE;

A sales table FCT_SALES has 100 million records.The following Query was executedSELECT COUNT (1) FROM FCT__SALES;How did Snowflake fulfill this query?

Query against the metadata excite

Query against the result set cache

Query against a virtual warehouse cache

Query against the most-recently created micro-partition

Query against the metadata excite

What is a key feature of Snowflake architecture?

Multi-cluster warehouses allow users to run a query that spans across multiple clusters

Zero-copy cloning creates a mirror copy of a database that updates with the original

Software updates are automatically applied on a quarterly basis

Snowflake eliminates resource contention with its virtual warehouse implementation

Multi-cluster warehouses allow users to run a query that spans across multiple clusters

Snowflake automatically sorts DATE columns during ingest for fast retrieval by date

What is a limitation of a Materialized View?

A Materialized View cannot be defined with a JOIN

A Materialized View cannot support any aggregate functions

A Materialized View can only reference up to two tables

A Materialized View cannot be joined with other tables

A Materialized View cannot be defined with a JOIN

What features does Snowflake Time Travel enable?

Restoring data-related objects that have been deleted within the past 90 days

Querying data-related objects that were created within the past 365 days

Restoring data-related objects that have been deleted within the past 90 days

Conducting point-in-time analysis for Bl reporting

Analyzing data usage/manipulation over all periods of time

Which statement about billing applies to Snowflake credits?

Credits are consumed based on the warehouse size and the time the warehouse is running

Credits are billed per-minute with a 60-minute minimum

Credits are used to pay for cloud data storage usage

Credits are consumed based on the number of credits billed for each hour that a warehouse runs

Credits are consumed based on the warehouse size and the time the warehouse is running

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

The use of warehouse auto scaling

Use of multi-clustered warehouses

The ability to scale up warehouses

The use of warehouse auto scaling

The ability to resize warehouses

Use of multi-clustered 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 warehouse According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).

Use multi-clustered warehousing to scale out warehouse capacity.

Migrate some queries to a new warehouse to reduce load

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 dat a. 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

Additional costs for storage are charged to a secondary account

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 describes how multiple Snowflake accounts in a single organization relate to various cloud providers?

Each Snowflake account must be hosted in a different cloud vendor and region

Each Snowflake account can be hosted in a different cloud vendor and region.

Each Snowflake account must be hosted in a different cloud vendor and region

All Snowflake accounts must be hosted in the same cloud vendor and region

Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.

A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?

It removes the outer array structure and loads the records into separate table rows,

It removes the last element of the outer array.

It removes the outer array structure and loads the records into separate table rows,

It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns

It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records

What are the default Time Travel and Fail-safe retention periods for transient tables?

Time Travel - 1 day. Fail-safe - 0 days

Time Travel - 1 day. Fail-safe - 1 day

Time Travel - 0 days. Fail-safe - 1 day

Time Travel - 1 day. Fail-safe - 0 days

Transient tables are retained in neither Fail-safe nor Time Travel

What is a best practice after creating a custom role?

Assign the custom role to the SYSADMIN role

Create the custom role using the SYSADMIN role.

Assign the custom role to the SYSADMIN role

Assign the custom role to the PUBLIC role

Add__CUSTOM to all custom role names

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?

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

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

Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).

A.

Internal stages

B.

Incremental backups

C.

Time Travel

D.

Zero-copy clones

E.

Fail-safe

Snowflake COF-R02 Practice Test 3

Question

Snowflake COF-R02 Practice Tests

Practice Tests