Which of the following Snowflake objects can be shared using a secure share? (Select TWO).

• A.Secure User Defined Functions (UDFs)
• B.Procedures
• C.Sequences
• D.Materialized views
• E.Tables

Comment: *

Name: *

Email: *

Verification: *

Which roles can make grant decisions to objects within a managed access schema? (Select TWO)

• A.ACCOUNTADMIN
• B.SECURITYADMIN
• C.SYSTEMADMIN
• D.ORGADMIN
• E.USERADMIN

Comment: *

Name: *

Email: *

Verification: *

What is one of the characteristics of data shares?

• A.Data shares support full DML operations.
• B.Data shares work by copying data to consumer accounts.
• C.Data shares utilize secure views for sharing view objects.
• D.Data shares are cloud agnostic and can cross regions by default.

Comment: *

Name: *

Email: *

Verification: *

Which of the following can be used when unloading data from Snowflake? (Choose two.)

• A.By using the SINGLE = TRUE parameter, a single file up to 5 GB in size can be exported to the storage layer.
• B.The OBJECT_CONSTRUCT function can be used to convert relational data to semi-structured data.
• C.When unloading semi-structured data, it is recommended that the STRIP_OUTER_ARRAY option be used.
• D.Use the PARSE_JSON function to ensure structured data will be unloaded into the VARIANT data type.
• E.Use the ENCODING file format option to change the encoding from the default UTF-8.

Comment: *

Name: *

Email: *

Verification: *

Which of the following Snowflake capabilities are available in all Snowflake editions? (Select TWO)

• A.Customer-managed encryption keys through Tri-Secret Secure
• B.Automatic encryption of all data
• C.Up to 90 days of data recovery through Time Travel
• D.Object-level access control
• E.Column-level security to apply data masking policies to tables and views

Comment: *

Name: *

Email: *

Verification: *