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

A query containing a WHERE clause is running longer than expected. The Query Profile shows that all micro- partitions being scanned How should this query be optimized?

• A.Create a view on the table.
• B.Add a clustering key to the table
• C.Add a limit clause to the query.
• D.Add a Dynamic Data Masking policy to the table.

Comment: *

Name: *

Email: *

Verification: *

Which key access control concept does Snowflake descibe as a defined level of access to an object?

• A.Grant
• B.Privilege
• C.Role
• D.Session

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake objects can be restored using Time Travel? (Select VNO).

• A.Roles
• B.Users
• C.Databases
• D.Schemas
• E.Virtual warehouses

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake partner specializes in data catalog solutions?

• A.Alation
• B.DataRobot
• C.dbt
• D.Tableau

Comment: *

Name: *

Email: *

Verification: *