Salesforce Analytics-DA-201 Real Exam Questions Test Engine Dumps Training With 176 Questions [Q95-Q117]

QUESTION 95
A Data Analyst would like to receive the draft results of a colleague’s Tableau Prep flow to start work on a dashboard before it has been published.
What should the analyst do to accomplish this?

On the Tableau Desktop Connect page, under To a File, choose “More …”, and browse for the colleague’s .tf file on the local file system.

Have the colleague output the results of the flow to a .hyper file. Create a new workbook in Tableau Cloud, choose Files on the Connect to Data page, and upload the .hyper file from the computer.

Open Tableau Desktop and make a connection to Tableau Prep, then choose the colleague’s flow that the analyst wants to connect to.

Have the colleague output the results of the flow to a .hyper file. On the Tableau Desktop Connect page, under To a File, choose “More …”, and browse for the .hyper file on the local file system.

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

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

QUESTION 97
You are subscribed to several views.
You need to unsubscribe from the views.
What should you use?

The My Content area of Tableau web pages

The Notifications area of Tableau Prep

The Data Source page of Tableau Desktop

The Shared with Me page

QUESTION 98
You conned to a Microsoft SQL Server database
You need to create a custom SQL query that retrieves rows from a table named Students Only students m the city of Berlin must be returned How should you complete the query? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

QUESTION 99

You need the top 10 values to appear in a different color. The lop 10 values must be colored dynamically.
What should you do?

Select the lop 10 bars, create a set. and then drag the set to Color on the Marks card.

Create a group field that groups the top 10 values into one group and the rest of the values into another group. Drag the group field to Color on the Marks card.

Select the top 10 bars, and then change the color by selecting Color on the Marks card.

Create a set that has a top 10 condition, and then drag the set to Color on the Marks card.

QUESTION 100
You plan to create a visualization that has a dual axis chart. The dual axis chart will contain a shape chart and a line chart will use the same measure named Population on the axis.
You need to configure be shapes to be much larger than the line.
What should you do?

Duplicate Population Drag the duplicate to the second Marks card and configure the see of the marks independently

Create a custom shape that is larger than the default shape and add the shape to the Shapes folder in My Repository

For the second axis select Shape on the Marks card From Select Shape Palette select Custom and then select Reset

Change Population to a discrete dimension

QUESTION 101
You have the following dataset.
Which Level of Detail (LOD) expression should you use to calculate tie grand total of all the regions?

{FIXED: [Region] SUM Sales}

{FIXED: SUM Sales}

{Fixed: [Region]: TOTAL Sales}

{FIXED: TOTAL (Sales)}

QUESTION 102
You are creating a new dashboard.
You need to add a button to the dashboard that allows users to export the dashboard as an image.
Which type of object should you use?

Image

Ask Data

Extension

Download

Navigation

QUESTION 103
You have the following map.

You need the map to appear as shown in the following visualization.
What should you do?

Change the mark type to Density

Drag Location to Size on the Marks card

Change the mark type to Map

Drag Population to Size on the Marks card

Change the opacity to 75%

The question presents a scenario where a geographic map visualization in Tableau needs to be transformed from a series of discrete circles representing data points to a density map visualization. The density map shows concentrations of data points with a gradient of color, where denser areas are indicated by a darker color.
Here’s the explanation for each option:
A). Change the mark type to Density: This is the correct answer because changing the mark type to ‘Density’ in Tableau creates a density map, which displays the concentration of data points with a color gradient. This is exactly what is needed to achieve the visual effect shown in the second image, where regions with a higher concentration of data points are represented by darker shades.
B). Drag Location to Size on the Marks card: This option would adjust the size of the marks based on the number of locations, which is not relevant to creating a density map. It would result in varying sizes of circles, not a continuous gradient.
C). Change the mark type to Map: The visualization is already using a map. This option would not change the visualization to the desired density map.
D). Drag Population to Size on the Marks card: This would change the size of the circles based on the population values, making some circles larger and others smaller. This is not how a density map is created, which uses color intensity rather than size to show concentration.
E). Change the opacity to 75%: Changing the opacity would affect the transparency of the marks on the map but would not transform the visualization into a density map.
To achieve the visualization shown in the second image, the mark type must be changed to ‘Density,’ which will produce a heat map-like effect where the color intensity represents the concentration of data points.
Therefore, the correct answer is A. Change the mark type to Density.
To create a density map from a scatter plot of data points, you would change the mark type to Density. This mark type allows you to visualize the concentration of data points in an area, which can be useful for identifying clusters or patterns in geospatial data.

QUESTION 104
You have the following visualization.
The Last() calculation is set to compute using Table (across)
Which value will appear in the crosstab for the Consumer segment of the year 2018 if you change compute to use Oder Dale?

0

2

4

3

QUESTION 105
You create a worksheet named Sales by Region and hide the tide of the worksheet. You print the worksheet as a PDF and notice that the worksheet title appears. You need to prevent the title from appearing when you print the worksheet as a PDF. Which settings should configure from the File menu in Tableau Desktop?

Page Setup

Print

Export As PowerPoint

Share

Export As Version

QUESTION 106
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?

NAMEUSERNAME()

ISFULLNAMETableu_USER_NAME))=USERNAME()

NAME Tableau-USER-NAME)

USERNAME()=(Tableau_USER_NAME)

QUESTION 107
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?

Drag the LOD expression to the Filters shelf.

Change the LOD expression to { FIXED [Region], [State] : SUM([Sales]) }.

Right-click the State dimension filter, and then click Attribute.

Right-click the State dimension filter, and then click Add to Context.

QUESTION 108
You have the following:

Overall Rank and Rank are calculated fields that use the RANK function.
You filter out the sub-category where [Ovorall Rank] – 1.
For which three the sub-categories will the value of Rank change? Choose three.

Furnishings

Tables

Chairs

Accessories

Copiers

Machines
G Phones

Bookcases

In Tableau, the RANK function assigns a rank to each row within a partition of the data, based on the value of the field being ranked. It is important to understand that the rank is recalculated whenever the underlying data or the partitioning changes.
In the given scenario, the Overall Rank is based on the Sales figures, while the Rank (presumably) is based on the Sales within the Category. When filtering on the condition where [Overall Rank] – 1, it means we are excluding the sub-category that has an Overall Rank of 2.
Looking at the data:
* Furnishings has an Overall Rank of 8, which does not meet the filter condition ([Overall Rank] – 1).
Therefore, its rank remains the same.
* Tables have an Overall Rank of 3. When the sub-category with an Overall Rank of 2 is removed (Chairs in this case), Tables move up in the overall ranking. However, since Tables are the top-ranked within the Furniture category, their Rank within the category would remain unchanged at 1.
* Chairs have an Overall Rank of 2, which meets the filter condition and thus will be removed from the view. We cannot determine the change in Rank for Chairs because they are filtered out.
* Accessories have an Overall Rank of 5. If any sub-category with a higher Overall Rank (1 to 4) is removed, the rank of Accessories within the Technology category could change because it is currently ranked 3 in its category. With the removal of Phones (Overall Rank 1), the Rank of Accessories could potentially increase.
* Copiers have an Overall Rank of 6, which does not meet the filter condition. Therefore, its rank remains the same.
* Machines have an Overall Rank of 4. If we remove Phones (Overall Rank 1), Machines will move up in the overall ranking and potentially within the Technology category as well, changing its Rank from 2 to 1.
* Phones have an Overall Rank of 1, which does not meet the filter condition of being Overall Rank 2.
Therefore, its rank remains the same.
* Bookcases have an Overall Rank of 7, which does not meet the filter condition. Therefore, its rank remains the same.
Based on this analysis, when the sub-category with an Overall Rank of 2 (Chairs) is removed, the Rank value will change for Tables, Accessories, and Machines, as they will move up in the overall ranking within their respective categories. However, it’s important to note that while Tables will move up in the overall ranking, their rank within the Furniture category would not change as they are already at the top. The rank changes for Accessories and Machines are due to the removal of Phones, which is ranked higher overall and within the Technology category.

QUESTION 109
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?

Top

General

Condition

Wildcard

QUESTION 110
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?

From the context menu of Sales over lime, select Filters and then select Enable Auto Update.

From the context menu of Profits by state, deselect Use as Filter and then select Use as Filter.

From the context menu of Detail table, select Ignore Actions.

From the context menu of Sales over time, select Use as Filter and then deselect Use as Filter

QUESTION 111
You have a table that contains four columns named Order Date, Country, Sales, and Profit.
You need to add a column that shows the day of the week for each row. For example, orders placed on August
31, 2022, will show a day of
Wednesday.
How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

QUESTION 112
Open the link to Book1 found on the desktop. Open SalesVSProfit worksheet.
Add a distribution band on Profit to show the standard deviation from- 1 to 1.

QUESTION 113
You have the following table.

You need each record to alternate between grey and white.
What should you change in the Format Shading pane?

the row banding size to 1

the column banding size to 1

the row banding size to 3

the column banding size to 3

QUESTION 114
You have a dashboard than contains two sheets named Sheet 1 and Sheet 2.
You want to add an object to the dashboard that users can click to switch to a different dashboard in the workbook.
Which object should you add to the dashboard?

QUESTION 115
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?

South

Cast

Central

West

QUESTION 116
You have the following dataset:
You want to create a parameter to dynamically filter the data to produce the following results.
Which two types of parameters can you use to produce the results? Choose two.

Float

Boolean

Date

Datetime

String

Integer

QUESTION 117
Open the link to Book1 found on the desktop. Open the CategoryPercentage worksheet.
Modify the bar chart show the percentage of sales for each Subcategory within every Category. The total percentage for every Category must be 100%.