Free Snowflake SnowPro-Core Exam Dumps Questions & Answers

A JSON document is stored in the source_colum of type VARIANT. The document has an array called elements. The array contains the name key that has a string value How can a Snowflake user extract the name from the first element?

• A.Source_column.element[1]:name
• B.Source_column.element[1].name
• C.Source_column.element[0]:name
• D.Source_column.element[0]:name

Which Snowflake layer is associated with virtual warehouses?

• A.Database storage
• B.Query processing
• C.Cloud services
• D.Elastic memory

Snowflake's access control framework combines which models for securing data? (Select TWO).

• A.Discretionary Access Control (DAC)
• B.Attribute-based Access Control (ABAC 1
• C.Access Control List (ACL)
• D.Role-based Access Control (RBAC)
• E.Rule-based Access Control (RuBAC)

What are common issues found by using the Query Profile? (Choose two.)

• A.Locating queries that consume a high amount of credits
• B.Identifying logical issues with the queries
• C.Identifying queries that will likely run very slowly before executing them
• D.Identifying inefficient micro-partition pruning
• E.Data spilling to a local or remote disk

What is the minimum Snowflake edition that has column-level security enabled?

• A.Virtual Private Snowflake
• B.Enterprise
• C.Business Critical
• D.Standard