What is cached during a query on a virtual warehouse?

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

Comment: *

Name: *

Email: *

Verification: *

When used with a SELECT statement in the COPY INTO < location > command, what statement will unload data from a table as JSON?

• A.TO_JSON
• B.TO_OBJECT
• C.OBJECT_CONSTRUCT
• D.PARSE_JSON

Comment: *

Name: *

Email: *

Verification: *

Which metadata table will store the storage utilization information even for dropped tables?

• A.DATABASE_STORAGE_USAGE_HISTORY
• B.TABLE_STORAGE_METRICS
• C.STORAGE_DAILY_HISTORY
• D.STAGE STORAGE USAGE HISTORY

Comment: *

Name: *

Email: *

Verification: *

A user has unloaded data from a Snowflake table to an external stage.
Which command can be used to verify if data has been uploaded to the external stage named my_stage?

• A.view @my_stage
• B.list @my_stage
• C.show @my_stage
• D.display @my_stage

Comment: *

Name: *

Email: *

Verification: *

What are benefits of using Snowpark with Snowflake? (Select TWO).

• A.Snowpark uses a Spark engine to generate optimized SQL query plans.
• B.Snowpark automatically sets up Spark within Snowflake virtual warehouses.
• C.Snowpark does not require that a separate cluster be running outside of Snowflake.
• D.Snowpark allows users to run existing Spark code on virtual warehouses without the need to reconfigure the code.
• E.Snowpark executes as much work as possible in the source databases for all operations including User- Defined Functions (UDFs).

Comment: *

Name: *

Email: *

Verification: *