Which methods can be used to delete staged files from a Snowflake stage? (Choose two.)

• A.Use the DROP <file> command after the load completes.
• B.Specify the TEMPORARY option when creating the file format.
• C.Specify the PURGE copy option in the COPY INTO <table> command.
• D.Use the REMOVE command after the load completes.
• E.Use the DELETE LOAD HISTORY command after the load completes.

Comment: *

Name: *

Email: *

Verification: *

Which statement describes Snowflake tables?

• A.Snowflake tables arc logical representation of underlying physical data.
• B.Snowflake tables are the physical instantiation of data loaded into Snowflake.
• C.Snowflake tables require that clustering keys be defined lo perform optimally.
• D.Snowflake tables are owned by a use.

Comment: *

Name: *

Email: *

Verification: *

Which of the following objects can be directly restored using the UNDROP command? (Choose two.)

• A.Schema
• B.View
• C.Internal stage
• D.Table
• E.User
• F.Role

Comment: *

Name: *

Email: *

Verification: *

What column type does a Kafka connector store formatted information in a single column?

• A.ARRAY
• B.OBJECT
• C.VARCHAR
• D.VARIANT

Comment: *

Name: *

Email: *

Verification: *

The Snowflake cloud services layer is responsible for which tasks? (Choose two.)

• A.Database storage
• B.Metadata management
• C.Local disk caching
• D.Authentication and access control
• E.Query processing

Comment: *

Name: *

Email: *

Verification: *