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