This page was exported from Exams Labs Braindumps [ http://blog.examslabs.com ] Export date:Thu Nov 21 13:31:47 2024 / +0000 GMT ___________________________________________________ Title: [Dec 30, 2022] Reliable COF-R02 Exam Tips Test Pdf Exam Material [Q151-Q175] --------------------------------------------------- [Dec 30, 2022] Reliable COF-R02 Exam Tips Test Pdf Exam Material New 2022 COF-R02 Test Tutorial (Updated 332 Questions) NEW QUESTION 151The Snowflake Cloud Data Platform is described as having which of the following architectures?  Shared-disk  Shared-nothing  Multi-cluster shared data  Serverless query engine NEW QUESTION 152What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?  VIEWS_HISTORY  OBJECT_HISTORY  ACCESS_HISTORY  LOGIN_HISTORY NEW QUESTION 153What is the maximum total Continuous Data Protection (CDP) charges incurred for a temporary table?  30 days  7 days  48 hours  24 hours NEW QUESTION 154What affects whether the query results cache can be used?  If the query contains a deterministic function  If the virtual warehouse has been suspended  If the referenced data in the table has changed  If multiple users are using the same virtual warehouse NEW QUESTION 155Which of the following statements are true about Schemas in Snowflake? (Choose two.)  A Schema may contain one or more Databases  A Database may contain one or more Schemas  A Schema is a logical grouping of Database Objects  Each Schema is contained within a Warehouse Reference: https://docs.snowflake.com/en/user-guide/data-sharing-mutiple-db.htmlNEW QUESTION 156Which of the following connectors allow Multi-Factor Authentication (MFA) authorization when connecting?(Choose all that apply.)  JDBC  SnowSQL  Snowflake Web Interface (UI)  ODBC  PythonD18912E1457D5D1DDCBD40AB3BF70D5D Reference: https://docs.snowflake.com/en/user-guide/security-mfa.htmlNEW QUESTION 157In which use cases does Snowflake apply egress charges?  Data sharing within a specific region  Query result retrieval  Database replication  Loading data into Snowflake ExplanationCloud 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%20dNEW QUESTION 158Which of the following objects is not covered by Time Travel?  Tables  Schemas  Databases  Stages Reference: https://docs.snowflake.com/en/user-guide/data-time-travel.htmlNEW QUESTION 159What features does Snowflake Time Travel enable?  Querying data-related objects that were created within the past 365 days  Restoring data-related objects that have been deleted within the past 90 days  Conducting point-in-time analysis for Bl reporting  Analyzing data usage/manipulation over all periods of time ExplanationSnowflake Time Travel enables accessing historical data (i.e. data that has been changed or deleted) at any point within a defined period. It serves as a powerful tool for performing the following tasks:* Restoring data-related objects (tables, schemas, and databases) that might have been accidentally or intentionally deleted.* Duplicating and backing up data from key points in the past.* Analyzing data usage/manipulation over specified periods of time.https://docs.snowflake.com/en/user-guide/data-time-travel.htmlNEW QUESTION 160A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes.The warehouse is currently suspended and the user performs the following actions:1. Runs a query that takes 3 minutes to complete2. Leaves for 15 minutes3. Returns and runs a query that takes 10 seconds to complete4. Manually suspends the warehouse as soon as the last query was completed When the user returns, how much billable compute time will have been consumed?  4 minutes  10 minutes  14 minutes  24 minutes NEW QUESTION 161What is the default file size when unloading data from Snowflake using the COPY command?  5 MB  8 GB  16 MB  32 MB NEW QUESTION 162Which snowflake objects will incur both storage and cloud compute charges? (Select TWO)  Materialized view  Sequence  Secure view  Transient table  Clustered table NEW QUESTION 163How often are the Account and Table master keys automatically rotated by Snowflake?  30 Days  60 Days  90 Days  365 Days. NEW QUESTION 164The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)  Users  Tables  Databases  Internal Stages NEW QUESTION 165True or False: It is possible to load data into Snowflake without creating a named File Format object.  True  False Reference: https://docs.snowflake.com/en/user-guide/data-load-external-tutorial-create-file-format.htmlNEW QUESTION 166When scaling out by adding clusters to a multi-cluster warehouse, you are primarily scaling for improved:  Concurrency  Performance Reference: https://docs.snowflake.com/en/user-guide/warehouses-multicluster.htmlNEW QUESTION 167What are common issues found by using the Query Profile? (Choose two.)  Identifying queries that will likely run very slowly before executing them  Locating queries that consume a high amount of credits  Identifying logical issues with the queries  Identifying inefficient micro-partition pruning  Data spilling to a local or remote disk NEW QUESTION 168Which of the following describes a Snowflake stored procedure?  They can be created as secure and hide the underlying metadata from the user.  They can only access tables from a single database.  They can contain only a single SQL statement.  They can be created to run with a caller’s rights or an owner’s rights. Reference: https://docs.snowflake.com/en/sql-reference/stored-procedures-overview.htmlNEW QUESTION 169Why would a customer size a Virtual Warehouse from an X-Small to a Medium?  To accommodate more queries  To accommodate more users  To accommodate fluctuations in workload  To accommodate a more complex workload Reference: https://docs.snowflake.com/en/user-guide/warehouses-considerations.htmlNEW QUESTION 170What effect does WAIT_FOR_COMPLETION = TRUE have when running an ALTER WAREHOUSE command and changing the warehouse size?  The warehouse size does not change until all queries currently running in the warehouse have completed.  The warehouse size does not change until all queries currently in the warehouse queue have completed.  The warehouse size does not change until the warehouse is suspended and restarted.  It does not return from the command until the warehouse has finished changing its size. NEW QUESTION 171True or False: Snowflake’s data warehouse was built from the ground up for the cloud in lieu of using an existing database or a platform, like Hadoop, as a base.  True  False Reference: https://docs.snowflake.com/en/user-guide/intro-key-concepts.htmlNEW QUESTION 172When cloning a database containing stored procedures and regular views, that have fully qualified table references, which of the following will occur?  The cloned views and the stored procedures will reference the cloned tables in the cloned database.  An error will occur, as views with qualified references cannot be cloned.  An error will occur, as stored objects cannot be cloned.  The stored procedures and views will refer to tables in the source database. NEW QUESTION 173What versions of Snowflake should be used to manage compliance with Personal Identifiable Information (PII) requirements? (Choose two.)  Custom Edition  Virtual Private Snowflake  Business Critical Edition  Standard Edition  Enterprise Edition NEW QUESTION 174Which Snowflake feature will allow small volumes of data to continuously load into Snowflake and will incrementally make the data available for analysis?  COPY INTO  CREATE PIPE  INSERT INTO  TABLE STREAM NEW QUESTION 175What is the MINIMUM edition of Snowflake that is required to use a SCIM security integration?  Business Critical Edition  Standard Edition  Virtual Private Snowflake (VPS)  Enterprise Edition  Loading … COF-R02 Cert Guide PDF 100% Cover Real Exam Questions: 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: 2022-12-30 12:26:29 Post date GMT: 2022-12-30 12:26:29 Post modified date: 2022-12-30 12:26:29 Post modified date GMT: 2022-12-30 12:26:29