ExamGecko
Search Search Login
Home Home / Snowflake / COF-R02

Snowflake COF-R02 Practice Test - Questions Answers, Page 19

Question list
Search
Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

A materialized view should be created when which of the following occurs? (Choose two.)
Which minimum Snowflake edition allows for a dedicated metadata store?
A sales table FCT_SALES has 100 million records. The following Query was executed SELECT COUNT (1) FROM FCT__SALES; How did Snowflake fulfill this query?
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files. How does Snowflake recommend maximizing the load performance?
Which TABLE function helps to convert semi-structured data to a relational representation?
How should a virtual warehouse be configured if a user wants to ensure that additional multi-clusters are resumed with no delay?
Which SQL command can be used to see the CREATE definition of a masking policy?
Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)
What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

Question 181

Report
Export
Collapse

What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?

A.
30 days
A.
30 days
Answers
B.
7 days
B.
7 days
Answers
C.
48 hours
C.
48 hours
Answers
D.
24 hours
D.
24 hours
Answers
Suggested answer: D

Question 182

Report
Export
Collapse

What type of query benefits the MOST from search optimization?

A.
A query that uses only disjunction (i.e., OR) predicates
A.
A query that uses only disjunction (i.e., OR) predicates
Answers
B.
A query that includes analytical expressions
B.
A query that includes analytical expressions
Answers
C.
A query that uses equality predicates or predicates that use IN
C.
A query that uses equality predicates or predicates that use IN
Answers
D.
A query that filters on semi-structured data types
D.
A query that filters on semi-structured data types
Answers
Suggested answer: C

Explanation:

Reference: https://community.snowflake.com/s/article/Search-Optimization-When-How-To-Use

Question 183

Report
Export
Collapse

Which of the following are characteristics of Snowflake virtual warehouses? (Choose two.)

A.
Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
A.
Auto-resume applies only to the last warehouse that was started in a multi-cluster warehouse.
Answers
B.
The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
B.
The ability to auto-suspend a warehouse is only available in the Enterprise edition or above.
Answers
C.
SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
C.
SnowSQL supports both a configuration file and a command line option for specifying a default warehouse.
Answers
D.
A user cannot specify a default warehouse when using the ODBC driver.
D.
A user cannot specify a default warehouse when using the ODBC driver.
Answers
E.
The default virtual warehouse size can be changed at any time.
E.
The default virtual warehouse size can be changed at any time.
Answers
Suggested answer: A

Question 184

Report
Export
Collapse

Which command should be used to load data from a file, located in an external stage, into a table in Snowflake?

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

Question 185

Report
Export
Collapse

The Snowflake Cloud Data Platform is described as having which of the following architectures?

A.
Shared-disk
A.
Shared-disk
Answers
B.
Shared-nothing
B.
Shared-nothing
Answers
C.
Multi-cluster shared data
C.
Multi-cluster shared data
Answers
D.
Serverless query engine
D.
Serverless query engine
Answers
Suggested answer: C

Question 186

Report
Export
Collapse

Which of the following is a data tokenization integration partner?

A.
Protegrity
A.
Protegrity
Answers
B.
Tableau
B.
Tableau
Answers
C.
DBeaver
C.
DBeaver
Answers
D.
SAP
D.
SAP
Answers
Suggested answer: A

Question 187

Report
Export
Collapse

What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)

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

Question 188

Report
Export
Collapse

What are supported file formats for unloading data from Snowflake? (Choose three.)

A.
XML
A.
XML
Answers
B.
JSON
B.
JSON
Answers
C.
Parquet
C.
Parquet
Answers
D.
ORC
D.
ORC
Answers
E.
AVRO
E.
AVRO
Answers
F.
CSV
F.
CSV
Answers
Suggested answer: B, C, F

Question 189

Report
Export
Collapse

The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

A.
Local disk caching
A.
Local disk caching
Answers
B.
Authentication and access control
B.
Authentication and access control
Answers
C.
Metadata management
C.
Metadata management
Answers
D.
Query processing
D.
Query processing
Answers
E.
Database storage
E.
Database storage
Answers
Suggested answer: C, D

Question 190

Report
Export
Collapse

When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)

A.
There is no need to have a Snowflake account in the target region, a share will be created for each user.
A.
There is no need to have a Snowflake account in the target region, a share will be created for each user.
Answers
B.
The listing is replicated into all selected regions automatically, the data is not.
B.
The listing is replicated into all selected regions automatically, the data is not.
Answers
C.
The user must have the ORGADMIN role available in at least one account to link accounts for replication.
C.
The user must have the ORGADMIN role available in at least one account to link accounts for replication.
Answers
D.
Shares attached to listings in remote regions can be viewed from any account in an organization.
D.
Shares attached to listings in remote regions can be viewed from any account in an organization.
Answers
E.
For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.
E.
For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.
Answers
Suggested answer: A, C
Total 330 questions
Go to page: of 33
ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms