最新的Snowflake SnowPro Core Recertification - COF-R02免費考試真題
Will data cached in a warehouse be lost when the warehouse is resized?
正確答案: B
What internal stages are available in Snowflake? (Choose three.)
正確答案: A,D,E
What is the default file size when unloading data from Snowflake using the COPY command?
正確答案: B
How long is Snowpipe data load history retained?
正確答案: C
說明：（僅 Fast2test 成員可見）
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).
正確答案: C,D
Which of the following are characteristics of security in Snowflake?
正確答案: C
True or False: Snowflake's Global Services Layer gathers and maintains statistics on all columns in all micro-partitions.
正確答案: B
說明：（僅 Fast2test 成員可見）
Which of the following statements are true of Virtual Warehouses? (Choose all that apply.)
正確答案: A,B,C,D
說明：（僅 Fast2test 成員可見）
When a Pipe is recreated using the CREATE OR REPLACE PIPE command:
正確答案: A
說明：（僅 Fast2test 成員可見）
What are advantages clones have over tables created with CREATE TABLE AS SELECT statement? (Choose two.)
正確答案: A,D
What is the minimum Snowflake edition required to create a materialized view?
正確答案: B
說明：（僅 Fast2test 成員可見）
A user created a transient table and made several changes to it over the course of several days. Three days after the table was created, the user would like to go back to the first version of the table.
How can this be accomplished?
How can this be accomplished?
正確答案: B
A data provider wants to share data with a consumer who does not have a Snowflake account. The provider creates a reader account for the consumer following these steps:
1. Created a user called "CONSUMER"
2. Created a database to hold the share and an extra-small warehouse to query the data
3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share Based on this configuration what is true of the reader account?
1. Created a user called "CONSUMER"
2. Created a database to hold the share and an extra-small warehouse to query the data
3. Granted the role PUBLIC the following privileges: Usage on the warehouse, database, and schema, and SELECT on all the objects in the share Based on this configuration what is true of the reader account?
正確答案: C