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

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

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 311

Report
Export
Collapse

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?

A.
Use auto-ingest Snowpipes to load large files in a serverless model.
A.
Use auto-ingest Snowpipes to load large files in a serverless model.
Answers
B.
Produce the largest files possible, reducing the overall number of files to process.
B.
Produce the largest files possible, reducing the overall number of files to process.
Answers
C.
Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.
C.
Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.
Answers
D.
Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.
D.
Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.
Answers
Suggested answer: B

Question 312

Report
Export
Collapse

If a Snowflake user decides a table should be clustered, what should be used as the cluster key?

A.
The columns that are queried in the select clause.
A.
The columns that are queried in the select clause.
Answers
B.
The columns with very high cardinality.
B.
The columns with very high cardinality.
Answers
C.
The columns with many different values.
C.
The columns with many different values.
Answers
D.
The columns most actively used in the select filters.
D.
The columns most actively used in the select filters.
Answers
Suggested answer: D

Question 313

Report
Export
Collapse

What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

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

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html#business-critical-edition

Question 314

Report
Export
Collapse

What privilege should a user be granted to change permissions for new objects in a managed access schema?

A.
Grant the OWNERSHIP privilege on the schema.
A.
Grant the OWNERSHIP privilege on the schema.
Answers
B.
Grant the OWNERSHIP privilege on the database.
B.
Grant the OWNERSHIP privilege on the database.
Answers
C.
Grant the MANAGE GRANTS global privilege.
C.
Grant the MANAGE GRANTS global privilege.
Answers
D.
Grant ALL privileges on the schema.
D.
Grant ALL privileges on the schema.
Answers
Suggested answer: C

Question 315

Report
Export
Collapse

A materialized view should be created when which of the following occurs? (Choose two.)

A.
There is minimal cost associated with running the query.
A.
There is minimal cost associated with running the query.
Answers
B.
The query consumes many compute resources every time it runs.
B.
The query consumes many compute resources every time it runs.
Answers
C.
The base table gets updated frequently.
C.
The base table gets updated frequently.
Answers
D.
The query is highly optimized and does not consume many compute resources.
D.
The query is highly optimized and does not consume many compute resources.
Answers
E.
The results of the query do not change often and are used frequently.
E.
The results of the query do not change often and are used frequently.
Answers
Suggested answer: C, E

Question 316

Report
Export
Collapse

Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?

A.
CREATE_SHARE on the account
A.
CREATE_SHARE on the account
Answers
B.
SHARE on databases and schemas
B.
SHARE on databases and schemas
Answers
C.
SELECT on tables used by the secure view
C.
SELECT on tables used by the secure view
Answers
D.
REFERENCE_USAGE on databases
D.
REFERENCE_USAGE on databases
Answers
Suggested answer: C

Question 317

Report
Export
Collapse

Which feature allows a user the ability to control the organization of data in a micro-partition?

A.
Range Partitioning
A.
Range Partitioning
Answers
B.
Search Optimization Service
B.
Search Optimization Service
Answers
C.
Automatic Clustering
C.
Automatic Clustering
Answers
D.
Horizontal Partitioning
D.
Horizontal Partitioning
Answers
Suggested answer: D

Question 318

Report
Export
Collapse

A Snowflake user executed a query and received the results. Another user executed the same query 4 hours later. The data had not changed.

What will occur?

A.
No virtual warehouse will be used, data will be read from the result cache.
A.
No virtual warehouse will be used, data will be read from the result cache.
Answers
B.
No virtual warehouse will be used, data will be read from the local disk cache.
B.
No virtual warehouse will be used, data will be read from the local disk cache.
Answers
C.
The default virtual warehouse will be used to read all data.
C.
The default virtual warehouse will be used to read all data.
Answers
D.
The virtual warehouse that is defined at the session level will be used to read all data.
D.
The virtual warehouse that is defined at the session level will be used to read all data.
Answers
Suggested answer: A

Question 319

Report
Export
Collapse

Which statements reflect key functionalities of a Snowflake Data Exchange? (Choose two.)

A.
If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.
A.
If an account is enrolled with a Data Exchange, it will lose its access to the Snowflake Marketplace.
Answers
B.
A Data Exchange allows groups of accounts to share data privately among the accounts.
B.
A Data Exchange allows groups of accounts to share data privately among the accounts.
Answers
C.
A Data Exchange allows accounts to share data with third, non-Snowflake parties.
C.
A Data Exchange allows accounts to share data with third, non-Snowflake parties.
Answers
D.
Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.
D.
Data Exchange functionality is available by default in accounts using the Enterprise edition or higher.
Answers
E.
The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.
E.
The sharing of data in a Data Exchange is bidirectional. An account can be a provider for some datasets and a consumer for others.
Answers
Suggested answer: B

Question 320

Report
Export
Collapse

Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

A.
Files
A.
Files
Answers
B.
External tables
B.
External tables
Answers
C.
Secure User-Defined Functions (UDFs)
C.
Secure User-Defined Functions (UDFs)
Answers
D.
Sequences
D.
Sequences
Answers
E.
Streams
E.
Streams
Answers
Suggested answer: B, 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