SnowPro Core Practice Test practice questions, page 48 of 54, with answer review and explanations.
Question 236
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?
Use Time Travel, as long as DATA_RETENTION_TIME_IN_DAYS was set to at least 3 days.
The transient table version cannot be retrieved after 24 hours.
Contact Snowflake Support to have the data retrieved from Fail-safe storage.
Use the FAIL_SAFE parameter for Time Travel to retrieve the data from Fail-safe storage.
Question 237
When reviewing the load for a warehouse using the load monitoring chart, the chart indicates that a high volume of queries is always queuing in the warehouse. According to recommended best practice, what should be done to reduce the queue volume? (Choose two.)
Use multi-clustered warehousing to scale out warehouse capacity.
Scale up the warehouse size to allow queries to execute faster.
Stop and start the warehouse to clear the queued queries.
Migrate some queries to a new warehouse to reduce load.
Limit user access to the warehouse so fewer queries are run against it.
Question 238
Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)
Tri-Secret Secure
Time Travel
Fail-safe
Data encryption
External stages
Question 239
Where can a user find and review the failed logins of a specific user for the past 30 days?