Which data types can be used in a Snowflake table that holds semi-structured data? (Select TWO).

• A.ARRAY
• B.BINARY
• C.TEXT
• D.VARIANT
• E.VARCHAK

Comment: *

Name: *

Email: *

Verification: *

Which statement accurately describes a characteristic of a materialized view?

• A.A materialized view can query only a single table.
• B.Data accessed through materialized views can be stale.
• C.Materialized view refreshes need to be maintained by the user.
• D.Querying a materialized view is slower than executing a query against the base table of the view.

Comment: *

Name: *

Email: *

Verification: *

In which layer of its architecture does Snowflake store its metadata statistics?

• A.Storage Layer
• B.Cloud Service Layer
• C.Database Layer
• D.Compute Layer

Comment: *

Name: *

Email: *

Verification: *

What are characteristics of transient tables in Snowflake? (Select TWO).

• A.Transient tables can be altered to make them permanent tables.
• B.Transient tables persist until they are explicitly dropped.
• C.Transient tables can be cloned to permanent tables.
• D.Transient tables have Time Travel retention periods of 0 or 1 day.
• E.Transient tables have a Fail-safe period of 7 days.

Comment: *

Name: *

Email: *

Verification: *

In a Snowflake role hierarchy, what is the top-level role?

• A.ORGADMIN
• B.ACCOUNTADMIN
• C.SYSADMIN
• D.SECURITYADMIN

Comment: *

Name: *

Email: *

Verification: *