Free Analytics-DA-201 Exam Braindumps - New 2025 Salesforce Pratice Exam
Practice Test for Analytics-DA-201 Certification Real 2025 Mock Exam
Salesforce Analytics-DA-201 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
NEW QUESTION # 82
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 # 83
You want to create the following dashboard.
The dashboard will contain two sheets that will connect to the same data source. The top sheet will be configured to filter the bottom sheet.
When you click a category on the top sheet, the sheets must resize as shown in the following exhibit.
How should you lay out the objects on the dashboard?
- A. Add both sheets to the dashboard. Set Fit to Fix width.
- B. Drag a vertical container to the dashboard and add both sheets to the container. Set Fit to Entire view.
- C. Drag a blank object to the dashboard and add both sheets to the dashboard. Set Fit to Entire view.
- D. Drag a horizontal container to the dashboard and add both sheets to the container. Set the Fit to Standard.
Answer: B
Explanation:
To create the dashboard as shown in the image, you need to use a vertical layout container that will adjust the height of the sheets according to the window size. You also need to set the Fit to Entire view option for both sheets so that they will resize proportionally when you click a category on the top sheet. This way, you can achieve the desired effect of having the bottom sheet expand to fill the space left by the top sheet when it filters out some categories. References:
* Size and Lay Out Your Dashboard - Tableau
* Create a Dashboard - Tableau
* Format Dashboard Layout in Tableau - GeeksforGeeks
NEW QUESTION # 84
In a worksheet, you have a calculated column named YTD Sales that uses the following formula.
[Order Date] <= TODAY () AND DATETBUNC {"year", [Order Dace]) = DATETPUNC)"year", TODAY(J) You want to create a calculated column named Exclude Current Month that will be dragged to the Filters shell. Exclude Current Month will exclude the current month values from YTD Sales.
How should you complete the formula for Exclude Current Month? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)
Answer:
Explanation:
Explanation:
NEW QUESTION # 85
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:
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 # 86
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. Integer
- C. Float
- D. Boolean
Answer: B,C
NEW QUESTION # 87
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. DATEDIFF, DATEPART
- D. DATETRUNC, DATEPART
Answer: D
NEW QUESTION # 88
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. Condition filter
- B. Wildcard filter
- C. Top filter
- D. General filter
Answer: A
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 # 89
You have the following tiled dashboard that has one sheet.
You want to replace the sheet with Sheet2.
What should you do?
- A. Select Sheet3 and click the Swap Sheet button next to Sheet2.
- B. From the context menu of Sheet3. select Remove Dashboard item
- C. From the context menu of Sheet3. select Deselect
- D. Drag Sheet2 to the dashboard.
- E. Right-click Sheet2 and select Add to Dashboard.
Answer: D
Explanation:
In Tableau, to replace a sheet on a dashboard, you can simply drag the desired sheet (Sheet2 in this case) from the sheets list onto the dashboard area where the current sheet (Sheet3) resides. This action will replace the existing sheet with the new one. Right-clicking and adding to the dashboard adds an additional sheet rather than replacing, and the context menu options mentioned in the other choices are not the standard methods for replacing sheets within a dashboard.
NEW QUESTION # 90
A Data Analyst has the following chart.
The analyst needs to enable the drilldown from Category to Subcategory as shown in the following chart.
What should the analyst create?
- A. A group of Category and Subcategory
- B. A combined set for Category and Subcategory
- C. A bin for Category and a bin for Subcategory
- D. A hierarchy of Category and Subcategory
Answer: D
NEW QUESTION # 91
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 Attribute.
- B. Drag the LOD expression to the Filters shelf.
- C. Change the LOD expression to { FIXED [Region], [State] : SUM([Sales]) }.
- D. Right-click the State dimension filter, and then click Add to Context.
Answer: D
NEW QUESTION # 92
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. MAX< [Sales], 50000)
- B. SUM{[Sales]) IN (50000)
- C. [Sales] > 50000
- D. IIF(SUM< [Sales] )>50000, TRUE, FALSE)
Answer: C,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 # 93
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. Full join
- B. Inner join
- C. Left join
- D. Unmatched only join
Answer: B
NEW QUESTION # 94
Below are some of the values in the Order_ID field:
Which calculation should a Data Analyst use to return the two-letter combinations starting with the letter "P" for each of these values?
- A. FINDNTH([Order_ID], "P*", 1)
- B. MID([Order_ID], FIND([Order_ID], "P") + 1, 2)
- C. SPLIT([Order_ID], "_", -2)
- D. LEFT(SPLIT([Order_ID], "_", 2), 2)
Answer: B
NEW QUESTION # 95
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 # 96
You have the following dataset.
Yon need to calculate the ranking shown in the Rank 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:
To calculate the ranking shown in the Rank field, you need to use the RANK_UNIQUE function, which returns the unique rank of each value in a partition. You need to specify the expression as SUM([Sales]), which calculates the total sales for each product. You also need to specify the order as descending, which means that the highest sales will have the lowest rank. Finally, you need to specify the restart as every
[Category], which means that the ranking will reset for each category. References: https://help.tableau.com
/current/pro/desktop/en-us/functions_functions_tablecalculation.htm https://help.tableau.com/current/pro
/desktop/en-us/calculations_calculatedfields_lod_rank.htm
NEW QUESTION # 97
You have a data source that contains the following columns.
You have the following view that shows the percentage of total sales by category:
You want to change the calculation to show the percentage of total sales within the categories of every region annually. Which Compute Using option should you use? (Click the appropriate Option in the Answer Area.)
Answer:
Explanation:
Explanation:
NEW QUESTION # 98
A Data Analyst is creating an annual report in Microsoft Word.
In Tableau Desktop, the analyst built a chart in a worksheet.
The analyst wants to create an image of the chart to add to the annual report.
Which two options should the analyst use to create the image? (Choose two.)
- A. Copy Image option from the Dashboard menu
- B. Export As Version option from the File menu
- C. Export Image option from the Dashboard menu
- D. Export option from the Worksheet menu
- E. Copy option from the Worksheet menu
Answer: D,E
NEW QUESTION # 99
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 the workbook, select Refresh Extracts, and then add a new extract refresh.
- B. From Tableau Server, select Schedules, find the schedule of the extract, and change the frequency to the last day of the month.
- C. From Tableau Server, select Schedules, and change the priority of the existing schedule.
- D. From Tableau Desktop, open the Publish Workbook dialog box and configure the schedule.
Answer: A
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 # 100
A Data Analyst wants to create the following table in a view:
Which function should the analyst use to create the Position column?
- A. INDEX
- B. RANK
- C. LAST
- D. FIRST
Answer: D
NEW QUESTION # 101
......
Prepare For Realistic Analytics-DA-201 Dumps PDF - 100% Passing Guarantee: https://www.premiumvcedump.com/Salesforce/valid-Analytics-DA-201-premium-vce-exam-dumps.html
Check the Available Analytics-DA-201 Exam Dumps with 176 QA's: https://drive.google.com/open?id=1n8WRWfuabeJNgXw-nygCIdArL4cM79qy