Which Snowflake layer is associated with virtual warehouses?

• A.Database storage
• B.Query processing
• C.Elastic memory
• D.Cloud services

Comment: *

Name: *

Email: *

Verification: *

What COPY INTO SQL command should be used to unload data into multiple files?

• A.MULTIPLE=TRUE
• B.SINGLE=FALSE
• C.SINGLE=TRUE
• D.MULTIPLE=FALSE

Comment: *

Name: *

Email: *

Verification: *

How does the search optimization service help Snowflake users improve query performance?

• A.It scans the micro-partitions based on the joins used in the queries and scans only join columns.
• B.It keeps track of running queries and their results and saves those extra scans on the table.
• C.II maintains a persistent data structure that keeps track of the values of the table's columns m each of its micro-partitions.
• D.It scans the local disk cache to avoid scans on the tables used in the Query.

Comment: *

Name: *

Email: *

Verification: *

Which of the following statements about data sharing are true? choose 2 answers

• A.New objects created by a Data Provider are automatically shared with existing Data Consumers & Reader Accounts
• B.Shared databases are read-only
• C.Reader Accounts are created and funded by Data Prowlers
• D.All database objects can be included In a shared database

Comment: *

Name: *

Email: *

Verification: *

Which interfaces can be used to create and/or manage Virtual Warehouses?

• A.SQL commands
• B.The Snowflake Web Interface (UI)
• C.All of the above
• D.Data integration tools

Comment: *

Name: *

Email: *

Verification: *