Latest Apr 30, 2026 Analytics-DA-201 Brain Dump: A Study Guide with Tips & Tricks for passing Exam
Analytics-DA-201 Question Bank: Free PDF Download Recently Updated Questions
Salesforce Analytics-DA-201 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
NEW QUESTION # 102
You have the following dataset.
You want to create a new calculated dimension field named Category that meets the following conditions:
. When Subject is Computer Science or Science, Category must be Sciences.
. When Subject is English or Social Studies, Category must be Humanities.
Which two logical functions achieve the goal? Choose two.
- A. CASE [Subject]
WHEN 'Computer Science' THEN 'Sciences'
WHEN 'Science' THEN 'Sciences'
WHEN 'English' THEN 'Humanities'
WHEN 'Social Studies' THEN 'Humanities'
End - B. IF [Subject]- 'Science' THEN 'Sciences'
ELSEIF [Subject]='English' THEN 'Humanities'
ELSEIF [Subject]-'Social Studies' THEN 'Humanities'
ELSEIF [Subject]= 'Computer Science' THEN 'Sciences'
END - C. IIF(( CONTAINS ([Subject], 'Science') = TRUE) , 'Humanities', 'Sciences')
- D. IF ENDSWITH ( [Subject], 'Computer Science') THEN 'Sciences' ELSE 'Humanities' END
Answer: A,B
Explanation:
To create a new calculated dimension field named Category that meets the given conditions, you can use either the IF or the CASE logical function. Both functions allow you to evaluate an expression and return a value based on different scenarios. Option A uses the IF function with multiple ELSEIF clauses to check the value of the Subject field and assign it to either 'Sciences' or 'Humanities'. Option D uses the CASE function with multiple WHEN clauses to do the same thing. Both options will produce the same result, but the CASE function is more concise and easier to read. Option B is incorrect because it will assign 'Humanities' to any subject that contains 'Science' in its name, which is not the desired outcome. Option C is incorrect because it will only check if the subject ends with 'Computer Science' and ignore the other subjects. References:
* Logical Functions - Tableau
* Tableau Certified Data Analyst Study Guide
NEW QUESTION # 103
You have a data set that contains three columns named Sales, Profit, and Quantity.
You need to build the following scatter plot.
Answer:
Explanation:
Explanation:
To build the scatter plot shown in the image, you need to place the Profit measure on the Rows shelf and the Sales measure on the Columns shelf. This will create a Cartesian chart with Profit as the y-axis and Sales as the x-axis. Then, you need to change the mark type to Circle on the Marks card. This will display the data points as circles that vary in size according to the Quantity measure. You can also add color or shape encoding to the marks to show additional dimensions or measures in the view. References:
* Build a Scatter Plot
* Understanding and Using Scatter Plots
* Scatter plot in Tableau
NEW QUESTION # 104
A Data Analyst has the following dashboard.
Currently, the map is used as a filter that affects the data on the other sheets of the dashboard.
The analyst needs to configure the dashboard to ensure that selecting a data point on the map only filters the Detail table.
What should the analyst do?
- A. Select Remove Dashboard Item from the drop-down menu of Sales over time.
- B. Select Ignore Actions from the drop-down menu of Sales over time.
- C. Select Deselect from the drop-down menu of Sales over time.
- D. Deselect Use as Filter from drop-down menu of Profits by State
Answer: B
NEW QUESTION # 105
You have a dataset that contains sates data. The following is a sample of the data.
You need to return a value of true if a month has sales greater than $50 000. otherwise the formula must return a value of false.
Which two formulas achieve the goal Choose two
- A. [Sales] > 50000
- B. MAX< [Sales], 50000)
- C. SUM{[Sales]) IN (50000)
- D. IIF(SUM< [Sales] )>50000, TRUE, FALSE)
Answer: A,D
Explanation:
The two formulas that will return a value of true if a month has sales greater than $50,000, otherwise the formula must return a value of false, are:
B). IIF(SUM([Sales]) > 50000, TRUE, FALSE) D. [Sales] > 50000
The IIF function is a logical function that returns one value if a condition is true, and another value if the condition is false. In this case, the condition is SUM([Sales]) > 50000, which means that the sum of sales for a month is greater than $50,000. The function will return TRUE if the condition is true, and FALSE if the condition is false.
The comparison operator > is a logical operator that returns TRUE if the left operand is greater than the right operand, and FALSE otherwise. In this case, the operands are [Sales] and 50000, which means that the sales for a month are greater than $50,000. The operator will return TRUE if the sales are greater than $50,000, and FALSE otherwise.
The other options are not correct for this scenario. The IN function is a logical function that returns TRUE if a value is in a set of values, and FALSE otherwise. In this case, the value is SUM([Sales]), which is not in the set of values (50000). The function will always return FALSE. The MAX function is an aggregation function that returns the maximum value in a field or expression. In this case, the field or expression is [Sales], 50000, which is not valid syntax. The function will return an error. References: https://help.tableau.com/current/pro
/desktop/en-us/functions_functions_logical.htm#IIF https://help.tableau.com/current/pro/desktop/en-us
/operators.htm https://help.tableau.com/current/pro/desktop/en-us/functions_functions_aggregate.htm#MAX
NEW QUESTION # 106
You want to show the cumulative total of each year for every state.
Which quick table calculation should you use?
- A. VTD Growth
- B. Running Total
- C. YTD Total
- D. Year Over Year Growth
Answer: B
NEW QUESTION # 107
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. Tables
- B. Copiers
- C. Machines
G Phones - D. Furnishings
- E. Bookcases
- F. Chairs
- G. Accessories
Answer: A,C,G
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 # 108
A Data Analyst has the following dataset.
The analyst wants to create a parameter to dynamically filter the data to produce the following results based on quantity being above X value.
Which two types of parameters should the analyst use to produce the results? (Choose two)
- A. Date
- B. Boolean
- C. Integer
- D. Float
Answer: C,D
NEW QUESTION # 109
You have the following dataset.
Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?
- A. {FIXED: TOTAL (Sales)}
- B. {FIXED: SUM Sales}
- C. {FIXED: [Region] SUM Sales}
- D. {Fixed: [Region]: TOTAL Sales}
Answer: B
Explanation:
The correct Level of Detail (LOD) expression to calculate the grand total of sales across all regions would be
{SUM(Sales)}. The FIXED expression is not needed here because we are not computing the sum at the level of each region, but rather the total sum across all regions. The FIXED keyword is typically used to aggregate at a certain level regardless of the view.
https://help.tableau.com/current/pro/desktop/en-us/functions_functions_tablecalculation.htm#TOTAL
NEW QUESTION # 110
A Data Analyst has a dataset that contains people and the awards they have won.
Which formula should the analyst use to get the number of different types of awards that have been won?
- A. WINDOW_COUNT ( [Award] )
- B. COUNT ( [Award] )
- C. COUNTD ( [NAME] )
- D. COUNTD ( [Award] )
Answer: D
NEW QUESTION # 111
You have a Tableau workbook that contain three worksheets named Sheet1 Sheet2 and Sheet3.
You create several filters.
From the Data Source page you plan to add data source fillers
When type of filter will appear in the Edit Data Source Filters dialog box?
- A. A table calculation filter used on Sheet
- B. A dimension filter on all the sheets
- C. A top N condition filer on a dimension in Sheet 1 and Sheet2
- D. A context filler on a dimension m Sheet3
Answer: B
Explanation:
A data source filter is a filter that applies to all the worksheets that use the same data source. It filters the data before any other filters or calculations are applied. You can add a data source filter from the Data Source page by clicking on the Add button next to Filters.
The type of filter that will appear in the Edit Data Source Filters dialog box is a dimension filter on all the sheets. This means that you can choose a dimension from your data source and filter it by values, range, condition, or top/bottom. The filter will affect all the worksheets that use that dimension.
The other types of filters are not data source filters and will not appear in the Edit Data Source Filters dialog box. A table calculation filter is a filter that applies to a table calculation, such as percent of total or running total. A top N condition filter is a filter that shows only the top or bottom N values of a measure or dimension based on a condition. A context filter is a filter that creates a subset of data that other filters can use.
References: https://help.tableau.com/current/pro/desktop/en-us/filtering_datasource.htm https://help.tableau.
com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop/en-us
/filtering_tablecalculations.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_topn.htm
https://help.tableau.com/current/pro/desktop/en-us/filtering_context.htm Data source filters in Tableau apply to the entire data source, affecting all sheets that use that data source. The Edit Data Source Filters dialog box allows you to add filters that operate at the data source level, which is different from context filters, top N filters, or table calculation filters that are applied at the worksheet level.
NEW QUESTION # 112
You receive a tab-delimited data file name sales.tsv.
You need to connect to the file.
Which option should you select in Tableau Desktop?
Answer:
Explanation:
Explanation:
To connect to a tab-delimited data file named sales.tsv, you should select the option To a File > Text file in Tableau Desktop. This option will allow you to browse and select the file from your local or network drive and connect to it as a data source. You can then specify the text file properties, such as the delimiter, the text qualifier, and whether the first row contains column names. You can also join, union, or blend the data with other data sources if needed. References:
* Text File - Tableau
* Tableau Certified Data Analyst Study Guide
NEW QUESTION # 113
You have the following visualization.
Answer:
Explanation:
Explanation:
NEW QUESTION # 114 
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. Select the top 10 bars, and then change the color by selecting Color on the Marks card.
- C. Create a set that has a top 10 condition, and then drag the set to 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.
Answer: C
NEW QUESTION # 115
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 site within the folders to which you have access
- C. All the data sources published to the Tableau Server within the folders to which you have access
- D. All the data sources published to the Tableau Server
Answer: B
Explanation:
When you sign in to a Tableau Server site from Tableau Desktop and search for a published data source, you will see all the data sources published to the site within the folders to which you have access. You will not see data sources published to other sites or folders that you do not have permission to view. You can also filter your search by project, owner, or tag. References: https://help.tableau.com/current/pro/desktop/en-us
/connect_basic.htm https://help.tableau.com/current/pro/desktop/en-us/connect_tableauserver.htm When signed in to Tableau Server from Tableau Desktop, you'll only be able to see the data sources that have been published to the site and are within the folders that you have been granted access to. Tableau's permission and project structure mean that you won't see all data sources from the entire server unless you have permissions to do so.
NEW QUESTION # 116
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 My Content area of Tableau web pages
- B. The Notification area of Tableau Prep
- C. The Data Source page of Tableau Desktop
- D. The Shared with Ma page
Answer: A
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 # 117
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: B
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 # 118
A Data Analyst has two tables named EmployeeInfo and DepartmentInfo. EmployeeInfo contains four fields named Full Name, Department ID, Start Date, and Salary. DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP. The analyst wants to combine the tables to meet the following requirements:
* EmployeeInfo is the first table that is dragged to the canvas,
* The records must contain the Full Name, and the Department Name, Size, and VP fields if available,
* Not all records have an exact match.
Which type of join should the analyst use?
- A. Inner
- B. Full outer
- C. Union
- D. Left
Answer: D
NEW QUESTION # 119
You want to add a draft watermark to a dashboard as shown in the following exhibit.
Which type of object should you use?
- A. Sheet
- B. Horizontal
- C. Image
- D. Web page
Answer: C
Explanation:
References: https://help.tableau.com/current/pro/desktop/en-us/dashboards.htm https://help.tableau.com
/current/pro/desktop/en-us/dashboards_create_layouts.htm https://help.tableau.com/current/pro/desktop/en-us
/dashboards_create_watermarks.htm
To add a draft watermark to a Tableau dashboard, you would use an image object. You can overlay this image across your dashboard, possibly with some transparency, to achieve the watermark effect without interfering with the readability of the dashboard content.
NEW QUESTION # 120
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. Condition
- B. Top
- C. General
- D. Wildcard
Answer: D
NEW QUESTION # 121
......
New Analytics-DA-201 Exam Dumps with High Passing Rate: https://exams4sure.pass4sures.top/Tableau-Data-Analyst/Analytics-DA-201-testking-braindumps.html