How long is the Fail-safe period for temporary and transient tables?

• A.There is no Fail-safe period for these tables.
• B.1 day
• C.7 days
• D.31 days
• E.90 days

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 a larger number of smaller files and process the ingestion with size Small virtual warehouses.
• C.Produce the largest files possible, reducing the overall number of files to process.
• D.Use an external tool to issue batched row-by-row inserts within BEGIN TRANSACTION and COMMIT commands.

Comment: *

Name: *

Email: *

Verification: *

What is the MINIMUM Snowflake edition required to use the periodic rekeying of micro-partitions?

• A.Enterprise
• B.Business Critical
• C.Standard
• D.Virtual Private Snowflake

Comment: *

Name: *

Email: *

Verification: *

Which TABLE function helps to convert semi-structured data to a relational representation?

• A.FLATTEN
• B.TO_JSON
• C.PARSE_JSON
• D.CHECK_JSON

Comment: *

Name: *

Email: *

Verification: *

What impacts the credit consumption of maintaining a materialized view? (Choose two.)

• A.How often the underlying base table is queried
• B.Whether the materialized view has a cluster key defined
• C.How often the base table changes
• D.Whether or not it is also a secure view
• E.How often the materialized view is queried

Comment: *

Name: *

Email: *

Verification: *