Which Snowflake object helps evaluate virtual warehouse performance impacted by query queuing?

Information_schema.warehouse_load_history

Information schema.warehouse metering history

What type of columns does Snowflake recommend to be used as clustering keys? (Select TWO).

A column with very high cardinality

A column that is most actively used in selective filters

A column with very low cardinality

A column with very high cardinality

A column that is most actively used in selective filters

A column that is most actively used in join predicates

Which of the following describes the Snowflake Cloud Services layer?

Coordinates activities in the Snowflake account

Executes queries submitted by the Snowflake account users

Manages quotas on the Snowflake account storage

Manages the virtual warehouse cache to speed up queries

What does Snowflake recommend regarding database object ownership? (Select TWO).

Create objects with a custom role and grant this role to SYSADMIN.

Create objects with ACCOUNTADMIN and do not reassign ownership.

Create objects with SECURITYADMIN to ease granting of privileges later.

Create objects with a custom role and grant this role to SYSADMIN.

Use only MANAGED ACCESS SCHEMAS for66 objects owned by ACCOUNTADMIN.

What happens when a database is cloned?

It does not retain any privileges granted on the source object.

It replicates all granted privileges on the corresponding source objects.

It replicates all granted privileges on the corresponding child objects.

It replicates all granted privileges on the corresponding child schema objects.

How does a scoped URL expire?

When the persisted query result period ends.

The encoded URL access is permanent.

The length of time is specified in the expiration_time argument.

Which features make up Snowflake's column level security? (Select TWO).

Continuous Data Protection (CDP)

What is the difference between a stored procedure and a User-Defined Function (UDF)?

Stored procedures can execute database operations while UDFs cannot.

Returning a value is required in a stored procedure while returning values in a UDF is optional.

Values returned by a stored procedure can be used directly in a SQL statement while the values returned by a UDF cannot.

Multiple stored procedures can be called as part of a single executable statement while a single SQL statement can only call one UDF at a time.

When should a user consider disabling auto-suspend for a virtual warehouse? (Select TWO).

When managing a steady workload

When the compute must be available with no delay or lag time

When users will be using compute at different times throughout a 24/7 period

When managing a steady workload

When the compute must be available with no delay or lag time

When the user does not want to have to manually turn on the warehouse each time it is needed

When the warehouse is shared across different teams

How does Snowflake handle the bulk unloading of data into single or multiple files?

It assigns each unloaded data file a unique name.

It uses the put command to download the data by default.

It uses COPY INTO <location> for bulk unloading where the default option is SINGLE - TRUE.

It uses COPY INTO <location> to copy the data from a table into one or more files in an external stage only.

Which statement accurately describes a characteristic of a materialized view?

Data accessed through materialized views can be stale.

A materialized view can query only a single table.

Data accessed through materialized views can be stale.

Materialized view refreshes need to be maintained by the user.

Querying a materialized view is slower than executing a query against the base table of the view.

What can a Snowflake user do in the Activity section in Snowsight?

Explore executed query performance.

What does Snowflake's search optimization service support?

Tables and views that are not protected by row access policies

Casts on table columns (except for fixed-point numbers cast to strings)

What action can a user take to address query concurrency issues?

Add additional clusters to the virtual warehouse

Enable the query acceleration service.

Enable the search optimization service.

Add additional clusters to the virtual warehouse

Resize the virtual warehouse to a larger instance size.

How long can a data consumer who has a pre-signed URL access data files using Snowflake?

Until the expiration time is exceeded

Until the retention_time is met

Until the expiration time is exceeded

Which parameter prevents streams on tables from becoming stale?

MTN_DATA_RETENTION_TTME_TN_DAYS

A user needs to create a materialized view in the schema MYDB.MYSCHEM

Which statements will provide this access?

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

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

GRANT ROLE MYROLE TO USER USER1; GRANT CREATE MATERIALIZED VIEW ON SCHEMA MYDB. K'-'SCHEMA TO USER! ;

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

Two users share a virtual warehouse named wh dev 01. When one of the users loads data, the other one experiences performance issues while querying data.How does Snowflake recommend resolving this issue?

Create separate warehouses for each workload.

Scale up the existing warehouse.

Create separate warehouses for each user.

Create separate warehouses for each workload.

Stop loading and querying data at the same time.

A view is defined on a permanent table. A temporary table with the same name is created in the same schema as the referenced table. What will the query from the view return?

The data from the permanent table.

The data from the temporary table.

An error stating that the view could not be compiled.

An error stating that the referenced object could not be uniquely identified.

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

What is the recommended way to change the existing file format type in my format from CSV to JSON?

ALTER FILE FORMAT my_format SET TYPE=JSON;

ALTER FILE FORMAT my format SWAP TYPE WITH JSON;

CREATE OR REPLACE FILE FORMAT my format TYPE-JSON;

REPLACE FILE FORMAT my format TYPE-JSON;

Comment (0)

Snowflake COF-C02 Practice Test 8

Question

Snowflake COF-C02 Practice Tests

Practice Tests