Which Snowflake database object can be shared with other accounts?

Secure User-Defined Functions (UDFs)

Snowflake's access control framework combines which models for securing data? (Select TWO).

Discretionary Access Control (DAC)

Role-based Access Control (RBAC)

Attribute-based Access Control (ABAC 1

Discretionary Access Control (DAC)

Role-based Access Control (RBAC)

Rule-based Access Control (RuBAC)

What does Snowflake recommend a user do if they need to connect to Snowflake with a tool or technology mat is not listed in Snowflake partner ecosystem?

Connect through Snowflake's JDBC or ODBC drivers

Contact Snowflake Support for a new driver.

Connect through Snowflake's JDBC or ODBC drivers

How should a Snowflake use' configure a virtual warehouse to be in Maximized mode''

Set the same value for both MIN_CLUSTER_COUNT and MAX_CLUSTER_COUNT.

Set the WAREHOUSES_SIZE to 6XL.

Set the STATEMENT_TIMEOUT_1M_SECOMES to 0.

Set the MAX_CONCURRENCY_LEVEL to a value of 12 or large.

Set the same value for both MIN_CLUSTER_COUNT and MAX_CLUSTER_COUNT.

When snaring data in Snowflake. what privileges does a Provider need to grant along with a share? (Select TWO).

USAGE on the specific tables in the database.

USAGE on the database and the schema containing the tables to share

USAGE on the specific tables in the database.

MODIFY on 1Mb specific tables in the database.

USAGE on the database and the schema containing the tables to share

OPEBATE on the database and the schema containing the tables to share.

What action should be taken if a Snowflake user wants to share a newly created object in a database with consumers?

Use the grant privilege ... TO share command to grant the necessary privileges.

Use the automatic sharing feature for seamless access.

Drop the object and then re-add it to the database to trigger sharing.

Recreate the object with a different name in the database before sharing.

Use the grant privilege ... TO share command to grant the necessary privileges.

What information is stored in the ACCESS_HlSTORY view?

Details around the privileges that have been granted for all objects in an account

History of the files that have been loaded into Snowflake

Names and owners of the roles that are currently enabled in the session

Query details such as the objects included and the user who executed the query

Details around the privileges that have been granted for all objects in an account

In the Data Exchange, who can get or request data from the listings? (Select TWO).

Users with import share privilege

Users with manage grants privilege

What causes objects in a data share to become unavailable to a consumer account?

The objects in the data share are being deleted and the grant pattern is not re-applied systematically.

The DATA_RETENTI0N_TIME_IN_DAYS parameter in the consumer account is set to 0.

The consumer account runs the GRANT IMPORTED PRIVILEGES command on the data share every 24 hours.

The objects in the data share are being deleted and the grant pattern is not re-applied systematically.

The consumer account acquires the data share through a private data exchange.

Which types of subqueries does Snowflake support? (Select TWO).

Uncorrelated scalar subqueries in any place that a value expression can be used

EXISTS, ANY /ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated or uncorrelated

Uncorrelated scalar subqueries in WHERE clauses

Uncorrelated scalar subqueries in any place that a value expression can be used

EXISTS, ANY / ALL, and IN subqueries in WHERE clauses: these subqueries can be uncorrelated only

EXISTS, ANY / ALL, and IN subqueries in where clauses: these subqueries can be correlated only

EXISTS, ANY /ALL, and IN subqueries in WHERE clauses: these subqueries can be correlated or uncorrelated

A clustering key was defined on a table, but It is no longer needed. How can the key be removed?

ALTER TABLE <TABLE NAME> DROP CLUSTERING KEY

ALTER TABLE <TABLE NAME> PURGE CLUSTERING KEY

ALTER TABLE <TABLE NAME> DELETE CLUSTERING KEY

ALTER TABLE <TABLE NAME> DROP CLUSTERING KEY

ALTER TABLE <TABLE NAME> REMOVE CLUSTERING KEY

What are characteristics of Snowflake network policies? (Select TWO).

They can be set for any Snowflake Edition.

They restrict or enable access to specific IP addresses.

They can be set for any Snowflake Edition.

They restrict or enable access to specific IP addresses.

They are activated using ALTER DATABASE SQL commands.

They can only be managed using the ORGADMIN role.

Which categories are included in the execution time summary in a Query Profile? (Select TWO).

Percentage of data read from cache

What should be considered when deciding to use a secure view? (Select TWO).

No details of the query execution plan will be available in the query profiler.

Secure views do not take advantage of the same internal optimizations as standard views.

No details of the query execution plan will be available in the query profiler.

Once created there is no way to determine if a view is secure or not.

Secure views do not take advantage of the same internal optimizations as standard views.

It is not possible to create secure materialized views.

The view definition of a secure view is still visible to users by way of the information schema.

Which virtual warehouse consideration can help lower compute resource credit consumption?

Automating the virtual warehouse suspension and resumption settings

Setting up a multi-cluster virtual warehouse

Resizing the virtual warehouse to a larger size

Automating the virtual warehouse suspension and resumption settings

Increasing the maximum cluster count parameter for a multi-cluster virtual warehouse

A Snowflake user wants to optimize performance for a query that queries only a small number of rows in a table. The rows require significant processing. The data in the table does not change frequently.What should the user do?

Create a materialized view based on the query.

Add a clustering key to the table.

Add the search optimization service to the table.

Create a materialized view based on the query.

Enable the query acceleration service for the virtual warehouse.

What happens when a suspended virtual warehouse is resized in Snowflake?

The additional compute resources are provisioned when the warehouse is resumed.

The suspended warehouse is resumed and new compute resources are provisioned immediately.

The additional compute resources are provisioned when the warehouse is resumed.

How does Snowflake handle the data retention period for a table if a stream has not been consumed?

The data retention period is temporarily extended to the stream's offset.

The data retention period is reduced to a minimum of 14 days.

The data retention period is permanently extended for the table.

The data retention period is temporarily extended to the stream's offset.

The data retention period is not affected by the stream consumption.

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

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-C02 Practice Test 15

Question

Snowflake COF-C02 Practice Tests

Practice Tests