Jun-2023 Pass Snowflake COF-R02 Exam in First Attempt Easily
Free COF-R02 Exam Files Downloaded Instantly 100% Dumps & Practice Exam
The SnowPro Core Recertification Exam is a comprehensive assessment of an individual’s skills and expertise in Snowflake. The exam covers a range of topics, including data loading and unloading, Snowflake architecture, performance tuning, and security. The exam is designed to be challenging and rigorous, ensuring that only the most qualified professionals achieve recertification.
The Snowflake COF-R02 certification exam is a recertification exam, which means that it is designed for individuals who have already achieved the SnowPro Core certification. This exam is intended to ensure that certified professionals maintain their skills and knowledge over time, and remain current with the latest Snowflake technologies and best practices. Passing the exam is a requirement for maintaining SnowPro Core certification.
NEW QUESTION # 143
What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?
- A. It does not return from the command until the warehouse has finished changing its size.
- B. The warehouse size does not change until all queries currently running in the warehouse have completed.
- C. The warehouse size does not change until all queries currently in the warehouse queue have completed.
- D. The warehouse size does not change until the warehouse is suspended and restarted.
Answer: A
NEW QUESTION # 144
A developer is granted ownership of a table that has a masking policy. The developer's role is not able to see the masked data. Will the developer be able to modify the table to read the masked data?
- A. No, because ownership of a table does not include the ability to change masking policies
- B. Yes, because a table owner has full control and can unset masking policies.
- C. No, because masking policies must always reference specific access roles.
- D. Yes, because masking policies only apply to cloned tables.
Answer: B
NEW QUESTION # 145
What is the maximum Time Travel retention period for a temporary Snowflake table?
- A. 7 days
- B. 1 day
- C. 45 days
- D. 90 days
Answer: B
NEW QUESTION # 146
True or False: A Virtual Warehouse can be resized while suspended.
- A. False
- B. True
Answer: B
Explanation:
Reference:
https://docs.snowflake.com/en/user-guide/warehouses-tasks.html#effects-of-resizing-a-suspended-warehouse
NEW QUESTION # 147
Network policies can be applied to which of the following Snowflake objects? (Choose two.)
- A. Databases
- B. Accounts
- C. Warehouses
- D. Users
- E. Roles
Answer: D,E
NEW QUESTION # 148
Which copy INTO command outputs the data into one file?
- A. FILE_NUMBER=1
- B. MULTIPLE=FAISE
- C. MAX_FILE_NUMBER=1
- D. SINGLE=TRUE
Answer: D
NEW QUESTION # 149
What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?
- A. VIEWS_HISTORY
- B. ACCESS_HISTORY
- C. OBJECT_HISTORY
- D. LOGIN_HISTORY
Answer: B
NEW QUESTION # 150
Which command sets the Virtual Warehouse for a session?
- A. COPY WAREHOUSE FROM <<config file>>;
- B. SET WAREHOUSE = <<warehouse name>>;
- C. USE WAREHOUSE <<warehouse name>>;
- D. USE VIRTUAL_WAREHOUSE <<warehouse name>>;
Answer: C
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-tasks.html
NEW QUESTION # 151
Which data type can store more than one type of data structure?
- A. BINARY
- B. VARCHAR
- C. VARIANT
- D. JSON
Answer: C
NEW QUESTION # 152
How often are the Account and Table master keys automatically rotated by Snowflake?
- A. 90 Days
- B. 30 Days
- C. 60 Days
- D. 365 Days.
Answer: D
NEW QUESTION # 153
The fail-safe retention period is how many days?
- A. 45 days
- B. 90 days
- C. 7 days
- D. 1 day
Answer: C
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-failsafe.html
NEW QUESTION # 154
What is the recommended file sizing for data loading using Snowpipe?
- A. A compressed file size greater than 10 MB, and up to 100 MB
- B. A compressed file size greater than 1 GB, and up to 2 GB
- C. A compressed file size greater than 100 MB, and up to 250 MB
- D. A compressed file size greater than 100 GB, and up to 250 GB
Answer: C
Explanation:
Explanation
https://www.phdata.io/blog/how-to-optimize-snowpipe-data-load/#:~:text=Snowpipe%20is%20typically%20use
NEW QUESTION # 155
The PUT command: (Choose two.)
- A. Automatically compresses files using Gzip
- B. Automatically creates a File Format object
- C. Automatically encrypts files
- D. Automatically uses the last Stage created
Answer: A,C
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/put.html
NEW QUESTION # 156
Which of the following commands cannot be used within a reader account?
- A. DROP ROLE
- B. ALTER WAREHOUSE
- C. SHOW SCHEMAS
- D. DESCRBE TABLE
- E. CREATE SHARE
Answer: B
Explanation:
Explanation
A reader account is intended primarily for querying data shared by the provider of the account. Adding new data to the account and/or updating shared data in the account is not supported. Changing the configuration of virtual warehouses is also not permitted as those resources are owned and managed by the provider of the account which is sharing the data.
NEW QUESTION # 157
Which privilege must be granted to a share to allow secure views the ability to reference data in multiple databases?
- A. CREATE_SHARE on the account
- B. SHARE on databases and schemas
- C. SELECT on tables used by the secure view
- D. REFERENCE_USAGE on databases
Answer: C
NEW QUESTION # 158
What is the purpose of an External Function?
- A. To run a function in another Snowflake database
- B. To call code that executes outside of Snowflake
- C. To share data in Snowflake with external parties
- D. To ingest data from on-premises data sources
Answer: B
Explanation:
Explanation
https://docs.snowflake.com/en/sql-reference/external-functions.html
NEW QUESTION # 159
True or False: Snowpipe via REST API can only reference External Stages as source.
- A. True
- B. False
Answer: B
Explanation:
Reference: https://community.snowflake.com/s/article/Making-Transient-table-by-Default
NEW QUESTION # 160
When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:
- A. Performance
- B. Concurrency
Answer: B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.html
NEW QUESTION # 161
Which formats does Snowflake store unstructured data in? (Choose two.)
- A. XML
- B. BLOB
- C. Object
- D. GeoJSON
- E. Array
Answer: B,C
NEW QUESTION # 162
Which of the following can be used when unloading data from Snowflake? (Choose two.)
- A. By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.
- B. The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.
- C. Use the ENCODING file format option to change the encoding from the default UTF-8.
- D. When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.
- E. Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.
Answer: A,D
NEW QUESTION # 163
Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)
- A. Tri-Secret Secure
- B. Data encryption
- C. Fail-safe
- D. External stages
- E. Time Travel
Answer: C,E
NEW QUESTION # 164
Which of the following statements are true of VALIDATION_MODE in Snowflake? (Choose two.)
- A. validation_mode=return_all_errors is a parameter of the copy command
- B. The validation_mode option will validate data to be loaded by the copy statement while completing the load and will return the rows that could not be loaded without error
- C. The validation_mode option is used when creating an Internal Stage
- D. The validation_mode option will validate data to be loaded by the copy statement without completing the load and will return possible errors
Answer: A,D
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-load-bulk-ts.html
NEW QUESTION # 165
What actions will prevent leveraging of the ResultSet cache? (Choose two.)
- A. Removing a column from the query SELECT list
- B. Executing the RESULTS_SCAN() table function
- C. Clustering of the data used by the query
- D. Changing a column that is not in the cached query
- E. Stopping the virtual warehouse that the query is running against
Answer: A,B
NEW QUESTION # 166
If 3 size Small virtual warehouse is made up of two servers, how many servers make up a Large warehouse?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
Explanation:
Explanation
Size specifies the amount of compute resources available per cluster in a warehouse. Snowflake supports the following warehouse sizes:
https://docs.snowflake.com/en/user-guide/warehouses-overview.html
NEW QUESTION # 167
......
Free Exam Updates COF-R02 dumps with test Engine Practice: https://www.actualtorrent.com/COF-R02-questions-answers.html