Latest COF-R02 Practice Tests with Actual Questions

Get Complete pool of questions with Premium PDF and Test Engine

Exam Code : COF-R02
Exam Name : Snowflake SnowPro Core Recertification
Vendor Name :
"SnowFlake"

Download Full Version of COF-R02

---

COF-R02 Dumps COF-R02 Braindumps

COF-R02 Real Questions COF-R02 Practice Test COF-R02 Actual Questions

killexams.com SnowFlake COF-R02

Snowflake SnowPro Core Recertification

https://killexams.com/pass4sure/exam-detail/COF-R02

Question: 83

What happens when a virtual warehouse is resized?

1. When increasing the size of an active warehouse the compute resource for all running and queued queries on the warehouse are affected

2. When reducing the size of a warehouse the compute resources are removed only when they are no longer being used to execute any current statements.

3. The warehouse will be suspended while the new compute resource is provisioned and will resume automatically once provisioning is complete.

4. Users who are trying to use the warehouse will receive an error message until the resizing is complete

Answer: B

Question: 84

A user has unloaded data from Snowflake to a stage

Which SQL command should be used to validate which data was loaded into the stage?

1. list @file stage

2. show @file stage

3. view @file stage

4. verify @file stage

Answer: A

Question: 85

Snowflake is designed for which type of workloads? (Choose two.)

1. OLAP (Analytics) workloads

2. OLTP (Transactional) workloads

3. Concurrent workloads

4. On-premise workloads

Answer: A,C
Explanation: Reference:

https://blog.couchbase.com/its-the-workload-stupid/

https://www.quora.com/Can-Snowflake-be-used-for-an-OLTP-system-or-is-it-only-best-suited-for-warehousing

Question: 86

Which of the following are best practice recommendations that should be considered when loading data into

Snowflake? (Select TWO).

1. Load files that are approximately 25 MB or smaller.

2. Remove all dates and timestamps.

3. Load files that are approximately 100-250 MB (or larger)

4. Avoid using embedded characters such as commas for numeric data types

5. Remove semi-structured data types

Answer: C,D
Explanation:

https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html

Question: 87

True or False: A Snowflake account is charged for data stored in both Internal and External Stages.

1. True

2. False

Answer: A
Explanation:

Reference: https://docs.snowflake.com/en/user-guide/tables-storage-considerations.html

Question: 88

Which of the following are valid methods for authenticating users for access into Snowflake? (Select THREE)

1. SCIM

2. Federated authentication

3. TLS 1.2

4. Key-pair authentication

5. OAuth

6. OCSP authentication

Answer: B,D,E

Question: 89

What is a machine learning and data science partner within the Snowflake Partner Ecosystem?

1. Informatica

2. Power Bl

3. Adobe

4. Data Robot

Answer: D

Explanation:

https://docs.snowflake.com/en/user-guide/ecosystem-analytics.html

Question: 90

Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)

1. Customers can change the size of the Warehouse after creation

2. A Warehouse can be resized while running

3. A Warehouse can be configured to suspend after a period of inactivity

4. A Warehouse can be configured to auto-resume when new queries are submitted

Answer: A,B,C,D
Explanation:

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

Question: 91

A virtual warehouse’s auto-suspend and auto-resume settings apply to which of the following?

1. The primary cluster in the virtual warehouse

2. The entire virtual warehouse

3. The database in which the virtual warehouse resides

4. The Queries currently being run on the virtual warehouse

Answer: B
Explanation:

https://docs.snowflake.com/en/user-guide/warehouses- overview.html#:~:text=Similarly%2C%20auto%2Dresume%20ensures%20that,individual% 20clusters%20in%20the%20warehouse.

Question: 92

Which of the following statements describes a benefit of Snowflake’s separation of compute and storage? (Choose all that apply.)

1. Growth of storage and compute are tightly coupled together

2. Storage expands without the requirement to add more compute

3. Compute can be scaled up or down without the requirement to add more storage

4. Multiple compute clusters can access stored data without contention

Answer: B,C,D
Explanation:

Reference: https://towardsdatascience.com/why-you-are-throwing-money-away-if-your-cloud-data-warehousedoesnt- separate-storage-and-compute-65d2dffd450f

Question: 93

Which interfaces can be used to create and/or manage Virtual Warehouses?

1. The Snowflake Web Interface (UI)

2. SQL commands

3. Data integration tools

4. All of the above

Answer: D
Explanation:

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

Question: 94

True or False: Some queries can be answered through the metadata cache and do not require an active Virtual Warehouse.

1. True

2. False

Answer: A
Explanation:

Some aggregate queries are answered thru micro partitions metadata only not requiring any VW spin ups.

Question: 95

What is the minimum Snowflake edition that provides multi-cluster warehouses and up to 90 days of Time Travel?

1. Standard

2. Premier

3. Enterprise

4. Business Critical Edition

Answer: C
Explanation:

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

Question: 96

In which use cases does Snowflake apply egress charges?

1. Data sharing within a specific region

2. Query result retrieval

3. Database replication

4. Loading data into Snowflake

Answer: A
Explanation:

Cloud providers apply data egress charges in either of the following use cases: Data is transferred from one region to another within the same cloud platform. Data is transferred out of the cloud platform.

https://docs.snowflake.com/en/user-guide/billing-data- transfer.html#:~:text=Cloud%20providers%20apply%20data%20egress,out%20of%20the% 20cloud%20platform.

Question: 97

True or False: It is possible to load data into Snowflake without creating a named File Format object.

1. True

2. False

Answer: A
Explanation:

Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.html

Question: 98

The PUT command: (Choose two.)

1. Automatically creates a File Format object

2. Automatically uses the last Stage created

3. Automatically compresses files using Gzip

4. Automatically encrypts files

Answer: C,D
Explanation:

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

Question: 99

What feature can be used to reorganize a very large table on one or more columns?

1. Micro-partitions

2. Clustering keys

3. Key partitions

4. Clustered partitions

Answer: B
Explanation:

https://docs.snowflake.com/en/user-guide/tables-clustering-keys.html

Question: 100

Which command can be used to load data into an internal stage?

1. LOAD

2. copy

3. GET

4. PUT

Answer: D
Explanation:

https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internal-stages-7121cc3cc9

User: Natalia***** If you want to change your destiny and ensure that happiness is part of your future, you must work hard. It was my destiny to find Killexams during my exams because it led me towards my destiny. My fate was getting accurate grades, and Killexams and its teachers made it possible through their exceptional coaching. Thanks to their material, I could not possibly fail the cof-r02 exam.

User: Stanley***** My unexpected popularity came after I achieved the best marks in my Cisco test, thanks to the preparatory education I received from killexams.com. Their first-class materials helped me to perform well and achieve great success.

User: Valeria***** I owe my achievement in passing the cof-r02 exam to Killexams.com. All the questions on the exam were from their guide, making it the true helper for me on the exam. This observation guide perfectly guided me for trying cof-r02 exam questions and ensured my 100% success in the exam.

User: Mildred***** I am grateful to Killexams.com for providing me with the best training material for the COF-R02 exam. The practice tests resolved all my doubts and helped me succeed with a high-quality score. I am thrilled with their remarkable help and highly recommend their materials.

User: Rashel***** After a long search, I found this particular source, and everyone here is cooperative and capable. The team provided me with an excellent practice test for cof-r02 preparation. Thanks to killexams.com, I was able to prepare for cof-r02 with pretty accurate material, and I will go for other SnowFlake tests with their help.

---