2023 ExamsTorrent Snowflake COF-C02 Dumps and Exam Test Engine [Q25-Q47]

Posted byadminFebruary 14, 2023Leave a Comment on 2023 ExamsTorrent Snowflake COF-C02 Dumps and Exam Test Engine [Q25-Q47]

Rate this post

2023 ExamsTorrent Snowflake COF-C02 Dumps and Exam Test Engine

Snowflake COF-C02 DUMPS WITH REAL EXAM QUESTIONS

NO.25 Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?

USAGE

OPERATE

MONITOR

MODIFY

NO.26 True or False the longer the data retention period, the higher the resulting storage costs.

True

False

NO.27 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

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

NO.28 Which stages are used with the Snowflake PUT command to upload files from a local file system? (Choose three.)

Schema Stage

User Stage

Database Stage

Table Stage

External Named Stage

Internal Named Stage

NO.29 What is the minimum Snowflake edition that has column-level security enabled?

Standard

Enterprise

Business Critical

Virtual Private Snowflake

NO.30 What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

Informatica

Power Bl

Adobe

Data Robot

https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html

NO.31 Which of the following are examples of operations that require a Virtual Warehouse to complete, assuming no quires have been executed previously? Choose 3 answers

MIN(< < column value>>)

COPY

SUM(<< column value >>)

UPDATE

NO.32 What privilege should a user be granted to change permissions for new objects in a managed access schema?

Grant the OWNERSHIP privilege on the schema.

Grant the OWNERSHIP privilege on the database.

Grant the MANAGE GRANTS global privilege.

Grant ALL privileges on the schema.

NO.33 Which of the following are considerations when using a directory table when working with unstructured data? (Choose two.)

A directory table is a separate database object.

Directory tables store data file metadata.

A directory table will be automatically added to a stage.

Directory tables do not have their own grantable privileges.

Directory table data can not be refreshed manually.

NO.34 Which statement is true about running tasks in Snowflake?

A task can be called using a CALL statement to run a set of predefined SQL commands.

A task allows a user to execute a single SQL statement/command using a predefined schedule.

A task allows a user to execute a set of SQL commands on a predefined schedule.

A task can be executed using a SELECT statement to run a predefined SQL command.

NO.35 What affects whether the query results cache can be used?

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

NO.36 When is the result set cache no longer available? (Select TWO)

When another warehouse is used to execute the query

When another user executes the query

When the underlying data has changed

When the warehouse used to execute the query is suspended

When it has been 24 hours since the last query

NO.37 Select the three types of tables that exist within Snowflake. Choose 3 answers

Temporary

Transient

Provisioned

Permanent

NO.38 Which of the following accurately describes shares?

Tables, secure views, and secure UDFs can be shared

Shares can be shared

Data consumers can clone a new table from a share

Access to a share cannot be revoked once granted

NO.39 Which statement describes how Snowflake supports reader accounts?

A reader account can consume data from the provider account that created it and combine it with its own data.

A consumer needs to become a licensed Snowflake customer as data sharing is only supported between Snowflake accounts.

The users in a reader account can query data that has been shared with the reader account and can perform DML tasks.

The SHOW MANAGED ACCOUNTS command will view all the reader accounts that have been created for an account.

NO.40 When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

The cloned views and the stored procedures will reference the cloned tables in the cloned database.

An error will occur, as views with qualified references cannot be cloned.

An error will occur, as stored objects cannot be cloned.

The stored procedures and views will refer to tables in the source database.

NO.41 How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?

Configure the warehouse to a size larger than generally required

Set the minimum and maximum clusters to autoscale

Use the standard warehouse scaling policy

Use the economy warehouse scaling policy

NO.42 Which URL type allows users to access unstructured data without authenticating into Snowflake or passing an authorization token?

Pre-signed URL

Scoped URL

Signed URL

File URL

NO.43 True or false: it is best practice to define a clustering key on every table.

True

False

NO.44 A virtual warehouse is created using the following command:
Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.

What action should be taken to address this situation?

Increase the warehouse size from Medium to 2XL.

Increase the value for the parameter MAX_CONCURRENCY_LEVEL.

Configure the warehouse to a multi-cluster warehouse.

Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.

NO.45 Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

Customer-managed encryption keys through Tri-Secret Secure

Automatic encryption of all data

Up to 90 days of data recovery through Time Travel

Object-level access control

Column-level security to apply data masking policies to tables and views

https://docs.snowflake.com/en/user-guide/intro-editions.html

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

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.

NO.47 What is the purpose of multi-cluster virtual warehouses?

To create separate data warehouses to increase query optimization

To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster

To eliminate or reduce Queuing of concurrent queries

To allow the warehouse to resize automatically

https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html#:~:text=Multi%2Dcluster%20warehouses%20enable%20you,during%20peak%20and%20off%20hours.

Loading …