Which Snowflake architectural layer is responsible for a query execution plan?

• A.Compute
• B.Cloud services
• C.Data storage
• D.Cloud provider

Comment: *

Name: *

Email: *

Verification: *

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

The Snowflake Search Optimization Services supports improved performance of which kind of query?

• A.Queries against large tables where frequent DML occurs
• B.Queries against tables larger than 1 TB
• C.Selective point lookup queries
• D.Queries against a subset of columns in a table

Comment: *

Name: *

Email: *

Verification: *

A user has 10 files in a stage containing new customer data. The ingest operation completes with no errors, using the following command:
COPY INTO my__table FROM @my__stage;
The next day the user adds 10 files to the stage so that now the stage contains a mixture of new customer data and updates to the previous data. The user did not remove the 10 original files.
If the user runs the same copy into command what will happen?

• A.The operation will fail with the error uncertain files in stage.
• B.All data from all of the files on the stage will be appended to the table
• C.All data from only the newly-added files will be appended to the table.
• D.Only data about new customers from the new files will be appended to the table

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake data type is used to store JSON key value pairs?

• A.BINARY
• B.TEXT
• C.STRING
• D.VARIANT

Comment: *

Name: *

Email: *

Verification: *