Which statement describes pruning?

• A.The filtering or disregarding of micro-partitions that are not needed to return a query.
• B.The return of micro-partitions values that overlap with each other to reduce a query's runtime.
• C.A service that is handled by the Snowflake Cloud Services layer to optimize caching.
• D.The ability to allow the result of a query to be accessed as if it were a table.

Comment: *

Name: *

Email: *

Verification: *

True or False: During data unloading, only JSON and CSV files can be compressed.

• A.True
• B.False

Comment: *

Name: *

Email: *

Verification: *

What services does Snowflake automatically provide for customer that they may have been responsible for with their on premise system? Select all the below that apply.

• A.Physical security
• B.Installing and configuring hardware
• C.Maintaining metadata and statists
• D.Patching software

Comment: *

Name: *

Email: *

Verification: *

Which query profile statistics help determine if efficient pruning is occurring? (Choose two.)

• A.Bytes spilled to local storage
• B.Partitions total
• C.Partitions scanned
• D.Percentage scanned from cache
• E.Bytes sent over network

Comment: *

Name: *

Email: *

Verification: *

What are value types that a VARIANT column can store? (Select TWO)

• A.STRUCT
• B.OBJECT
• C.BINARY
• D.ARRAY
• E.CLOB

Comment: *

Name: *

Email: *

Verification: *