Securing Data Questions
Practice questions for Securing Data topic in Databricks Certified Data Analyst Associate. 16 questions covering this domain.
A company stores customer PII data in a Unity Catalog table. The data governance team requires that only users in the `compliance_team` group can see ...
A Databricks data analyst wants to confirm which privileges have been granted on a specific table in Unity Catalog. Which command should they run?
A data analyst needs to enforce that users in a specific group can only see rows in a sales table where the region column matches their own region. Wh...
An analyst accidentally granted SELECT on a sensitive table to the wrong group. Which ANSI SQL command should the administrator use to remove this pri...
Unity Catalog operates on the principle of least privilege. What does this mean in the context of default access for new non-admin users?
In Unity Catalog, which privilege allows a user to query data from a table?
A data engineering team creates a Unity Catalog external table pointing to an S3 bucket managed by the company. The team wants to grant read access to...
A data governance admin wants to ensure that a group of junior analysts can discover the existence of tables in a schema and read their metadata (colu...
A governance team wants most users to see a redacted SSN value while keeping the row visible. Which Unity Catalog feature should they apply?
Why does Databricks recommend ABAC policies for many row-filter and column-mask use cases?
You need a read-only layer that applies filtering logic across multiple source tables for sharing scenarios. Which approach is the best fit?
Junior analysts should be able to discover tables and inspect schema metadata, but they must not read table data. Which least-privilege access pattern...
Which Databricks approach is best when you need a read-only filtered layer spanning multiple source tables for sharing?
A governance team wants most users to see a redacted SSN value while keeping each row visible in query results. Which Unity Catalog feature should the...
What is the main reason Databricks recommends ABAC for many row-filter and column-mask scenarios?
Which least-privilege grants let junior analysts browse schemas and column metadata without letting them query table rows?
Sign in to see all 16 questions
Create a free account to browse all questions — completely free during our launch phase.