[UPDATED 2025] Getting Analytics-DA-201 Certification Made Easy!
Analytics-DA-201 Exam Crack Test Engine Dumps Training With 176 Questions
NEW QUESTION # 43
You have the following dataset:
Which grouping option should you use in Tableau Prep to group all five names automatically?
- A. Pronunciation
- B. Manual Selection
- C. Common Characters
- D. Spelling
Answer: C
Explanation:
Common Characters: Find and group values that have letters or numbers in common. This option uses the ngram fingerprint algorithm that indexes words by their unique characters after removing punctuation, duplicates, and whitespace. This algorithm works for any supported language. This option isn't available for data roles. For example, this algorithm would match names that are represented as "John Smith" and "Smith, John" because they both generate the key "hijmnost". Since this algorithm doesn't consider pronunciation, the value "Tom Jhinois" would have the same key "hijmnost" and would also be included in the group.
NEW QUESTION # 44
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. Left join
- B. Full join
- C. Inner join
- D. Unmatched only join
Answer: C
NEW QUESTION # 45
A Data Analyst has a data source that contains data for every city in the United States. The following is a sample of the data.
The analyst needs to use the City dimension to create a dynamic filter that shows the cities that have a population greater than 1 million.
Which type of filter should the analyst use?
- A. Special
- B. Condition
- C. Range
- D. Top
Answer: B
NEW QUESTION # 46
A Data Analyst has the following view.
The analyst wants to filter the view to show only records that have a movie name starting with the word
"The". The analyst must achieve the goal without writing any formulas.
Which type of filter should the analyst use?
- A. Wildcard
- B. Top
- C. Condition
- D. General
Answer: A
NEW QUESTION # 47
You have a table that contains the following data.
How should you complete the formula? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)
Answer:
Explanation:
Explanation:
To complete the formula, you should drag the option MAX from the list of options and drop it into the first blank space, and then drag the option [Sales] and drop it into the second blank space. The formula will look like this: Option (MAX) Option ([Sales]). This formula will calculate the maximum value of the sales field for each country. You can use this formula to create a calculated field that will show the highest sales amount for each country in your data source. References:
* Create a Simple Calculated Field - Tableau
* MAX Function - Tableau
* Tableau Certified Data Analyst Study Guide
NEW QUESTION # 48
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 # 49
You want to create the following table in a view.
Which function should you use to create the Position column?
- A. FIRST
- B. INDKX
- C. LAST
- D. RANK
Answer: A
Explanation:
To create the Position column, you should use the FIRST () function. The FIRST () function returns the number of rows from the current row to the first row in the partition. For example, the first row in a partition will return 0, the second row will return -1, and so on. In this question, the partition is defined by the Segment field, and the table is sorted by the Sales field in descending order. Therefore, the Position column shows the offset of each row from the first row in each segment, based on the sales ranking. References:
* Tableau Certified Data Analyst Exam Prep Guide, page 11, section "Creating Calculated Fields"
* Tableau Help: FIRST Function
NEW QUESTION # 50
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. Float
- C. Integer
- D. Boolean
Answer: B,C
NEW QUESTION # 51
You have a sales dataset that contains the following fields.
You need to analyze the average revenue per product in different regions over time.
Which two fields should be measures? Choose two.
- A. Order Date
- B. Quantity
- C. Customer Region
- D. Revenue
- E. Product Name
Answer: B,D
Explanation:
To analyze the average revenue per product in different regions over time, you need to use two fields that contain numeric, quantitative values that you can measure and aggregate. Quantity and Revenue are both measures that fit this criterion. You can multiply Quantity and Revenue to get the total sales for each product, and then divide by the number of products to get the average revenue. You can also use these measures to create charts and tables that show the trends and comparisons over time and across regions. References:
* Dimensions and Measures, Blue and Green - Tableau
* Tableau Certified Data Analyst Study Guide
NEW QUESTION # 52
A Data Analyst has the following bar chart.
The analyst wants the chart to appear as shown in the following exhibit.
What should the analyst add?
- A. A reference band
- B. An average line
- C. A reference line
- D. A distribution band
Answer: D
NEW QUESTION # 53
You have the following dataset.
You plan to create a dashboard that will be filtered to show only data that is relevant to a specific Tableau user based on the Tableau_User_Name field You need to create a boolean calculated field to place on the data source finer Which formula should you use for the filter?
- A. USERNAME()=(Tableau_USER_NAME)
- B. NAME Tableau-USER-NAME)
- C. ISFULLNAMETableu_USER_NAME))=USERNAME()
- D. NAMEUSERNAME()
Answer: A
Explanation:
To create a boolean calculated field to place on the data source filter, you should use the formula USERNAME() = [Tableau_user]. This formula will return TRUE if the current Tableau user name matches the value in the Tableau_user field, and FALSE otherwise. You can use this formula as a data source filter by dragging it to the Filters shelf and selecting TRUE from the menu. This will filter the data to show only the rows that are relevant to the specific Tableau user.
The other options are not correct for this scenario. NAME([Tableau_user]) is not a valid function in Tableau.
ISFULLNAME([Tableau_user]) = USERNAME() is not a valid expression in Tableau. 'S' + STR([Sales]
/1000) is not a boolean expression, but a string expression that converts sales to thousands with a prefix of
"S". References: https://help.tableau.com/current/pro/desktop/en-us/filtering_datasource.htm https://help.
tableau.com/current/pro/desktop/en-us/functions_functions_logical.htm#USERNAME https://help.tableau.
com/current/pro/desktop/en-us/calculations_calculatedfields.htm
In Tableau, the USERNAME() function returns the username of the user who is currently logged in. To create a filter that only shows data relevant to the logged-in Tableau user, a boolean calculated field can be created to compare the current username with the usernames listed in the Tableau_User_Name field of the dataset. Therefore, the correct formula for this filter is USERNAME() = [Tableau_USER_NAME], which will return true for rows where the Tableau_User_Name matches the current user's username.
NEW QUESTION # 54
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. Change the LOD expression to { FIXED [Region], [State] : SUM([Sales]) }.
- B. Drag the LOD expression to the Filters shelf.
- C. Right-click the State dimension filter, and then click Add to Context.
- D. Right-click the State dimension filter, and then click Attribute.
Answer: C
NEW QUESTION # 55
You have the following dashboard.
From the context menu of Sales over time, select Ignore Actions.
Several Lays later, you decide that you want to filter both Sales over time and Detail table by selecting a data point on the map.
What should you do?
- A. From the context menu of Sales over lime, select Filters and then select Enable Auto Update.
- B. From the context menu of Profits by state, deselect Use as Filter and then select Use as Filter.
- C. From the context menu of Detail table, select Ignore Actions.
- D. From the context menu of Sales over time, select Use as Filter and then deselect Use as Filter
Answer: B
NEW QUESTION # 56
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 row banding size to 1
- B. the column banding size to 1
- C. the column banding size to 3
- D. the row banding size to 3
Answer: A
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 # 57
You have two tables named Employeelnfo and DepartmentInfo. Employeelnfo contains four fields named Full Name, Department ID, Start Date, and Salary.
DepartmentInfo contains four fields named Department Name, Size, Department ID, and VP.
You want to combine the tables to meet the following requirements:
. Each record in Employeelnfo must be retained in the combined table.
. The records must contain the Department Name, Size, and VP fields.
* Every record must have a full name.
Which type of join should you use?
- A. Full outer
- B. Left
- C. Union
- D. Inner
Answer: B
Explanation:
To combine the tables and meet the requirements, you should use a left join. A left join will keep all the records from the left table (Employeelnfo) and match them with the records from the right table (DepartmentInfo) based on the common field (Department ID). If there is no matching record in the right table, the fields from the right table will be null. This way, you will retain all the records from Employeelnfo, and also include the Department Name, Size, and VP fields from DepartmentInfo. Every record will have a full name because it is a field from the left table. A left join will look like this:
References:
Join Your Data - Tableau
Join Types in Tableau
NEW QUESTION # 58
In a dataset, a Data Analyst has a string field named Name that contains unnecessary semicolons.
Which function should the analyst use to remove the semicolons from the Name field?
- A. CONTAINS
- B. SPLIT
- C. FIND
- D. REPLACE
Answer: D
NEW QUESTION # 59
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. Show/hide buttons
- C. A parameter and a calculated filed
- D. Worksheet actions
Answer: C
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 # 60
You have the following visualization.
Answer:
Explanation:
NEW QUESTION # 61
......
Salesforce Analytics-DA-201 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
Analytics-DA-201 Exam Dumps Contains FREE Real Quesions from the Actual Exam: https://www.examsreviews.com/Analytics-DA-201-pass4sure-exam-review.html
Obtain the Analytics-DA-201 PDF Dumps Get 100% Outcomes Exam Questions For You To Pass: https://drive.google.com/open?id=1_6sVNIGl7Et2o8zcZInG-DtK-0qPu9aH