Snowflake COF-R02 Practice Test - Questions Answers, Page 20
Question list
List of questions
Related questions
When loading data into Snowflake via Snowpipe what is the compressed file size recommendation?
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?
What is the SNOWFLAKE.ACCOUNT_USAGE view that contains information about which objects were read by queries within the last 365 days (1 year)?
A running virtual warehouse is suspended.
What is the MINIMUM amount of time that the warehouse will incur charges for when it is restarted?
What are the responsibilities of Snowflake's Cloud Service layer? (Choose three.)
How long is the Fail-safe period for temporary and transient tables?
Which command should be used to download files from a Snowflake stage to a local folder on a client's machine?
How does Snowflake Fail-safe protect data in a permanent table?
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?
Which minimum Snowflake edition allows for a dedicated metadata store?
Question