Cisco®
Oracle
CompTIA
Checkpoint
ISC
EC-Council
EXIN
Fortinet
ITIL®
Juniper
Microsoft
VMware
Avaya
SAP
Google
Salesforce
Amazon
Palo Alto Networks
ISC2
Splunk®
All Vendors
  2. Home
  3. Exams
  4. Salesforce
  5. Analytics-DA-201

Free Salesforce Analytics-DA-201 Exam Questions (page: 2)

Page 2 of 23
PDF with 174 Questions

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?

  1. South
  2. Cast
  3. Central
  4. West

Answer(s): 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.



HOTSPOT (Drag and Drop is not supported)
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.)

  1. See Explanation for the Answer.

Answer(s): A

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.


Reference:

https://help.tableau.com/current/pro/desktop/en-us/actions.htm https://help.tableau.com/current/pro/desktop/en-us/actions_filter.htm



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?

  1. A parameter and a calculated filed
  2. Worksheet actions
  3. Show/hide buttons
  4. Dashboard actions

Answer(s): 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.



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?

  1. From Tableau Desktop, open the Publish Workbook dialog box and configure the schedule.
  2. From Tableau Server select the workbook select Refresh Extracts and then add a new extract refresh
  3. From Tableau Server. select Schedules find the schedule of the extract, and change the frequency to the Last day of the month
  4. From Tableau Server. select Schedules and change the priority of the existing schedule

Answer(s): 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.


Reference:

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.



A colleague provides you with access to a folder that contains the following files:
· Sates.csv
· Bookl.twb
· Sates.hyper
· Export.mdb
Which He contains an extract?

  1. Export mdb
  2. Book1.twb
  3. Sales.hyper
  4. Sales.csv

Answer(s): C

Explanation:

A .hyper file is an extract file that contains a snapshot of data from a data source. It is a compressed and optimized file format that can be used to improve the performance and portability of dashboards and workbooks. A .twb file is a workbook file that contains the visualization and connection information, but not the data itself. A .csv file is a comma-separated values file that contains plain text data. A .mdb file is a Microsoft Access database file that contains tables, queries, forms, and other objects.


Reference:

https://help.tableau.com/current/pro/desktop/en- us/save_savework_packagedworkbooks.htm https://help.tableau.com/current/pro/desktop/en- us/extracting_data.htm https://help.tableau.com/current/pro/desktop/en-us/examples_csv.htm https://support.microsoft.com/en-us/office/introduction-to-access-database-files-9f9a0f8c-9a3c- 4a0b-8e6c-6d1f1f7c2b7e
In Tableau, a .hyper file is an extract file created by the Hyper database engine. It contains a snapshot of the data pulled into Tableau and is used to perform data analysis without the need for a live connection to the data source.



You have the following tiled dashboard that has one sheet.



You want to replace the sheet with Sheet2.
What should you do?

  1. Right-click Sheet2 and select Add to Dashboard.
  2. Select Sheet3 and click the Swap Sheet button next to Sheet2.
  3. From the context menu of Sheet3. select Remove Dashboard item
  4. Drag Sheet2 to the dashboard.
  5. From the context menu of Sheet3. select Deselect

Answer(s): 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.



You have the following line chart that shows the average sales by month.



Which month had the biggest increase in swage sales compared to me previous month in 2019?

  1. August
  2. October
  3. December
  4. November

Answer(s): D

Explanation:

Based on the line chart provided, each point on the line chart represents the average sales for a given month, and the percentage values indicate the change in average sales compared to the previous month. The month of November shows a significant increase from the month of October, indicated by a large upward spike on the chart and a high percentage increase.



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?

  1. The Data Source page of Tableau Desktop
  2. The Notification area of Tableau Prep
  3. The My Content area of Tableau web pages
  4. The Shared with Ma page

Answer(s): C

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.


Reference:

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.



Viewing page 2 of 23



Post your Comments and Discuss Salesforce Analytics-DA-201 exam prep with other Community members:

Analytics-DA-201 Exam Discussions & Posts