Which Snowflake objects track DML changes made to tables, like inserts, updates, and deletes?

• A.Pipes
• B.Streams
• C.Tasks
• D.Procedures

Comment: *

Name: *

Email: *

Verification: *

What does Snowflake recommend a user do if they need to connect to Snowflake with a tool or technology mat is not listed in Snowflake partner ecosystem?

• A.Use Snowflake's native API.
• B.Use a custom-built connector.
• C.Contact Snowflake Support for a new driver.
• D.Connect through Snowflake's JDBC or ODBC drivers

Comment: *

Name: *

Email: *

Verification: *

How does Snowflake Fail-safe protect data in a permanent table?

• A.Fail-safe makes data available up to 1 day, recoverable by user operations.
• B.Fail-safe makes data available for 7 days, recoverable by user operations.
• C.Fail-safe makes data available for 7 days, recoverable only by Snowflake Support.
• D.Fail-safe makes data available up to 1 day, recoverable only by Snowflake Support.

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

The following JSON is stored in a VARIANT column called src of the CAR_SALES table:

A user needs to extract the dealership information from the JSON.
How can this be accomplished?

• A.select src:dealership from car_sales;
• B.select src.dealership from car_sales;
• C.select src:Dealership from car_sales;
• D.select dealership from car_sales;

Comment: *

Name: *

Email: *

Verification: *