Ensure Success With Updated Verified Analytics-DA-201 Exam Dumps [2025]
Exam Materials for You to Prepare & Pass Analytics-DA-201 Exam.
NEW QUESTION # 14
You have a blank dashboard.
You want to add two sheets to the dashboard. The sheets must support the Show/Hide button.
To which two objects can you add the sheets? (Click the two appropriate Options in the Answer Area.)
Answer:
Explanation:
To add two sheets to the dashboard that support the Show/Hide button, you can add them to either a horizontal or a vertical container. A container is an object that can hold one or more sheets or other objects and allow you to arrange them in a layout. A Show/Hide button is a feature that lets you hide or show a container and its contents on the dashboard. You can add a Show/Hide button to any container, whether it is tiled or floating, by using the drop-down menu of the container and selecting "Add Show/Hide Button." You can also customize the appearance and behavior of the button.
To add a horizontal or a vertical container to the dashboard, you can drag them from the Objects pane to the dashboard. A horizontal container will arrange the sheets or objects horizontally, while a vertical container will arrange them vertically. You can then drag the sheets you want to add from the Sheets pane to the container. You can resize and reorder the sheets or objects within the container by using the handles and arrows.
The other objects in the Answer Area, such as text, image, web page, blank, navigation, download, and extension, do not support the Show/Hide button. They are either static elements that cannot hold other objects, or dynamic elements that require user interaction or external sources. You can add them to the dashboard as well, but they will not have the same functionality as a container with a Show/Hide button.
References:
Add Show/Hide Buttons - Tableau
Layout Containers - Tableau
NEW QUESTION # 15
You are developing a data source in Tableau Prep.
You have two tables named Orders and Employees.
The Orders table was created in 2019 and contains the following columns.
The Employees table contains all the employee information for the various sales teams in the sales department and contains the following columns
You want to prepare the data so that you can analyze sales trends over time for every sales team.
Which three actions should you perform in order? (Place the three correct options in order. Use the arrows to move Options to Answer Area. Use Answer Area arrows to re-order the options.)
Answer:
Explanation:
Explanation:
There are different ways to prepare the data in Tableau Prep, but one possible answer is:
Answer area:
* Join the tables.
* Aggregate the data by Sales Team.
* Add the following filter to the Employees table: Sale Team - Team Alpha.
To analyze sales trends over time for every sales team, you need to combine the data from the Orders and Employees tables. You can do this by joining the tables on the Rep ID column, which is a common identifier for both tables. This will create a single table with all the columns from both tables. Next, you need to aggregate the data by Sales Team, which is the level of analysis you want. You can do this by grouping the data by the Sales Team column and applying an aggregation function (such as sum, average, count, etc.) to the other columns that you want to measure (such as Total Amount, Rep Tenure, etc.). This will create a summary table with one row for each sales team and the aggregated values for the other columns. Finally, you need to filter the data to focus on a specific sales team, such as Team Alpha. You can do this by adding a filter to the Employees table and selecting only the rows where Sales Team equals Team Alpha. This will remove the rows for other sales teams and keep only the data for Team Alpha.
References:
[Tableau Certified Data Analyst Exam Prep Guide], page 9, section "Preparing Data"
[Tableau Help: Join Your Data]
[Tableau Help: Aggregate Your Data]
[Tableau Help: Filter Your Data]
NEW QUESTION # 16
You have the following visualization.
The Last() calculation is set to compute using Table (across)
Which value will appear in the crosstab for the Consumer segment of the year 2018 if you change compute to use Oder Dale?
- A. 0
- B. 1
- C. 2
- D. 3
Answer: C
Explanation:
The LAST() function in Tableau returns the number of rows from the current row to the last row in the partition. When you compute using 'Order Date', it will change the partitioning of the calculation. If
'Consumer' in '2018' is the last row in its partition when computed by 'Order Date', then LAST() will return 0 for that cell.
The LAST() function in Tableau is a table calculation that returns the number of rows from the current row to the last row in the partition. The value of LAST() is 0 for the last row, increases by 1 for each row above the last row, and can be negative for rows below the current row if there are such rows in the partition.
In the provided visualization, LAST() is set to compute using Table (across). Changing the compute mode to use "Order Date" will adjust the partitioning of the data upon which the LAST() function is calculated. Since
"Order Date" is likely to be a unique value per row (assuming each order has a unique date), each row becomes its own partition.
For the Consumer segment of the year 2018, if "Order Date" is unique for each row, then the last row in each partition (in this case, each individual row) will have a LAST() value of 0 because there are no other rows in the partition - it's the last row of its own partition.
Therefore, when you change the compute mode of LAST() to use "Order Date", each cell under the Consumer segment for the year 2018 will have the LAST() value of 0, because each order date creates a partition of one, making every row the last in its partition.
NEW QUESTION # 17
Open the link to Book1 found on the desktop. Open the Histogram worksheet and use the Superstone data source.
Create a histogram on the Quantity field by using bin size of 3.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To create a histogram on the Quantity field by using bin size of 3, you need to do the following steps:
* Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the Superstore data source.
* Click on the Histogram tab at the bottom of the workbook to open the Histogram worksheet. You will see a blank worksheet with no marks.
* Right-click on Quantity in the Measures pane and select Create Bins from the menu. This will open a dialog box that allows you to create bins for the Quantity field. Bins are groups of values that are treated as one unit in a histogram.
* Enter 3 in the Size of bins text box. This will set the bin size to 3, which means that each bin will contain values that are 3 units apart. For example, one bin will contain values from 0 to 2, another bin will contain values from 3 to 5, and so on.
* Click OK to create the bins. You will see a new field named Quantity (bin) in the Measures pane with a
# sign next to it.
* Drag Quantity (bin) from the Measures pane to Columns on the worksheet. This will create a histogram that shows the distribution of Quantity by bins. You will see bars that represent the frequency or count of values in each bin.
* Optionally, you can adjust the width, color, and labels of the bars by using the options on the Marks card. You can also add filters, tooltips, or annotations to enhance your histogram.
References: https://help.tableau.com/current/pro/desktop/en-us/histograms.htm https://help.tableau.com
/current/pro/desktop/en-us/calculations_bins.htm https://help.tableau.com/current/pro/desktop/en-us
/buildmanual_histograms.htm
NEW QUESTION # 18
You create the following worksheet
The Pick Measure parameter contains the following list of values
Users can select a value from Pick Measure to change the visualization to show either the Sales measure or the Profit measure.
Which formula is used in the Selected Measure calculated field lo switch between measures?
- A. Case AVG([Pick Measure])
WHEN [Sales] then 1
WHEN [Profit] then 2
END - B. Case STFMEPick Measure])
WHEN "Sales" then ([Sales])
WHEN "Profit" then ([Profit]) e::i - C. Case [Pick Measure]
WHEN 1 then ([Sales])
WHEN 2 then ([Profit])
END - D. Case [Pick Measure:
WHEN [Sales] then 1
WHEN [Profit] then 2 END
Answer: C
Explanation:
https://help.tableau.com/current/pro/desktop/en-us/parameters_swap.htm
This formula uses a parameter (Pick Measure) to switch between the Sales and Profit measures. When the user selects '1', it shows Sales, and when '2' is selected, it shows Profit. This dynamic switching is enabled by the Case function.
NEW QUESTION # 19
You want to create the following dashboard that will contain two sheets.
What should you do?
- A. Add both sheets lo a horizontal container and add a border to the container.
- B. Drag both sheets to the dashboard and add a border to each sheet.
- C. Drag both sheets to the dashboard and add a background lo each sheet.
- D. Add a border to both sheets and add both sheets to a horizontal object.
Answer: A
NEW QUESTION # 20
You have the following primary data source that contains a dimension named Dorm_Code.
You receive the following secondary data source that contains updated dorm codes.
You need to bring the updated dorm codes into Tableau and use the codes in existing visualizations. The new dorm codes must use the existing field name of Dorm_Code.
What should you do?
- A. Bring in the secondary table as a left join to the primary data source. From the Data Source page, select Create Calculated Field in the Dorm_Name field and enter [Dcrm_Name_New] in the calculation window
- B. Bring in the secondary data source by using relationships. From the Data pane, right-click Dorm_Name select Replace References, and then select Dorm_Name_New
- C. Bring in the secondary data source as a union.
- D. Create a data blend and select Edit Primary Aliases to replace the primary data source alias values with values from the secondary data source
Answer: B
Explanation:
* Using relationships: You can use relationships to link the secondary data source with the primary data source based on a common field. This will allow you to use fields from both data sources in your visualization without creating new fields or duplicating data. You can then replace references to update the dimension values. For example, you can use relationships to link the updated dorm codes with the primary data source and then replace Dorm_Code with Dorm_Code_New in your visualization.
https://community.tableau.com/s/question/0D54T00000C5ldZSAR/update-data-view-based-on-dimension To update existing visualizations with new codes without changing the field name, using relationships to bring in the secondary data source is appropriate. Then using Replace References allows you to update the references from the old dorm codes to the new ones while maintaining the existing field name.
NEW QUESTION # 21
You create the following story that contains two story point.
You want to change the story point format to show the current story point number out of the total number of story points.
Which Layout option should you use?
- A. Arrows only
- B. Caption boxes
- C. Numbers
- D. Dots
Answer: C
Explanation:
To change the story point format to show the current story point number out of the total number of story points, you should use the Numbers option in the Layout tab. This option will display the story points as numbers in a horizontal or vertical sequence, such as 1/2, 2/2. You can also choose to show or hide the next and previous arrows for navigation. The Numbers option will help you indicate the progress and order of your story points more clearly than the other options. References:
* Creating a Story - Tableau
* New in 9.0: Formatting the Story Points Navigator - Tableau
* Tableau Certified Data Analyst Study Guide
NEW QUESTION # 22
Which option must a Data Analyst enable to build the following table to add quarterly totals?
- A. Add All Subtotals
- B. Show Column Grand Totals
- C. Add Pane Totals
- D. Show Row Grand Totals
Answer: A
NEW QUESTION # 23
You have the following:
Overall Rank and Rank are calculated fields that use the RANK function.
You filter out the sub-category where [Ovorall Rank] - 1.
For which three the sub-categories will the value of Rank change? Choose three.
- A. Copiers
- B. Accessories
- C. Machines
G Phones - D. Tables
- E. Chairs
- F. Furnishings
- G. Bookcases
Answer: B,C,D
Explanation:
In Tableau, the RANK function assigns a rank to each row within a partition of the data, based on the value of the field being ranked. It is important to understand that the rank is recalculated whenever the underlying data or the partitioning changes.
In the given scenario, the Overall Rank is based on the Sales figures, while the Rank (presumably) is based on the Sales within the Category. When filtering on the condition where [Overall Rank] - 1, it means we are excluding the sub-category that has an Overall Rank of 2.
Looking at the data:
* Furnishings has an Overall Rank of 8, which does not meet the filter condition ([Overall Rank] - 1).
Therefore, its rank remains the same.
* Tables have an Overall Rank of 3. When the sub-category with an Overall Rank of 2 is removed (Chairs in this case), Tables move up in the overall ranking. However, since Tables are the top-ranked within the Furniture category, their Rank within the category would remain unchanged at 1.
* Chairs have an Overall Rank of 2, which meets the filter condition and thus will be removed from the view. We cannot determine the change in Rank for Chairs because they are filtered out.
* Accessories have an Overall Rank of 5. If any sub-category with a higher Overall Rank (1 to 4) is removed, the rank of Accessories within the Technology category could change because it is currently ranked 3 in its category. With the removal of Phones (Overall Rank 1), the Rank of Accessories could potentially increase.
* Copiers have an Overall Rank of 6, which does not meet the filter condition. Therefore, its rank remains the same.
* Machines have an Overall Rank of 4. If we remove Phones (Overall Rank 1), Machines will move up in the overall ranking and potentially within the Technology category as well, changing its Rank from 2 to 1.
* Phones have an Overall Rank of 1, which does not meet the filter condition of being Overall Rank 2.
Therefore, its rank remains the same.
* Bookcases have an Overall Rank of 7, which does not meet the filter condition. Therefore, its rank remains the same.
Based on this analysis, when the sub-category with an Overall Rank of 2 (Chairs) is removed, the Rank value will change for Tables, Accessories, and Machines, as they will move up in the overall ranking within their respective categories. However, it's important to note that while Tables will move up in the overall ranking, their rank within the Furniture category would not change as they are already at the top. The rank changes for Accessories and Machines are due to the removal of Phones, which is ranked higher overall and within the Technology category.
NEW QUESTION # 24
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 Desktop, open the Publish Workbook dialog box and configure the schedule.
- B. From Tableau Server, select the workbook, select Refresh Extracts, and then add a new extract refresh.
- C. From Tableau Server, select Schedules, find the schedule of the extract, and change the frequency to the last day of the month.
- D. From Tableau Server, select Schedules, and change the priority of the existing schedule.
Answer: B
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 # 25
You need to change the values of a dimension without creating a new field.
What should you do?
- A. Create aliases
- B. Rename the fields
- C. Create groups
- D. Transforms the fields
Answer: A
Explanation:
You can create aliases for the members of a dimension by right-clicking the dimension in the Data pane or in the view and selecting Aliases. This changes how the values are displayed in the view, but not the underlying data. For example, you can create an alias for "Central" as "Midwest".
In Tableau, aliases can be used to change the way dimension members appear without altering the underlying data. This is useful for display purposes and does not create a new field within the dataset.
NEW QUESTION # 26
You plan to publish a workbook to Tableau Server.
You want to ensure that users can see other published dashboards from their current dashboard.
Which setting should you configure? (Click the appropriate Option in the Answer Area.)
Answer:
Explanation:
Explanation:
To achieve the requirement of letting users navigate between different published dashboards directly from their current dashboard, you need to enable the "Show sheets as tabs" option. This setting allows each sheet in your workbook, including dashboards, to be displayed as a tab, making it easy for users to switch between different views or dashboards within the same published workbook.
Here is the option you should configure:
* Check the Show sheets as tabs checkbox in the 'More Options' section.
This action will ensure that all sheets, when published to the Tableau Server, appear as tabs, facilitating user navigation across multiple dashboards included in the workbook.
NEW QUESTION # 27
You have the following table.
You need each record to alternate between grey and white.
What should you change in the Format Shading pane?
- A. the column banding size to 1
- B. the row banding size to 1
- C. the column banding size to 3
- D. the row banding size to 3
Answer: B
Explanation:
To have each record alternate between grey and white, you should change the row banding size to 1 in the Format Shading pane. This setting will ensure that each row has a different shading from the one above and below it, creating an alternating pattern of grey and white rows. References: The answer can be verified through practical application within Tableau or by consulting Tableau's official learning resources, such as Tableau Help: Format Shading or Tableau Training Pass: Formatting.
NEW QUESTION # 28
What should a Data Analyst use to visualize the distribution and variability of measure values along an axis?
- A. Histogram
- B. Box Plot
- C. Scatter Plot
- D. Bullet Graph
Answer: B
NEW QUESTION # 29
You have the following dataset.
Which grouping option should you use m Tableau Prep to group al five names automatically?
- A. Spelling
- B. Common Characters
- C. Pronunciation
- D. Manual Selection
Answer: A
Explanation:
Tableau Prep's Grouping feature includes various methods to group similar data. The Spelling option is used when the data has small variations in spelling, such as capitalization differences or common typos. Given that the names in the dataset vary in capitalization and punctuation but are spelled correctly, the Spelling grouping option would be the most appropriate choice to automatically group all five names.
NEW QUESTION # 30
You are the owner of an alert.
You receive an email notification that the alert was suspended
From where can you resume the suspended alert?
- A. The Shared with Ma page
- B. The Notification area of Tableau Prep
- C. The My Content area of Tableau web pages
- D. The Data Source page of Tableau Desktop
Answer: C
Explanation:
To resume a suspended alert, you need to go to the My Content area of Tableau web pages, where you can see all the alerts that you own or subscribe to. You can click on the alert name and then select Resume from the menu. You can also edit or delete the alert from there. References: https://help.tableau.com/current/pro
/desktop/en-us/alerts.htm https://help.tableau.com/current/pro/desktop/en-us/alerts_manage.htm In Tableau, the "My Content" area on the web interface is the place where a user can manage their content, including workbooks, data sources, and alerts. If an alert is suspended, the owner of the alert can go to the
"My Content" area to resume it.
NEW QUESTION # 31
Which syntax should a Data Analyst use to find the first purchase date per customer when Customer is not in the view?
- A. { FIXED [Customer ID] : MIN([Purchase Date]) }
- B. [Customer ID] : MIN([Purchase Date])
- C. MIN([Purchase Date])
- D. [Customer ID] : { [Purchase Date] }
Answer: A
NEW QUESTION # 32
You have the following view.
You want to filter the view lo show only records that have a movie name starting with the word. "The". You must achieve the goal without writing any formulas.
Which type of filter should you use?
- A. Wildcard
- B. Top
- C. General
- D. Condition
Answer: A
NEW QUESTION # 33
You have the following dashboard.
When a user selects a only on the map the data on the bar chart must show only the data for the selected city.
The data in the bar chart must change only when the user selects a different city How should you configure the dashboard action? (Use the dropdowns in the Answers Area to select the correct options.)
Answer:
Explanation:
Explanation:
To configure the dashboard action, you should select Filter as the action type, Select as the run action on option, and All Fields as the target filters option. This will ensure that when a user selects a city on the map, the bar chart will show only the data for the selected city based on all fields in common between the two worksheets. The action will run only when the user selects a different city. References: https://help.tableau.
com/current/pro/desktop/en-us/actions.htm https://help.tableau.com/current/pro/desktop/en-us/actions_filter.
htm
NEW QUESTION # 34
A colleague provides a Data Analyst with access to a folder that has the following files:
* Sales.csv
* Book1.json
* Sales.tds
* Export.mdb
Which file can contain information for connecting to an external data source, such as an SQL Server database?
- A. Sales.tds
- B. Book1.json
- C. Sales.csv
- D. Export.mdb
Answer: C
NEW QUESTION # 35
Open the link to Book1 found on the desktop. Use the Superstore data source.
Split the Customer Name field into two fields named First Name and Last Name.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To split the Customer Name field into two fields named First Name and Last Name, you need to do the following steps:
* Open the link to Book1 found on the desktop. This will open the Tableau workbook that uses the Superstore data source.
* 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 Superstore data source.
* Right-click on Customer Name in the table and select Split from the menu. This will split the field into two fields based on a separator, which is a space by default. You will see two new fields named Customer Name - Split 1 and Customer Name - Split 2 in the table.
* Right-click on Customer Name - Split 1 and select Rename from the menu. Type First Name as the new name and press Enter. This will rename the field as First Name.
* Right-click on Customer Name - Split 2 and select Rename from the menu. Type Last Name as the new name and press Enter. This will rename the field as Last Name.
References: https://help.tableau.com/current/pro/desktop/en-us/datasource_prepare.htm https://help.tableau.
com/current/pro/desktop/en-us/split.htm https://help.tableau.com/current/pro/desktop/en-us/renamefield.htm
NEW QUESTION # 36
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. Table calculation filter
- B. Dimension filler
- C. Measure filter
- D. Context filter
Answer: D
NEW QUESTION # 37
You have a dashboard than contains two sheets named Sheet 1 and Sheet 2.
You want to add an object to the dashboard that users can click to switch to a different dashboard in the workbook.
Which object should you add to the dashboard?
Answer:
Explanation:
Explanation:
The object that you should add to the dashboard to allow users to switch to a different dashboard in the workbook is Navigation.
Navigation objects are used to create links between dashboards or sheets in a workbook. You can add a navigation object to a dashboard by dragging it from the list of objects and dropping it on the dashboard. You can then configure the navigation object to specify the destination dashboard or sheet that you want users to navigate to when they click on it.
You can learn more about navigation objects and how to use them in this article: https://help.tableau.com
/current/pro/desktop/en-us/dashboards_navigation.htm
NEW QUESTION # 38
......
Salesforce Analytics-DA-201 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
Updated Analytics-DA-201 Certification Exam Sample Questions: https://pass4sures.free4torrent.com/Analytics-DA-201-valid-dumps-torrent.html