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"






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