Snowflake DEA-C01 Practice Test - Questions Answers, Page 6
Related questions
Question 51

Can the same column be specified in both a Dynamic data masking policy signature and a row ac-cess policy signature at the same time?
Question 52

Which two Account usage views can be used for auditing Dynamic data masking purpose?
Question 53

Which of the below concepts/functions helps while implementing advanced Column-level Security?
Explanation:
Column-level Security supports using Context Functions in the conditions of the masking policy body to enforce whether a user has authorization to see data. To determine whether a user can see data in a given SQL statement, it is helpful to consider:
Masking policy conditions using CURRENT_ROLE target the role in use for the current session.
Masking policy conditions using INVOKER_ROLE target the executing role in a SQL statement.
Role hierarchy Determine if a specified role in a masking policy condition (e.g. ANALYST custom role) is a lower privilege role in the CURRENT_ROLE or INVOKER_ROLE role hierarchy. If so, then the role returned by the CURRENT_ROLE or INVOKER_ROLE functions inherits the privileges of the specified role.
Question 54

Select the Incorrect statement about External Functions in SnowFlake?
Question 55

Which are the Cloud Platforms that Support Calling an External Function?
Question 56

While creating External function, Which Database object required with at least ACCOUNTAD-MIN privileges?
Question 57

What are Invalid rules applicable when using stored procedure contains transaction?
Question 58

You can execute zero, one, or more transactions inside a stored procedure?
Question 59

Snowflake does not treat the inner transaction as nested; instead, the inner transaction is a separate transaction. What is term used to call these Transaction?
Question 60

Elon, a Data Engineer, needs to Split Semi-structured Elements from the Source files and load them as an array into Separate Columns.
Source File:
Question