Column and Row Level Security Quiz

5 questions Pass: 70% +25 pts (50 with Pro)

Quiz covering Designing the Security Model

What you'll be asked

  1. Which of the following best describes the primary purpose of Row-Level Security (RLS)?
  2. A healthcare application needs to hide the 'Social Security Number' column from all users except those in the HR department. Which security mechanism is most appropriate?
  3. When implementing Row-Level Security using a predicate function, what happens if the function returns a value that evaluates to FALSE for a particular row?
  4. In a multi-tenant SaaS application, you want to ensure that 'Tenant A' can never see data belonging to 'Tenant B'. Which design pattern is most effective?
  5. You have a table with 10 million rows. You implement a complex Row-Level Security function that performs a recursive lookup to determine user access. What is the most likely architectural impact?

Answers and explanations come after you submit.