ExamGecko
Home Home / Snowflake / COF-C02

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

Question list
Search
Search

Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?

A.
External Tokenization
A.
External Tokenization
Answers
B.
External Tables
B.
External Tables
Answers
C.
Materialized Views
C.
Materialized Views
Answers
D.
User-Defined Table Functions (UDTF)
D.
User-Defined Table Functions (UDTF)
Answers
Suggested answer: A

Explanation:

The feature in Snowflake that allows a user to substitute a randomly generated identifier for sensitive data before loading it into Snowflake is known as External Tokenization.This process helps to secure sensitive data by ensuring that it is not exposed in its original form, thus preventing unauthorized access3.

What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?

A.
VIEWS_HISTORY
A.
VIEWS_HISTORY
Answers
B.
OBJECT_HISTORY
B.
OBJECT_HISTORY
Answers
C.
ACCESS_HISTORY
C.
ACCESS_HISTORY
Answers
D.
LOGIN_HISTORY
D.
LOGIN_HISTORY
Answers
Suggested answer: C

Explanation:

TheACCESS_HISTORYview in theSNOWFLAKE.ACCOUNT_USAGEschema contains information about the access history of Snowflake objects, such as tables and views, within the last 365 days1.

A running virtual warehouse is suspended.

What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?

A.
1 second
A.
1 second
Answers
B.
60 seconds
B.
60 seconds
Answers
C.
5 minutes
C.
5 minutes
Answers
D.
60 minutes
D.
60 minutes
Answers
Suggested answer: B

Explanation:

When a running virtual warehouse in Snowflake is suspended and then restarted, the minimum amount of time it will incur charges for is 60 seconds2.

What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)

A.
Authentication
A.
Authentication
Answers
B.
Resource management
B.
Resource management
Answers
C.
Virtual warehouse caching
C.
Virtual warehouse caching
Answers
D.
Query parsing and optimization
D.
Query parsing and optimization
Answers
E.
Query execution
E.
Query execution
Answers
F.
Physical storage of micro-partitions
F.
Physical storage of micro-partitions
Answers
Suggested answer: A, B, D

Explanation:

The responsibilities of Snowflake's Cloud Service layer include authentication (A), which ensures secure access to the platform; resource management (B), which involves allocating and managing compute resources; and query parsing and optimization (D), which improves the efficiency and performance of SQL query execution3.

How long is the Fail-safe period for temporary and transient tables?

A.
There is no Fail-safe period for these tables.
A.
There is no Fail-safe period for these tables.
Answers
B.
1 day
B.
1 day
Answers
C.
7 days
C.
7 days
Answers
D.
31 days
D.
31 days
Answers
E.
90 days
E.
90 days
Answers
Suggested answer: A

Explanation:

Temporary and transient tables in Snowflake do not have a Fail-safe period.Once the session ends or the tables are dropped, the data is purged and not recoverable1.

Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?

A.
PUT
A.
PUT
Answers
B.
GET
B.
GET
Answers
C.
COPY
C.
COPY
Answers
D.
SELECT
D.
SELECT
Answers
Suggested answer: B

Explanation:

The GET command is used to download files from a Snowflake stage to a local folder on a client's machine2.

How does Snowflake Fail-safe protect data in a permanent table?

A.
Fail-safe makes data available up to 1 day, recoverable by user operations.
A.
Fail-safe makes data available up to 1 day, recoverable by user operations.
Answers
B.
Fail-safe makes data available for 7 days, recoverable by user operations.
B.
Fail-safe makes data available for 7 days, recoverable by user operations.
Answers
C.
Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
C.
Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
Answers
D.
Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.
D.
Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.
Answers
Suggested answer: C

Explanation:

Snowflake's Fail-safe provides a 7-day period during which data in a permanent table may be recoverable, but only by Snowflake Support, not by user operations3.

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?

A.
Increase the warehouse size from Medium to 2XL.
A.
Increase the warehouse size from Medium to 2XL.
Answers
B.
Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
B.
Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
Answers
C.
Configure the warehouse to a multi-cluster warehouse.
C.
Configure the warehouse to a multi-cluster warehouse.
Answers
D.
Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.
D.
Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.
Answers
Suggested answer: C

Explanation:

The graphical representation of warehouse utilization indicates periods of significant queuing, suggesting that the current single cluster cannot efficiently handle all incoming queries.Configuring the warehouse to a multi-cluster warehouse will distribute the load among multiple clusters, reducing queuing times and improving overall performance1.

References = Snowflake Documentation on Multi-cluster Warehouses1

Which minimum Snowflake edition allows for a dedicated metadata store?

A.
Standard
A.
Standard
Answers
B.
Enterprise
B.
Enterprise
Answers
C.
Business Critical
C.
Business Critical
Answers
D.
Virtual Private Snowflake
D.
Virtual Private Snowflake
Answers
Suggested answer: B

Explanation:

The Enterprise edition of Snowflake allows for a dedicated metadata store, providing additional features designed for large-scale enterprises

Network policies can be set at which Snowflake levels? (Choose two.)

A.
Role
A.
Role
Answers
B.
Schema
B.
Schema
Answers
C.
User
C.
User
Answers
D.
Database
D.
Database
Answers
E.
Account
E.
Account
Answers
F.
Tables
F.
Tables
Answers
Suggested answer: C, E

Explanation:

Network policies in Snowflake can be set at the user level and at the account level2.

Total 716 questions
Go to page: of 72