Apply Masking and Row Access Policies DEA-C02 Practice Questions (Page 5)

Questions 21–21

1. 21application · medium

   A data engineer has created a masking policy and a row access policy. Before deploying to production, the engineer wants to verify that the policies behave as expected for different roles. Which approach should the engineer use to test the policies?

   • ARun a query with the 'EXPLAIN' command to see the query plan and check if policies are applied.
   • BUse the DESCRIBE MASKING POLICY and DESCRIBE ROW ACCESS POLICY commands to review the policy definitions.
   • CCreate a test role, grant it the necessary privileges, and then use the 'USE ROLE' command to switch to that role and run queries to observe the results.
   • DUse the SYSTEM$MASKING_POLICY_REFERENCE and SYSTEM$ROW_ACCESS_POLICY_REFERENCE functions to check which policies are applied.
   Reveal Solution Discussion Select an answer first