What is a limitation of a Materialized View?

• A.A Materialized View cannot support any aggregate functions
• B.A Materialized View can only reference up to two tables
• C.A Materialized View cannot be joined with other tables
• D.A Materialized View cannot be defined with a JOIN

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

• A.Pipes
• B.Streams
• C.Tasks
• D.Procedures

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 would you determine the size of the virtual warehouse used for a task?

• A.If using the stored procedure to execute multiple SQL statements, it's best to test run the stored procedure separately to size the compute resource first
• B.Root task may be executed concurrently (i.e. multiple instances), it is recommended to leave some margins in the execution window to avoid missing instances of execution
• C.Since task infrastructure is based on running the task body on schedule, it's recommended to configure the virtual warehouse for automatic concurrency handling using Multi-cluster warehouse (MCW) to match the task schedule
• D.Querying (select) the size of the stream content would help determine the warehouse size. For example, if querying large stream content, use a larger warehouse size

Comment: *

Name: *

Email: *

Verification: *