Download Free Snowflake COF-C02 Exam Questions & Answer
Online VALID COF-C02 Exam Dumps File Instantly
Snowflake COF-C02 (SnowPro Core Certification) Exam is a comprehensive certification exam designed to test an individual's knowledge and skills in the core concepts of Snowflake. SnowPro Core Certification Exam certification is intended for data professionals interested in demonstrating their expertise in using Snowflake to manage and analyze data. Achieving this certification is recognized and valued by organizations worldwide and can help individuals advance their careers in the data industry. Interested individuals can register and schedule their exams through the Snowflake certification portal.
NEW QUESTION # 79
If queries start to queue in a multi-cluster virtual warehouse, an additional compute cluster starts immediately under what setting?
- A. Standard scaling policy
- B. Maximized mode
- C. Auto-scale mode
- D. Economy scaling policy
Answer: A
NEW QUESTION # 80
Which DDL/DML operation is allowed on an inbound data share?
- A. SELECT
- B. ALTER TA3LE
- C. INSERT INTO
- D. MERGE
Answer: A
NEW QUESTION # 81
What are the default Time Travel and Fail-safe retention periods for transient tables?
- A. Time Travel - 1 day. Fail-safe - 0 days
- B. Transient tables are retained in neither Fail-safe nor Time Travel
- C. Time Travel - 1 day. Fail-safe - 1 day
- D. Time Travel - 0 days. Fail-safe - 1 day
Answer: A
Explanation:
https://docs.snowflake.com/en/user-guide/data-cdp-storage-costs.html#:~:text=Temporary%20and%20Transient%20Tables,-To%20help%20manage&text=Temporary%20tables%20can%20also%20have,have%20no%20Fail%2Dsafe%20period.
NEW QUESTION # 82
What features does Snowflake Time Travel enable?
- A. Querying data-related objects that were created within the past 365 days
- B. Conducting point-in-time analysis for Bl reporting
- C. Restoring data-related objects that have been deleted within the past 90 days
- D. Analyzing data usage/manipulation over all periods of time
Answer: C
Explanation:
Snowflake 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.html
NEW QUESTION # 83
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 # 84
Which command is used to unload files from an internal or external stage to a local file system?
- A. PUT
- B. COPY INTO
- C. TRANSFER
- D. GET
Answer: B
NEW QUESTION # 85
Which operations are handled in the Cloud Services layer of Snowflake? (Select TWO).
- A. Metadata management
- B. Query computation
- C. Security
- D. Data storage
- E. Data visualization
Answer: A,C
NEW QUESTION # 86
What are best practice recommendations for using the ACCOUNTADMIN system-defined role in Snowflake? (Choose two.)
- A. The ACCOUNTADMIN role must be granted to only one user.
- B. Assign the ACCOUNTADMIN role to at least two users, but as few as possible.
- C. All users granted ACCOUNTADMIN role must also be granted SECURITYADMIN role.
- D. Ensure all ACCOUNTADMIN roles use Multi-factor Authentication (MFA).
- E. All users granted ACCOUNTADMIN role must be owned by the ACCOUNTADMIN role.
Answer: B,D
NEW QUESTION # 87
What privilege should a user be granted to change permissions for new objects in a managed access schema?
- A. Grant the OWNERSHIP privilege on the database.
- B. Grant ALL privileges on the schema.
- C. Grant the MANAGE GRANTS global privilege.
- D. Grant the OWNERSHIP privilege on the schema.
Answer: C
NEW QUESTION # 88
Which of the following describes external functions in Snowflake?
- A. They call code that is stored inside of Snowflake.
- B. They can return multiple rows for each row received
- C. They are a type of User-defined Function (UDF).
- D. They contain their own SQL code.
Answer: C
NEW QUESTION # 89
Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)
- A. Roles
- B. Secure User-Defined Functions (UDFs)
- C. Tables
- D. Schemas
- E. Secure Views
- F. Stored Procedures
Answer: B,C,E
NEW QUESTION # 90
Which Snowflake technique can be used to improve the performance of a query?
- A. Clustering
- B. Fragmenting
- C. Indexing
- D. Using INDEX_HINTS
Answer: A
NEW QUESTION # 91
True 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.
- A. True
- B. False
Answer: B
NEW QUESTION # 92
True or False: You can query the files in an External Stage directly without having to load the data into a table.
- A. False
- B. True
Answer: B
NEW QUESTION # 93
A Virtual Warehouse's auto-suspend and auto-resume settings apply to:
- A. The entire Virtual Warehouse
- B. The queries currently being run by the Virtual Warehouse
- C. The primary duster in the virtual warehouse
- D. The database the Virtual Warehouse resides in
Answer: A
NEW QUESTION # 94
Account-level storage usage can be monitored via:
- A. The Account usage Schema - > ACCOUNT_USAGE_METRICS View
- B. The Information Schema -> ACCOUNT_USAGE_HISTORY View
- C. The Snowflake web interface (UI) in the Account -> Billing a usage section
- D. The snowflake wet Interface (UI) in the Databases section.
Answer: C
NEW QUESTION # 95
If a virtual warehouse runs for 61 seconds, shut down, and then restart and runs for 30 seconds, for how many seconds is it billed?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: B
NEW QUESTION # 96
Which statement accurately describes how a virtual warehouse functions?
- A. All virtual warehouses share the same compute resources so performance degradation of one warehouse can significantly affect all the other warehouses.
- B. Each virtual warehouse is an independent compute cluster that shares compute resources with other warehouses.
- C. Increasing the size of a virtual warehouse will always improve data loading performance.
- D. Each virtual warehouse is a compute cluster composed of multiple compute nodes allocated by Snowflake from a cloud provider.
Answer: D
NEW QUESTION # 97
Which of the following statements describes a schema in Snowflake?
- A. A logical grouping of objects that belongs to a single database
- B. A logical grouping of objects that belongs to multiple databases
- C. A named Snowflake object that includes all the information required to share a database
- D. A uniquely identified Snowflake account within a business entity
Answer: A
NEW QUESTION # 98
Which of the following are best practice recommendations that should be considered when loading data into Snowflake? (Select TWO).
- A. Load files that are approximately 100-250 MB (or larger)
- B. Load files that are approximately 25 MB or smaller.
- C. Avoid using embedded characters such as commas for numeric data types
- D. Remove semi-structured data types
- E. Remove all dates and timestamps.
Answer: A,C
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/data-load-considerations-prepare.html
NEW QUESTION # 99
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 # 100
Which of the following is a data tokenization integration partner?
- A. Protegrity
- B. Tableau
- C. DBeaver
- D. SAP
Answer: A
NEW QUESTION # 101
What are two ways to create and manage Data Shares in Snowflake? (Choose two.)
- A. Via the Snowflake Web Interface (Ul)
- B. Via SQL commands
- C. Via Virtual Warehouses
- D. Via the data_share=true parameter
Answer: A,B
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/data-sharing-provider.html
NEW QUESTION # 102
......
The SnowPro Core Certification Exam is a rigorous assessment of a candidate's Snowflake skills and knowledge. It is a multiple-choice, timed exam that covers a range of topics such as Snowflake architecture, data loading and unloading, performance optimization, security and access control, and user management. COF-C02 exam is designed to measure a candidate's ability to configure, manage, and troubleshoot Snowflake environments, as well as their understanding of Snowflake's data storage and processing capabilities. Upon successful completion of the exam, candidates will be awarded the SnowPro Core Certification, which is a widely recognized industry certification that demonstrates their expertise in Snowflake.
COF-C02 Exam Dumps For Certification Exam Preparation: https://www.prepawaypdf.com/Snowflake/COF-C02-practice-exam-dumps.html
100% Pass Guaranteed Download SnowPro Core Exam PDF Q&A: https://drive.google.com/open?id=1-iYcM-FWqJ9LwZ59EaWvFuL48-iF0cKx