What is the purpose of multi-cluster virtual warehouses?

• A.To create separate data warehouses to increase query optimization
• B.To allow users the ability to choose the type of compute nodes that make up a virtual warehouse cluster
• C.To allow the warehouse to resize automatically
• D.To eliminate or reduce Queuing of concurrent queries

Comment: *

Name: *

Email: *

Verification: *

Which of the following describes external functions in Snowflake?

• A.They are a type of User-defined Function (UDF).
• B.They contain their own SQL code.
• C.They call code that is stored inside of Snowflake.
• D.They can return multiple rows for each row received

Comment: *

Name: *

Email: *

Verification: *

A user has an application that writes a new Tile to a cloud storage location every 5 minutes.
What would be the MOST efficient way to get the files into Snowflake?

• A.Create a task that runs a copy into operation from an external stage every 5 minutes
• B.Create a task that puts the files in an internal stage and automate the data loading wizard
• C.Create a task that runs a GET operation to intermittently check for new files
• D.Set up cloud provider notifications on the Tile location and use Snowpipe with auto-ingest

Comment: *

Name: *

Email: *

Verification: *

When a schema is cloned what happens to the tags that reside in that schema or database?

• A.The tags become temporarily inactive until they are manually reactivated.
• B.The tags are deleted and must be redefined in the target schema.
• C.The tags remain in the source schema unchanged.
• D.The tags are automatically cloned with the schema, maintaining all associations.

Comment: *

Name: *

Email: *

Verification: *

Which SQL commands, when committed, will consume a stream and advance the stream offset? (Choose two.)

• A.UPDATE TABLE FROM STREAM
• B.SELECT FROM STREAM
• C.INSERT INTO TABLE SELECT FROM STREAM
• D.ALTER TABLE AS SELECT FROM STREAM
• E.BEGIN COMMIT

Comment: *

Name: *

Email: *

Verification: *