Snowflake SnowPro Core Practice Test - Questions Answers, Page 15

What are the correct parameters for time travel and fail-safe in the Snowflake Enterprise Edition?

Which of the following objects are contained within a schema? (Choose two.)

Which of the following statements describe features of Snowflake data caching? (Choose two.)

A table needs to be loaded. The input data is in JSON format and is a concatenation of multiple JSON documents. The file size is 3 GB. A warehouse size small is being used. The following COPY INTO command was executed:

COPY INTO SAMPLE FROM @~/SAMPLE.JSON (TYPE=JSON)

The load failed with this error:

Max LOB size (16777216) exceeded, actual size of parsed column is 17894470.

How can this issue be resolved?

Which of the following features, associated with Continuous Data Protection (CDP), require additional Snowflake-provided data storage? (Choose two.)

Where can a user find and review the failed logins of a specific user for the past 30 days?

Which of the following statements apply to Snowflake in terms of security? (Choose two.)

A single user of a virtual warehouse has set the warehouse to auto-resume and auto-suspend after 10 minutes. The warehouse is currently suspended and the user performs the following actions:

1. Runs a query that takes 3 minutes to complete

2. Leaves for 15 minutes

3. Returns and runs a query that takes 10 seconds to complete

4. Manually suspends the warehouse as soon as the last query was completed

When the user returns, how much billable compute time will have been consumed?

What actions will prevent leveraging of the ResultSet cache? (Choose two.)