100% Pass Guaranteed Accurate Analytics-DA-201 Answers 365 Days Free Updates
Analytics-DA-201 DUMPS Q&As with Explanations Verified & Correct Answers
NEW QUESTION # 63
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 # 64
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:
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 # 65
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 # 66
A Data Analyst has a dataset that contains the fallowing rows of sales data.
The analyst needs 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 this goal? (Choose two.)
- A. [Sales] > 50000
- B. MAX([Sales], 50000)
- C. IF [Sales] > 50000 THEN TRUE ELSE FALSE END
- D. SUM([Sales]) IN (50000)
Answer: A,C
NEW QUESTION # 67
You have the following visualization.
Answer:
Explanation:
Explanation:
NEW QUESTION # 68
A colleague provides a Data Analyst with access to a folder that contains the following files:
Sales.csv
Book1.twb
Sales.hyper
Export.mdb
Which file is a Tableau extract?
- A. Book1.twb
- B. Sales.hyper
- C. Export.mdb
- D. Sales.csv
Answer: B
NEW QUESTION # 69
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 # 70
You have the following Map.
You need the map to appear as shown in the following visualization.
What should you do?
- A. Change the opacity to 75%.
- B. Drag Population to Size on the Marks card.
- C. Change the mark type to Density.
- D. Drag Location to Size on the Marks card.
- E. Change the mark type to Map.
Answer: C
Explanation:
To create a map visualization that shows the concentration of data points in different locations, you need to change the mark type to Density. This will create a heatmap that uses color and size to indicate the density of the data points. You can also adjust the intensity and transparency of the density marks to suit your needs. References: The information is based on the following sources:
* Create Heatmaps that Show Trends or Density in Tableau
* Build a Simple Map - Tableau
NEW QUESTION # 71
Open the link to Book1 found on the desktop. Open Disciplines worksheet.
Filter the table to show the Top 10 NOC based on the number of medals won.
Answer:
Explanation:
check the steps below in explanation.
Explanation:
To filter the table to show the Top 10 NOC based on the number of medals won, 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 NOC, discipline, and medals for each country.
* Drag Medals from the Measures pane to the Filters shelf. This will open a dialog box that allows you to filter by different criteria.
* Select Top from the dialog box. This will show you options to filter by the top or bottom values of a field.
* Enter 10 in the text box next to By field. This will filter by the top 10 values of Medals.
* Select NOC from the drop-down list next to By field. This will filter by the top 10 values of NOC based on Medals.
* Click OK to apply the filter. You will see that the table now shows only 10 rows, one for each NOC with the highest number of medals.
References: https://help.tableau.com/current/pro/desktop/en-us/filtering.htm https://help.tableau.com/current/pro/desktop/en-us/filtering_topn.htm
NEW QUESTION # 72
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. SUM{[Sales]) IN (50000)
- C. MAX< [Sales], 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 # 73
The following table displays the row-level data in a Tableau data source:
A Data Analyst creates this calculated field:
SUM(IF [Item] = 'A' THEN [Sales] END) / COUNT([Order ID])
What is the result of this aggregate calculation?
- A. 0
- B. 1
- C. An error
- D. 2
Answer: B
NEW QUESTION # 74
You have a workbook that uses an extracted data source.
You publish the workbook to Tableau Server.
Which three actions can you perform from the Extract Refresh page in Tableau Server? Choose three.
- A. Delete the refresh.
- B. Change the priority of the refresh.
- C. Run a refresh.
- D. Change the refresh from full to incremental.
- E. Modify the frequency of the refresh.
Answer: A,B,C
NEW QUESTION # 75
A Data Analyst creates a parameter named Choose Region that contains values from a field named Region.
The analyst wants users to be able to use the Choose Region parameter to interact with a chart by toggling between different regions.
What should the analyst do next?
- A. Add the Choose Region parameter to the Pages card.
- B. Add the [Region] = [Choose Region] formula to the Filters card.
- C. Add Region to the Filters card.
- D. Set the Choose Region parameter to Single Value (list).
Answer: B
NEW QUESTION # 76
A Data Analyst has the following sets in a Tableau workbook:
* Top N Customers
* Customers of 2024
* Top N Products
* Sellers of 2024
Which two sets can the analyst combine? (Choose two.)
- A. Sellers of 2024
- B. Customers of 2024
- C. Top N Products
- D. Top N Customers
Answer: B,D
NEW QUESTION # 77
Which function should a Data Analyst use to average sales at a less-granular level of detail than is in the view?
- A. RUNNING_AVG
- B. INCLUDE
- C. AVG
- D. EXCLUDE
Answer: D
NEW QUESTION # 78
You publish a dashboard tut uses an attract. 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 Schedules and change the priority of the existing schedule
- B. From Tableau Server select the workbook select Refresh Extracts and then add a new extract refresh
- C. From Tableau Desktop, open the Publish Workbook dialog box and configure the schedule.
- D. From Tableau Server. select Schedules find the schedule of the extract, and change the frequency to the Last day of the month
Answer: B
Explanation:
To refresh an extract on Tableau Server, you need to select the workbook, select Refresh Extracts, and then add a new extract refresh. You can specify the frequency and time of the refresh, as well as any custom options. You can have multiple extract refreshes for the same workbook with different schedules. References:
https://help.tableau.com/current/server/en-us/refresh_extracts.htm https://help.tableau.com/current/server/en- us/refresh_extracts_add.htm On Tableau Server, you can manage the scheduling of extract refreshes by selecting the specific workbook and configuring additional refresh schedules as needed. This allows for multiple refresh triggers, such as the regular Monday at 10:00 AM schedule, as well as an additional trigger for the last day of the month at 18:00.
NEW QUESTION # 79
In a dataset, you have a string field named Name that contains unnecessary semicolons.
Which function should you use to remove the semicolons from the Name field?
- A. CONTAINS
- B. REPLACE
- C. TRIM
- D. SPLIT
Answer: B
Explanation:
The REPLACE function is used to replace all occurrences of a substring within a string with another substring. In this case, it can be used to remove the semicolons from the Name field by replacing them with an empty string. For example, REPLACE ("John;Doe", ";", "") = "JohnDoe". References: The information is based on the following sources:
* String Functions - Tableau
* Remove special characters and add a semi colon in a word - Tableau
NEW QUESTION # 80
You want to add a draft watermark to a dashboard as shown in the following exhibit.
Which type of object should you use?
- A. Horizontal
- B. Image
- C. Web page
- D. Sheet
Answer: B
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 # 81
Which option must a Data Analyst enable to build the following table to add quarterly totals?
- A. Add Pane Totals
- B. Show Column Grand Totals
- C. Show Row Grand Totals
- D. Add All Subtotals
Answer: D
NEW QUESTION # 82
......
Salesforce Analytics-DA-201 Exam Syllabus Topics:
| Topic | Details |
|---|---|
| Topic 1 |
|
| Topic 2 |
|
| Topic 3 |
|
| Topic 4 |
|
| Topic 5 |
|
Analytics-DA-201 dumps Exam Material with 176 Questions: https://www.prepawaypdf.com/Salesforce/Analytics-DA-201-practice-exam-dumps.html
Analytics-DA-201 Questions and Answers Guarantee you Oass the Test Easily: https://drive.google.com/open?id=1FY1LY0Rr4UaFY4KR5vlqHNBlK6cH-Xku