[Q408-Q431] Get up-to-date Real Exam Questions for COF-C02 UPDATED [2024]

5/5 - (1 vote)

Get up-to-date Real Exam Questions for COF-C02 UPDATED [2024]

Pass Snowflake COF-C02 Exam in First Attempt Guaranteed

NEW QUESTION 408
Which interfaces can be used to create and/or manage Virtual Warehouses?

The Snowflake Web Interface (UI)

SQL commands

Data integration tools

All of the above

NEW QUESTION 409
What is the purpose of the STRIP NULL_VALUES file format option when loading semi-structured data files into Snowflake?

It removes null values from all columns in the data.

It converts null values to empty strings during loading.

It skips rows with null values during the loading process.

It removes object or array elements containing null values.

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

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

NEW QUESTION 411
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

NEW QUESTION 412
Which formats are supported for unloading data from Snowflake? Choose 2 answers

Delimited (CSV, TSV, etc.)

Avro

JSON

ORC

NEW QUESTION 413
What is a directory table in Snowflake?

A separate database object that is used to store file-level metadata

An object layered on a stage that is used to store file-level metadata

A database object with grantable privileges for unstructured data tasks

A Snowflake table specifically designed for storing unstructured files

NEW QUESTION 414
Which services does the Snowflake Cloud Services layer manage? (Choose two.)

Compute resources

Query execution

Authentication

Data storage

Metadata

NEW QUESTION 415
Which of the following describes a Snowflake stored procedure?

They can be created as secure and hide the underlying metadata from the user.

They can only access tables from a single database.

They can contain only a single SQL statement.

They can be created to run with a caller’s rights or an owner’s rights.

NEW QUESTION 416
Which formats does Snowflake store unstructured data in? (Choose two.)

GeoJSON

Array

XML

Object

BLOB

NEW QUESTION 417
When unloading to a stage, which of the following is a recommended practice or approach?

Set SINGLE: = true for larger files

Use OBJECT_CONSTRUCT ( * ) when using Parquet

Avoid the use of the CAST function

Define an individual file format

NEW QUESTION 418
Credit charges for Snowflake virtual warehouses are calculated based on which of the following considerations? (Choose two.)

The number of queries executed

The number of active users assigned to the warehouse

The size of the virtual warehouse

The length of time the warehouse is running

The duration of the queries that are executed

NEW QUESTION 419
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

NEW QUESTION 420
What type of account can be used to share data with a consumer who does have a Snowflake account?

Data provider

Data consumer

Reader

Organization

NEW QUESTION 421
A JSON object is loaded into a column named data using a Snowflake variant datatype. The root node of the object is BIKE. The child attribute for this root node is BIKEID.
Which statement will allow the user to access BIKEID?

select data:BIKEID

select data.BIKE.BIKEID

select data:BIKE.BIKEID

select data:BIKE:BIKEID

NEW QUESTION 422
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)

Bytes scanned

Bytes sent over the network

Number of partitions scanned

Percentage scanned from cache

External bytes scanned

NEW QUESTION 423
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

Pipe

External stage

Task

Stream

NEW QUESTION 424
What actions will prevent leveraging of the ResultSet cache? (Choose two.)

Removing a column from the query SELECT list

Stopping the virtual warehouse that the query is running against

Clustering of the data used by the query

Executing the RESULTS_SCAN() table function

Changing a column that is not in the cached query

NEW QUESTION 425
Which Snowflake feature allows administrators to identify unused data that may be archived or deleted?

Access history

Data classification

Dynamic Data Masking

Object tagging

NEW QUESTION 426
Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?

Compute layer

Storage layer

Cloud infrastructure layer

Cloud services layer

NEW QUESTION 427
User1, who has the SYSADMIN role, executed a query on Snowsight. User2, who is in the same Snowflake account, wants to view the result set of the query executed by User1 using the Snowsight query history.
What will happen if User2 tries to access the query history?

If User2 has the sysadmin role they will be able to see the results.

If User2 has the securityadmin role they will be able to see the results.

If User2 has the ACCOUNTADMIN role they will be able to see the results.

User2 will be unable to view the result set of the query executed by User1.

NEW QUESTION 428
In Snowflake, what allows users to perform recursive queries?

QUALIFY

LATERAL

PIVOT

CONNECT BY

NEW QUESTION 429
Which type of charts are supported by Snowsight? {Select TWO)

Flowcharts

Gantt charts

Line charts

Pie charts

Scatterplots

NEW QUESTION 430
When unloading data, which file format preserves the data values for floating-point number columns?

Avro

CSV

JSON

Parquet

NEW QUESTION 431
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

CREATE_SHARE on the account

SHARE on databases and schemas

SELECT on tables used by the secure view

REFERENCE_USAGE on databases

Snowflake COF-C02 (SnowPro Core Certification) Exam is a certification exam that tests the skills of candidates in data warehousing, data analytics, and data engineering. Snowflake is a cloud-based data warehousing and analytics platform that is rapidly gaining popularity amongst businesses and organizations. The SnowPro Core Certification Exam is designed to test the skills of candidates in using Snowflake to solve real-world data-related problems.

Snowflake COF-C02 Study Guide Archives : https://www.testkingfree.com/Snowflake/COF-C02-practice-exam-dumps.html