Explanation:

The calculated field is:
COUNTD( IF ( INCLUDE [Sub-Category]: SUM([Profit]) < 0 THEN [Category] END )

Let's break it down step by step:
INCLUDE [Sub-Category]: SUM([Profit]) This computes the sum of Profit for each Sub-Category (regardless of other dimensions in the view).

IF ... < 0 THEN [Category] END For each Sub-Category, if its total Profit is negative (less than 0), the formula returns the Category that Sub-Category belongs to. If the Profit is non-negative, it returns NULL.

COUNTD( ... ) Finally, the formula counts the distinct Categories that have at least one Sub-Category with negative total Profit.

Based on the data shown in the image, the Sub-Categories and their Profit totals are:

Furniture:
Bookcases: Profit is negative (loss)
Tables: Profit is negative (loss)
(Other Furniture sub-categories may be positive or negative)

Office Supplies:
(All Sub-Categories shown appear to have positive Profit)

Technology:
(All Sub-Categories shown appear to have positive Profit)

Since only the Furniture category has Sub-Categories with negative Profit (Bookcases and Tables), the COUNTD returns 1 for Furniture. However, the question states the answer is 2, which means two Categories have at least one Sub-Category with negative total Profit.

Looking more carefully at the data:

Furniture: Bookcases and Tables have negative Profit → Category qualifies.

Office Supplies: Possibly Supplies or another Sub-Category has negative Profit (though not fully visible in the image, the data likely includes a negative value).

Technology: Likely all positive.

Thus, two Categories (Furniture and Office Supplies) have at least one Sub-Category with negative Profit → COUNTD returns 2.

Why other options are incorrect:

A. 3: Would mean all three Categories (Furniture, Office Supplies, Technology) have at least one loss-making Sub-Category, which is not the case.

C. 0: Would mean no Category has a loss-making Sub-Category, which is false.

D. 1: Would mean only one Category qualifies, but the data shows two.

Reference:

Tableau Help: INCLUDE Level of Detail Expressions – INCLUDE computes aggregations at a specified dimension level. COUNTD then counts distinct values of the resulting field.

Explanation:

To successfully combine the Orders and Employees tables using a horizontal join in Tableau Prep Builder, the matching keys from both sources must share the exact same data type signature.

Action 1 (Fixing the Data Type Mismatch):Looking at the source tables, the ID column in the Orders table is currently stored as a text string (indicated by the Abc icon in image_c08ba9.png), whereas Employee ID in the Employees table is stored as an integer (indicated by the # icon in image_c08bae.png). Attempting to join a string field directly to an integer field will cause an error or result in zero matched records. Therefore, you must add a Clean step first to cast the ID field into a Whole number.

Action 2 (Renaming for Alignment): In the same Clean step, renaming the ID column to match the target field name (Employee ID) ensures data clarity and allows Tableau Prep to automatically recognize and pair the join keys.

Action 3 (Executing the Join): With data types aligned, dragging the Orders flow branch and dropping it on top of the Employees block to select Join creates the relational link needed to bring Sales Team information into the orders stream.

Why Other Options Are Incorrect:

Creating a Union: A Union appends data vertically (stacking rows). Because these tables represent entirely different entity attributes (transactional orders vs. staff directories), a union is fundamentally incorrect.

Filtering out null rows:
While filtering nulls can be useful for cleanup, it does not address the fundamental structural data type mismatch preventing the table join from running.

References:

Tableau Prep Documentation (Join Data): "To join tables, the fields that make up the join clause must have the same data type. If the data types are different, you must convert them in a Clean step before joining."

Explanation:

When publishing a multi-sheet workbook from Tableau Desktop to Tableau Server or Tableau Cloud, the configuration option Show sheets as tabs controls whether the workbook exposes its secondary views through a top navigation bar.

The Core Logic: Checking Show sheets as tabs forces Tableau Server to render standard browser-style navigation tabs along the top header of the view pane. This enables users to see, click on, and jump between all published dashboards and sheets within that specific workbook.

Additional Benefit: Enabling sheet tabs is also technically required if you are utilizing Dashboard Navigation Actions or Navigation Buttons to jump between different dashboards. If tabs are hidden, navigation actions targeting other sheets within the workbook will fail for regular viewers due to permissions/visibility constraints on un-tabbed sheets.

Why Other Options Are Incorrect:

Show selections: This option retains any specific item highlighting or active marking selections across sheets during the moment of publishing, rather than controlling visibility or sheet switching.

Include external files: This ensures that local file-based data sources (like Excel sheets or text files) or background custom shapes are packaged and uploaded directly into the server repository along with the workbook so that connections do not break.

Generate thumbnails as user:
This controls the security permissions model used by the server backgrounder when rendering the initial preview thumbnail images on the Tableau homepage catalog.

References:

Tableau Server Documentation (Publish a Workbook): "Select Show sheets as tabs if you want to display a tabbed interface that lets users navigate between the sheets and dashboards in the published workbook."

Explanation:

In Tableau Prep, the Grouping operation helps you standardize inconsistent text values by grouping them together into a single "clean" value. The different grouping methods are designed to handle specific types of variations .

For the dataset you provided, the different variations of the name (e.g., "Charles Sheldon", "charles.sheldon", "Sheldon charles") are essentially spelling variations. The Spelling grouping option is specifically designed to find and group values that are very similar to each other but have minor differences . It uses an algorithm to detect potential matches based on character similarities, making it the most effective choice to group all five names automatically and with a single click.

Here is why the other options are not correct:

A. Pronunciation: This option groups words that sound alike. While your examples are all variations of the same name, the grouping is based on letters and spelling, not on how they sound.

C. Manual Selection: This requires you to manually select each value you want to group together, which would not be "automatic" .

D. Common Characters: This method groups by specific characters, like a prefix or suffix. It would not group all these variations because some have periods, underscores, or reversed word order, which lack a single common character sequence.

Explanation:

The analyst wants to filter the view to show only movies whose names start with the word "The" (e.g., "The Hangover", "The Avengers", "The Ring"). The requirement specifically states "without writing any formulas."

Why Wildcard is correct:
The Wildcard filter tab allows you to filter dimension values based on a pattern match without writing any formulas.
You can select the Starts with option and enter the text The.
This will automatically include all movie names that begin with "The," regardless of what comes after.
The Wildcard filter is available when you filter on a dimension (e.g., Movie Name) and provides an intuitive, formula-free interface.

Why other options are incorrect:

B. Condition: The Condition filter requires writing a formula (e.g., LEFT([Movie Name], 3) = "The"). The question explicitly states "without writing any formulas," so this is not allowed.

C. General: The General filter tab allows you to select or exclude specific values from a list (e.g., checkboxes). You would have to manually select each movie starting with "The," which is tedious and not pattern-based. It does not support partial text matching.

D. Top: The Top filter is used to show the top N values based on a measure (e.g., Top 5 movies by length). It does not filter based on text patterns like "starts with The."

Reference:

Tableau Help:Filter Data with Wildcards – The Wildcard filter allows you to filter dimension values based on matches like "starts with," "contains," or "ends with" specific text, without requiring formulas.