Tableau Data Analyst Analytics-DA-201 Syllabus Exam Questions Answers

To create the dashboard as shown in the image, you need to use a vertical layout container that will adjust the height of the sheets according to the window size. You also need to set the Fit to Entire view option for both sheets so that they will resize proportionally when you click a category on the top sheet. This way, you can achieve the desired effect of having the bottom sheet expand to fill the space left by the top sheet when it filters out some categories. References:

Size and Lay Out Your Dashboard - Tableau

Create a Dashboard - Tableau

Format Dashboard Layout in Tableau - GeeksforGeeks

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.

A full outer join preserves every row from both physical tables, returning matched records where possible and null values where a corresponding row does not exist. That directly satisfies the requirement to retain books that appear in only one of the two incomplete tables. A Tableau relationship can also satisfy the requirement because relationships keep logical tables separate and defer physical joining until analysis time. Tableau dynamically determines the appropriate joins based on fields used in the visualization and makes the row and column data from related tables potentially available without permanently collapsing the tables. Left or right joins would discard unmatched rows from one side, while an inner join retains only matches. Therefore, Full outer join or Relationship model is the correct combination.