Salesforce Analytics-DA-201 Exam With Confidence Using Practice Dumps

The target visualization shows a subtotal after the members of each Category while retaining the individual Sub-Category rows. In Tableau, Analysis > Totals > Add All Subtotals inserts subtotal rows or columns when multiple dimensions are present on Rows or Columns. Here, Category and Sub-Category are both on Rows, so Tableau can calculate a subtotal for each Category group. Show Column Grand Totals and Show Row Grand Totals create totals for the entire view along the corresponding direction; they do not insert a separate total inside every Category section. Column Totals to Top only changes the placement of existing column totals. Because the requirement is to add a Total row for Furniture, Office Supplies, and Technology individually, Add All Subtotals is the correct command.

The matching-pattern capability is configured in an Input step in Tableau Prep Builder. When connecting to file-based data such as text files or Excel files, Tableau Prep can include multiple files and create an input union by using wildcard or matching-pattern criteria. This allows similarly named files to be combined into a single table as they are brought into the flow. A separate Union step combines already-added tables or inputs, but the question specifically asks where a single table can be created from a matching pattern of multiple file names. Join combines tables based on key fields, while New Rows generates missing sequential records. Because wildcard file matching is part of the file-ingestion configuration, Input is the correct step.