ExamGecko
Home / Snowflake / COF-R02
Ask Question

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

Question list
Search

Question 41

Report
Export
Collapse

If a Small Warehouse is made up of 2 servers/cluster, how many servers/cluster make up a Medium Warehouse?

4
4
16
16
32
32
128
128
Suggested answer: A

Explanation:

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

asked 23/09/2024
Erik de Bont
39 questions

Question 42

Report
Export
Collapse

Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)

Is available to all Snowflake Editions
Is available to all Snowflake Editions
Is only available to customers with Business Critical Edition
Is only available to customers with Business Critical Edition
Restricts or enables access to specific IP addresses
Restricts or enables access to specific IP addresses
Is activated using an “ALTER DATABASE” command
Is activated using an “ALTER DATABASE” command
Suggested answer: A, C

Explanation:

Reference: https://docs.snowflake.com/en/sql-reference/sql/create-network-policy.html

asked 23/09/2024
charles ratchagaraj
37 questions

Question 43

Report
Export
Collapse

A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

The tables are now orphaned
The tables are now orphaned
The user that deleted the role
The user that deleted the role
SYSADMIN
SYSADMIN
The assumed role that dropped the role
The assumed role that dropped the role
Suggested answer: D

Explanation:

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

asked 23/09/2024
HW Yan
45 questions

Question 44

Report
Export
Collapse

The Query History in the Snowflake Web Interface (UI) is kept for approximately:

60 minutes
60 minutes
24 hours
24 hours
14 days
14 days
30 days
30 days
1 year
1 year
Suggested answer: C

Explanation:

Reference: https://docs.snowflake.com/en/sql-reference/account-usage/query_history.html

asked 23/09/2024
Stephanie Scheffers
42 questions

Question 45

Report
Export
Collapse

To run a Multi-Cluster Warehouse in auto-scale mode, a user would:

Configure the Maximum Clusters setting to “Auto-Scale”
Configure the Maximum Clusters setting to “Auto-Scale”
Set the Warehouse type to “Auto”
Set the Warehouse type to “Auto”
Set the Minimum Clusters and Maximum Clusters settings to the same value
Set the Minimum Clusters and Maximum Clusters settings to the same value
Set the Minimum Clusters and Maximum Clusters settings to the different values
Set the Minimum Clusters and Maximum Clusters settings to the different values
Suggested answer: D

Explanation:

Reference: https://help.pentaho.com/Documentation/9.1/Products/Modify_Snowflake_warehouse

asked 23/09/2024
Jhonatan Abril
27 questions

Question 46

Report
Export
Collapse

Which of the following terms best describes Snowflake’s database architecture?

Columnar shared nothing
Columnar shared nothing
Shared disk
Shared disk
Multi-cluster, shared data
Multi-cluster, shared data
Cloud-native shared memory
Cloud-native shared memory
Suggested answer: C

Explanation:

https://www.snowflake.com/product/architecture/

Built from the ground up for the cloud, Snowflake’s unique multi-cluster shared data architecture delivers the performance, scale, elasticity, and concurrency today’s organizations require.

asked 23/09/2024
Dennis Spring
45 questions

Question 47

Report
Export
Collapse

Which of the following objects is not covered by Time Travel?

Tables
Tables
Schemas
Schemas
Databases
Databases
Stages
Stages
Suggested answer: D

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/data-time-travel.html

asked 23/09/2024
Josue Medrano Caldera
21 questions

Question 48

Report
Export
Collapse

When can a Virtual Warehouse start running queries?

12am-5am
12am-5am
Only during administrator defined time slots
Only during administrator defined time slots
When its provisioning is complete
When its provisioning is complete
After replication
After replication
Suggested answer: C

Explanation:

https://docs.snowflake.com/en/user-guide/warehouses-overview.html

asked 23/09/2024
Anass Chadid ansari
38 questions

Question 49

Report
Export
Collapse

True or False: Pipes can be suspended and resumed.

True
True
False
False
Suggested answer: A

Explanation:

https://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#pausing-or-resuming-pipes Pausing or Resuming Pipes In addition to the pipe owner, a role that has the following minimum permissions can pause or resume the pipe:

asked 23/09/2024
Miguel Tuimil Galdo
40 questions

Question 50

Report
Export
Collapse

Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)

The validation_mode option is used when creating an Internal Stage
The validation_mode option is used when creating an Internal Stage
validation_mode=return_all_errors is a parameter of the copy command
validation_mode=return_all_errors is a parameter of the copy command
The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error
The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error
The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
Suggested answer: B, D

Explanation:

Reference: https://docs.snowflake.com/en/user-guide/data-load-bulk-ts.html

asked 23/09/2024
Russell Ang
34 questions
Total 330 questions
Go to page: of 33