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

Questions 16–20

1. 16foundation · easy

   During query execution, when are masking and row access policies evaluated?

   • AOnly when the user explicitly calls the policy function
   • BDuring query compilation and execution, before results are returned
   • CAfter the query results are returned to the user
   • DOnly when the table is created
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   Which statement is used to remove a row access policy from a table?

   • ADROP ROW ACCESS POLICY ... ON TABLE
   • BALTER TABLE ... UNSET ROW ACCESS POLICY
   • CDELETE ROW ACCESS POLICY ... FROM TABLE
   • DREVOKE ROW ACCESS POLICY ... ON TABLE
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   What is a potential performance impact of applying row access policies to large tables?

   • ANo impact, because policies are applied only at the metadata level
   • BImproved performance because policies reduce the number of rows scanned
   • CDecreased storage requirements because rows are physically removed
   • DIncreased query latency due to additional evaluation of policy conditions for each row
   Reveal Solution Discussion Select an answer first
5. 19foundation · easy

   Which context information can a row access policy use to determine row visibility?

   • AThe user's current role
   • BThe user's password hash
   • CThe user's authentication method
   • DThe user's IP address
   Reveal Solution Discussion Select an answer first
6. 20foundation · easy

   What is the purpose of using the POLICY_CONTEXT function when debugging a row access policy?

   • ATo verify which rows a specific role would see without switching roles
   • BTo create a new role for testing purposes
   • CTo permanently change the role for the current session
   • DTo drop the policy from the table
   Reveal Solution Discussion Select an answer first