Valid DAA-C01 Dumps shared by EduDump.com for Helping Passing DAA-C01 Exam! EduDump.com now offer the newest DAA-C01 exam dumps, the EduDump.com DAA-C01 exam questions have been updated and answers have been corrected get the newest EduDump.com DAA-C01 dumps with Test Engine here:
You are tasked with building a dashboard in Looker Studio to visualize data from a Snowflake database. The data contains sensitive information, and the security team requires that only authorized users can access specific data based on their role. The Snowflake database has roles defined: 'ANALYST, 'MANAGER, and 'EXECUTIVE. The 'SALES DATA' table contains a 'REGION' column. 'ANALYST' should only see data for their assigned region, 'MANAGER should see data for their region and direct reports regions, and 'EXECUTIVE should see all regions. Which of the following is/are the MOST secure and efficient way(s) to implement row-level security in Snowflake and integrate it with Looker Studio without duplicating the data?
Correct Answer: C,E
Row Access Policies (RAP) in Snowflake provide the most secure and efficient way to implement row-level security. By defining policies based on the user's role, you can ensure that users only see the data they are authorized to access directly at the Snowflake level. Combining RAPs with dynamic data masking for 'SALE_AMOUNT adds an extra layer of security by redacting sensitive data based on the user's role. Option A requires managing multiple views, which can be cumbersome. Option B introduces complexity with stored procedures. Option D moves security logic into Looker Studio, which is less secure and can be bypassed. Using a service account with appropriate privileges ensures that Looker Studio can access the data securely and apply the defined Row Access Policies. Options C is correct because it keeps security logic within Snowflake. Option E is correct because it provides additional data masking depending on the security policies for sale amount.