[Mar-2026] Pass Salesforce Analytics-DA-201 Exam in First Attempt Guaranteed!
Full Analytics-DA-201 Practice Test and 176 unique questions with explanations waiting just for you, get it now!
NEW QUESTION # 96
Open the Link to Book1 found on the desktop. Open Map worksheet and use Superstore data source.
Create a filed map to show the distribution of total Sales by State across the United States.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To create a filled map to show the distribution of total Sales by State across the United States, 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 Map tab at the bottom of the workbook to open the Map worksheet. You will see a blank worksheet with no marks.
* Drag State from the Dimensions pane to Detail on the Marks card. This will create a map that shows each state as a mark. You may need to zoom in or out to see the whole map.
* Drag Sales from the Measures pane to Color on the Marks card. This will create a filled map that shows the distribution of total Sales by State across the United States. The color legend will show you the range of values and colors for Sales.
* Optionally, you can adjust the color scheme, transparency, size, and borders of the marks by clicking on the Color menu on the Marks card. You can also add labels, tooltips, or filters to enhance your map.
References: https://help.tableau.com/current/pro/desktop/en-us/maps.htm https://help.tableau.com/current/pro
/desktop/en-us/maps_howto_filled.htm https://help.tableau.com/current/pro/desktop/en-us/marks_markproperties_color.htm
NEW QUESTION # 97
You have the following dashboard.
Currently the map is used as a filter that affects the data on the otter sheets of the dashboard You need to configure the dashboard to ensure that selecting a data point on the map only tillers the Detail table What should you do?
- A. From the context menu of Sales over time select Ignore Actions
- B. From the context menu of Sales over time select Deselect
- C. From the context menu of Profits by Stale deselect Use as Filter
- D. From the context menu of Sales over lime select Remove Dashboard Item
Answer: A
Explanation:
To configure the dashboard to ensure that selecting a data point on the map only filters the Detail table, you should select Ignore Actions from the context menu of Sales over time. Ignore Actions is a feature that allows you to exclude a sheet from being affected by any actions on the dashboard, such as filters or highlights. You can select Ignore Actions by right-clicking on a sheet on the dashboard and selecting Ignore Actions from the menu.
In this case, you want to exclude Sales over time from being filtered by the map, so you should select Ignore Actions from its context menu. This will make Sales over time ignore any selections on the map and show all values. The Detail table will still be filtered by the map as usual.
The other options are not correct for this scenario. Removing Dashboard Item will delete Sales over time from the dashboard, which is not what you want. Deselecting Use as Filter will disable the map as a filter for any sheet on the dashboard, which is not what you want. Selecting Deselect will clear any selections on the map, but it will not prevent Sales over time from being filtered by future selections. References: https://help.tableau.
com/current/pro/desktop/en-us/actions.htm https://help.tableau.com/current/pro/desktop/en-us/actions_ignore.
htm
On a Tableau dashboard, when a map is used as a filter, it affects all other sheets in the dashboard by default.
To restrict the filter action to only affect the Detail table and not the 'Sales over time' chart, you would modify the action settings. By selecting "Ignore Actions" from the context menu of the 'Sales over time' chart, it will no longer respond to the filtering action initiated by selecting data points on the map.
NEW QUESTION # 98
Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the members of the Top10 set and the members of the Bottom10 set. There should be a total of 20 rows.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To filter the table to show the members of the Top10 set and the Bottom10 set, 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 Disciplines worksheet.
* Click on the Disciplines tab at the bottom of the workbook to open the worksheet. You will see a table that shows the disciplines, sales, and profit for each salesperson.
* Click on the drop-down arrow next to Salesperson on the Filters shelf. This will open a menu that allows you to filter by different criteria.
* Select Set from the menu. This will show you the sets that are available for the Salesperson field. You will see Top10 and Bottom10 as two sets that have been created based on the sales ranking.
* Check the boxes next to Top10 and Bottom10. This will filter the table to show only the members of these two sets. You can also click on All to deselect all other values.
* Click OK to apply the filter. You will see that the table now shows 20 rows, 10 for each set.
References: https://help.tableau.com/current/pro/desktop/en-us/sets.htm
https://help.tableau.com/current/pro/desktop/en-us/filtering.htm
NEW QUESTION # 99
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. Book1.json
- B. Export.mdb
- C. Sales.tds
- D. Sales.csv
Answer: D
NEW QUESTION # 100
A Data Analyst has a website that displays data in a table format.
The analyst wants to connect to the data of the website by using the least amount of effort.
What should the analyst use to connect to the data?
- A. Clipboard
- B. ODBC connector
- C. CSV file
- D. Web data connector
Answer: A
NEW QUESTION # 101
You have the following calculated fields in a worksheet.
[Calc1] = DATEADD ('year', -1, TODAY ())
[Calc2] = DATETRUNC ( 'month' , DATEADD ('year', -1, TODAY ())
You want to calculate the month to date value of the prior year.
How should you complete the formula? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)
Answer:
Explanation:
Explanation:
To calculate the month to date value of the prior year, you need to filter the order date to be between the first day of the same month of the previous year and the same day of the previous year. You can use the calculated fields [Calc1] and [Calc2] to get these dates. [Calc1] returns the date that is one year before today, and
[Calc2] returns the date that is the first day of the month of [Calc1]. By using these fields in the filter condition, you can get the desired result.
References:
Finding the Month-to-Date Values for the Prior Year
[DATEADD Function]
[DATETRUNC Function]
NEW QUESTION # 102
You have a data source that contains data tor every city in the Unites States. The following is a sample of the data.
You need to use the City dimension to create a dynamic filter that snows the cities that have a population greater than one million Which type of filter should you use?
- A. Top filter
- B. General filter
- C. Condition filter
- D. Wildcard filter
Answer: C
Explanation:
To use the City dimension to create a dynamic filter that shows the cities that have a population greater than one million, you should use a condition filter. A condition filter is a type of filter that shows only the values that meet a specified condition based on a measure or a calculation. You can create a condition filter by dragging a dimension to the Filters shelf and selecting Condition from the dialog box. Then you can enter a formula or choose an option that defines your condition.
In this case, you want to create a condition filter based on Population, which is a measure. You can drag City to the Filters shelf and select Condition from the dialog box. Then you can choose By field from the tab and select Population > Sum > Greater than > 1000000 from the drop-down lists. This will create a condition filter that shows only the cities that have a sum of population greater than one million.
The other options are not correct for this scenario. A general filter is not a specific type of filter, but a term that refers to any type of filter in Tableau. A wildcard filter is a type of filter that shows only the values that match a specified pattern or string, such as "New*" or "*ton". A top filter is a type of filter that shows only the top or bottom N values of a measure or dimension based on a ranking or an aggregation. References:
https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop
/en-us/filtering_condition.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_wildcard.htm
https://help.tableau.com/current/pro/desktop/en-us/filtering_topn.htm
NEW QUESTION # 103
You have the following dataset.
When you use the dataset in a worksheet, you want Sales to appear automatically as shown in the following table.
What should you do?
- A. Create a calculated field that uses a formula of 'S' * str (Round((sales],2)) + 'k'
- B. Create a calculated field that uses a formula of 'S' + stri < (Sales)/1000)).
- C. Change the data type of the Sates field to Siring
- D. Change the default number format of the Sales told
Answer: D
Explanation:
To make Sales appear automatically as shown in the second table, you should change the default number format of the Sales field. The default number format is how Tableau displays a field when you drag it to a worksheet. You can change the default number format by right-clicking on the field and selecting Default Properties > Number Format from the menu. This will open a dialog box where you can choose a category, such as Currency or Percentage, and customize the options, such as decimal places or prefixes.
In this case, you want to change the default number format of Sales to Currency with zero decimal places and a custom prefix of "S". This will make Sales appear as "S" followed by the rounded value in thousands.
The other options are not correct for this scenario. Changing the data type of Sales to String will not affect how it appears on a worksheet. Creating a calculated field that uses a formula will not change the default number format of Sales, but create a new field that you have to drag to a worksheet. Converting Sales to Attribute will return only one value for each partition of data, which will not show any variation over time.
References: https://help.tableau.com/current/pro/desktop/en-us/formatting.htm https://help.tableau.com/current
/pro/desktop/en-us/formatting_change_default.htm
To achieve the formatting as shown in the example, where sales figures are displayed with a "K" to represent thousands and rounded to the nearest thousand (e.g., $20K, $44K, etc.), you would need to adjust the default number format of the Sales field in Tableau. By changing the default number format, every instance where the Sales field is used would automatically reflect this new formatting. This is more efficient than creating a calculated field as it preserves the numeric nature of the field, allowing for further numerical operations and aggregations.
NEW QUESTION # 104
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 data source based on the Excel worksheet and create a calculated field based on Start Date.
Add the calculated field to the extract filter. - C. 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 - D. Create a custom SOL query that references Stan Date in the WHERE clause.
Answer: B
NEW QUESTION # 105
A Data Analyst has a data source that contains the following columns:
he analyst has the following FIXED Level of Detail (LOD) expression called Region Sales:
{ FIXED [Region] : SUM([Sales]) }
The analyst has a view that has a dimension filter on the State column to exclude five states.
What should the analyst do to ensure the five states are also excluded from the LOD expression?
- A. Right-click the State dimension filter, and then click Add to Context.
- B. Drag the LOD expression to the Filters shelf.
- C. Right-click the State dimension filter, and then click Attribute.
- D. Change the LOD expression to { FIXED [Region], [State] : SUM([Sales]) }.
Answer: A
NEW QUESTION # 106
A Data Analyst needs to calculate the first Tuesday of each month in the data.
Which set of functions should the analyst use to perform this calculation?
- A. DATEADD, DATENAME
- B. DATETRUNC, DATEADD
- C. DATETRUNC, DATEPART
- D. DATEDIFF, DATEPART
Answer: C
NEW QUESTION # 107
You have the following box plot that shows the distribution of average profits made in every state by region.
Which region has the smallest distribution of profits?
- A. South
- B. West
- C. Cast
- D. Central
Answer: A
Explanation:
The box plot visualization displays the distribution of average profits by region. The distribution of profits is represented by the range of the box (interquartile range) and the whiskers (which often represent the total range excluding outliers). From the image provided, the South region has the smallest visible range within its box and the shortest whiskers, indicating the smallest distribution of average profits among the choices provided.
NEW QUESTION # 108
You have the following dataset.
You need to generate the results in the Day field.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)
Answer:
Explanation:
Explanation:
NEW QUESTION # 109
You want to ensure that when you click a bar on a dashboard, a tooltip appears that contains a link named
"Click here to know more!" as shown in the following exhibit.
Answer:
Explanation:
Explanation:
NEW QUESTION # 110
A Data Analyst has the following dataset:
The analyst wants to create a new calculated dimension field named Category that meets the following conditions:
When Subject is Computer Science or Science, the Category must be Sciences.
When Subject is English or Social Studies, the Category must be Humanities.
Which two logical functions achieve this goal? (Choose two.)
- A. IIF((CONTAINS([Subject], 'Science') = TRUE), 'Humanities', 'Sciences')
- B. IF ENDSWITH([Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END
- C. CASE [Subject]
WHEN 'Computer Science' THEN 'Sciences'
WHEN 'English' THEN 'Humanities'
WHEN 'Social Studies' THEN 'Humanities'END - D. IF [Subject] = 'Science' THEN 'Sciences'
ELSEIF [Subject] = 'English' THEN 'Humanities'
ELSEIF [Subject] = 'Social Studies' THEN 'Humanities'
ELSEIF [Subject] = 'Computer Science' THEN 'Sciences'
END
Answer: C,D
NEW QUESTION # 111
......
Get Latest Analytics-DA-201 Dumps Exam Questions in here: https://itcertspass.prepawayexam.com/Salesforce/braindumps.Analytics-DA-201.ete.file.html