Snowflake COF-R02 SnowPro Core Recertification Exam Online Training
Snowflake COF-R02 Online Training
The questions for COF-R02 were last updated at Nov 23,2024.
- Exam Code: COF-R02
- Exam Name: SnowPro Core Recertification Exam
- Certification Provider: Snowflake
- Latest update: Nov 23,2024
A virtual warehouse’s auto-suspend and auto-resume settings apply to which of the following?
- A . The primary cluster in the virtual warehouse
- B . The entire virtual warehouse
- C . The database in which the virtual warehouse resides
- D . The Queries currently being run on the virtual warehouse
When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of Queries are always queuing in the warehouse
According to recommended best practice, what should be done to reduce the Queue volume? (Select TWO).
- A . Use multi-clustered warehousing to scale out warehouse capacity.
- B . Scale up the warehouse size to allow Queries to execute faster.
- C . Stop and start the warehouse to clear the queued queries
- D . Migrate some queries to a new warehouse to reduce load
- E . Limit user access to the warehouse so fewer queries are run against it.
Which account__usage views are used to evaluate the details of dynamic data masking? (Select TWO)
- A . ROLES
- B . POLICY_REFERENCES
- C . QUERY_HISTORY
- D . RESOURCE_MONIT ORS
- E . ACCESS_HISTORY
How would you determine the size of the virtual warehouse used for a task?
- A . 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 - B . 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
- C . 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
- D . 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
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 25 MB or smaller.
- B . Remove all dates and timestamps.
- C . Load files that are approximately 100-250 MB (or larger)
- D . Avoid using embedded characters such as commas for numeric data types
- E . Remove semi-structured data types
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 LAST_SUCCESS_LOGIN, LOGIN_NAME
FROM ACCOUNT_USAGE.USERS; - B . SELECT EVENT_TIMESTAMP, USER_NAME
FROM table(information_schema.login_history_by_user()) - C . SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.ACCESS_HISTORY; - D . SELECT EVENT_TIMESTAMP, USER_NAME
FROM ACCOUNT_USAGE.LOGIN_HISTORY;
What feature can be used to reorganize a very large table on one or more columns?
- A . Micro-partitions
- B . Clustering keys
- C . Key partitions
- D . Clustered partitions
In the query profiler view for a query, which components represent areas that can be used to help optimize query performance? (Select TWO)
- A . Bytes scanned
- B . Bytes sent over the network
- C . Number of partitions scanned
- D . Percentage scanned from cache
- E . External bytes scanned
What is a machine learning and data science partner within the Snowflake Partner Ecosystem?
- A . Informatica
- B . Power Bl
- C . Adobe
- D . Data Robot
Which command can be used to load data into an internal stage?
- A . LOAD
- B . copy
- C . GET
- D . PUT
Latest COF-R02 Dumps Valid Version with 330 Q&As
Latest And Valid Q&A | Instant Download | Once Fail, Full Refund
