Snowflake COF-R02 Practice Test - Questions Answers, Page 20
List of questions
Question 191
When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?
Question 192
Which Snowflake feature allows a user to substitute a randomly generated identifier for sensitive data, in order to prevent unauthorized users access to the data, before loading it into Snowflake?
Question 193
What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?
Question 194
A running virtual warehouse is suspended.
What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?
Question 195
What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)
Question 196
How long is the Fail-safe period for temporary and transient tables?
Question 197
Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?
Question 198
How does Snowflake Fail-safe protect data in a permanent table?
Question 199
A virtual warehouse is created using the following command:
Create warehouse my_WH with
warehouse_size = MEDIUM
min_cluster_count = 1
max_cluster_count = 1
auto_suspend = 60
auto_resume = true;
The image below is a graphical representation of the warehouse utilization across two days.
What action should be taken to address this situation?
Question 200
Which minimum Snowflake edition allows for a dedicated metadata store?
Question