Weekend Sale Limited Time Flat 70% Discount offer - Ends in 0d 00h 00m 00s - Coupon code: 70spcl

Salesforce Analytics-DA-201 Salesforce Certified Tableau Data Analyst Exam Practice Test

Page: 1 / 17
Total 174 questions

Salesforce Certified Tableau Data Analyst Questions and Answers

Question 1

You have the following dataset in Microsoft Excel.

You are using Data interpreter to cleans the dataset. Data interpreter provides the following results.

How many rows of data will be ingested into Tableau as values?

Options:

A.

10

B.

20

C.

17

D.

15

Question 2

A Data Analyst at a coffee company has the following visualization already built.

Question # 2

The analyst wants to make this more visually appealing by coloring the bars based on whether they are above or below the Average Sales within each Product Type.

Which calculation should the analyst use to calculate the Average Sales for each Product Type?

Options:

A.

( FIXED [Product] : AVG( (FIXED [Product Type] : AVG( [Sales] ) ) )

B.

{ EXCLUDE [Product] : SUM( [Sales] ) }

C.

{ FIXED [Product Type] : AVG( [Sales] ) }

D.

: FIXED ([Product Type]) : AVG( [ FIXED [Product] : SUM( [Sales] ) ] )

Question 3

You connect to a database server by using Tableau Prep. The database server has a data role named Role1.

You have the following field in the data.

You need to apply the Role1 data role to the Material field.

Which two actions should you perform? Choose two.

Options:

A.

From the More actions menu of Materials, select Valid in the Show values section.

B.

For the data type of the Material field, select Custom, and then select Role1.

C.

From the More actions menu of Materials, select Group Values, and then select Spelling.

D.

From the More actions menu of Materials, filter the selected values.

Question 4

You have the following view.

Question # 4

You want to filter the view lo show only records that have a movie name starting with the word. "The". You must achieve the goal without writing any formulas.

Which type of filter should you use?

Options:

A.

Wildcard

B.

Condition

C.

General

D.

Top

Question 5

You have a dataset that contains daily sales by business segment from 2017 to the present

You want to use monthly historical trends to predict sales by segment in the future

Which three actions should you perform m order?

(Place the three correct options in order Use the arrows to move Options lo Answer Area I In Answer Area arrows to re order the options.)

Question # 5

Options:

Question 6

You have a sales dataset that contains the following fields.

Question # 6

You need to analyze the average revenue per product in different regions over time.

Which two fields should be measures? Choose two.

Options:

A.

Customer Region

B.

Order Date

C.

Product Name

D.

Quantity

E.

Revenue

Question 7

You have the following chart that shows the cumulative of sales from various dates.

You want the months to appear as shown in the following chart.

What should you do?

Options:

A.

Convert the date to Exact Date

B.

Convert the date to Continuous

C.

Select Show Misting Values for the dale

D.

Convert the date to Attribute

Question 8

You have two data sources that use the same schema One data source contains order data from 2019 and the other data source contains order data from 2020.

You have a worksheet that shows the orders from 2019.

You need to configure the worksheet to show the orders from 2020 without reloading the data.

Which option should you select?

Question # 8

Options:

Question 9

You have the following dataset

You need to create the following visualization.

Question # 9

Which quick table calculation should you drag to Text on the Marks card?

Options:

A.

Percent of Total

B.

Percent Difference

C.

Compound Growth Rate

D.

Percentile

Question 10

A Data Analyst has a data source that contains data for every city in the United States. The following is a sample of the data.

Question # 10

The analyst needs to use the City dimension to create a dynamic filter that shows the cities that have a population greater than 1 million.

Which type of filter should the analyst use?

Options:

A.

Range

B.

Special

C.

Condition

D.

Top

Question 11

You want to create the following dashboard.

Question # 11

The dashboard will contain two sheets that will connect to the same data source. The top sheet will be configured to filter the bottom sheet.

When you click a category on the top sheet, the sheets must resize as shown in the following exhibit.

How should you lay out the objects on the dashboard?

Options:

A.

Drag a horizontal container to the dashboard and add both sheets to the container. Set the Fit to Standard.

B.

Add both sheets to the dashboard. Set Fit to Fix width.

C.

Drag a blank object to the dashboard and add both sheets to the dashboard. Set Fit to Entire view.

D.

Drag a vertical container to the dashboard and add both sheets to the container. Set Fit to Entire view.

Question 12

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?

Options:

A.

NAMEUSERNAME()

B.

ISFULLNAMETableu_USER_NAME))=USERNAME()

C.

NAME Tableau-USER-NAME)

D.

USERNAME()=(Tableau_USER_NAME)

Question 13

You have a dashboard that contains a parameter named Start Date.

You need to create an extract from a Microsoft Excel file. The extract must be filtered based on Start Date.

What should you do?

Options:

A.

Create a data source based on the Excel worksheet and create a calculated field based on Start Date. Add the calculated field to the extract filter.

B.

Create a custom SOL query to define the data source and create a calculated field based on Start Date. Add the calculated field to the extract filter.

C.

Create a custom SOL query that references Stan Date in the WHERE clause.

D.

Create a data source based on the Excel worksheet and create a calculated field based on Start Date. From the Data pane, add the calculated field to the data source filter

Question 14

You have a Tableau workbook that has a live data source. The data source connects to a Microsoft SQL Server database. Only the users in your department can access the database.

You plan to publish the workbook to a Tableau Server site named Public. All the users in your company can access Public.

What are two ways to ensure that all the users can view the worksheets in the workbook? Choose two.

Options:

A.

Change the data source to an extract before you publish.

B.

Embed the credentials when you publish the workbook.

C.

Remove all the data source filters before you publish.

D.

Export the data to a .csv before you publish.

E.

Configure the local file permissions to the workbook file, and then publish the workbook.

Question 15

You have the following map.

Question # 15

You need the map to appear as shown in the following visualization.

What should you do?

Options:

A.

Change the mark type to Density

B.

Drag Location to Size on the Marks card

C.

Change the mark type to Map

D.

Drag Population to Size on the Marks card

E.

Change the opacity to 75%

Question 16

You have the following chart that sorts states by the number of products each state has purchased.

Which formula should you use to include a number with the position of each state within each region?

Options:

A.

FIRST ()

B.

INDEX ()

C.

WINDOW_SUM(SUM ([Quantity]))

D.

LOOKUP (SUM ([Quantity]))

Question 17

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?

Options:

A.

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.

B.

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.

C.

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

D.

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 18

A Data Analyst creates the following story that contains two story points.

Question # 18

The analyst wants 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 the analyst use?

Options:

A.

Arrows only

B.

Caption boxes

C.

Numbers

D.

Dots

Question 19

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

What should you do from Tableau Desktop?

Options:

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

Question 20

You have the following dataset.

Question # 20

Yon need to calculate the ranking shown in the Rank field.

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

Question # 20

Options:

Question 21

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

Question # 21

Which region has the smallest distribution of profits?

Options:

A.

South

B.

Cast

C.

Central

D.

West

Question 22

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?

Options:

A.

From Tableau Desktop, open the Publish Workbook dialog box and configure the schedule.

B.

From Tableau Server select the workbook select Refresh Extracts and then add a new extract refresh

C.

From Tableau Server. select Schedules find the schedule of the extract, and change the frequency to the Last day of the month

D.

From Tableau Server. select Schedules and change the priority of the existing schedule

Question 23

You have the following data source in tableau Server.

Question # 23

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

What should you select?

Options:

A.

New

B.

Extract Refreshes

C.

Connected Workbooks

D.

Connections

Question 24

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?

Options:

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

Question 25

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

Question # 25

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

Options:

A.

August

B.

October

C.

December

D.

November

Question 26

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)

Options:

Question 27

You have the following dashboard that contains two visualizations.

Question # 27

You want to show only one visualization at time. Users must be able to switch between visualizations.

What should you me?

Options:

A.

A parameter and a calculated filed

B.

Worksheet actions

C.

Show/hide buttons

D.

Dashboard actions

Question 28

You have the following dashboard.

Question # 28

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

Options:

Question 29

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?

Options:

A.

Export mdb

B.

Book1.twb

C.

Sales.hyper

D.

Sales.csv

Question 30

You want to add a comment to March 2020 as shown in the following visualization.

You have the following sets in a Tableau workbook

• Top N Customers

• Customers of 2020

• Top N Products

• Sellers of 2020

Which two sets can you combine? Choose two

Options:

A.

Sellers of 2020

B.

Customers of 2020

C.

Top N Products

D.

Top N Customers

Question 31

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?

Options:

A.

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

B.

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

C.

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

D.

Change Population to a discrete dimension

Question 32

You company has two divisions located in the United States and Germany Bach division has a separate database. The following is a sample of the sales data for the division in the United States.

The following is a sample of the sales data for me division in Germany.

Question # 32

You have population data in a file named Populatio.csv. the following is a sample of the data.

Question # 32

You plan to create a visualization that ml show tie sales per capita for each salesperson Each salesperson must be identified by identified by their full name.

You need to prepare the data to support the planned visualization. The data source must support being published .

Which four actions should you perform in order?

(Place the four correct options n order Use the arrows to move Options to Answer Area arrows to re-order the options.

Use Answer Area arrows to re-order the options)

Question # 32

Options:

Question 33

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:

A.

The Data Source page of Tableau Desktop

B.

The Notification area of Tableau Prep

C.

The My Content area of Tableau web pages

D.

The Shared with Ma page

Question 34

You have the following dataset.

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

Options:

A.

{FIXED: [Region] SUM Sales}

B.

{FIXED: SUM Sales}

C.

{Fixed: [Region]: TOTAL Sales}

D.

{FIXED: TOTAL (Sales)}

Question 35

You have the following tiled dashboard that has one sheet.

You want to replace the sheet with Sheet2.

What should you do?

Options:

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

Question 36

You have a dashboard that contains confidential information about patients health. The data needs to always be up to date tor a team of healthcare workers How should you share me dashboard with the healthcare workers?

Options:

A.

Publish the dashboard to Tableau Public

B.

Print the dashboard to PDF

C.

Publish the dashboard to Tableau Server

D.

Export the dashboard as a .twbx

Question 37

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.

Options:

Question 38

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.

Options:

Question 39

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.

Options:

Question 40

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.

Question # 40

Options:

Question 41

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.

Options:

Question 42

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.

Question # 42

Options:

Question 43

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

Question # 43

Options:

Question 44

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.

Options:

Question 45

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.

Options:

Question 46

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.

Options:

Page: 1 / 17
Total 174 questions