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

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

List of questions

Question 181

Report
Export
Collapse

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

30 days
30 days
7 days
7 days
48 hours
48 hours
24 hours
24 hours
Suggested answer: D
asked 23/09/2024
Giorgio Bertocchi
39 questions

Question 182

Report
Export
Collapse

What type of query benefits the MOST from search optimization?

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

Explanation:

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

asked 23/09/2024
Madhanraj N
42 questions

Question 183

Report
Export
Collapse

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

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

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?

INSERT
INSERT
PUT
PUT
GET
GET
COPY
COPY
Suggested answer: D
asked 23/09/2024
Ken Wilson
40 questions

Question 185

Report
Export
Collapse

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

Shared-disk
Shared-disk
Shared-nothing
Shared-nothing
Multi-cluster shared data
Multi-cluster shared data
Serverless query engine
Serverless query engine
Suggested answer: C
asked 23/09/2024
Suraj Porwal
36 questions

Question 186

Report
Export
Collapse

Which of the following is a data tokenization integration partner?

Protegrity
Protegrity
Tableau
Tableau
DBeaver
DBeaver
SAP
SAP
Suggested answer: A
asked 23/09/2024
Bob Hanselman
37 questions

Question 187

Report
Export
Collapse

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

Custom Edition
Custom Edition
Virtual Private Snowflake
Virtual Private Snowflake
Business Critical Edition
Business Critical Edition
Standard Edition
Standard Edition
Enterprise Edition
Enterprise Edition
Suggested answer: B, C
asked 23/09/2024
Lampros Diamantopoulos
31 questions

Question 188

Report
Export
Collapse

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

XML
XML
JSON
JSON
Parquet
Parquet
ORC
ORC
AVRO
AVRO
CSV
CSV
Suggested answer: B, C, F
asked 23/09/2024
Vikram Panchal
37 questions

Question 189

Report
Export
Collapse

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

Local disk caching
Local disk caching
Authentication and access control
Authentication and access control
Metadata management
Metadata management
Query processing
Query processing
Database storage
Database storage
Suggested answer: C, D
asked 23/09/2024
charles ratchagaraj
37 questions

Question 190

Report
Export
Collapse

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

There is no need to have a Snowflake account in the target region, a share will be created for each user.
There is no need to have a Snowflake account in the target region, a share will be created for each user.
The listing is replicated into all selected regions automatically, the data is not.
The listing is replicated into all selected regions automatically, the data is not.
The user must have the ORGADMIN role available in at least one account to link accounts for replication.
The user must have the ORGADMIN role available in at least one account to link accounts for replication.
Shares attached to listings in remote regions can be viewed from any account in an organization.
Shares attached to listings in remote regions can be viewed from any account in an organization.
For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.
For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.
Suggested answer: A, C
asked 23/09/2024
Felomino Bacquiano II
45 questions
Total 330 questions
Go to page: of 33
Open VPLUS File
Convert VPLUS to PDF

Related questions

A materialized view should be created when which of the following occurs? (Choose two.)
What is the default character set used when loading CSV files into Snowflake?
Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)
A virtual warehouse's auto-suspend and auto-resume settings apply to which of the following?
Which of the following terms best describes Snowflake’s database architecture?
Which privilege is required for a role to be able to resume a suspended warehouse if auto-resume is not enabled?
What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?
Which of the following are best practices for loading data into Snowflake? (Choose three.)
A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?
What are the three layers that make up Snowflake’s architecture? Choose 3 answer