COF-R02 : Snowflake SnowPro Core Recertification Exam

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: Stassia***** As an administrator, killexams.com’s testprep materials enabled me to answer 60 COF-R02 exam questions in 80 minutes, passing effortlessly. Their confidence-building resources are my only recommendation for preparation, and I am thankful for their support.

User: Alejandro***** The answers provided in Killexams.com Questions and Answers were concise and easy to understand, yet had a significant impact. With their help, I was able to pass my COF-R02 exam with a healthy score of 69. I would strongly recommend Killexams.com Questions and Answers for anyone looking to practice for the COF-R02 exam.

User: Nadezhda***** My goal was not just to pass the COF-R02 exam but to excel and make a strong impression. Killexams.com provided the high-quality resources I needed to achieve outstanding results. Their practice tests were key to my high score, and I could not be more satisfied.

User: Meera***** The COF-R02 exam is not easy, but with the Killexams.com preparation package, I scored a perfect 100%. The package includes actual exam questions, modern updates, and extra materials to ensure that you understand what needs to be learned. I used their exam simulator extensively, which gave me the confidence to pass the exam on the day. This has been a tremendous investment in my career, and I have proudly included my marks on my resume and LinkedIn profile as a recognition booster.

User: Joaquín***** After failing the cof-r02 exam, killexams.com’s testprep practice pack, with its questions, answers, and exam simulator, helped me score 98%. Their resources made preparation effortless, and I am thrilled with their exceptional support in achieving my certification.

---