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.Connect through Snowflake's JDBC or ODBC drivers
• B.Use a custom-built connector.
• C.Use Snowflake's native API.
• D.Contact Snowflake Support for a new driver.

Comment: *

Name: *

Email: *

Verification: *

Which statements are true concerning Snowflake's underlying cloud infrastructure? (Select THREE),

• A.Snowflake data and services are deployed in a single availability zone within a cloud provider's region.
• B.Snowflake data and services are available in a single cloud provider and a single region, the use of multiple cloud providers is not supported.
• C.Snowflake can be deployed in a customer's private cloud using the customer's own compute and storage resources for Snowflake compute and storage
• D.Snowflake uses the core compute and storage services of each cloud provider for its own compute and storage
• E.All three layers of Snowflake's architecture (storage, compute, and cloud services) are deployed and managed entirely on a selected cloud platform
• F.Snowflake data and services are deployed in at least three availability zones within a cloud provider's region

Comment: *

Name: *

Email: *

Verification: *

The fail-safe retention period is how many days?

• A.1 day
• B.7 days
• C.45 days
• D.90 days

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

A tag object has been assigned to a table (TABLE_A) in a schema within a Snowflake database.
Which CREATE object statement will automatically assign the TABLE_A tag to a target object?

• A.CREATE TABLE <table_name> LIKE TABLE_A;
• B.CREATE VIEW <view_name> AS SELECT * FROM TABLE_A;
• C.CREATE TABLE <table_name> AS SELECT * FROM TABLE_A;
• D.CREATE MATERIALIZED VIEW <view name> AS SELECT * FROM TABLE A;

Comment: *

Name: *

Email: *

Verification: *