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

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

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.)
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?
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 minimum Snowflake edition allows for a dedicated metadata store?
Which of the following Snowflake features provide continuous data protection automatically? (Select TWO).
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?
What is a responsibility of Snowflake’s virtual warehouses?
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?

Question 241

Report
Export
Collapse

Which of the following accurately describes shares?

A.
Tables, secure views, and secure UDFs can be shared
A.
Tables, secure views, and secure UDFs can be shared
Answers
B.
Shares can be shared
B.
Shares can be shared
Answers
C.
Data consumers can clone a new table from a share
C.
Data consumers can clone a new table from a share
Answers
D.
Access to a share cannot be revoked once granted
D.
Access to a share cannot be revoked once granted
Answers
Suggested answer: A

Question 242

Report
Export
Collapse

What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)

A.
Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
A.
Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
Answers
B.
All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.
B.
All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.
Answers
C.
The ACCOUNTADMIN role must be granted to only one user.
C.
The ACCOUNTADMIN role must be granted to only one user.
Answers
D.
Assign the ACCOUNTADMIN role to at least two users, but as few as possible.
D.
Assign the ACCOUNTADMIN role to at least two users, but as few as possible.
Answers
E.
All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.
E.
All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.
Answers
Suggested answer: A, D

Question 243

Report
Export
Collapse

What is the minimum Snowflake edition required for row level security?

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

Question 244

Report
Export
Collapse

The is the minimum Fail-safe retention time period for transient tables?

A.
1 day
A.
1 day
Answers
B.
7 days
B.
7 days
Answers
C.
12 hours
C.
12 hours
Answers
D.
0 days
D.
0 days
Answers
Suggested answer: D

Question 245

Report
Export
Collapse

Which statements are correct concerning the leveraging of third-party data from the Snowflake Data Marketplace? (Choose two.)

A.
Data is live, ready-to-query, and can be personalized.
A.
Data is live, ready-to-query, and can be personalized.
Answers
B.
Data needs to be loaded into a cloud provider as a consumer account.
B.
Data needs to be loaded into a cloud provider as a consumer account.
Answers
C.
Data is not available for copying or moving to an individual Snowflake account.
C.
Data is not available for copying or moving to an individual Snowflake account.
Answers
D.
Data is available without copying or moving.
D.
Data is available without copying or moving.
Answers
E.
Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.
E.
Data transformations are required when combining Data Marketplace datasets with existing data in Snowflake.
Answers
Suggested answer: A, D

Question 246

Report
Export
Collapse

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

A.
Whether or not it is also a secure view
A.
Whether or not it is also a secure view
Answers
B.
How often the underlying base table is queried
B.
How often the underlying base table is queried
Answers
C.
How often the base table changes
C.
How often the base table changes
Answers
D.
Whether the materialized view has a cluster key defined
D.
Whether the materialized view has a cluster key defined
Answers
E.
How often the materialized view is queried
E.
How often the materialized view is queried
Answers
Suggested answer: D, E

Question 247

Report
Export
Collapse

What COPY INTO SQL command should be used to unload data into multiple files?

A.
SINGLE=TRUE
A.
SINGLE=TRUE
Answers
B.
MULTIPLE=TRUE
B.
MULTIPLE=TRUE
Answers
C.
MULTIPLE=FALSE
C.
MULTIPLE=FALSE
Answers
D.
SINGLE=FALSE
D.
SINGLE=FALSE
Answers
Suggested answer: C

Question 248

Report
Export
Collapse

When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?

A.
The cloned views and the stored procedures will reference the cloned tables in the cloned database.
A.
The cloned views and the stored procedures will reference the cloned tables in the cloned database.
Answers
B.
An error will occur, as views with qualified references cannot be cloned.
B.
An error will occur, as views with qualified references cannot be cloned.
Answers
C.
An error will occur, as stored objects cannot be cloned.
C.
An error will occur, as stored objects cannot be cloned.
Answers
D.
The stored procedures and views will refer to tables in the source database.
D.
The stored procedures and views will refer to tables in the source database.
Answers
Suggested answer: D

Question 249

Report
Export
Collapse

When loading data into Snowflake, how should the data be organized?

A.
Into single files with 100-250 MB of compressed data per file
A.
Into single files with 100-250 MB of compressed data per file
Answers
B.
Into single files with 1-100 MB of compressed data per file
B.
Into single files with 1-100 MB of compressed data per file
Answers
C.
Into files of maximum size of 1 GB of compressed data per file
C.
Into files of maximum size of 1 GB of compressed data per file
Answers
D.
Into files of maximum size of 4 GB of compressed data per file
D.
Into files of maximum size of 4 GB of compressed data per file
Answers
Suggested answer: A

Question 250

Report
Export
Collapse

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

A.
Schema
A.
Schema
Answers
B.
View
B.
View
Answers
C.
Internal stage
C.
Internal stage
Answers
D.
Table
D.
Table
Answers
E.
User
E.
User
Answers
F.
Role
F.
Role
Answers
Suggested answer: A, D
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