[Feb-2023] Exam Sure Pass Snowflake Certification with COF-R02 exam questions
Real Snowflake COF-R02 Exam Questions Study Guide
NEW QUESTION 15
Query compilation occurs in which architecture layer of the Snowflake Cloud Data Platform?
- A. Cloud services layer
- B. Cloud infrastructure layer
- C. Compute layer
- D. Storage layer
Answer: C
Explanation:
Explanation
For query execution, Snowflake uses the Virtual Warehouse. The query processing layer is separated from the disk storage layer in the Snowflake data architecture. You can use the data from the storage layer to run queries in this layer
https://www.projectpro.io/article/snowflake-architecture-what-does-snowflake-do/556#:~:text=Query%20Proces
NEW QUESTION 16
How would you determine the size of the virtual warehouse used for a task?
- A. Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule
- B. If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
- C. Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size
- D. Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
Answer: B
NEW QUESTION 17
What happens to historical data when the retention period for an object ends?
- A. Time Travel on the historical data is dropped.
- B. The data is cloned into a historical object.
- C. The object containing the historical data is dropped.
- D. The data moves to Fail-safe
Answer: C
NEW QUESTION 18
What are supported file formats for unloading data from Snowflake? (Choose three.)
- A. AVRO
- B. ORC
- C. JSON
- D. CSV
- E. Parquet
- F. XML
Answer: C,D,E
NEW QUESTION 19
When publishing a Snowflake Data Marketplace listing into a remote region what should be taken into consideration? (Choose two.)
- A. The listing is replicated into all selected regions automatically, the data is not.
- B. The user must have the ORGADMIN role available in at least one account to link accounts for replication.
- C. Shares attached to listings in remote regions can be viewed from any account in an organization.
- D. There is no need to have a Snowflake account in the target region, a share will be created for each user.
- E. For a standard listing the user can wait until the first customer requests the data before replicating it to the target region.
Answer: B,D
NEW QUESTION 20
How often are encryption keys automatically rotated by Snowflake?
- A. 90 Days
- B. 365 Days
- C. 30 Days
- D. 60 Days
Answer: C
Explanation:
Explanation
All Snowflake-managed keys are automatically rotated by Snowflake when they are more than 30 days old.
Active keys are retired, and new keys are created. When Snowflake determines the retired key is no longer needed, the key is automatically destroyed.
https://docs.snowflake.com/en/user-guide/security-encryption-manage.html#:~:text=All%20Snowflake%2Dman
NEW QUESTION 21
Which of the following practices are recommended when creating a user in Snowflake? (Choose two.)
- A. Force an immediate password change.
- B. Set the user's access to expire within a specified timeframe.
- C. Set a default role for the user.
- D. Configure the user to be initially disabled.
- E. Set the number of minutes to unlock to 15 minutes.
Answer: B,D
NEW QUESTION 22
Which of the following are benefits of micro-partitioning? (Select TWO)
- A. Rows are automatically stored in sorted order within micro-partitions
- B. Micro-partitions are immutable objects that support the use of Time Travel.
- C. Micro-partitions cannot overlap in their range of values
- D. Micro-partitions can be defined on a schema-by-schema basis
- E. Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
Answer: A,C
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/tables-clustering-micropartitions.html
NEW QUESTION 23
Which command can be used to stage local files from which Snowflake interface?
- A. SnowSQL
- B. Snowflake classic web interface (Ul)
- C. Snowsight
- D. .NET driver
Answer: A
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/snowsql-use.html
NEW QUESTION 24
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:
- A. All of the above
- B. The Pipe load history is reset to empty
- C. Previously loaded files will be ignored
- D. The REFRESH parameter is set to TRUE
Answer: B
Explanation:
Explanation
https://docs.snowflake.com/en/user-guide/data-load-snowpipe-manage.html#load-history
"When a pipe is recreated, the load history is dropped."
NEW QUESTION 25
A company's security audit requires generating a report listing all Snowflake logins (e.g.. date and user) within the last 90 days. Which of the following statements will return the required information?
- A. SELECT EVENT_TIMESTAMP, USER_NAME
FROM table(information_schema.login_history_by_user()) - B. SELECT LAST_SUCCESS_LOGIN, LOGIN_NAME
FROM ACCOUNT_USAGE.USERS; - C. SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.ACCESS_HISTORY; - D. SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.LOGIN_HISTORY;
Answer: D
NEW QUESTION 26
Which Snowflake objects can be shared with other Snowflake accounts? (Choose three.)
- A. Secure User-Defined Functions (UDFs)
- B. Secure Views
- C. Schemas
- D. Tables
- E. Stored Procedures
- F. Roles
Answer: A,C,F
NEW QUESTION 27
What do the terms scale up and scale out refer to in Snowflake? (Choose two.)
- A. Scaling out adds clusters of varying sizes to a virtual warehouse.
- B. Snowflake recommends using both scaling up and scaling out to handle more concurrent queries.
- C. Scaling out adds additional database servers to an existing running cluster to handle more concurrent queries.
- D. Scaling up resizes a virtual warehouse so it can handle more complex workloads.
- E. Scaling up adds additional database servers to an existing running cluster to handle larger workloads.
- F. Scaling out adds clusters of the same size to a virtual warehouse to handle more concurrent queries.
Answer: D,F
NEW QUESTION 28
Which feature allows a user the ability to control the organization of data in a micro-partition?
- A. Search Optimization Service
- B. Automatic Clustering
- C. Range Partitioning
- D. Horizontal Partitioning
Answer: D
NEW QUESTION 29
What is true about sharing data in Snowflake? (Choose two.)
- A. The shared data is copied into the Data Consumer account, so the Consumer can modify it without impacting the base data of the Provider.
- B. The Data Consumer pays for data storage as well as for data computing.
- C. A Snowflake account can both provide and consume shared data.
- D. The Data Consumer pays only for compute resources to query the shared data.
- E. The Provider is charged for compute resources used by the Data Consumer to query the shared data.
Answer: A,C
NEW QUESTION 30
When unloading to a stage, which of the following is a recommended practice or approach?
- A. Avoid the use of the CAST function
- B. Define an individual file format
- C. Use OBJECT_CONSTRUCT ( * ) when using Parquet
- D. Set SINGLE: = true for larger files
Answer: A
NEW QUESTION 31
......
Updated and Accurate COF-R02 Questions for passing the exam Quickly: https://www.braindumpquiz.com/COF-R02-exam-material.html