Explanation

The correct answer is C. Bins. In Tableau, bins are used to divide a continuous measure (such as salary) into equal-sized intervals or "buckets." When an analyst creates a bin on a numeric field, Tableau generates a new discrete dimension that groups the measure values into ranges of equal width (e.g., $10,000 increments). This allows the analyst to visualize the distribution of values across the range using a histogram. This makes option C the correct answer.

Why the other options are incorrect:

A. Group
– A group combines discrete dimension members into categories based on manual selection or patterns (e.g., grouping specific job titles). Groups do not divide continuous measures into equal numeric intervals.

B. Hierarchy
– A hierarchy organizes fields into levels of granularity (e.g., Category > Sub-Category > Product Name) for drill-down analysis. It does not create equal intervals for numeric measures.

D. Set
– A set defines a subset of data based on a condition (e.g., top 100 salaries or salaries above a threshold). Sets are used for filtering and comparison, not for creating equal-width bins across a range.

Reference:

Tableau Desktop Specialist and Tableau Data Analyst content areas on Data Preparation and Visualizations — specifically creating bins from continuous measures, equal-interval binning, and using bins to build histograms for distribution analysis.

Explanation

The correct answer is A. Pronunciation. In Tableau Prep Builder, the "Pronunciation" grouping option uses a phonetic algorithm (such as Metaphone or Soundex) to group values that sound alike when pronounced, even if they are spelled differently or formatted differently. In this dataset, all five values — "Charles Sheldon", "charles,sheldon", "Sheldon charles", "Charles.Sheldon", and "Charles_Sheldon" — represent the same name, differing only in case, order, punctuation, or spacing. The Pronunciation grouping method normalizes these variations by evaluating how the names sound, allowing Tableau Prep to automatically group them as a single entity. This makes option A the correct answer.

Why the other options are incorrect:

B. Common Characters
– The Common Characters option groups values that share a high percentage of the same characters. While the names share many letters, the variation in order (e.g., "Sheldon charles" vs. "Charles Sheldon") and punctuation would prevent reliable automatic grouping. This method is better suited for values with minor character-level typos, not structural rearrangements.

C. Manual Selection
– Manual Selection requires the analyst to manually select and group values one by one. The question specifically asks for an option that groups all five names automatically, so manual selection does not meet the requirement.

D. Spelling
– The Spelling option groups values based on similar spelling using edit distance (e.g., Levenshtein distance). While it can handle minor typos, it does not account for reordered words or different separators (commas, periods, underscores) as effectively as Pronunciation. "Sheldon charles" has a different word order, which spelling-based grouping may not resolve automatically.

Reference:

Tableau Prep Builder content areas on Grouping and Cleaning Data — specifically the automatic grouping options (Pronunciation, Common Characters, and Spelling) and their use in standardizing name values that differ in formatting, order, or punctuation.

Explanation

The correct answer is D. Select only values that appear in the data whenever the data refreshes. When configuring a parameter in Tableau, the "When workbook opens" option is found in the Allowable Values section of the parameter creation dialog. This option dynamically populates the parameter's list of allowable values from a specified field in the data source each time the workbook is opened. This means the user can select from values that are current and present in the data at the time of opening, reflecting any updates or refreshes that have occurred since the workbook was last saved. This ensures the parameter list stays synchronized with the underlying data. This makes option D the correct answer.

Why the other options are incorrect:

A. Select only values that appeared in the data when the parameter was created
– This describes the behavior of a static list of allowable values that is manually entered or copied at the time of parameter creation. The "When workbook opens" option specifically refreshes the values dynamically, so the list is not limited to values from creation time.

B. Type any value into the parameter
– This describes the "All" option under Allowable Values, which permits free-form text entry. The "When workbook opens" option restricts the user to a predefined list drawn from the data field, not arbitrary typed input.

C. Select any value between a fixed range of 1 to 100
– This describes the "Range" option under Allowable Values, where a minimum and maximum numeric range is defined. It is unrelated to the "When workbook opens" setting, which pulls values from a data field.

Reference:

Tableau Desktop Specialist and Tableau Data Analyst content areas on Parameters — specifically the Allowable Values section, the "When workbook opens" option, and how dynamic parameter value lists are populated from data source fields upon workbook opening.

Explanation

The correct answers are C. Revenue and E. Quantity. The requirement is to analyze the "average revenue per item sold" across different regions over time. "Revenue per item" is a ratio measure calculated by dividing total revenue by the quantity of items sold. Therefore, the analyst needs to measure the Revenue field (to determine total revenue) and the Quantity field (to determine the number of items sold). The calculation would be `SUM([Revenue]) / SUM([Quantity])`, which yields the average revenue per item. These two measures provide the numerical values required for the analysis. This makes options C and E the correct answers.

Why the other options are incorrect:

A. Product Name
– Product Name is a text dimension that identifies the product. It is useful for grouping or filtering data, but it is not a measure and does not contribute to calculating average revenue per item.

B. Customer Region
– Customer Region is a geographical dimension used to group data by region. While the analysis is performed "in different regions," the region field itself is used for grouping or slicing the view, not as a measure to be aggregated.

D. Order Date
– Order Date is a date dimension used to define the "over time" aspect of the analysis. It is used for trending or grouping by time period, but it is not a measure and does not contribute to the revenue-per-item calculation.

Reference:

Tableau Desktop Specialist and Tableau Data Analyst content areas on Dimensions and Measures — specifically distinguishing measures (numeric, aggregatable fields such as Revenue and Quantity) from dimensions (categorical or date fields used for grouping and filtering), and applying them in calculated ratios.

Explanation

The correct answer is D. Input. In Tableau Prep Builder, the Input step is where a data analyst connects to data sources and configures how files are read into the flow. When working with multiple files, the Input step provides a "Wildcard union" option that allows the analyst to specify a matching pattern (such as "Sales_*.csv" or "2024*") to automatically combine multiple files with similar names into a single table. This eliminates the need to manually add each file individually and is the appropriate step for consolidating files based on a naming pattern. This makes option D the correct answer.

Why the other options are incorrect:

A. New Rows
– The New Rows step is used to add new rows of data manually within Tableau Prep Builder, typically for testing or filling in missing data. It does not combine multiple files based on file name patterns.

B. Join
– A Join step combines two or more existing tables based on matching field values (keys) rather than file names. Joins operate on columns within already-connected data sources, not on file naming patterns.

C. Union
– While a Union step does combine multiple tables by stacking rows, it requires the tables to already be present in the flow as separate inputs. It does not automatically detect or match files based on name patterns. The wildcard pattern matching functionality exists within the Input step, not the Union step itself.

Reference:

Tableau Prep Builder content areas on Connecting to Data — specifically the Input step, Wildcard Union functionality, and the use of search patterns to combine multiple files with matching names into a single table.