Explanation:

When establishing a data connection to a file that stores structured table data using character separators—such as commas (.csv) or tabs (.tsv)—Tableau handles these formats natively through the flat-file parser.

The Core Logic: A .tsv extension stands explicitly for Tab-Separated Values. Despite not using a standard .txt file suffix, it is structurally identical to plain-text layout systems.

The Mechanism: Clicking the Text file connector under the To a File menu prompts a standard Windows explorer dialog. By default, this connector reads and imports text-encoded data frameworks including .txt, .csv, .tsv, and .tab. Once imported, Tableau parses the fields automatically using the tab character as the structural column delimiter.

Why Other Options Are Incorrect:

Microsoft Excel: This interface parses binary spreadsheet container workbooks (.xls, .xlsx, .xlsm) rather than plain, raw text files.

JSON file: This connection wizard scans text organized in serialized hierarchical keys and nested javascript arrays ({ "key": "value" }), which is incompatible with a flat tab-delimited matrix.

Statistical file: This targets custom data structures emitted by statistical software ecosystems, such as SAS (.sas7bdat), SPSS (.sav), and R workspaces (.rdata).

Spatial file: This parses geographic boundary files containing vector maps and polygons, including Esri Shapefiles (.shp), KML, and GeoJSON formats.

References:

Tableau Documentation (Supported File Types): "Text files connection includes comma-separated values (.csv), tab-separated values (.tsv), and plain text (.txt) extensions."

Explanation:

To make a chart dynamically interactive with a parameter, you need to link the parameter to the data so that Tableau knows how to filter the chart.

🟢 Correct Option: B – Add [Region] = [Choose Region] formula to the Filters card
✅ This is a calculated field that compares each row’s Region to the selected value in the Choose Region parameter.
✅ When a user selects a region in the parameter dropdown, only rows matching that region are displayed in the chart.
✅ This approach allows true interactivity, as the chart updates automatically based on user input.
✅ Without this calculated filter, the parameter alone has no effect on the visualization—it’s just a control with values.

Incorrect Options:

🔴 A – Add Region to the Filters card
❌ Simply adding Region to the Filters card allows static filtering only, meaning you must manually select a value each time.
❌ It does not make the chart dynamically respond to the Choose Region parameter.

🔴 C – Add the Choose Region parameter to the Pages card
❌ The Pages card is used for animating or paging through data (like showing each region one at a time).
❌ It does not filter the chart dynamically based on user selection in the way the parameter is intended here.

🔴 D – Set the Choose Region parameter to Single Value (list)
❌ Setting the display type to Single Value (list) only affects how the parameter appears on the dashboard.
❌ Without linking it via a calculated field to the Filters card, it will not filter the chart.

Step-by-Step Approach for Users:
Create the parameter Choose Region with all region values.
Create a calculated field: [Region] = [Choose Region].
Drag the calculated field to the Filters card and select True.
Show the parameter control on the dashboard for user interaction.
Now, users can select any region, and the chart updates dynamically.

Summary:
To make the chart interactive by region, you must create a calculated filter that links the parameter to the field ([Region] = [Choose Region]). Other options either filter statically, animate through data, or only change parameter appearance without filtering.

Reference:
Tableau Official Docs: Create Parameters
Tableau Official Docs: Get Started with Calculations in Tableau

Explanation:

The correct answer is B. Create an extract filter on Store Number and select Condition by field Sales. The requirement is to extract only the data for stores whose total sales are $500 or more. Since a store may have multiple rows of sales transactions in the dataset, the filter must first aggregate sales by store and then apply the threshold. In Tableau, this is achieved by creating an extract filter on the Store Number dimension and selecting the Condition option, then choosing By field and setting the aggregation to SUM(Sales) with the condition "At least 500". This ensures that the extract includes all rows for stores that meet the total sales threshold, while excluding rows for stores that fall below it. This makes option B the correct answer.

Why the other options are incorrect:

A. Create an extract filter on Sales and set the At least value
– Filtering directly on the Sales measure applies the $500 threshold to individual sales transactions, not to the total sales per store. This would exclude individual rows with sales under $500 even if the store's total exceeds $500, which does not meet the requirement.

C. Create an extract filter on Store Number and select Top by field Sales
– The "Top" filter returns a specified number of top-ranked stores (e.g., Top 10 by Sales), not stores meeting a minimum sales threshold. It cannot express the condition "at least $500 in total sales."

D. Create an extract filter on Store Number and select Top by field Store Number
– This filters by the highest Store Numbers rather than by sales values, which is entirely unrelated to the requirement of extracting stores with $500 or more in total sales.

Reference:
Tableau Desktop Specialist and Tableau Data Analyst content areas on Extracts and Data Filtering — specifically creating extract filters, using the Condition filter option on a dimension, applying "By field" aggregation (SUM), and filtering based on aggregated measure thresholds.

Explanation:

When working with dimensions in Tableau, sometimes you need to adjust how values appear in your visualizations without altering the underlying data or creating new fields. This ensures that dashboards remain consistent, user-friendly, and readable while maintaining data integrity. Choosing the right method depends on whether you are changing the field name, individual values, or grouping data.

Correct Option (✅ B. Create aliases):
Aliases allow you to rename individual members of a dimension without creating a new field. For example, “NY” can be displayed as “New York,” or “Q1” as “Quarter 1.” The underlying data remains intact, so any calculations, filters, or joins still work normally. This is ideal for improving dashboard readability, standardizing terminology, or aligning value labels across multiple sheets. (help.tableau.com)

Incorrect Options:

🔴 A. Rename the fields:
This only changes the name of the field in the Data Pane, not the values themselves. So, if you rename “State” to “Region,” the individual members like “NY” or “CA” remain the same. It doesn’t help if you want to change how the values appear in a chart.

🔴 C. Create groups:
Groups are used to combine multiple dimension members into a new category. While this can simplify visualizations, it actually creates a new grouped field, which violates the requirement of not creating a new field. This is more suitable for aggregation rather than simple value renaming.

🔴 D. Transforms the fields:
Transformations (e.g., calculated fields, pivoting, or converting data types) modify data structure or create new fields. They do not simply rename existing dimension values, making them unsuitable for this specific requirement.

Summary:
To update dimension values without creating new fields, always use aliases. Renaming changes only the field name, grouping generates new fields, and transformations modify the dataset. Aliases keep the underlying data intact while improving readability and consistency in Tableau dashboards.

Reference:
Tableau Help: Create Aliases to Rename Members in the View

Explanation

When you need to show how a measure is distributed (spread, central tendency, outliers, skewness) across categories or time, the chart that explicitly displays variability along an axis with clear statistical markers is a box-and-whisker plot.

🟢 Correct Option: B. Box Plot
A Box Plot visually summarizes distribution and variability in one glance:

The box shows the interquartile range (25th to 75th percentile)
The line inside is the median
Whiskers extend to min/max (or 1.5× IQR)
Dots beyond whiskers are outliers
Perfect for comparing variability of a continuous measure (e.g., Sales, Profit, Duration) across categories.

🔴 Incorrect Option: A. Bullet Graph
Bullet graphs are designed for comparing a primary measure against a target and benchmarks (like a gauge alternative). They show performance, not statistical distribution or variability of the underlying data points.

🔴 Incorrect Option: C. Scatter Plot
Scatter plots are excellent for showing relationships or correlation between two continuous measures, or spotting clusters/outliers individually. They do not summarize distribution (median, quartiles, whiskers) in a compact statistical way like a box plot does.

🔴 Incorrect Option: D. Histogram
Histograms show the frequency distribution of a single measure using bins, but they are not placed “along an axis” of categories. They visualize one overall distribution, not side-by-side variability across multiple groups.

Reference:
Tableau Official – Build a Box Plot