How would you determine the size of the virtual warehouse used for a task?

• A.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
• B.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
• C.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
• D.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

Comment: *

Name: *

Email: *

Verification: *

A Virtual Warehouse's auto-suspend and auto-resume settings apply to:

• A.The queries currently being run by the Virtual Warehouse
• B.The primary duster in the virtual warehouse
• C.The entire Virtual Warehouse
• D.The database the Virtual Warehouse resides in

Comment: *

Name: *

Email: *

Verification: *

Which statement accurately describes a characteristic of a materialized view?

• A.Data accessed through materialized views can be stale.
• B.A materialized view can query only a single table.
• C.Querying a materialized view is slower than executing a query against the base table of the view.
• D.Materialized view refreshes need to be maintained by the user.

Comment: *

Name: *

Email: *

Verification: *

A stream can be created on which Snowflake objects to record data manipulation language(DML) changes? (Select TWO).

• A.Standard tables
• B.Database
• C.Schemas
• D.Pipes
• E.Standard tables
• F.Standard views

Comment: *

Name: *

Email: *

Verification: *

What is the default character set used when loading CSV files into Snowflake?

• A.UTF-16
• B.UTF-8
• C.ANSI_X3.A
• D.ISO S859-1

Comment: *

Name: *

Email: *

Verification: *