Which of the following are benefits of micro-partitioning? (Select TWO)

• A.Micro-partitions cannot overlap in their range of values
• B.Micro-partitions are immutable objects that support the use of Time Travel.
• C.Micro-partitions can reduce the amount of I/O from object storage to virtual warehouses
• D.Rows are automatically stored in sorted order within micro-partitions
• E.Micro-partitions can be defined on a schema-by-schema basis

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: *

Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

• A.Pipe
• B.External stage
• C.Task
• D.Stream

Comment: *

Name: *

Email: *

Verification: *

which of the following are valid approaches to loading data into a snowflake table? select all the below that apply.

• A.Bulk copy from an Internal Stage
• B.Bulk copy from an External Stage
• C.The Snowflake Web Interface (UT) data loading wizard
• D.Continuous load using Snowpipe REST API

Comment: *

Name: *

Email: *

Verification: *

Which formats are supported for unloading data from Snowflake?
Choose 2 answers

• A.Avro
• B.Delimited (CSV, TSV, etc.)
• C.ISON
• D.ORC

Comment: *

Name: *

Email: *

Verification: *