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


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?
A. When increasing the size of an active warehouse the compute resource for all running and queued queries on the
warehouse are affected
B. 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.
C. The warehouse will be suspended while the new compute resource is provisioned and will resume automatically
once provisioning is complete.
D. 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?
A. list @file__stage
B. show @file__stage
C. view @file__stage
D. verify @file__stage
Answer: A
Question: 85
Snowflake is designed for which type of workloads? (Choose two.)
A. OLAP (Analytics) workloads
B. OLTP (Transactional) workloads
C. Concurrent workloads
D. 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).
A. Load files that are approximately 25 MB or smaller.
B. Remove all dates and timestamps.
C. Load files that are approximately 100-250 MB (or larger)
D. Avoid using embedded characters such as commas for numeric data types
E. 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.
A. True
B. 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)
A. SCIM
B. Federated authentication
C. TLS 1.2
D. Key-pair authentication
E. OAuth
F. OCSP authentication
Answer: B,D,E
Question: 89
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
A. Informatica
B. Power Bl
C. Adobe
D. 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.)
A. Customers can change the size of the Warehouse after creation
B. A Warehouse can be resized while running
C. A Warehouse can be configured to suspend after a period of inactivity
D. 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?
A. The primary cluster in the virtual warehouse
B. The entire virtual warehouse
C. The database in which the virtual warehouse resides
D. 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.)
A. Growth of storage and compute are tightly coupled together
B. Storage expands without the requirement to add more compute
C. Compute can be scaled up or down without the requirement to add more storage
D. 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?
A. The Snowflake Web Interface (UI)
B. SQL commands
C. Data integration tools
D. 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.
A. True
B. 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?
A. Standard
B. Premier
C. Enterprise
D. 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?
A. Data sharing within a specific region
B. Query result retrieval
C. Database replication
D. 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.
A. True
B. 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.)
A. Automatically creates a File Format object
B. Automatically uses the last Stage created
C. Automatically compresses files using Gzip
D. 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?
A. Micro-partitions
B. Clustering keys
C. Key partitions
D. 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?
A. LOAD
B. copy
C. GET
D. PUT
Answer: D
Explanation:
https://medium.com/@divyanshsaxenaofficial/snowflake-loading-unloading-of-data-part-1-internal-stages-7121cc3cc9

User: LĂ©na***** I highly recommend Killexams.com for their outstanding coaching program that helped me exceed all expectations and perform exceptionally well on the COF-R02 exam. It is one of the most admirable online coaching ventures I have ever encountered and deserves recognition.

User: Venera***** I am feeling very happy and accomplished that I have successfully cleared my COF-R02 exam. I would like to express my gratitude to Killexams.com, which helped me throughout my journey of preparing for the exam. Without their generosity and support, I would not have been able to achieve such excellent results.

User: Natalia***** 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.

User: Ulya***** Thanks to killexams.com, I passed my COF-R02 exam and was relieved to know that I was not alone in my struggles. killexams.com provides an outstanding way to prepare for IT exams. The exam simulator runs smoothly, and I could practice in the exam environment for hours, using actual exam questions and checking my answers. It was the best Christmas and New Years gift I could have given myself!

User: Timofei***** I have to admit that selecting Killexams.com was one of the best decisions I made while preparing for the cof-r02 exam. Their practice questions and simulations are so well designed that individuals can raise their bar by the time they reach the last simulation exam. I appreciate their efforts and sincerely thank them for helping me pass the exam. Keep up the good work, Killexams.com!

---