Download SnowPro Core Recertification.COF-R02.VCEplus.2024-10-21.142q.vcex

Vendor: Snowflake
Exam Code: COF-R02
Exam Name: SnowPro Core Recertification
Date: Oct 21, 2024
File Size: 610 KB
Download Exam

How to open VCEX files?

Files with VCEX extension can be opened by ProfExam Simulator.

Download
ProfExam Simulator

Purchase
Coupon: EXAMFILESCOM

Discount: 20%

ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator ProfExam Simulator

Demo Questions

Question 1
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
Correct answer: A
Question 2
What happens when a cloned table is replicated to a secondary database? (Select TWO)
  1. A read-only copy of the cloned tables is stored.
  2. The replication will not be successful.
  3. The physical data is replicated
  4. Additional costs for storage are charged to a secondary account
  5. Metadata pointers to cloned tables are replicated
Correct answer: CD
Explanation:
Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account.https://docs.snowflake.com/en/user-guide/database-replicationconsiderations.html#:~:text=Replication%20and%20Cloning,-Cloned%20objects%20are&text=However%2C%20when%20a%20cloned%20table,storage%20usage%20for%20your%20account.
Cloned objects are replicated physically rather than logically to secondary databases. That is, cloned tables in a standard database do not contribute to the overall data storage unless or until DML operations on the clone add to or modify existing data. However, when a cloned table is replicated to a secondary database, the physical data is also replicated, increasing the data storage usage for your account.
https://docs.snowflake.com/en/user-guide/database-replicationconsiderations.html#:~:text=Replication%20and%20Cloning,-
Cloned%20objects%20are&text=However%2C%20when%20a%20cloned%20table,storage%20usage%20for%20your%20account.
Question 3
Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?
  1. PUT
  2. GET
  3. COPY
  4. SELECT
Correct answer: B
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/get.html
Reference: https://docs.snowflake.com/en/sql-reference/sql/get.html
Question 4
How does Snowflake Fail-safe protect data in a permanent table?
  1. Fail-safe makes data available up to 1 day, recoverable by user operations.
  2. Fail-safe makes data available for 7 days, recoverable by user operations.
  3. Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
  4. Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.
Correct answer: C
Question 5
A virtual warehouse is created using the following command:
Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.
What action should be taken to address this situation?
  1. Increase the warehouse size from Medium to 2XL.
  2. Increase the value for the parameter MAX_CONCURRENCY_LEVEL.
  3. Configure the warehouse to a multi-cluster warehouse.
  4. Lower the value of the parameter STATEMENT_QUEUED_TIMEOUT_IN_SECONDS.
Correct answer: B
Question 6
Which minimum Snowflake edition allows for a dedicated metadata store?
  1. Standard
  2. Enterprise
  3. Business Critical
  4. Virtual Private Snowflake
Correct answer: D
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html
Question 7
Network policies can be set at which Snowflake levels? (Choose two.)
  1. Role
  2. Schema
  3. User
  4. Database
  5. Account
  6. Tables
Correct answer: CE
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/network-policies.html#creating-networkpolicies
Reference: https://docs.snowflake.com/en/user-guide/network-policies.html#creating-networkpolicies
Question 8
What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?
  1. Default Time Travel Retention is set to 0 days.
    Maximum Time Travel Retention is 30 days.
    Fail Safe retention time is 1 day.
  2. Default Time Travel Retention is set to 1 day.
    Maximum Time Travel Retention is 365 days.
    Fail Safe retention time is 7 days.
  3. Default Time Travel Retention is set to 0 days.
    Maximum Time Travel Retention is 90 days.
    Fail Safe retention time is 7 days.
  4. Default Time Travel Retention is set to 1 day.
    Maximum Time Travel Retention is 90 days.
    Fail Safe retention time is 7 days.
  5. Default Time Travel Retention is set to 7 days.
    Maximum Time Travel Retention is 1 day.
    Fail Safe retention time is 90 days.
  6. Default Time Travel Retention is set to 90 days.
    Maximum Time Travel Retention is 7 days.
    Fail Safe retention time is 356 days.
Correct answer: D
Question 9
Which data types does Snowflake support when querying semi-structured data? (Select TWO)
  1. VARIANT
  2. ARRAY
  3. VARCHAR
  4. XML
  5. BLOB
Correct answer: AB
Explanation:
https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-dataA VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY.The maximum length of a VARIANT is 16 MB.A Snowflake ARRAY is similar to an array in many other programming languages. An ARRAY contains 0 or more pieces of data. Each element is accessed by specifying its position in the array.
https://docs.snowflake.com/en/user-guide/semistructured-intro.html#label-loading-semi-structured-data
A VARIANT stores semi-structured data in Snowflake. It can store a value of any other type, including OBJECT and ARRAY.
The maximum length of a VARIANT is 16 MB.
A Snowflake ARRAY is similar to an array in many other programming languages. An ARRAY contains 0 or more pieces of data. Each element is accessed by specifying its position in the array.
Question 10
Which of the following describes how multiple Snowflake accounts in a single organization relate to various cloud providers?
  1. Each Snowflake account can be hosted in a different cloud vendor and region.
  2. Each Snowflake account must be hosted in a different cloud vendor and region
  3. All Snowflake accounts must be hosted in the same cloud vendor and region
  4. Each Snowflake account can be hosted in a different cloud vendor, but must be in the same region.
Correct answer: B
Explanation:
https://docs.snowflake.com/en/user-guide/intro-regions.html
https://docs.snowflake.com/en/user-guide/intro-regions.html
CONNECT US
HOW TO OPEN VCE FILES

Use VCE Exam Simulator to open VCE files
Avanaset

HOW TO OPEN VCEX AND EXAM FILES

Use ProfExam Simulator to open VCEX and EXAM files
ProfExam Screen

ProfExam
ProfExam at a 20% markdown

You have the opportunity to purchase ProfExam at a 20% reduced price

Get Now!