ExamGecko
Home / Snowflake / COF-C02
Ask Question

Snowflake COF-C02 Practice Test - Questions Answers, Page 33

Question list
Search

Question 321

Report
Export
Collapse

What column type does a Kafka connector store formatted information in a single column?

ARRAY
ARRAY
OBJECT
OBJECT
VARCHAR
VARCHAR
VARIANT
VARIANT
Suggested answer: D

Explanation:

The Kafka connector stores formatted information in a single column of type VARIANT.This column type is used to store semi-structured data like JSON or Avro, which allows for flexibility in the data structure

asked 23/09/2024
Rostyslav Skrypnyk
48 questions

Question 322

Report
Export
Collapse

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

1 GB
1 GB
5 GB
5 GB
10 GB
10 GB
16 GB
16 GB
Suggested answer: B

Explanation:

When unloading data to an external stage, the maximum file size supported is 5 GB.This limit ensures efficient data transfer and management within Snowflake's architecture

asked 23/09/2024
miguel sartori
34 questions

Question 323

Report
Export
Collapse

By definition, a secure view is exposed only to users with what privilege?

IMPORT SHARE
IMPORT SHARE
OWNERSHIP
OWNERSHIP
REFERENCES
REFERENCES
USAGE
USAGE
Suggested answer: B

Explanation:

A secure view in Snowflake is exposed only to users with the OWNERSHIP privilege.This privilege ensures that only authorized users who own the view, or roles that include ownership, can access the secure view

asked 23/09/2024
Haleem SHITOU OGUNGBEMI
42 questions

Question 324

Report
Export
Collapse

What is a characteristic of the Snowflake Query Profile?

It can provide statistics on a maximum number of 100 queries per week.
It can provide statistics on a maximum number of 100 queries per week.
It provides a graphic representation of the main components of the query processing.
It provides a graphic representation of the main components of the query processing.
It provides detailed statistics about which queries are using the greatest number of compute resources.
It provides detailed statistics about which queries are using the greatest number of compute resources.
It can be used by third-party software using the Query Profile API.
It can be used by third-party software using the Query Profile API.
Suggested answer: B

Explanation:

The Snowflake Query Profile provides a graphic representation of the main components of the query processing.This visual aid helps users understand the execution details and performance characteristics of their queries4.

asked 23/09/2024
Pedro Miguel Garcia Valdes
43 questions

Question 325

Report
Export
Collapse

What statistical information in a Query Profile indicates that the query is too large to fit in memory? (Select TWO).

Bytes spilled to local cache.
Bytes spilled to local cache.
Bytes spilled to local storage.
Bytes spilled to local storage.
Bytes spilled to remote cache.
Bytes spilled to remote cache.
Bytes spilled to remote storage.
Bytes spilled to remote storage.
Bytes spilled to remote metastore.
Bytes spilled to remote metastore.
Suggested answer: A, B

Explanation:

In a Query Profile, the statistical information that indicates a query is too large to fit in memory includes bytes spilled to local cache and bytes spilled to local storage.These metrics suggest that the working data set of the query exceeded the memory available on the warehouse nodes, causing intermediate results to be written to disk

asked 23/09/2024
Misael Mosco Jiménez
40 questions

Question 326

Report
Export
Collapse

What is the MAXIMUM Time Travel retention period for a transient table?

O days
O days
1 day
1 day
7 days
7 days
90 days
90 days
Suggested answer: B

Explanation:

The maximum Time Travel retention period for a transient table in Snowflake is 1 day.This is the default and maximum duration for which Snowflake maintains the historical data for transient tables, allowing users to query data as it appeared at any point within the past 24 hours2.

asked 23/09/2024
Brooke Galiata
32 questions

Question 327

Report
Export
Collapse

Which query contains a Snowflake hosted file URL in a directory table for a stage named bronzestage?

list @bronzestage;
list @bronzestage;
select * from directory(@bronzestage);
select * from directory(@bronzestage);
select metadata$filename from @bronzestage;
select metadata$filename from @bronzestage;
select * from table(information_schema.stage_directory_file_registration_history( stage name=>'bronzestage1));
select * from table(information_schema.stage_directory_file_registration_history( stage name=>'bronzestage1));
Suggested answer: B

Explanation:

The query that contains a Snowflake hosted file URL in a directory table for a stage named bronzestage isselect * from directory(@bronzestage).This query retrieves a list of all files on the stage along with metadata, including the Snowflake file URL for each file3.

asked 23/09/2024
Michele Punzo
39 questions

Question 328

Report
Export
Collapse

Which Snowflake edition enables data sharing only through Snowflake Support?

Virtual Private Snowflake
Virtual Private Snowflake
Business Critical
Business Critical
Enterprise
Enterprise
Standard
Standard
Suggested answer: A

Explanation:

The Snowflake edition that enables data sharing only through Snowflake Support is the Virtual Private Snowflake (VPS).By default, VPS does not permit data sharing outside of the VPS environment, but it can be enabled through Snowflake Support4.

asked 23/09/2024
Alvaro Campos
35 questions

Question 329

Report
Export
Collapse

When would Snowsight automatically detect if a target account is in a different region and enable cross-cloud auto-fulfillment?

When using a paid listing on the Snowflake Marketplace
When using a paid listing on the Snowflake Marketplace
When using a private listing on the Snowflake Marketplace
When using a private listing on the Snowflake Marketplace
When using a personalized listing on the Snowflake Marketplace
When using a personalized listing on the Snowflake Marketplace
When using a Direct Share with another account
When using a Direct Share with another account
Suggested answer: A

Explanation:

Snowsight automatically detects if a target account is in a different region and enables cross-cloud auto-fulfillment when using a paid listing on the Snowflake Marketplace.This feature allows Snowflake to manage the replication of data products to consumer regions as needed, without manual intervention1.

asked 23/09/2024
Matthew Montgomery
32 questions

Question 330

Report
Export
Collapse

Which languages requite that User-Defined Function (UDF) handlers be written inline? (Select TWO).

Java
Java
Javascript
Javascript
Scala
Scala
Python
Python
SQL
SQL
Suggested answer: B, E

Explanation:

User-Defined Function (UDF) handlers must be written inline for Javascript and SQL.These languages allow the UDF logic to be included directly within the SQL statement that creates the UDF2.

asked 23/09/2024
Yunus Emre Akay
33 questions
Total 716 questions
Go to page: of 72