This page was exported from Exams Labs Braindumps [ http://blog.examslabs.com ] Export date:Sat Nov 23 9:27:26 2024 / +0000 GMT ___________________________________________________ Title: [May 06, 2023] COF-R02 Exam Dumps 100% Same Q&A In Your Real Exam [Q10-Q33] --------------------------------------------------- [May 06, 2023] COF-R02 Exam Dumps 100% Same Q&A In Your Real Exam COF-R02 Test Engine Dumps Training With 332 Questions The Snowflake COF-R02 (SnowPro Core Recertification) Certification Exam is a web-based exam that consists of 60 multiple-choice questions that must be completed within 90 minutes. The exam is proctored, and candidates must have a webcam and a reliable internet connection to take the test. The exam covers various topics such as Snowflake architecture, database objects, data loading, and performance optimization techniques. The Snowflake COF-R02 Exam is a timed exam, with a duration of 90 minutes. The exam consists of 60 multiple-choice questions that are designed to test the knowledge, skills, and experience of Snowflake users. The exam is designed to be challenging, so it is important for participants to prepare thoroughly before taking the exam.   QUESTION 10What is a best practice after creating a custom role?  Create the custom role using the SYSADMIN role.  Assign the custom role to the SYSADMIN role  Assign the custom role to the PUBLIC role  Add__CUSTOM to all custom role names ExplanationWhen creating roles that will serve as the owners of securable objects in the system, Snowflake recommends creating a hierarchy of custom roles, with the top-most custom role assigned to the system role SYSADMIN.This role structure allows system administrators to manage all objects in the account, such as warehouses and database objects, while restricting management of users and roles to the USERADMIN role.QUESTION 11Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?  Pipes  Streams  Tasks  Procedures Explanationhttps://dataterrain.com/how-to-change-tracking-using-table-streams-in-snowflake/#:~:text=A%20stream%20is%QUESTION 12Which statement is true about running tasks in Snowflake?  A task can be called using a CALL statement to run a set of predefined SQL commands.  A task allows a user to execute a single SQL statement/command using a predefined schedule.  A task allows a user to execute a set of SQL commands on a predefined schedule.  A task can be executed using a SELECT statement to run a predefined SQL command. QUESTION 13What is a limitation of a Materialized View?  A Materialized View cannot support any aggregate functions  A Materialized View can only reference up to two tables  A Materialized View cannot be joined with other tables  A Materialized View cannot be defined with a JOIN ExplanationThere are several limitations to using materialized views:* A materialized view can query only a single table.* Joins, including self-joins, are not supported.QUESTION 14Which of the following can be used when unloading data from Snowflake? (Choose two.)  When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.  Use the ENCODING file format option to change the encoding from the default UTF-8.  The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.  By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.  Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type. QUESTION 15True or False: Pipes can be suspended and resumed.  True  False Explanationhttps://docs.snowflake.com/en/user-guide/data-load-snowpipe-intro.html#pausing-or-resuming-pipes Pausing or Resuming Pipes In addition to the pipe owner, a role that has the following minimum permissions can pause or resume the pipe:QUESTION 16Which SQL command can be used to see the CREATE definition of a masking policy?  SHOW MASKING POLICIES  DESCRIBE MASKING POLICY  GET_DDL  LIST MASKING POLICIES QUESTION 17What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?  Default Time Travel Retention is set to 0 days.Maximum Time Travel Retention is 30 days.Fail Safe retention time is 1 day.  Default Time Travel Retention is set to 1 day.Maximum Time Travel Retention is 365 days.Fail Safe retention time is 7 days.  Default Time Travel Retention is set to 0 days.Maximum Time Travel Retention is 90 days.Fail Safe retention time is 7 days.  Default Time Travel Retention is set to 1 day.Maximum Time Travel Retention is 90 days.Fail Safe retention time is 7 days.  Default Time Travel Retention is set to 7 days.Maximum Time Travel Retention is 1 day.Fail Safe retention time is 90 days.  Default Time Travel Retention is set to 90 days.Maximum Time Travel Retention is 7 days.Fail Safe retention time is 356 days. QUESTION 18Which of the following Snowflake objects can be shared using a secure share? (Select TWO).  Materialized views  Sequences  Procedures  Tables  Secure User Defined Functions (UDFs) ExplanationSecure Data Sharing enables sharing selected objects in a database in your account with other Snowflake accounts. The following Snowflake database objects can be shared:* Tables* External tables* Secure views* Secure materialized views* Secure UDFshttps://docs.snowflake.com/en/user-guide/data-sharing-intro.htmlQUESTION 19A user has a standard multi-cluster warehouse auto-scaling policy in place.Which condition will trigger a cluster to shut-down?  When after 2-3 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.  When after 5-6 consecutive checks the system determines that the load on the most-loaded cluster could be redistributed.  When after 5-6 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed.  When after 2-3 consecutive checks the system determines that the load on the least-loaded cluster could be redistributed. QUESTION 20A marketing co-worker has requested the ability to change a warehouse size on their medium virtual warehouse called mktg__WH.Which of the following statements will accommodate this request?  ALLOW RESIZE ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;  GRANT MODIFY ON WAREHOUSE MKTG WH TO ROLE MARKETING;  GRANT MODIFY ON WAREHOUSE MKTG__WH TO USER MKTG__LEAD;  GRANT OPERATE ON WAREHOUSE MKTG WH TO ROLE MARKETING; QUESTION 21Which Snowflake architectural layer is responsible for a query execution plan?  Compute  Data storage  Cloud services  Cloud provider QUESTION 22Which services does the Snowflake Cloud Services layer manage? (Select TWO).  Compute resources  Query execution  Authentication  Data storage  Metadata Explanationhttps://docs.snowflake.com/en/user-guide/intro-key-concepts.htmlThe cloud services layer is a collection of services that coordinate activities across Snowflake. These services tie together all of the different components of Snowflake in order to process user requests, from login to query dispatch. The cloud services layer also runs on compute instances provisioned by Snowflake from the cloud provider.Services managed in this layer include:* Authentication* Infrastructure management* Metadata management* Query parsing and optimization* Access controlQUESTION 23Which of the following statement is true of Snowflake?Select one.  It was built specifically for the cloud  it was built as an on-premises solution and then potted to the cloud  It was designed as a hybrid database to allow customers to store data either on premises or in the cloud  It was built for Hadoop architecture  It’s based on an Oracle Architecture QUESTION 24True or False: Reader Accounts incur no additional Compute costs to the Data Provider since they are simply reading the shared data without making changes.  True  False Reference: https://interworks.com/blog/bdu/2020/02/05/zero-to-snowflake-secure-data-sharing/QUESTION 25Which of the following conditions must be met in order to return results from the results cache? (Select TWO).  The user has the appropriate privileges on the objects associated with the query  Micro-partitions have been reclustered since the query was last run  The new query is run using the same virtual warehouse as the previous query  The query includes a User Defined Function (UDF)  The query has been run within 24 hours of the previously-run query QUESTION 26True or False: A table in Snowflake can only be queried using the Virtual Warehouse that was used to load the data.  True  False QUESTION 27Which is true of Snowflake network policies? A Snowflake network policy: (Choose two.)  Is available to all Snowflake Editions  Is only available to customers with Business Critical Edition  Restricts or enables access to specific IP addresses  Is activated using an “ALTER DATABASE” command Reference: https://docs.snowflake.com/en/sql-reference/sql/create-network-policy.htmlQUESTION 28Which of the following is a valid source for an external stage when the Snowflake account is located on Microsoft Azure?  An FTP server with TLS encryption  An HTTPS server with WebDAV  A Google Cloud storage bucket  A Windows server file share on Azure QUESTION 29Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)  Bytes sent over network  Percentage scanned from cache  Partitions total  Bytes spilled to local storage  Partitions scanned QUESTION 30True or False: Snowflake’s Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.  True  False ExplanationSnowflake is a single, integrated platform delivered as-a-service. It features storage, compute, and global services layers that are physically separated but logically integrated.QUESTION 31True or False: Query ID’s are unique across all Snowflake deployments and can be used in communication with Snowflake Support to help troubleshoot issues.  True  False QUESTION 32Query parsing and compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?  Cloud services layer  Compute layer  Storage layer  Cloud agnostic layer Reference: https://www.projectpro.io/article/snowflake-architecture-what-does-snowflake-do/556QUESTION 33Which of the following objects are contained within a schema? (Choose two.)  Role  Stream  Warehouse  External table  User  Share  Loading … The Snowflake COF-R02 (SnowPro Core Recertification) Certification Exam is a comprehensive exam that covers various topics related to Snowflake's cloud data platform. The exam is designed to test the candidate's understanding of Snowflake's architecture, data loading, data processing, and data querying. The exam also covers topics related to security, performance tuning, and troubleshooting.   COF-R02 Practice Test Pdf Exam Material: https://www.examslabs.com/Snowflake/SnowPro-Core/best-COF-R02-exam-dumps.html --------------------------------------------------- Images: https://blog.examslabs.com/wp-content/plugins/watu/loading.gif https://blog.examslabs.com/wp-content/plugins/watu/loading.gif --------------------------------------------------- --------------------------------------------------- Post date: 2023-05-06 13:37:38 Post date GMT: 2023-05-06 13:37:38 Post modified date: 2023-05-06 13:37:38 Post modified date GMT: 2023-05-06 13:37:38