Understand Column-Level Masking and Row-Level Security to Restrict Data Visibility Based on User Groups. DATA-ENGINEER-ASSOCIATE Practice Questions (Page 4)

Questions 16–20

1. 16foundation · easy

   Which SQL statement is used to create a row filter in Databricks?

   • ACREATE ROW POLICY filter_name ON TABLE table_name AS (col STRING) RETURNS BOOLEAN -> ...
   • BCREATE FUNCTION filter_name ON TABLE table_name AS (col STRING) RETURNS BOOLEAN -> ...
   • CCREATE ROW FILTER filter_name ON TABLE table_name AS (col STRING) RETURNS BOOLEAN -> ...
   • DCREATE FILTER filter_name ON TABLE table_name AS (col STRING) RETURNS BOOLEAN -> ...
   Reveal Solution Discussion Select an answer first
2. 17foundation · easy

   Which of the following is a common method to test a masking policy without affecting production data?

   • AChanging the table's owner
   • BRunning the query in a development environment with sample data
   • CDropping the masking policy
   • DDisabling the policy temporarily
   Reveal Solution Discussion Select an answer first
4. 18foundation · easy

   How can you verify that a row filter correctly restricts rows for a specific user group?

   • ABy checking the table's storage location
   • BBy querying the table as a user in that group and checking which rows are returned
   • CBy running a DESCRIBE command on the filter
   • DBy examining the table's schema in the catalog
   Reveal Solution Discussion Select an answer first
5. 19expert · hard

   A company has a table 'employee_data' with columns 'name', 'salary', and 'department'. The compliance team requires that: 1) Users in the 'hr' group see the full salary, but users in the 'manager' group see only a masked salary. 2) Users in the 'manager' group see only employees in their own department, while 'hr' users see all employees. You need to implement both restrictions. What is the best approach?

   • ACreate a view that masks the salary and filters rows, and grant access to the view for both groups.
   • BCreate a single masking policy that masks the salary and also filters rows based on the user's group.
   • CCreate a row filter that filters rows and also masks the salary column in the same function.
   • DCreate a masking policy on the 'salary' column that shows the full value to 'hr' and masks for others, and create a row filter on the table that shows all rows to 'hr' and only the user's department to 'manager'.
   Reveal Solution Discussion Select an answer first
6. 20foundation · medium

   A data engineer has created a row filter function and wants to apply it to an existing table so that only rows matching the filter logic are returned to users. Which SQL statement applies the row filter to the table?

   • ACREATE ROW FILTER sales_filter ON sales (region);
   • BUPDATE TABLE sales SET ROW FILTER = sales_filter (region);
   • CAPPLY ROW FILTER sales_filter TO TABLE sales (region);
   • DALTER TABLE sales ADD ROW FILTER sales_filter ON (region);
   Reveal Solution Discussion Select an answer first