You have the following data source in tableau Server. You need to ensure that the data is updated every hour. What should you select?
Correct Answer: B
To ensure that the data is updated every hour, you need to select Extract Refreshes from the data source menu on Tableau Server. This will allow you to add a new extract refresh schedule or edit an existing one. You can specify the frequency and time of the refresh, as well as any custom options or credentials. New will create a new data source, Connected Workbooks will show you which workbooks use this data source, and Connections will show you which tables or files are connected to this data source. Reference: https://help.tableau.com/current/server/en-us/refresh_extracts.htm https://help.tableau.com/current/server/en-us/refresh_extracts_add.htm
Question 92
You have the following chart that shows profits and discounts over time. You need to combine the lines to appear as shown in the following chart. What should you do?
Correct Answer: C
Question 93
You have the following visualization. You want the count of Returns displayed only for the first year in the table. How should you complete the formula in the calculated field? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
Correct Answer:
Question 94
You have the following bar chart. You want the chart to appear as shown in the Mowing exhibit. What should you add?
Correct Answer: D
A reference band is a shaded area that shows a range of values on an axis. You can use a reference band to highlight a target range, a confidence interval, or a standard deviation. In this case, you want to add a reference band that shows the range of values from 0 to 100 on the y-axis. This will create a shaded area behind the bars that indicates the percentage of sales. To add a reference band, you need to do the following steps: Click on the Analytics tab on the left side of the workbook to open the Analytics pane. You will see a list of analytical objects that you can drag and drop onto your worksheet. Drag Reference Band from the Analytics pane to Y-Axis on the worksheet. This will add a reference band on the y-axis that shows the average and confidence interval for all values. Click on the Edit button on the reference band to open the Edit Reference Band dialog box. You will see options to customize your reference band. Change the Band From value to 0 and the Band To value to 100. This will change the reference band to show the range of values from 0 to 100 on the y-axis. Click OK to apply the changes. You will see that the reference band now shows a shaded area behind the bars.
Question 95
You have the following dashboard that contains two visualizations. You want to show only one visualization at time. Users must be able to switch between visualizations. What should you me?
Correct Answer: C
In Tableau, you can manage the visibility of different visualizations on a dashboard using various techniques. Among the options provided, the most straightforward method to allow users to switch between two visualizations is to use show/hide buttons. Here's why each option is or isn't suitable for the requirement: A). A parameter and a calculated field: While it's possible to use a parameter and a calculated field to control which visualization is displayed, it requires creating a calculated field that responds to a parameter and then using that field to filter the view. This method can become complex and is not as user-friendly for simply showing and hiding visualizations. B). Worksheet actions: Worksheet actions in Tableau typically allow users to interact with the data within a visualization, such as filtering data or highlighting related data points when clicking or hovering. They are not designed to control the visibility of entire visualizations on a dashboard. C). Show/hide buttons: Show/hide buttons are a feature specifically designed to manage the visibility of dashboard elements. When you create a show/hide button, it can be configured to display or hide a particular visualization, container, or any other dashboard element when clicked. This provides a very intuitive interface for users to switch between visualizations. D). Dashboard actions: Dashboard actions, like worksheet actions, are used to create interactions between sheets, such as filtering data or navigating to other sheets or URLs based on user interactions. They are not intended for toggling the visibility of visualizations. Therefore, the correct answer is C. Show/hide buttons as they provide a user-friendly way to switch between visualizations on a dashboard without the need for complex calculations or actions that aren't meant for this purpose. The show/hide button feature is specifically designed for toggling visibility and offers a simple and effective solution for the requirement.
