Free Practice Questions for Salesforce Analytics-DA-201 Exam

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

FIXED is the Level of Detail scoping keyword designed to compute an aggregation using explicitly specified dimensions without reference to the dimensions currently present in the view. For regional totals, an expression such as {FIXED [Region] : SUM([Sales] )} calculates sales at the Region level even when the visualization includes additional dimensions such as State or Customer. INCLUDE adds a dimension to the view’s level of detail, while EXCLUDE removes specified view dimensions; both therefore depend on the view context. SUM by itself is a standard aggregate and operates at the current visualization level of detail. Because the requirement states that total regional sales must be calculated regardless of what is in the view, FIXED provides the necessary view-independent level of detail.

Selecting Publish as Data Source on a Tableau Prep output step causes the output of that step to be published as a Tableau data source on Tableau Server or Tableau Cloud. Tableau’s current interface refers to this destination as a Published data source, while older versions used the wording shown in the question. The analyst chooses the target server or site, project, and output name. This is different from publishing the Prep flow itself: a flow and its output data source are separate Tableau content objects. It also does not simply save the output locally or write the resulting data directly back to the originating database. Consequently, option D correctly distinguishes publishing the output as a reusable server-based data source from publishing the entire flow.

Publishing a new data source from Tableau Desktop requires publishing rights that are available with a Creator site role, together with the necessary project capabilities. Tableau documents Creator as the site role that provides full connection and publishing access from Tableau Desktop, including the ability to create and publish data sources, workbooks, and flows. Server administrator rights are not required for ordinary publishing. A Tableau Public account applies to Tableau Public rather than publishing governed content to Tableau Server or Tableau Cloud. View permission alone is also insufficient because viewing an existing project or workbook does not grant the Save and publish capabilities needed to create a new published data source. Therefore, among the listed choices, a Creator site role is the required condition.

The correct order of the three actions is:

Add the date to the Columns shelf. Add the segment and the sales to the Rows shelf.

Aggregate the date to month and year.

From the Analytics pane, drag Forecast to the worksheet.

The first action is to add the date to the Columns shelf and the segment and the sales to the Rows shelf. This will create a line chart that shows the daily sales by segment over time. You can use the Show Me menu to choose a line chart if it is not selected by default.

The second action is to aggregate the date to month and year. This will group the daily sales into monthly sales and show the yearly trend. You can right-click on the date field on the Columns shelf and select Month (January 2017) from the menu. You can also drag Year from the Dimensions pane to the Columns shelf before or after Month.

The third action is to drag Forecast from the Analytics pane to the worksheet. This will add a forecast that predicts future sales by segment based on historical trends. You can customize the forecast by clicking on it and using the options on the Marks card.

The other options are not relevant for this scenario. Adding a trend line would show a linear or nonlinear relationship between two measures, but not a prediction of future values. Creating a calculated field that uses the model quantile function would return a value from a statistical model based on a given quantile, but not a forecast.

Tableau Desktop controls the presentation of printed worksheets through File > Page Setup. The Page Setup dialog contains print-specific settings that are independent of whether the worksheet title is currently visible in the interactive workbook. Under the General settings, Tableau provides a Show section where the analyst can choose whether printed output includes the worksheet title, view, captions, and legends. Therefore, if a hidden title unexpectedly appears in PDF output, the analyst should open Page Setup and disable the title for printing. Export As PowerPoint creates a different output format and does not configure PDF print elements. Share and Export As Version likewise do not control printed worksheet titles. Tableau’s current printing documentation identifies Page Setup as the location for showing or hiding worksheet titles in printed output.