ExamGecko
Home / Snowflake / COF-R02
Ask Question

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

Question list
Search

Question 11

Report
Export
Collapse

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

True
True
False
False
Suggested answer: A

Explanation:

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

asked 23/09/2024
Gift Thanyane
33 questions

Question 12

Report
Export
Collapse

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

Auto-suspend
Auto-suspend
Auto-resume
Auto-resume
Local SSD size
Local SSD size
User count
User count
Suggested answer: A, B
asked 23/09/2024
Mihai Stefanescu
35 questions

Question 13

Report
Export
Collapse

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

UPSERT
UPSERT
MERGE
MERGE
UPDATE
UPDATE
TRUNCATE TABLE
TRUNCATE TABLE
Suggested answer: A

Explanation:

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

asked 23/09/2024
Martin Schouten
41 questions

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.

True
True
False
False
Suggested answer: B

Explanation:

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

asked 23/09/2024
Vaniko Batiashvili
30 questions

Question 15

Report
Export
Collapse

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

A multi-cluster Warehouse can add clusters automatically based on query activity
A multi-cluster Warehouse can add clusters automatically based on query activity
A multi-cluster Warehouse can automatically turn itself off after a period of inactivity
A multi-cluster Warehouse can automatically turn itself off after a period of inactivity
A multi-cluster Warehouse can scale down when query activity slows
A multi-cluster Warehouse can scale down when query activity slows
A multi-cluster Warehouse can automatically turn itself on when a query is executed against it
A multi-cluster Warehouse can automatically turn itself on when a query is executed against it
Suggested answer: A, B, C, D
asked 23/09/2024
vinoth inigo
43 questions

Question 16

Report
Export
Collapse

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

Choose 3 answers

On-premise availability
On-premise availability
Simplicity
Simplicity
Open source based
Open source based
Concurrency
Concurrency
Performance
Performance
Suggested answer: B, D, E
asked 23/09/2024
Andrew Dobie
34 questions

Question 17

Report
Export
Collapse

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

True
True
False
False
Suggested answer: B

Explanation:

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

asked 23/09/2024
PHINIT LAORUNGRUANGDECH
44 questions

Question 18

Report
Export
Collapse

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

Custom
Custom
Economy
Economy
Optimized
Optimized
Standard
Standard
Suggested answer: B, D

Explanation:

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

asked 23/09/2024
Raza Todorovac
44 questions

Question 19

Report
Export
Collapse

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

True
True
False
False
Suggested answer: B

Explanation:

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

asked 23/09/2024
Christian Gyssels
38 questions

Question 20

Report
Export
Collapse

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

SYSADMIN
SYSADMIN
SECURITYADMIN
SECURITYADMIN
PUBLIC
PUBLIC
ACCOUNTADMIN
ACCOUNTADMIN
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"

asked 23/09/2024
Arnold Bronson TCHOFFO
44 questions
Total 330 questions
Go to page: of 33