Ensuring Data Security and Compliance Questions
Practice questions for Ensuring Data Security and Compliance topic in Databricks Certified Data Engineer Professional. 20 questions covering this domain.
A company has a single large orders table in Unity Catalog shared across regional business units. Each team should only see orders from their own regi...
Why are service principals preferred over personal access tokens (PATs) from a user account for automated production Databricks workflows?
A data engineer creates a column mask for the `salary` column on an HR table. The mask should return `NULL` for all users who are NOT members of the `...
What is the correct three-level namespace for referencing a table in Unity Catalog?
A data team needs to ensure that users outside the `finance_admin` group see only the last 4 digits of an `account_number` column (displayed as `****X...
In Unity Catalog, what is the difference between a managed table and an external table with respect to data deletion?
A data engineer creates a Delta Sharing share and adds a large partitioned table. They want to allow recipients to filter data by `region` at the shar...
A Unity Catalog admin wants to restrict a table so that a user can only see rows where `country = 'US'` based on their account group membership. The a...
A data engineer needs to create a connection in Unity Catalog to allow Lakehouse Federation queries against an external PostgreSQL database. Which pri...
A data engineer needs to grant a group of analysts read-only access to all current and future tables created in the schema `main.reporting`. Which Uni...
Which kind of function defines a Unity Catalog row filter?
A governance team wants centrally managed row filters and masks that table owners cannot override one by one. Which approach does Databricks recommend...
A row-filter UDF parameter is declared as `INT`, but the table column passed into it is `STRING`. ANSI mode is disabled. What risk does the documentat...
A table has row-filter or column-mask policies that use nested expressions and non-deterministic logic. Which statement about `MERGE` is correct?
What requirement must a column-mask SQL UDF satisfy with respect to the masked column?
A sensitive table has row-filter or column-mask policies that use nested expressions and non-deterministic logic. Which statement about `MERGE` is cor...
A governance team wants centrally managed row filters and column masks that table owners cannot override one table at a time. Which approach does Data...
A team drops two Unity Catalog tables: one managed and one external. Which statement is correct?
A Unity Catalog admin defines a column mask for an email column. What must be true about the masking SQL UDF?
A row-filter UDF parameter is declared as `INT`, but the table column passed into it is `STRING` and ANSI mode is disabled. What risk does Databricks ...
Sign in to see all 20 questions
Create a free account to browse all questions — completely free during our launch phase.