Explanation

The correct answer is D. Page Setup. In Tableau Desktop, the "Page Setup" option under the File menu controls how a worksheet or dashboard is printed and exported to PDF. Within the Page Setup dialog, there is a "Show Selections" section that includes checkboxes for "Show title," "Show view," "Show legends," and "Show captions." To prevent the worksheet title from appearing when printing as a PDF, the analyst must uncheck the "Show title" option. This ensures that the title, even if hidden on the worksheet itself, is excluded from the printed output. This makes option D the correct answer.

Why the other options are incorrect:

A. Export As PowerPoint
– This option exports the worksheet to a PowerPoint file format. It does not control the print or PDF export settings, including whether the worksheet title appears.

B. Share
– The Share option is used to publish the workbook or worksheet to Tableau Server or Tableau Cloud. It does not configure print layout settings or PDF export options.

C. Export As Version
– This option is used to save the workbook as a previous version of Tableau. It does not affect the appearance of the worksheet when printed or exported to PDF.

Reference:

Tableau Desktop Specialist and Tableau Data Analyst content areas on Printing and Exporting — specifically the Page Setup dialog under the File menu, the "Show Selections" options, and configuring whether the worksheet title appears in printed or PDF output.

Explanation

The correct answer is D. Use the Custom Split option and specify a space as the delimiter. In Tableau, the "Custom Split" feature allows the analyst to split a single field into multiple new fields based on a specified delimiter. Since FullName contains names separated by spaces, using the space character (" ") as the delimiter will divide the names into separate fields. By configuring the Custom Split to split on all occurrences of the space, Tableau will generate up to three fields: one for the first name, one for the middle name (which will be null for names without a middle name), and one for the last name. This approach minimizes manual effort because Tableau automatically handles the varying number of name parts. This makes option D the correct answer.

Why the other options are incorrect:

A. Use Data Interpreter
– The Data Interpreter is a feature that cleans up messy Excel and CSV files by detecting and removing headers, footers, and extra tables. It does not split fields into multiple columns based on delimiters.

B. Use the Custom Split option for the first name and the last name and create a calculated field for the middle name
– This approach requires unnecessary manual steps. It would require multiple Custom Split operations plus an additional calculated field for the middle name, which increases effort rather than minimizing it. A single Custom Split on the space delimiter handles all three fields at once.

C. Use the Split option
– The standard "Split" option in Tableau's Data Source page splits fields based on a predefined set of common delimiters (such as commas, spaces, and semicolons) but uses a default split behavior that may not fully separate all name parts correctly (e.g., it may split into a fixed number of fields without allowing customization of the delimiter). The "Custom Split" option provides more control by allowing the analyst to specify the exact delimiter (space) and the number of splits.

Reference:

Tableau Desktop Specialist and Tableau Data Analyst content areas on Data Preparation — specifically the Custom Split feature, specifying delimiters to separate fields, and minimizing manual effort when parsing name fields with variable numbers of components.

Explanation

The correct answer is C. Only the data sources the user has the Connect permission to. When a user connects to a published data source on Tableau Cloud or Tableau Server, Tableau enforces permission-based access control. The user will only see and be able to connect to data sources for which they have been granted the "Connect" permission (or higher capabilities that include Connect). This ensures data security and governance by preventing users from accessing data sources they are not authorized to use. This makes option C the correct answer.

Why the other options are incorrect:

A. Only the data sources the user has created themselves previously
– Users can connect to published data sources created by other users, provided they have the appropriate permissions. The list is not limited to the user's own creations.

B. Only certified data sources
– Certification is a governance indicator that marks a data source as trusted and approved. While certified data sources are highlighted with a badge, non-certified data sources are also displayed if the user has Connect permission. Certification does not restrict visibility.

D. Only data sources in the user's home directory
– Published data sources are typically stored in project folders, not just the user's home directory. Restricting visibility to the home directory would prevent collaboration and sharing. Access is governed by project-level permissions, not just home directory location.

Reference:

Tableau Desktop Specialist and Tableau Data Analyst content areas on Connecting to Data — specifically connecting to published data sources on Tableau Cloud/Server, permission-based visibility, and the Connect permission as the gatekeeper for data source access.

Explanation:

To add a specific comment to a data point—like March 2020 on a line chart—you use annotations in Tableau. An annotation allows you to call out important events, outliers, or milestones directly on the chart. In this case, you might want to highlight something significant that happened in March 2020 (e.g., a drop in sales due to COVID-19).

To do this:

➡️ Right-click on the data point for March 2020 in the line chart.
➡️ Select "Annotate" → choose "Mark", "Point", or "Area" depending on the context.
➡️ Enter your comment in the annotation box that appears.

This will visually anchor the note to that specific part of the chart, making it clear and informative for viewers.

❌ Why the other options are incorrect:

A. Drag the growth rate to Text on the Marks card: This would display numerical values as labels on the chart, not explanatory comments. It’s for data labeling, not annotation.

B. Enable captions: Captions add a description below the chart for the whole worksheet—not for a specific data point. This wouldn’t help you comment on just March 2020.

D. Add a tooltip: Tooltips appear on hover, not as visible comments on the chart. Also, they don’t persist unless the user interacts with the chart.

📘 Tableau Reference:
"You can annotate a point, an area, or a mark to help explain data in your view."
🔗 Tableau Docs – Annotate Views

Explanation

The correct answer is C. New Rows. In Tableau Prep Builder, the "New Rows" step is specifically designed to handle missing or incomplete data by generating additional rows. When dealing with date-based data that has gaps (missing days), the analyst can use the New Rows step to create a scaffold of dates between a specified start and end date. This ensures that every day in the range is represented, even if no event occurred on that day. The generated rows can then be joined or unioned with the original dataset, and null values can be filled appropriately. This makes option C the correct answer.

Why the other options are incorrect:

A. Union
– A Union step combines multiple tables by stacking rows, typically used when the same schema exists across multiple files or tables. It does not generate new rows to fill date gaps within a single table.

B. Pivot
– A Pivot step reshapes data by converting columns into rows or rows into columns (wide-to-tall or tall-to-wide). It changes the structure of existing data but does not create new rows to fill missing dates.

D. Aggregate
– An Aggregate step summarizes data by grouping and calculating values (e.g., SUM, COUNT, AVG). It reduces the number of rows and cannot add missing rows to fill gaps in a date sequence.

Reference:

Tableau Prep Builder content areas on Data Preparation — specifically the New Rows step, its use in generating rows for missing dates or values, and its application in creating complete date scaffolds for time-based analysis.