ExamGecko
Login
Home / Snowflake / COF-C02 / List of questions
Ask Question

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

List of questions

Question 121

Report Export Collapse

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?

External Tokenization
External Tokenization
External Tables
External Tables
Materialized Views
Materialized Views
User-Defined Table Functions (UDTF)
User-Defined Table Functions (UDTF)
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.

asked 23/09/2024
wendy brouwer
44 questions

Question 122

Report Export Collapse

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

VIEWS_HISTORY
VIEWS_HISTORY
OBJECT_HISTORY
OBJECT_HISTORY
ACCESS_HISTORY
ACCESS_HISTORY
LOGIN_HISTORY
LOGIN_HISTORY
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.

asked 23/09/2024
fadi kako
46 questions

Question 123

Report Export Collapse

A running virtual warehouse is suspended.

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

1 second
1 second
60 seconds
60 seconds
5 minutes
5 minutes
60 minutes
60 minutes
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.

asked 23/09/2024
Josh Davis
42 questions

Question 124

Report Export Collapse

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

Authentication
Authentication
Resource management
Resource management
Virtual warehouse caching
Virtual warehouse caching
Query parsing and optimization
Query parsing and optimization
Query execution
Query execution
Physical storage of micro-partitions
Physical storage of micro-partitions
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.

asked 23/09/2024
Ankit Singh
39 questions

Question 125

Report Export Collapse

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

There is no Fail-safe period for these tables.
There is no Fail-safe period for these tables.
1 day
1 day
7 days
7 days
31 days
31 days
90 days
90 days
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.

asked 23/09/2024
Ann Nacua
51 questions

Question 126

Report Export Collapse

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

PUT
PUT
GET
GET
COPY
COPY
SELECT
SELECT
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.

asked 23/09/2024
Kanta Prasad
42 questions

Question 127

Report Export Collapse

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

Fail-safe makes data available up to 1 day, recoverable by user operations.
Fail-safe makes data available up to 1 day, recoverable by user operations.
Fail-safe makes data available for 7 days, recoverable by user operations.
Fail-safe makes data available for 7 days, recoverable by user operations.
Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.
Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.
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.

asked 23/09/2024
bhaskar siddanadham
36 questions

Question 128

Report Export Collapse

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.

Snowflake COF-C02 image Question 128 73270 09232024004424000000

What action should be taken to address this situation?

Increase the warehouse size from Medium to 2XL.
Increase the warehouse size from Medium to 2XL.
Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
Configure the warehouse to a multi-cluster warehouse.
Configure the warehouse to a multi-cluster warehouse.
Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.
Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.
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

asked 23/09/2024
Fabio Morais Melo
44 questions

Question 129

Report Export Collapse

Which minimum Snowflake edition allows for a dedicated metadata store?

Standard
Standard
Enterprise
Enterprise
Business Critical
Business Critical
Virtual Private Snowflake
Virtual Private Snowflake
Suggested answer: B
Explanation:

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

asked 23/09/2024
B Erol
63 questions

Question 130

Report Export Collapse

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

Role
Role
Schema
Schema
User
User
Database
Database
Account
Account
Tables
Tables
Suggested answer: C, E
Explanation:

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

asked 23/09/2024
Vivek Nandey
38 questions
Total 716 questions
Go to page: of 72
Open VPLUS File
Convert VPLUS to PDF

Related questions

How can the outer array structure of a semi-structured file be removed?
While preparing to unload data in Snowflake, the file format option can be specified in which commands? (Select TWO).
How can a data provider validate that a secure view is configured to display only the data the provider wishes to expose?
What are characteristics of the ownership privilege when it is granted on a regular Snowflake schema? (Select TWO).
A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micro-partitions being scanned How should this query be optimized?
During periods of warehouse contention which parameter controls the maximum length of time a warehouse will hold a query for processing?
How does the search optimization service improve query performance?
What is a key feature of Snowflake architecture?
Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?
Which of the following indicates that it may be appropriate to use a clustering key for a table? (Select TWO).