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: Rhodie***** After using the killexams.com set for a few weeks, I passed the EC exam. The questions and answers in the bundle were correct, and I got them right even during the exam. It simplified things, and I scored higher than I had hoped.

User: Simon***** I am grateful for the excellent cof-r02 exam preparation option provided by Killexams.com. The exam practice tests were actual, and I contacted customer support before making a purchase to ensure that the material was up-to-date. They assured me that they update all exams almost every day, and it was true. The exam brain sell-off was worth buying because I could rely on the cutting-edge exam material. I am confident that I will use Killexams.com as my primary training resource to expand my certification portfolio into other providers.

User: Pat***** After weeks of preparation with the Killexams.com set, I finally passed the cof-r02 exam. I am relieved to leave it behind but happy that I found Killexams.com to help me get through it. The questions and answers in their package are accurate, and the questions were taken from the actual cof-r02 exam, making the subjects much simpler. I even got higher marks than I had hoped for.

User: Simeon***** I struggled to manage my preparation time for the cof-r02 exam, with only 10 days left. Thankfully, killexams.com helped me tremendously and made the exam smoother for me. The way the exam topics were presented and addressed in their material resulted in a score of 959.

User: Richard***** I was struggling to pass the cof-r02 exam due to my poor knowledge of the subject. The language used in the books was too complicated and made me feel sleepy. But with killexams.com practice tests, I found an easy guide that helped me wrap up the preparation in just three weeks. I passed the exam with 88% marks, and it was all thanks to killexams.com. I got all the questions and answers in one place, making it an incredible resource for me.

---