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

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

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 11

Report
Export
Collapse

True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

A.
True
A.
True
Answers
B.
False
B.
False
Answers
Suggested answer: A

Explanation:

Reference: https://blog.ippon.tech/innovative-snowflake-features-caching/

Question 12

Report
Export
Collapse

Which of the following are options when creating a Virtual Warehouse?

A.
Auto-suspend
A.
Auto-suspend
Answers
B.
Auto-resume
B.
Auto-resume
Answers
C.
Local SSD size
C.
Local SSD size
Answers
D.
User count
D.
User count
Answers
Suggested answer: A, B

Question 13

Report
Export
Collapse

Which of the following DML commands isn’t supported by Snowflake?

A.
UPSERT
A.
UPSERT
Answers
B.
MERGE
B.
MERGE
Answers
C.
UPDATE
C.
UPDATE
Answers
D.
TRUNCATE TABLE
D.
TRUNCATE TABLE
Answers
Suggested answer: A

Explanation:

Reference: https://docs.snowflake.com/en/sql-reference/sql-dml.html

Question 14

Report
Export
Collapse

True or False: A customer using SnowSQL / native connectors will be unable be unable to able to also use the Snowflake Web interface (UI) unless access to the UI is explicitly granted by supported.

A.
True
A.
True
Answers
B.
False
B.
False
Answers
Suggested answer: B

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/connecting.html

Question 15

Report
Export
Collapse

Which of the following are true of multi-cluster Warehouses? Select all that apply below.

A.
A multi-cluster Warehouse can add clusters automatically based on query activity
A.
A multi-cluster Warehouse can add clusters automatically based on query activity
Answers
B.
A multi-cluster Warehouse can automatically turn itself off after a period of inactivity
B.
A multi-cluster Warehouse can automatically turn itself off after a period of inactivity
Answers
C.
A multi-cluster Warehouse can scale down when query activity slows
C.
A multi-cluster Warehouse can scale down when query activity slows
Answers
D.
A multi-cluster Warehouse can automatically turn itself on when a query is executed against it
D.
A multi-cluster Warehouse can automatically turn itself on when a query is executed against it
Answers
Suggested answer: A, B, C, D

Question 16

Report
Export
Collapse

What are the three things customers want most from their enterprise data warehouse solution?

Choose 3 answers

A.
On-premise availability
A.
On-premise availability
Answers
B.
Simplicity
B.
Simplicity
Answers
C.
Open source based
C.
Open source based
Answers
D.
Concurrency
D.
Concurrency
Answers
E.
Performance
E.
Performance
Answers
Suggested answer: B, D, E

Question 17

Report
Export
Collapse

True or False: Snowflake charges a premium for storing semi-structured data.

A.
True
A.
True
Answers
B.
False
B.
False
Answers
Suggested answer: B

Explanation:

Reference: https://snowflakecommunity.force.com/s/question/0D50Z00008ckwNuSAI/doessnowflakechargespremium-for-storing-semi-structured-data

Question 18

Report
Export
Collapse

Which of the following are valid Snowflake Virtual Warehouse Scaling Policies? (Choose two.)

A.
Custom
A.
Custom
Answers
B.
Economy
B.
Economy
Answers
C.
Optimized
C.
Optimized
Answers
D.
Standard
D.
Standard
Answers
Suggested answer: B, D

Explanation:

Reference: https://community.snowflake.com/s/article/Snowflake-Visualizing-Warehouse-Performance

Question 19

Report
Export
Collapse

True or False: A single database can exist in more than one Snowflake account.

A.
True
A.
True
Answers
B.
False
B.
False
Answers
Suggested answer: B

Explanation:

Reference: https://docs.snowflake.com/en/sql-reference/ddl-database.html

Question 20

Report
Export
Collapse

Which of the following roles is recommended to be used to create and manage users and roles?

A.
SYSADMIN
A.
SYSADMIN
Answers
B.
SECURITYADMIN
B.
SECURITYADMIN
Answers
C.
PUBLIC
C.
PUBLIC
Answers
D.
ACCOUNTADMIN
D.
ACCOUNTADMIN
Answers
Suggested answer: B

Explanation:

https://docs.snowflake.com/en/user-guide/security-access-control-overview.html"Security admin: Role that can manage any object grant globally, as well as create, monitor, andmanage users and roles"

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