Which parameter prevents streams on tables from becoming stale?

• A.STALE_AFTER
• B.MAXDATAEXTENSIONTIMEINDAYS
• C.LOCK_TIMEOUT
• D.MTN_DATA_RETENTION_TTME_TN_DAYS

Comment: *

Name: *

Email: *

Verification: *

The Information Schema and Account Usage Share provide storage information for which of the following objects? (Choose three.)

• A.Users
• B.Tables
• C.Databases
• D.Internal Stages

Comment: *

Name: *

Email: *

Verification: *

A company needs to read multiple terabytes of data for an initial load as part of a Snowflake migration. The company can control the number and size of CSV extract files.
How does Snowflake recommend maximizing the load performance?

• A.Use auto-ingest Snowpipes to load large files in a serverless model.
• B.Produce the largest files possible, reducing the overall number of files to process.
• C.Produce a larger number of smaller files and process the ingestion with size Small virtual warehouses.
• D.Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.

Comment: *

Name: *

Email: *

Verification: *

How many days is load history for Snowpipe retained?

• A.1 day
• B.7 days
• C.14 days
• D.64 days

Comment: *

Name: *

Email: *

Verification: *

How does Snowflake Fail-safe protect data in a permanent table?

• A.Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
• B.Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.
• C.Fail-safe makes data available up to 1 day, recoverable by user operations.
• D.Fail-safe makes data available for 7 days, recoverable by user operations.

Comment: *

Name: *

Email: *

Verification: *