Updated Feb-2026 Premium Analytics-DA-201 Exam Engine pdf - Download Free Updated 176 Questions
Authentic Analytics-DA-201 Dumps With 100% Passing Rate Practice Tests Dumps
Salesforce Analytics-DA-201 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
NEW QUESTION # 84
You have a database that includes field named sales, City and Region.
You have the following chart that shows the number of sales made in different cities.
You want to dynamically show the corresponding region when users hover their mouse over any of the bars.
What should you do?
- A. Edit the aliases for City.
- B. Right-click a bar in the chart select Mark Label and then select Always show.
- C. Drag Region to Tooltip on the Marks card
- D. Right-click a in the chat, select Annotate and then select Mark.
Answer: C
Explanation:
To show the corresponding region when users hover their mouse over any of the bars, you need to drag Region to Tooltip on the Marks card. This will add Region as a field in the tooltip text that appears when users hover over a mark. You can also customize the tooltip text by editing it in the Tooltip dialog box.
References: https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/formatting_tooltips.htm To show additional information such as the corresponding region when hovering over a bar in Tableau, you can drag the 'Region' field to the 'Tooltip' shelf on the 'Marks' card. This will ensure that when a user hovers over a bar representing a city, the tooltip will dynamically display the region associated with that city.
NEW QUESTION # 85
A Data Analyst has the following chart that shows the cumulative volume of sales from various dates.
The analyst wants the months to appear as shown in the following chart.
What should the analyst do?
- A. Convert the date to Exact Date
- B. Convert the date to Attribute
- C. Change the Sort Order
- D. Convert the date to Continuous
Answer: D
NEW QUESTION # 86
You create a worksheet named Sales by Region and hide the tide of the worksheet. You print the worksheet as a PDF and notice that the worksheet title appears. You need to prevent the title from appearing when you print the worksheet as a PDF. Which settings should configure from the File menu in Tableau Desktop?
- A. Share
- B. Export As PowerPoint
- C. Export As Version
- D. Page Setup
- E. Print
Answer: D
NEW QUESTION # 87
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?
- A. Dashboard actions
- B. Worksheet actions
- C. A parameter and a calculated filed
- D. Show/hide buttons
Answer: D
Explanation:
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.
NEW QUESTION # 88
A Data Analyst has a large data source that contains more than 10 million rows. Users can filter the rows by a field named Animal.
The following is a sample of the data.
The analyst wants to ensure that every calculation is affected by including only animals of a particular type.
Which type of filter should the analyst create on the worksheet?
- A. Table calculation
- B. Extract
- C. Context
- D. Measure
Answer: C
NEW QUESTION # 89
The following table displays the row-level data in a Tableau data source:
A Data Analyst creates this calculated field:
SUM(IF [Item] = 'A' THEN [Sales] END) / COUNT([Order ID])
What is the result of this aggregate calculation?
- A. An error
- B. 0
- C. 1
- D. 2
Answer: B
NEW QUESTION # 90
You publish a dashboard that uses an extract. The extract refreshes every Monday at 10:00.
You need to ensure that the extract also refreshes on the last day of the month at 18:00.
What should you do?
- A. From Tableau Server, select Schedules, and change the priority of the existing schedule.
- B. From Tableau Desktop, open the Publish Workbook dialog box and configure the schedule.
- C. From Tableau Server, select the workbook, select Refresh Extracts, and then add a new extract refresh.
- D. From Tableau Server, select Schedules, find the schedule of the extract, and change the frequency to the last day of the month.
Answer: C
Explanation:
To ensure that the extract also refreshes on the last day of the month at 18:00, you need to add a new extract refresh task to the workbook on Tableau Server. You can do this by selecting the workbook, selecting Refresh Extracts, and then choosing Schedule a Refresh. You can then select an existing schedule that matches your desired frequency and time, or create a new schedule with a custom frequency and time. This will add a new extract refresh task to the workbook, in addition to the existing one that refreshes every Monday at 10:00. You can also modify or delete the extract refresh tasks as needed. References:
* Tableau Certified Data Analyst Exam Prep Guide, page 10, section "Publishing and Scheduling Data Refreshes"
* Tableau Help: Refresh Data on a Schedule
* Tableau Help: Manage Refresh Tasks
NEW QUESTION # 91
You have the following two datasets:
* A Microsoft Excel worksheet that has two columns named Employee Name and Department
* A Microsoft SQL Server table that has three columns named Employee Name. Pay Grade and Team Size.
You want to use Tableau Prep to join the two datasets.
Which three actions should you perform in order? (Place the three correct options in order.)
Answer:
Explanation:
The correct order of the three actions is:
* From the connections pane, connect to both data sources
* Join both datasets and select the join type
* Specify Employee Name as the join key
The first action is to connect to both data sources from the connections pane in Tableau Prep. The connections pane is where you can access and add data sources to your flow. You can connect to various types of data sources, such as Excel, SQL Server, or Tableau Server. In this case, you want to connect to an Excel worksheet and a SQL Server table.
The second action is to join both datasets and select the join type. A join is a way of combining data from two or more tables based on a common field. You can join datasets by dragging one table to the canvas and dropping it on top of another table. This will create a join step in your flow. You can select the join type from the drop-down list on the join step. The join type determines which rows are returned from the tables.
The third action is to specify Employee Name as the join key. A join key is a field that is used to match rows from different tables. You can specify the join key by clicking on the field name in each table and dragging it to the center of the join step. This will create a join clause that shows the field name and the operator. In this case, you want to use Employee Name as the join key, because it is a common field between the two datasets.
The other options are not relevant for this scenario. Specifying Department and Team Size as a join condition will not work, because they are not common fields between the two datasets. Opening both data sources in Tableau Desktop will not help you join them in Tableau Prep. Adding a step to aggregate the data in the SQL Server table will not affect the join, but it may change the level of detail of your data. References: https://help.
tableau.com/current/prep/en-us/prep_connect.htm https://help.tableau.com/current/prep/en-us/prep_join.htm
https://help.tableau.com/current/prep/en-us/prep_join_types.htm
NEW QUESTION # 92
A Data Analyst has the following two tables named Orders and Returns.
The analyst needs to get the Customer ID and Customer Name for only the orders that were returned. Orders will be the leading table.
Which type of join should the analyst perform in Tableau Prep?
- A. Unmatched only join
- B. Full join
- C. Left join
- D. Inner join
Answer: D
NEW QUESTION # 93
You have the following dashboard that contains two sheets.
You want to minimize the whitespace between the sheets.
What should you configure?
- A. The padding
- B. The background
- C. The border
- D. The size
- E. The position
Answer: A
Explanation:
To minimize the whitespace between the sheets, you should configure the padding of the sheets and the dashboard. Padding is the amount of space between the edge of a sheet or dashboard and its content. You can adjust the padding by using the Layout tab in the Format pane. You can reduce the padding for each sheet by selecting the sheet and changing the values for the inner and outer padding. You can also reduce the padding for the dashboard by selecting the dashboard and changing the values for the outer padding. Reducing the padding will make the sheets and the dashboard more compact and eliminate unnecessary whitespace. References:
* Format Dashboards - Tableau
* Tableau Certified Data Analyst Study Guide
NEW QUESTION # 94
You have two data sources that use the same schema One data source contains order data from 2019 and the other data source contains order data from 2020.
You have a worksheet that shows the orders from 2019.
You need to configure the worksheet to show the orders from 2020 without reloading the data.
Which option should you select?
Answer:
Explanation:
Explanation:
Replace Data Source
Replace Data Source is a feature that allows you to replace one data source with another one that has the same or similar fields and structure. It updates all the worksheets that use the original data source with the new one, without reloading the data. In this case, you want to replace the data source that contains order data from 2019 with the one that contains order data from 2020.
To replace the data source, you need to do the following steps:
* Go to the Data Source tab at the bottom of the workbook to see the data source page. You will see a table that shows the fields and values from the original data source.
* Click on the drop-down arrow next to the data source name at the top of the page and select Replace Data Source from the menu. This will open a dialog box that allows you to replace your data source with another one.
* Select the data source that contains order data from 2020 from the list of available data sources and click OK. This will replace your original data source with the new one and update your worksheet accordingly. You may need to fix any broken fields or calculations that result from the replacement.
References: https://help.tableau.com/current/pro/desktop/en-us/datasource_replace.htm https://help.tableau.
com/current/pro/desktop/en-us/datasource_replace_workbook.htm
NEW QUESTION # 95
You have a large data source that contains more than 10 million rows. Users can filter the rows by a field named Animal.
The following is a sample of the data.
You want to improve the performance of the views by including only animals of a particular type.
To which filter should you add the Type field on the worksheet?
- A. Context filter
- B. Measure filter
- C. Dimension filler
- D. Table calculation filter
Answer: A
NEW QUESTION # 96
You have a dashboard that contains a parameter named Start Date.
You need to create an extract from a Microsoft Excel file. The extract must be filtered based on Start Date.
What should you do?
- A. Create a custom SOL query to define the data source and create a calculated field based on Start Date.
Add the calculated field to the extract filter. - B. Create a custom SOL query that references Stan Date in the WHERE clause.
- C. Create a data source based on the Excel worksheet and create a calculated field based on Start Date.
Add the calculated field to the extract filter. - D. Create a data source based on the Excel worksheet and create a calculated field based on Start Date.
From the Data pane, add the calculated field to the data source filter
Answer: C
NEW QUESTION # 97
Open the link to Book1 found on the desktop. Open SalesVSProfit worksheet.
Add a distribution band on Profit to show the standard deviation from- 1 to 1.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To add a distribution band on Profit to show the standard deviation from -1 to 1, you need to do the following steps:
* Open the link to Book1 found on the desktop. This will open the Tableau workbook that contains the SalesVSProfit worksheet.
* Click on the SalesVSProfit tab at the bottom of the workbook to open the worksheet. You will see a scatter plot that shows the relationship between Sales and Profit for each Sub-Category.
* 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 Distribution Band from the Analytics pane to Profit on the Rows shelf. This will add a distribution band on Profit that shows the average and confidence interval for each Sub-Category.
* Click on the Edit button on the distribution band to open the Edit Distribution Band dialog box. You will see options to customize your distribution band.
* Change the Band From value to -1 and the Band To value to 1. This will change the distribution band to show the standard deviation from -1 to 1, which means one standard deviation below and above the average.
* Click OK to apply the changes. You will see that the distribution band now shows a narrower range of values for Profit.
References: https://help.tableau.com/current/pro/desktop/en-us/analytics.htm https://help.tableau.com/current
/pro/desktop/en-us/analytics_distributionband.htm https://help.tableau.com/current/pro/desktop/en-us
/analytics_distributionband_edit.htm
NEW QUESTION # 98
You have the following bar chart.
You want the chart to appear as shown in the Mowing exhibit.
What should you add?
- A. A distribution band
- B. A reference band
- C. An average line
- D. A reference line
Answer: D
Explanation:
A reference line is used in Tableau to display a line at a constant value or a computed value such as an average, median, minimum, or maximum in a bar chart. In this case, adding a reference line would allow you to show the median, upper quartile, and lower quartile, which corresponds to the changes shown in the bar chart.
NEW QUESTION # 99
......
Verified Pass Analytics-DA-201 Exam in First Attempt Guaranteed: https://www.2pass4sure.com/Tableau-Data-Analyst/Analytics-DA-201-actual-exam-braindumps.html
Salesforce Analytics-DA-201 Real Exam Questions Guaranteed Updated Dump from 2Pass4sure: https://drive.google.com/open?id=19UTXatuG4JRhGgT9umUYiPXLVzqLiupK