In a dataset, you have a string field named Name that contains unnecessary semicolons.
Which function should you use to remove the semicolons from the Name field?

• A.TRIM
• B.CONTAINS
• C.REPLACE
• D.SPLIT

Comment: *

Name: *

Email: *

Verification: *

Refer to the exhibit.

You need the top 10 values to appear in a different color. The lop 10 values must be colored dynamically.
What should you do?

• A.Create a group field that groups the top 10 values into one group and the rest of the values into another group. Drag the group field to Color on the Marks card.
• B.Create a set that has a top 10 condition, and then drag the set to Color on the Marks card.
• C.Select the top 10 bars, and then change the color by selecting Color on the Marks card.
• D.Select the lop 10 bars, create a set. and then drag the set to Color on the Marks card.

Comment: *

Name: *

Email: *

Verification: *

From Tableau Desktop you sign in lo a Tableau Server site.
What appears in the list of available data sources when you search for a published data source?

• A.All the data sources published to the site
• B.All the data sources published to the Tableau Server
• C.All the data sources published to the site within the folders to which you have access
• D.All the data sources published to the Tableau Server within the folders to which you have access

Comment: *

Name: *

Email: *

Verification: *

You have a dataset that contains daily sales by business segment from 2017 to the present You want to use monthly historical trends to predict sales by segment in the future Which three actions should you perform m order?
(Place the three correct options in order Use the arrows to move Options lo Answer Area I In Answer Area arrows to re order the options.)

Correct Answer:

Explanation:
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.
References: https://help.tableau.com/current/pro/desktop/en-us/analytics.htm https://help.tableau.com/current
/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/dates.htm
https://help.tableau.com/current/pro/desktop/en-us/analytics_forecast.htm https://help.tableau.com/current/pro
/desktop/en-us/functions_functions_statistical.htm#MODEL_QUANTILE

Comment: *

Name: *

Email: *

Verification: *

Open the link to Book1 found on the desktop. Open the CategoryPercentage worksheet.
Modify the bar chart show the percentage of sales for each Subcategory within every Category. The total percentage for every Category must be 100%.

Comment: *

Name: *

Email: *

Verification: *