New COF-R02 Dumps For Preparing SnowPro Core Certified Snowflake Exam Well [Q165-Q185]

Share

New COF-R02 Dumps For Preparing SnowPro Core Certified Snowflake Exam Well

Updated COF-R02 Dumps Questions Are Available [2023] For Passing Snowflake Exam


Snowflake COF-R02 Exam is a timed exam, with a duration of 90 minutes. COF-R02 exam consists of 60 multiple-choice questions that are designed to test the knowledge, skills, and experience of Snowflake users. COF-R02 exam is designed to be challenging, so it is important for participants to prepare thoroughly before taking the exam.

 

NEW QUESTION # 165
A user is loading JSON documents composed of a huge array containing multiple records into Snowflake. The user enables the strip__outer_array file format option What does the STRIP_OUTER_ARRAY file format do?

  • A. It removes the outer array structure and loads the records into separate table rows,
  • B. It removes the last element of the outer array.
  • C. It removes the NULL elements from the JSON object eliminating invalid data and enables the ability to load the records
  • D. It removes the trailing spaces in the last element of the outer array and loads the records into separate table columns

Answer: A

Explanation:
Explanation
Data Size Limitations
The VARIANT data type imposes a 16 MB size limit on individual rows.
For some semi-structured data formats (e.g. JSON), data sets are frequently a simple concatenation of multiple documents. The JSON output from some software is composed of a single huge array containing multiple records. There is no need to separate the documents with line breaks or commas, though both are supported.
If the data exceeds 16 MB, enable the STRIP_OUTER_ARRAY file format option for the COPY INTO
<table> command to remove the outer array structure and load the records into separate table rows:
copy into <table>
from @~/<file>.json
file_format = (type = 'JSON' strip_outer_array = true);
https://docs.snowflake.com/en/user-guide/semistructured-considerations.html


NEW QUESTION # 166
Which Snowflake architectural layer is responsible for a query execution plan?

  • A. Data storage
  • B. Compute
  • C. Cloud services
  • D. Cloud provider

Answer: D


NEW QUESTION # 167
Which database objects can be shared with the Snowflake secure data sharing feature? (Choose two.)

  • A. Files
  • B. Sequences
  • C. External tables
  • D. Streams
  • E. Secure User-Defined Functions (UDFs)

Answer: C,E


NEW QUESTION # 168
What are the three layers that make up Snowflake's architecture?
Choose 3 answer

  • A. Compute
  • B. Tri-Secret Secure
  • C. Storage
  • D. Cloud Services

Answer: A,C,D

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.html


NEW QUESTION # 169
Which feature is only available in the Enterprise or higher editions of Snowflake?

  • A. Object-level access control
  • B. Column-level security
  • C. Multi-factor Authentication (MFA)
  • D. SOC 2 type II certification

Answer: B

Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/intro-editions.html


NEW QUESTION # 170
Will data cached in a warehouse be lost when the warehouse is resized?

  • A. No. because the size of the cache is independent from the warehouse size
  • B. Possibly, if the warehouse is resized to a smaller size and the cache no longer fits.
  • C. Yes. became the new compute resource will no longer have access to the cache encryption key
  • D. Yes. because the compute resource is replaced in its entirety with a new compute resource.

Answer: B


NEW QUESTION # 171
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)

  • A. Via SQL commands
  • B. Via the data_share=true parameter
  • C. Via Virtual Warehouses
  • D. Via the Snowflake Web Interface (Ul)

Answer: A,D

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html


NEW QUESTION # 172
A user unloaded a Snowflake table called mytable to an internal stage called mystage.
Which command can be used to view the list of files that has been uploaded to the staged?

  • A. list @mytable;
  • B. list @mystage;
  • C. list @%raytable;
  • D. list @ %m.ystage;

Answer: B


NEW QUESTION # 173
True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.

  • A. True
  • B. False

Answer: B


NEW QUESTION # 174
What is the minimum Snowflake edition needed for database failover and fail-back between Snowflake accounts for business continuity and disaster recovery?

  • A. Business Critical
  • B. Virtual Private Snowflake
  • C. Enterprise
  • D. Standard

Answer: C


NEW QUESTION # 175
True or False: Micro-partition metadata enables some operations to be completed without requiring Compute.

  • A. False
  • B. True

Answer: B

Explanation:
Reference: https://blog.ippon.tech/innovative-snowflake-features-caching/


NEW QUESTION # 176
What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

  • A. Default Time Travel Retention is set to 1 day.
    Maximum Time Travel Retention is 365 days.
    Fail Safe retention time is 7 days.
  • B. Default Time Travel Retention is set to 1 day.
    Maximum Time Travel Retention is 90 days.
    Fail Safe retention time is 7 days.
  • C. Default Time Travel Retention is set to 7 days.
    Maximum Time Travel Retention is 1 day.
    Fail Safe retention time is 90 days.
  • D. Default Time Travel Retention is set to 0 days.
    Maximum Time Travel Retention is 90 days.
    Fail Safe retention time is 7 days.
  • E. Default Time Travel Retention is set to 90 days.
    Maximum Time Travel Retention is 7 days.
    Fail Safe retention time is 356 days.
  • F. Default Time Travel Retention is set to 0 days.
    Maximum Time Travel Retention is 30 days.
    Fail Safe retention time is 1 day.

Answer: B


NEW QUESTION # 177
A role is created and owns 2 tables. This role is then dropped. Who will now own the two tables?

  • A. SYSADMIN
  • B. The assumed role that dropped the role
  • C. The tables are now orphaned
  • D. The user that deleted the role

Answer: B

Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/drop-role.html


NEW QUESTION # 178
What tasks can be completed using the copy command? (Select TWO)

  • A. Columns can be reordered
  • B. Columns can be omitted
  • C. Columns can be aggregated
  • D. Data can be loaded without the need to spin up a virtual warehouse
  • E. Columns can be joined with an existing table

Answer: A,B


NEW QUESTION # 179
What is the minimum Snowflake edition required for row level security?

  • A. Business Critical
  • B. Virtual Private Snowflake
  • C. Enterprise
  • D. Standard

Answer: C


NEW QUESTION # 180
What is a responsibility of Snowflake's virtual warehouses?

  • A. Permanent storage of micro-partitions
  • B. Query parsing and optimization
  • C. Infrastructure management
  • D. Query execution
  • E. Metadata management

Answer: D

Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/warehouses.html#:~:text=A%20warehouse%20provides%20the%20re


NEW QUESTION # 181
What happens to the shared objects for users in a consumer account from a share, once a database has been created in that account?

  • A. The shared objects are copied.
  • B. The shared objects can be re-shared.
  • C. The shared objects are transferred.
  • D. The shared objects become accessible.

Answer: A


NEW QUESTION # 182
Why does Snowflake recommend file sizes of 100-250 MB compressed when loading data?

  • A. Allows a user to import the files in a sequential order
  • B. Increases the latency staging and accuracy when loading the data
  • C. Allows optimization of parallel operations
  • D. Optimizes the virtual warehouse size and multi-cluster setting to economy mode

Answer: C


NEW QUESTION # 183
Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

  • A. Percentage scanned from cache
  • B. Partitions scanned
  • C. Partitions total
  • D. Bytes spilled to local storage
  • E. Bytes sent over network

Answer: A,B


NEW QUESTION # 184
Why would a customer size a Virtual Warehouse from an X-Small to a Medium?

  • A. To accommodate more queries
  • B. To accommodate more users
  • C. To accommodate fluctuations in workload
  • D. To accommodate a more complex workload

Answer: D

Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-considerations.html


NEW QUESTION # 185
......

Snowflake Exam 2023 COF-R02 Dumps Updated Questions: https://www.prep4pass.com/COF-R02_exam-braindumps.html

Free UPDATED Snowflake COF-R02 Certification Exam Dumps is Online: https://drive.google.com/open?id=1ZVZgSaVx9DbbgLPtWRCEIdJ0ixlECBZk