March Special Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: buysanta

Exact2Pass Menu

Question # 4

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?

A.

August

B.

October

C.

December

D.

November

Full Access
Question # 5

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.

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

What should you do?

A.

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

B.

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

C.

Edit the aliases for City.

D.

Drag Region to Tooltip on the Marks card

Full Access
Question # 6

You have the following dataset.

You need to create the following worksheet.

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)

Full Access
Question # 7

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.

Full Access
Question # 8

Open the link to Book1 found on the desktop. Open the sales dashboard.

Add the Sales by State sheet in a Show/Hide button to the right side of the dashboard.

Full Access
Question # 9

Open the link to Book1 found on the desktop. Open the Histogram worksheet and use the Superstone data source.

Create a histogram on the Quantity field by using bin size of 3.

Full Access
Question # 10

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.

Full Access
Question # 11

Open the link to Book1 found on the desktop. Open the Movie Durations worksheet.

Replace the existing data source with the Netflix_2019 data source.

Full Access
Question # 12

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.

Full Access
Question # 13

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

Full Access
Question # 14

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.

Full Access
Question # 15

You want to add a draft watermark to a dashboard as shown in the following exhibit.

Which type of object should you use?

A.

Image

B.

Sheet

C.

Web page

D.

Horizontal

Full Access
Question # 16

Open the link to Book1 found on the desktop. Open the Line worksheet.

Modify the chart to show only main and max values of both measures in each region.

Full Access
Question # 17

Open the Link to Book1 found on the desktop. Open Map worksheet and use Superstore data source.

Create a filed map to show the distribution of total Sales by State across the United States.

Full Access
Question # 18

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?

Full Access
Question # 19

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.

Right-click Sheet2 and select Add to Dashboard.

C.

From the context menu of Sheet3, select Deselect.

D.

Drag Sheet2 to the dashboard.

E.

From the context menu of Sheet3, select Remove Dashboard Item.

Full Access
Question # 20

You have the following dataset:

Which grouping option should you use in Tableau Prep to group all five names automatically?

A.

Pronunciation

B.

Spelling

C.

Manual Selection

D.

Common Characters

Full Access
Question # 21

You have a Tableau workbook that contain three worksheets named Sheet1 Sheet2 and Sheet3.

You create several filters.

From the Data Source page you plan to add data source fillers

When type of filter will appear in the Edit Data Source Filters dialog box?

A.

A table calculation filter used on Sheet

B.

A top N condition filer on a dimension in Sheet 1 and Sheet2

C.

A context filler on a dimension m Sheet3

D.

A dimension filter on all the sheets

Full Access
Question # 22

You have the following dataset.

When you use the dataset in a worksheet, you want Sales to appear automatically as shown in the following table.

What should you do?

A.

Change the data type of the Sates field to Siring

B.

Create a calculated field that uses a formula of 'S' * str (Round((sales],2)) + 'k'

C.

Change the default number format of the Sales told

D.

Create a calculated field that uses a formula of 'S' + stri < (Sales)/1000)).

Full Access
Question # 23

You have the following worksheet.

You want to create a table calculation that shows sales growth over each year.

How should you complete the formula? (Use the dropdowns in the Answer Area to select the correct options to complete the formula.)

Full Access
Question # 24

You have the following table.

You need each record to alternate between grey and white.

What should you change in the Format Shading pane?

A.

the row banding size to 1

B.

the column banding size to 1

C.

the row banding size to 3

D.

the column banding size to 3

Full Access
Question # 25

You have the following primary data source that contains a dimension named Dorm_Code.

You receive the following secondary data source that contains updated dorm codes.

You need to bring the updated dorm codes into Tableau and use the codes in existing visualizations. The new dorm codes must use the existing field name of Dorm_Code.

What should you do?

A.

Bring in the secondary data source as a union.

B.

Bring in the secondary table as a left join to the primary data source. From the Data Source page, select Create Calculated Field in the Dorm_Name field and enter [Dcrm_Name_New] in the calculation window

C.

Bring in the secondary data source by using relationships. From the Data pane, right-click Dorm_Name select Replace References, and then select Dorm_Name_New

D.

Create a data blend and select Edit Primary Aliases to replace the primary data source alias values with values from the secondary data source

Full Access
Question # 26

You have the following visualization.

You Create a table calculation named Rank_Score that has a formula of RANK(AVG([Score]), and you drag Rank_Score to Text on the Marks cards.

What is the Rank Score value for Student ID 4220?

A.

5

B.

4

C.

6

D.

3

Full Access
Question # 27

You want to connect a Tableau workbook to a dataset in a Microsoft Excel spreadsheet.

What should you do from Tableau Desktop?

A.

From the Data menu select New Data Source

B.

From the Data menu select Replace Data Source

C.

From the File menu select Import Workbook

D.

From the File menu select New

Full Access
Question # 28

You have the following data source in tableau Server.

You need to ensure that the data is updated every hour.

What should you select?

A.

New

B.

Extract Refreshes

C.

Connected Workbooks

D.

Connections

Full Access
Question # 29

You have the following tiled dashboard that has one sheet.

You want to replace the sheet with Sheet2.

What should you do?

A.

Right-click Sheet2 and select Add to Dashboard.

B.

Select Sheet3 and click the Swap Sheet button next to Sheet2.

C.

From the context menu of Sheet3. select Remove Dashboard item

D.

Drag Sheet2 to the dashboard.

E.

From the context menu of Sheet3. select Deselect

Full Access
Question # 30

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?

A.

South

B.

Cast

C.

Central

D.

West

Full Access