Salesforce Certified Tableau Consultant free question 5 / 10 · Domain 2: Plan and Prepare Data Connections
A consultant designs the data for row-level security with an entitlements table and a mapping table that links the entitlements to users or roles. How does the page advise combining the entitlement tables before they are joined to the data?
- Hold the mapping table in a separate workbook and link it through a parameter
- Create one data source per user role and publish the sources side by side
- Join the entitlements and the mapping tables into one denormalized entitlements view
- Keep the entitlements and mapping tables normalized and join them when queries run
Show the answer and explanation
Answer: C
Why this is correct
Whichever model represents the entitlements, the page advises joining all entitlements and mapping tables together into a single denormalized entitlements view. Denormalizing is recommended from a performance standpoint because joins are expensive operations. The combined view is then joined with the data. At first this causes a blowup, a highly duplicative version of the entitlements, and the filtering for the user reduces it back down.
Why the other options are wrong
"Keep the entitlements and mapping tables normalized and join them when queries run" … Denormalizing is recommended from a performance standpoint because joins are expensive operations, so the joins are better done once, before the entitlements view meets the data.
"Create one data source per user role and publish the sources side by side" … The page keeps one data source. The entitlements view is joined with the data, and a user-based filter then brings in only the entitlements of the relevant user.
"Hold the mapping table in a separate workbook and link it through a parameter" … Row-level security in Tableau is built on a join between the entitlements view and the data in the same data source. A parameter linking two workbooks is not described.
Key points
Most commonly there are separate tables for the entitlements themselves and for mapping those entitlements to users or user roles.