Snowflake COF-R02 Practice Test - Questions Answers, Page 20
List of questions
Related 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?
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/tables-temp-transient.html
Question 197

Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?
Explanation:
Reference: https://docs.snowflake.com/en/sql-reference/sql/get.html
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?
Explanation:
Reference: https://docs.snowflake.com/en/user-guide/intro-editions.html
Question