Exam dbt-Analytics-Engineering Topic 1 Question 203 Discussion

Actual exam question for dbt Labs's dbt-Analytics-Engineering exam
Question #: 203
Topic #: 1
You maintain a large dbt project with various reporting models that source data from a set of core business tables. These core tables often include columns with sensitive information. What technique could ensure compliance and maintainability when restricting access to this data?

Suggested Answer: A Vote an answer

Views provide a modular and maintainable way to define access restrictions. This approach centralizes the filtering logic, preventing repeated and potentially inefficient WHERE clauses across models.

by Penelope at Aug 15, 2026, 02:04 PM

Limited Time Offer

15%

Off

Get Premium dbt-Analytics-Engineering Questions as Interactive Self Test Engine or PDF

Comments

Chosen Answer:
This is a voting comment (?) , you can switch to a simple comment.
Switch to a voting comment New
Nick name: Submit Cancel
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
0
0
0
10