Salesforce Certified Tableau Consultant free question 6 / 10 · Domain 2: Plan and Prepare Data Connections
A company's internal Tableau users each have a login in its Microsoft SQL Server, and the DBA has built views with row-level security filters. The users are not in Active Directory. Which method in the comparison matrix fits?
- Impersonation, using embedded SQL Server credentials that can EXECUTE AS users
- An entitlements table with a CONTAINS() calculation in a single-table extract
- Kerberos delegation with Tableau Server joined to the Active Directory domain
- Initial SQL that sets an Oracle VPD session identifier for the signed-in user
Show the answer and explanation
Answer: A
Why this is correct
Microsoft SQL Server can be configured so that its users only have access to views with RLS filters built in, and Tableau takes advantage of this through impersonation. The matrix lists impersonation as useful when every user accessing the data exists as a user in the SQL Server, usually in internal deployments, and security is maintained in one place, the database. Its cons are that every person must exist as a user in SQL Server and that it works only for Microsoft SQL Server.
Why the other options are wrong
"Kerberos delegation with Tableau Server joined to the Active Directory domain" … The matrix lists as requirements that Tableau is configured to use LDAP- Active Directory, that Tableau Server is joined to the AD domain, and that every user exists in the AD domain.
"An entitlements table with a CONTAINS() calculation in a single-table extract" … The matrix lists CONTAINS() with extracts for implementing RLS in extracts prior to version 2018.3, and it maps users in Tableau rather than using the database's security.
"Initial SQL that sets an Oracle VPD session identifier for the signed-in user" … That technique is for Oracle VPD, where the DBA sets up VPD and the users on the database. The security in this company is built in SQL Server.
Key points
For impersonation, either the AD Run-As account or the embedded SQL Server credentials must have permission to EXECUTE AS for the Tableau users, who need SELECT rights on the views.