Which Snowflake feature or tool helps troubleshoot issues in SQL query expressions that commonly cause performance bottlenecks?

• A.Persisted query results
• B.QUERY_HISTORY View
• C.Query acceleration service
• D.Query Profile

Comment: *

Name: *

Email: *

Verification: *

What metadata does Snowflake store for rows in micro-partitions? (Select TWO).

• A.Range of values
• B.Distinct values
• C.Index values
• D.Sorted values
• E.Null values

Comment: *

Name: *

Email: *

Verification: *

How does Snowflake support Multi-Factor Authentication (MFA) with a second factor device?

• A.Through integration with OAuth
• B.Using federated authentication and Single Sign-On (SSO)
• C.Using time-based, one-time passcodes
• D.Through Role-Based Access Control (RBAC)

Comment: *

Name: *

Email: *

Verification: *

When is the VARIANT data type suitable when using semi-structured data? (Select TWO).

• A.When there is a need to add or modify elements within the data structure without interrupting the session.
• B.When the data set is huge and the order of the data elements in the data set does not change.
• C.When there is a need for a predefined schema which cannot be changed after it is created.
• D.When the data contains nested data structures like JSON or XML.
• E.When the data consists of images and videos.

Comment: *

Name: *

Email: *

Verification: *

How does Snowflake reorganize data when it is loaded? (Select TWO).

• A.Binary format
• B.Columnar format
• C.Compressed format
• D.Raw format
• E.Zipped format

Comment: *

Name: *

Email: *

Verification: *