View All COF-C02 Actual Exam Questions, Answers and Explanations for Free [Q290-Q312]

Rate this post

View All COF-C02 Actual Exam Questions, Answers and Explanations for Free

COF-C02 Exam Free Practice Test with100% Accurate Answers

The SnowPro Core Certification Exam is a comprehensive examination that tests candidates on a wide range of topics related to Snowflake’s data warehousing technology. COF-C02 exam covers topics such as data modeling, database design, performance tuning, security, and data migration. Candidates must demonstrate their proficiency in these areas to earn the certification.

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

Standard

Enterprise

Business Critical

Virtual Private Snowflake

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

Internal stages

Incremental backups

Time Travel

Zero-copy clones

Fail-safe

NO.292 True or False: Multi_Factor Authentication (MFA) in Snowflake is only supported in conjunction with single Sign-on (sso).

True

False

NO.293 Which feature is integrated to support Multi-Factor Authentication (MFA) at Snowflake?

Authy

Duo Security

One Login

RSA SecurlD Access

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

Within the policy DDL

Within the create table or create view DDL

By future APPLY for all objects in a schema

Within a control table

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

NO.295 If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?

Auto-scale mode

Maximized mode

Economy scaling policy

Standard scaling policy

NO.296 Account-level storage usage can be monitored via:

The snowflake wet Interface (UI) in the Databases section.

The Snowflake web interface (UI) in the Account -> Billing a usage section

The Information Schema -> ACCOUNT_USAGE_HISTORY View

The Account usage Schema – > ACCOUNT_USAGE_METRICS View

NO.297 Which data type can be used to store geospatial data in Snowflake?

Variant

Object

Geometry

Geography

https://docs.snowflake.com/en/sql-reference/data-types-geospatial.html#:~:text=have%20SRID%3D4326.-,Geospatial%20Object%20Types,Point

NO.298 Data storage for individual tables can be monitored using which commands and/or objects? (Choose two.)

SHOW STORAGE BY TABLE;

SHOW TABLES;

Information Schema -> TABLE_HISTORY

Information Schema -> TABLE_FUNCTION

Information Schema -> TABLE_STORAGE_METRICS

NO.299 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.300 How can a user improve the performance of a single large complex query in Snowflake?

Scale up the virtual warehouse.

Scale out the virtual warehouse.

Enable standard warehouse scaling.

Enable economy warehouse scaling.

NO.301 What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

Via the Snowflake Web Interface (Ul)

Via the data_share=true parameter

Via SQL commands

Via Virtual Warehouses

Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html

NO.302 Credit Consumption by the Compute Layer (Virtual Warehouses) is based on: (Choose two.)

Number of users

Warehouse size

Amount of data processed

# of clusters for the Warehouse

NO.303 Where can a user find and review the failed logins of a specific user for the past 30 days?

The USERS view in ACCOUNT_USAGE

The LOGIN_HISTORY view in ACCOUNT_USAGE

The ACCESS_HISTORY view in ACCOUNT_USAGE

The SESSIONS view in ACCOUNT_USAGE

NO.304 Which of the following is true of Snowpipe via REST API? Choose 2 answers

you can only use it on internal Stages

All COPY INTO options are available fluting pipe creation

Snowflake automatically manages the compute required to execute the Pipe’s copy into commands

Snowpipe keeps track of which files it has loaded

NO.305 What parameter controls if the Virtual warehouse starts immediately after the CREATE WAREHOUSE statement?

INITTIALLY_SUSPENDED = TRUE/FALSE

START_AFTCR_CREATE = TRUE/FALSE

START_TTIME = 60 // (seconds from now)

START.TIME = CURRENT.DATE()

NO.306 What privileges are required to execute a task?

To execute a task, you need the EXECUTE TASK.

A task is an account-level object and can only be executed by the Account Admin role.

Tasks run automatically and do run under any rote.

Tasks are stored in a special database called the utility database and require EXECUTE TASK privilege in the utility database.

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

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.

NO.308 When unloading data to an external stage, what is the MAXIMUM file size supported?

1 GB

5 GB

10 GB

16 GB

NO.309 True or False: Snowpipe via REST API can only reference External Stages as source.

True

False

NO.310 How can a user change which columns are referenced in a view?

Modify the columns in the underlying table

Use the ALTER VIEW command to update the view

Recreate the view with the required changes

Materialize the view to perform the changes

NO.311 Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

Pipes

Streams

Tasks

Procedures

Explanation
https://dataterrain.com/how-to-change-tracking-using-table-streams-in-snowflake/#:~:text=A%20stream%20is%

NO.312 In which scenarios would a user have to pay Cloud Services costs? (Select TWO).

Compute Credits = 50 Credits Cloud Services = 10

Compute Credits = 80 Credits Cloud Services = 5

Compute Credits = 10 Credits Cloud Services = 9

Compute Credits = 120 Credits Cloud Services = 10

Compute Credits = 200 Credits Cloud Services = 26

Loading …

COF-C02 dumps Free Test Engine Verified By It Certified Experts: https://www.pdf4test.com/COF-C02-dump-torrent.html

Free certification test prep

View All COF-C02 Actual Exam Questions, Answers and Explanations for Free [Q290-Q312]

Leave a Reply Cancel reply