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 dealership from car_sales;
• B.select src:Dealership from car_sales;
• C.select src.dealership from car_sales;
• D.select src:dealership from car_sales;

Comment: *

Name: *

Email: *

Verification: *

What does Snowflake recommend regarding database object ownership? (Select TWO).

• A.Create objects with ACCOUNTADMIN and do not reassign ownership.
• B.Create objects with SECURITYADMIN to ease granting of privileges later.
• C.Create objects with SYSADMIN.
• D.Use only MANAGED ACCESS SCHEMAS for66 objects owned by ACCOUNTADMIN.
• E.Create objects with a custom role and grant this role to SYSADMIN.

Comment: *

Name: *

Email: *

Verification: *

How long is Snowpipe data load history retained?

• A.As configured in the create pipe settings
• B.Until the pipe is dropped
• C.64 days
• D.14 days

Comment: *

Name: *

Email: *

Verification: *

Which statement describes Snowflake tables?

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

Comment: *

Name: *

Email: *

Verification: *

Where would a Snowflake user find information about query activity from 90 days ago?

• A.account__usage.query__history__archive View
• B.account__usage . query history view
• C.information__schema . cruery_history view
• D.information__schema - query history_by_ses s i on view

Comment: *

Name: *

Email: *

Verification: *