ADA-C01 Exam Dumps | Which masking policy will mask a column whenever it is queried through a view owned by a role named MASKED_VIEW

Home
Snowflake
SnowPro Advanced Administrator
Snowflake.ADA-C01.v2024-07-18.q29
Question 26

Valid ADA-C01 Dumps shared by ExamDiscuss.com for Helping Passing ADA-C01 Exam! ExamDiscuss.com now offer the newest ADA-C01 exam dumps, the ExamDiscuss.com ADA-C01 exam questions have been updated and answers have been corrected get the newest ExamDiscuss.com ADA-C01 dumps with Test Engine here:

Access ADA-C01 Dumps Premium Version
(80 Q&As Dumps, 35%OFF Special Discount Code: freecram)

<< Prev Question Next Question >>

Question 26/29

Which masking policy will mask a column whenever it is queried through a view owned by a role named MASKED_VIEW_ROLE?

A. create or replace masking policy maskstring as (val string) returns string -> case when is_role_in_session ('MASKED_VIEW_ROLE') then ' ** else val end;
*,

B. create or replace masking policy maskString as (val string) returns string -> case when array_contains ('MASKED_VIEW_ROLE' :: variant, parse_json (current_available_roles ())) then
'*
else val
end;
** '

C. create or replace masking policy maskstring as (val string) returns string -> case when invoker_role() in ('MASKED_VIEW_ROLE') then else val end;
' **

D. create or replace masking policy maskString as (val string) returns string -> case when current_role() in ('MASKED_VIEW_ROLE') then ' ********* ' else val end;

Correct Answer: A

Explanation
A masking policy is a SQL expression that transforms the data in a column based on the role that queries the column1. The is_role_in_session function returns true if the specified role is in the current session2. Therefore, the masking policy in option A will mask the column data with asterisks whenever it is queried through a view owned by the MASKED_VIEW_ROLE3. The other options use different functions that do not check the ownership of the view, but rather the current role, the invoker role, or the available roles in the session45.
These functions may not return the desired result if the role that owns the view is different from the role that queries the view.

Your email address will not be published. Required fields are marked *

Comment: *

Name: *

Email: *

Rating: *

Verification: *

Question List (29q): Question 1: A large international company with many operating regions re...; Question 2: What is a characteristic of Snowflake's transaction locking ...; Question 3: The ACCOUNTADMIN of Account 123 works with Snowflake Support...; Question 4: When does auto-suspend occur for a multi-cluster virtual war...; Question 5: A Snowflake Administrator needs to set up Time Travel for a ...; Question 6: An Administrator has a user who needs to be able to suspend ...; Question 7: A Snowflake customer is experiencing higher costs than antic...; Question 8: Which actions are considered breaking changes to data that i...; Question 9: An Administrator has a warehouse which is intended to have a...; Question 10: An Administrator has a user who needs to be able to suspend ...; Question 11: A Snowflake Administrator needs to persist all virtual wareh...; Question 12: What is required for stages, without credentials, to limit d...; Question 13: What roles can be used to create network policies within Sno...; Question 14: A data provider wants to share data from multiple databases ...; Question 15: A virtual warehouse report_wh is configured with AUTO_RESUME...; Question 16: An Administrator wants to delegate the administration of a c...; Question 17: Which type of listing in the Snowflake Marketplace can be ad...; Question 18: Which Snowflake objects can be managed using SCIM integratio...; Question 19: A retailer uses a TRANSACTIONS table (100M rows, 1.2 TB) tha...; Question 20: Review the output of the SHOW statement below which displays...; Question 21: The following SQL command was executed: Use role SECURITYADM...; Question 22: What are the requirements when creating a new account within...; 1 commentQuestion 23: What are the MINIMUM grants required on the database, schema...; Question 24: When a role is dropped, which role inherits ownership of obj...; Question 25: A user with the proper role issues the following commands wh...; Question 26: Which masking policy will mask a column whenever it is queri...; Question 27: A Snowflake Administrator is investigating why a query is no...; Question 28: What are characteristics of data replication in Snowflake? (...; Question 29: Which function is the role SECURITYADMIN responsible for tha...

[×]

Download PDF File

Enter your email address to download Snowflake.ADA-C01.v2024-07-18.q29.pdf

Email:

Disclaimer:
Freecram doesn't offer Real GIAC Exam Questions. Freecram doesn't offer Real SAP Exam Questions. Freecram doesn't offer Real (ISC)² Exam Questions. Freecram doesn't offer Real CompTIA Exam Questions. Freecram doesn't offer Real Microsoft Exam Questions.
Oracle and Java are registered trademarks of Oracle and/or its affiliates.
Freecram material do not contain actual actual Oracle Exam Questions or material.
Microsoft®, Azure®, Windows®, Windows Vista®, and the Windows logo are registered trademarks of Microsoft Corporation.
Freecram Materials do not contain actual questions and answers from Cisco's Certification Exams. The brand Cisco is a registered trademark of CISCO, Inc.
CFA Institute does not endorse, promote or warrant the accuracy or quality of these questions. CFA® and Chartered Financial Analyst® are registered trademarks owned by CFA Institute.
Freecram does not offer exam dumps or questions from actual exams. We offer learning material and practice tests created by subject matter experts to assist and help learners prepare for those exams. All certification brands used on the website are owned by the respective brand owners. Freecram does not own or claim any ownership on any of the brands.

Question 26/29

LEAVE A REPLY

Download PDF File