Data Analyst Practice Exam 2

Tableau's Data Analyst exam features scored and unscored questions. The scored questions are 30 knowledge-based items and 1 hands-on lab with 10-11 tasks. For more detail please see https://mkt.tableau.com/files/TableauCertifiedDataAnalyst_ExamGuide.pdf.

The lab questions are not scored automatically. You will need to go through the lab questions here using this workbook and then check your solutions using this guide.

To simulate the exam experience, answer the knowledge-based questions without using Tableau or a web browser. For the lab portion, you may use this a pdf version of the Tableau help https://www.tableau.com/support/help.

You have 120 minutes to complete the exam.

Click "Next" to go to the first question.

1. New extracts use the .hyper format instead of the .tde format. Which statement is true concerning .hyper format files in Tableau?

You can use the Export as Version in Tableau Desktop to downgrade a workbook that contains a .hyper extract

For Tableau 10.4 and older versions when you extract data, you automatically get a .hyper file output.

Extracts in the .hyper format can contain billions of rows of data.

You can convert the upgraded extract to .hyper back to a .tde extract.

2. You want to show a comparison of sales against profit by month using a dual axis chart. The chart is shown as follows

You discover that the Sales and Profit axis are not aligning. A colleague helps you out and comes up with the following chart What steps were taken to correct the chart?

Right click (control-click on Mac) the Profit axis, Synchronize axis, Untick Show header, Edit Sales Axis, Rename to Sales Amount

Right click (control-click on Mac) anywhere in the graph, Synchronize axis, Untick Show header, Edit Sales Axis, Rename to Sales Amount

On the Format menu, select Synchronize axis, Untick Show header, Edit Sales Axis, Rename to Sales Amount.

On the Worksheet menu, select Axis, Synchronize axis, Untick Show header, Edit Sales Axis, Rename to Sales Amount.

3. You are importing a data about technology adoption in farming.

You want to use extract connection option to get the data in Tableau desktop, however the requirement for the analysis is that all those below the age of 40 years should be excluded. How would you accomplish this task at this stage?

Go on File menu and select Filter for age that is at least 40 years.

Right click (control-click on Mac) dataset name and select Add a filter for age greater than 40 years

Add a filter for age that is at least 40 years.

Right Click (control-click on Mac) the Age column and add a Filter for age that is at least 40 years.

4. Which of the following statements are true about grouping fields in folders?

When you connect to a single table in your data source, grouping by folder is enabled by default.

When you connect to a data source with multiple tables, grouping by table is enabled.

“Group by” options are available on multidimensional data sources.

"Group by" options are only available for relational data sources.

None of the above

5. What happens when you convert a date field from discrete to continuous?

The dates will act as labels.

The dates will have an axis.

Dates cannot be converted continuous fields.

Dates are always continuous fields so they cannot be converted.

6. You want to create a bar chart showing unique orders by year. What steps should be taken?

Create a function using COUNT([Order ID]), drag the function to the row shelf then Order Date to the column shelf.

Drag Orders(Count) from the data pane to the row shelf, then Order Date to the column shelf

Create a function using COUNTD([Order ID]), drag the function to rows then Order Date to the column shelf.

Create a function using AGG([Order ID]), drag the function to rows then Order Date to the column shelf.

Create a function using UNIQUE ([Order ID]), drag the function to the row shelf then Order Date to the column shelf.

7. The dataset below shows alcoholic drinks consumption by country.

You want to come up with a table visual that shows top 10 Countries by average Beer Servings. What should you do to create the chart?

Drag Country to rows
Change from sum to average and then OK
Click By Field option
Beer Servings to Text Marks card
Sort the Beer Servings by descending order
Drag country to Filters card
Choose Top tab

6, 7, 3, 4, 2, 1, 5

2, 6, 7, 3, 4, 1, 5

2, 4, 5, 6, 7, 3, 1

1, 4, 5, 6, 7, 3, 2

8. You have a connected to a data source on Tableau Server from Tableau Desktop. You want to create a local copy of the data source so that you able to work offline. How will you accomplish the task?

On the Data menu, select the data source and then select Create Local Copy.

You cannot download a data source from Tableau Server

On the File menu select Click Save As Local Copy.

On the Worksheet menu, select the data source and then select Create Local Copy

9. Data blending is a method for combining data from multiple sources. What are the characteristics of data blending?

A blend combines and then aggregates data.

Values that do not have corresponding matches in the primary data source also appear in the view.

Primary data source is indicated with an orange check mark, whilst secondary data source is indicated with blue check mark

Data blending brings data from two separate data sources into the same worksheet, rather than creating a combined data source.

Data blending is similar to a left join because data from the secondary data source is excluded when there are no matching values in the primary data source.

10. You are importing a dataset into Tableau. One of the columns contains postal codes and was treated as a measure by tableau. How can you change the column from a measure to a dimension?

Click and drag the field from a measures area in the Data pane and drop it into a dimensions area.

Once the column is treated as a measure it cannot be converted to a dimension.

Right-click (control-click on a Mac) the measure in the Data pane and select Convert to Dimension.

Select the field and from the Format menu select convert to dimension.

You can convert the field from a measure to a dimension in the in the Column or Rows shelf by click the drop down arrow and select dimension.

11. You have a data source with automobile data car dataset that contains “Make” and “Model” fields. What steps should you take to create Vehicle Name hierarchy which can be used to drill down from by Make and Model?

Create the hierarchy in the dataset before connecting to Tableau.

Right click Make, click Create Hierarchy, and rename the hierarchy to Vehicle Name

Drag Model to Make and rename the hierarchy to Vehicle Name.

Hierarchies are only created on date fields so it is not possible.

Hierarchies are created on related columns automatically.

12. What steps should you take to add row and column grand totals on a table as shown below?

Go on Marks card, Show Row Grand Totals, Show Column Grand Totals, and All Sub Totals.

Go on Format tab, Show Row Grand Totals, Show Column Grand Totals, and All Sub Totals.

Go on Marks card and select All Totals from the drop down menu.

Go on Analysis tab, Totals, Show Row Grand Totals. Go on Analysis tab, Totals, Show Column Grand Totals

None of the above

13.You have the following tables with student marks for three subjects.

You want to combine these tables by appending values of the three tables to one table using a union.

What is the correct order of steps can you take to combine the data? The step can be used once, more than once or not at all.

Select another table from the left pane and drag it directly below the first/second table.
Drag one of the tables from the left pane
Click Apply or OKto union
Double-click New Union on the data source page
Click a relationship line to open the Edit Relationship dialog box and correct the relationship

1, 2, 4, 5, 3

1, 2, 3, 4, 5

4, 2, 1, 5, 3

4, 2, 1, 1, 3

14. You have a column with name and surname on the left and you want to split the column into two separate columns of name and same as shown on the right.

Which two option will give you Firstname and Lastname?

Create Firstname field SPLIT([Customer Name], ' ',1)

Create Lastname field as RIGHT([Customer Name], 3)

Create Firstname field as LEFT([Customer Name], 3)

Create Lastname field as SPLIT([Customer Name], ' ', 2)

Create Lastname field as LEFT([Customer Name], 3)

Create Firstname field as RIGHT([Customer Name], 3)

15. You have two tables Orders and Returns. You are required to come up with a CSV file with only Orders that were returned.

The diagram below the shows the flow that was created in Tableau Prep.

From the cleaning step how do you add the Join step?

Drag the Returns dataset and place it below the Clean step until the Join option displays and Drop it there.

Drag the Returns dataset and place it to the right of Clean step until the Join option displays and Drop it there.

Add a Join step from Clean step, Drag the Returns dataset to the right of Join step until the Join option displays, Drop it there and edit the Applied Join Clause with the correct fields.

Add a Join step from Clean step, Drag the Returns dataset to the left of Join step until the Add option displays, Drop it there and edit the Applied Join Clause with the correct fields.

16. You want to see how each segment performed against the average sales, you come up with the following graph.

How will you accomplish the task?

Right click (control-click on a Mac) Segment axis, Add a reference line and select Average in the dropdown.

Right click (control-click on a Mac) Sales measure and change aggregation from sum to average.

Right click (control-click on a Mac) Sales axis, Add a reference line and select Average in the dropdown.

Create a calculated field for average sales and add it as line to the chart.

17. Which is correct for a Tableau Data Extract (.tde) file?

It contains file path information.

It contains information about the data source.

Only contain a local copy of the entire or a subset of data from its source.

Data in it can be refreshed automatically as and when it refreshes at the source.

18. Which statements below are not true for bins in Tableau?

Once the bin dimension is created, you cannot convert it to a continuous dimension.

Discrete fields can be considered as sets of bins.

When you create bins from a measure you do not create a new dimension.

When you create bins from a measure you create a new dimension.

Only data from relational data sources can be binned and fields cannot be used in calculations.

When you add a binned dimension to the view, each bin acts as a different sized container.

19. You have a chart showing sales for Accessories and Appliances by Region. You want the trend line within a Sub-Category to be the same across all regions.

What should you do to carry out the task?

Right click any trend line, Edit All Trend Lines, on Factors untick Region and Ok.

Remove Region from the visual.

On the Worksheet menu, Right click any trend line, Edit All Trend Lines, on Factors untick Region and Ok.

On the Format menu, Right click any trend line, Edit All Trend Lines, on Factors untick Region and Ok.

20. What is true about context filters in Tableau?

Context Filter is a filter in Tableau that gets applied after any other filter.

It is an independent filter such that all the other filters will be applied to the data that is fetched by the Context filter.

Context filter decreases performance.

Context filter are similar to Measure Filters.

None of the above

21. A story is an extremely important part of Tableau. It can influence its viewers and make them change their minds. A story in Tableau contains story points. What is true about Tableau story points?

A story point is only made up of a dashboard.

The title of a worksheet or dashboard cannot be changed in a story point.

A story point can be either a worksheet or a dashboard.

A story point can be only made up of a worksheet.

22. You are in the process of designing a dashboard. You now have a template that is shown below.

The users want to be able to select a Region and it filters all the other sheets on the dashboard. How will you do the task?

Click the Dropdown arrow on the Total Sales by Region worksheet and select Use as Filters.

Go back to the Worksheet and drag Region to Filters.

On Format menu select Filters

On the Dashboard pane drag Filters to the Total Sales by Region worksheet.

23. The image below shows actions found on Add Actions on a dashboard.

How is the chosen selection on a dashboard work?

When clicking, the dashboard will highlight the required information and display the outcome.

Click a mark in the view to run the action.

Rest the pointer over a mark in the view to run the action.

Right-click a selected mark in the view and then select an option on the context menu.

24. Below is part of a Dashboard showing Category, Percent of Total Profit and Profit when you point to a part of the pie chart.

Users also want to see Sales being displayed on the tooltip as well. How would you configure the tooltip?

Go on Dashboard Objects and right click Tooltip and select Edit Tooltip.

Go back to the worksheet and.drag Sales to Tooltip on the Marks card.

Go on Analysis Menu item, select Tooltip and select Edit Tooltip.

Once a worksheet is added to a dashboard it can no longer be edited.

25. You have removed grid lines on a worksheet. Now you want to implement the same formatting to other worksheets before you add them to a dashboard. What step will you take to implement that?

Select the formatted worksheet, Right click the worksheet tab and select Copy Formatting, Go on Format menu item and select Copy Formatting to all worksheets.

Select the formatted worksheet, Right click the worksheet tab and select Copy Formatting, Go on Worksheet menu item and select Copy Formatting to all worksheets.

The functionality is not present in Tableau so you have to format the worksheets one at a time.

Select the formatted worksheet, Right click the worksheet tab and select Copy Formatting, Select the worksheet which needs to be formatted, Right click the worksheet tab and select Paste Formatting.

26. You have created a workbook with several worksheets. You now want to publish one worksheet only. Given the steps below what is the order of steps do you take to publish the workbook?

On Sheets click Edit and Select the remove all the other sheets except the one you want to publish.
Select Server > Publish Workbook.
In Tableau Desktop, open the workbook you want to publish.
In the Publish Workbook dialog box, select the project, enter a name for the workbook, and add search tags.
For Permissions, accept the default project settings or Edit where possible.
Click Publish.

4, 3, 5, 1, 2, 6

4, 3, 5, 2, 6, 1

4, 3, 2, 5, 6, 1

3, 2, 4, 1, 5, 6

27. You are in Tableau online and opened a workbook.

What is the effect of clicking Subscribing then subscribing a group?

Each user is added individually at the time the subscription is created.

If more users are added to the group later, you do not have re-subscribe the group for those new users to receive the subscription.

Users later removed from the group will have their subscriptions removed automatically.

No permissions for View and Download Image/PDF are required.

28. The Compound growth rate is a measure of growth over multiple time periods. It shows the growth rate from the initial value to the final value, assuming that the investment has compounding growth over the time period. It is calculated with the following formula.

You have a dataset with a Sales and Order Date column, you now want to create a calculated field called CAGR. You have created a parameter called N Years as the initial step.

What is the formula that you will write in the calculated field?

POWER(ZN(SUM([Sales]))/LOOKUP(ZN(SUM([Sales])),-[N Years]), ZN(1/[N Years]))

(ZN(SUM([Sales]))/LOOKUP(ZN(SUM([Sales])),-[N Years]), POWER(ZN(1/[N Years])) )- 1

(ZN(SUM([Sales]))/LOOKUP(ZN(SUM([Sales])),-[N Years]), POWER(ZN(1/[N Years])) )

POWER(ZN(SUM([Sales]))/LOOKUP(ZN(SUM([Sales])),-[N Years]), ZN(1/[N Years])) - 1

29. You are scheduling a refresh and you want it to be an incremental refresh based of Date column as shown below.

What happens when a refresh occurs?

If a new column is added you do not need to do a full extract refresh.

Refreshing will add all rows whose date is after that last time a refresh occurred.

It replaces all of the rows with the data in the original data source every time a refresh occurs.

It will create duplicate rows if the records already exist.

Which calculation will return a value of 2 Adam Bellavance? Assume table calculations are set to Table(Down).
[select all that apply]

FIRST()

LAST()

INDEX()

RANK()

Lawrence Ambam

February 7, 2023 at 9:17 pm

I want to thank you for setting up an exam format that is very close to the actual exam. I took the tableau data analyst exam after going over your practice questions and easily passed. I could’ve sworn that one of the exam questions was from your practice questions.

Amin Rustamli

October 8, 2023 at 11:25 am

great exam

October 8, 2023 at 3:06 pm

great i aso benefit from this exam.

carina

December 5, 2023 at 7:52 pm

Q11,

B. Right click Make, click Create Hierarchy, and rename the hierarchy to Vehicle Name

This option doesn’t include Model into the hierarchy, why is it a correct answer?

Thanks for your help!

Narcis
September 29, 2024 at 10:25 am

Hi Carina,

Option B is one of the 2 correct option, along with option C. The 2 of them are the steps that form an entire correct answer.

Hope this makes it clearer,
Narcis

Data Analyst Practice Exam 2

Data Analyst Practice Exam 2

5 thoughts on “Data Analyst Practice Exam 2”

Leave a Reply Cancel reply