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 4 / 10 · Domain 2: Plan and Prepare Data Connections

In a Tableau Prep flow, an inner join between Customers and Sales leaves out rows whose customer names differ only in capitalization and extra spaces. What does the documentation suggest?

  1. Fix the values in the join clauses, or clean the excluded values, so they match
  2. Remove the join and aggregate the tables to one row per customer
  3. Change the join type to full so the mismatched names are matched
  4. Replace the join with a union step so the mismatched rows are appended to Sales
Show the answer and explanation

Answer: A

Why this is correct
Tableau Prep reads values as not matching, and leaves them out of the join, when they differ in capitalization, spelling, extra separators, or extra spaces. The page says you can fix mismatched values right in the join clause, or work with the excluded values by clicking the Excluded bars in the Summary of Join Results and using the cleaning operations in the profile card menu.

Why the other options are wrong
"Replace the join with a union step so the mismatched rows are appended to Sales" … A union appends the rows of tables that have matching fields. It does not make the values of a join key match.
"Change the join type to full so the mismatched names are matched" … A full join includes all values from both tables, with nulls where there is no match. The names still do not match, and the cleaning is still needed.
"Remove the join and aggregate the tables to one row per customer" … An aggregate step adjusts the granularity of the data. Names that differ in capitalization or spaces still count as different values after it.

Key points
The Summary of Join Results shows the values that are included and excluded, and the edits you make are tracked in the Changes pane of the join step.

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

See the full practice set