Which DDL/DML operation is allowed on an inbound data share?

• A.SELECT
• B.ALTER TA3LE
• C.MERGE
• D.INSERT INTO

Comment: *

Name: *

Email: *

Verification: *

What is cached during a query on a virtual warehouse?

• A.All rows accessed during the query
• B.All columns in a micro-partition
• C.Any columns accessed during the query
• D.The columns in the result set of the query

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake feature records changes mace to a table so actions can be taken using that change data capture?

• A.Stream
• B.Materialized View
• C.Task
• D.Pipe

Comment: *

Name: *

Email: *

Verification: *

What are valid sub-clauses to the OVER clause for a window function? (Select TWO).

• A.LIMIT
• B.ORDER BY
• C.GROUP BY
• D.PARTITION BY
• E.UNION ALL

Comment: *

Name: *

Email: *

Verification: *

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

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

Comment: *

Name: *

Email: *

Verification: *