Halloween Sale Special Limited Time 75% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code = drift75

Home
Salesforce
Tableau Data Analyst
Analytics-DA-201
Salesforce Certified Tableau Data Analyst Questions and Answers

Pass the Salesforce Tableau Data Analyst Analytics-DA-201 Questions and answers with ExamsMirror

Practice at least 50% of the questions to maximize your chances of passing.

Exam Analytics-DA-201 Premium Access

View all detail and faqs for the Analytics-DA-201 exam

Go to Exam

740 Students Passed

93% Average Score

97% Same Questions

Viewing page 7 out of 7 pages

Viewing questions 61-70 out of questions

Questions # 61:

You want to create the following dashboard that will contain two sheets.

Question # 61

What should you do?

Options:

Drag both sheets to the dashboard and add a border to each sheet.

Drag both sheets to the dashboard and add a background lo each sheet.

Add both sheets lo a horizontal container and add a border to the container.

Add a border to both sheets and add both sheets to a horizontal object.

Answer

Questions # 62:

A Data Analyst has a dataset that contains people and the awards they have won.

Question # 62

Which formula should the analyst use to get the number of different types of awards that have been won?

Options:

COUNTD ( [NAME] )

COUNT ( [Award] )

WINDOW_COUNT ( [Award] )

COUNTD ( [Award] )

Answer

Questions # 63:

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.)

Question # 63

Options:

Answer

Answer:

Questions # 64:

You create the following story that contains two story point.

Question # 64

You want to change the story point format to show the current story point number out of the total number of story points.

Which Layout option should you use?

Options:

Dots

Arrows only

Caption boxes

Numbers

Answer

Explanation

To change the story point format to show the current story point number out of the total number of story points, you should use the Numbers option in the Layout tab. This option will display the story points as numbers in a horizontal or vertical sequence, such as 1/2, 2/2. You can also choose to show or hide the next and previous arrows for navigation. The Numbers option will help you indicate the progress and order of your story points more clearly than the other options. References:

Creating a Story - Tableau

New in 9.0: Formatting the Story Points Navigator - Tableau

Tableau Certified Data Analyst Study Guide

Questions # 65:

You have the following dataset.

Question # 65

You need to create the following worksheet.

Question # 65

The table must show either profit or sales based on the selection from the Parameter 1 menu.

Which three actions should you perform in orders

(Place the three correct options in order Use the arrows to move Options lo Answer Area Use Answer Area arrows to reorder the options)

Question # 65

Options:

Answer

Answer:

Questions # 66:

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

Question # 66

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

Options:

August

October

December

November

Answer

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.

Questions # 67:

You have the following dataset.

Question # 67

Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?

Options:

{FIXED: [Region] SUM Sales}

{FIXED: SUM Sales}

{Fixed: [Region]: TOTAL Sales}

{FIXED: TOTAL (Sales)}

Answer

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

Questions # 68:

You have the following box plot that shows the distribution of average profits made in every state by region.

Question # 68

Which region has the smallest distribution of profits?

Options:

South

Cast

Central

West

Answer

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.

Questions # 69:

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?

Options:

The Data Source page of Tableau Desktop

The Notification area of Tableau Prep

The My Content area of Tableau web pages

The Shared with Ma page

Answer

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.

Questions # 70:

You have a database that includes field named sales, City and Region.

You have the following chart that shows the number of sales made in different cities.

Question # 70

You want to dynamically show the corresponding region when users hover their mouse over any of the bars.

What should you do?

Options:

Right-click a in the chat, select Annotate and then select Mark.

Right-click a bar in the chart select Mark Label and then select Always show.

Edit the aliases for City.

Drag Region to Tooltip on the Marks card

Answer

Explanation

To show the corresponding region when users hover their mouse over any of the bars, you need to drag Region to Tooltip on the Marks card. This will add Region as a field in the tooltip text that appears when users hover over a mark. You can also customize the tooltip text by editing it in the Tooltip dialog box. References: https://help.tableau.com/current/pro/desktop/en-us/buildmanual_shelves.htm https://help.tableau.com/current/pro/desktop/en-us/formatting_tooltips.htm

To show additional information such as the corresponding region when hovering over a bar in Tableau, you can drag the ' Region ' field to the ' Tooltip ' shelf on the ' Marks ' card. This will ensure that when a user hovers over a bar representing a city, the tooltip will dynamically display the region associated with that city.

Viewing page 7 out of 7 pages

Viewing questions 61-70 out of questions