In Snowflake's data security framework, how does column-level security contribute to the protection of sensitive information? (Select TWO).

• A.Implementation of column-level security will optimize query performance.
• B.Column-level security supports encryption of the entire database.
• C.Column-level security ensures that only the table owner can access the data.
• D.Column-level security limits access to specific columns within a table based on user privileges
• E.Column-level security allows the application of a masking policy to a column within a table or view.

Comment: *

Name: *

Email: *

Verification: *

What will be the result of this command?
SELECT value FROM LATERAL FLATTEN(input => parse_json('[1, 2, 3]'));

• A.It will return a single row with three columns with values 1, 2, and 3.
• B.It will return three rows with the values 1, 2, and 3.
• C.It will return a single row with the array [1, 2, 3].
• D.It will return a single row with the values 1, 2, and 3 concatenated.

Comment: *

Name: *

Email: *

Verification: *

What causes objects in a data share to become unavailable to a consumer account?

• A.The DATA_RETENTI0N_TIME_IN_DAYS parameter in the consumer account is set to 0.
• B.The consumer account runs the GRANT IMPORTED PRIVILEGES command on the data share every 24 hours.
• C.The objects in the data share are being deleted and the grant pattern is not re-applied systematically.
• D.The consumer account acquires the data share through a private data exchange.

Comment: *

Name: *

Email: *

Verification: *

What is the Fail-safe retention period for transient and temporary tables?

• A.0 days
• B.1 day
• C.7 days
• D.90 days

Comment: *

Name: *

Email: *

Verification: *

Which Snowflake object enables loading data from files as soon as they are available in a cloud storage location?

• A.Pipe
• B.External stage
• C.Task
• D.Stream

Comment: *

Name: *

Email: *

Verification: *