Salesforce Certified Tableau Consultant Practice Questions

Salesforce Certified Tableau Consultant exam preparation

Salesforce Certified Tableau Consultant practice questions in English: 180 questions with explanations. The mock exam has 60 questions and 105 minutes.

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?

  1. Impersonation, using embedded SQL Server credentials that can EXECUTE AS users
  2. An entitlements table with a CONTAINS() calculation in a single-table extract
  3. Kerberos delegation with Tableau Server joined to the Active Directory domain
  4. 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.

Go to the Salesforce Certified Tableau Consultant practice app (10 free questions; purchase unlocks all questions)

See the full practice set