# Free Analytics-101 practice questions

> 10 free Analytics-101 practice questions with the correct answer and an explanation.

Page: https://devopscodelab.com/exams/tableau-desktop-foundations/free-practice-questions/
Practice exams: https://devopscodelab.com/exams/tableau-desktop-foundations/

### Question 1 of 10

An extract of an append-only log table is refreshed every night. A full refresh takes hours. New rows always have a higher Log ID than existing rows. Which option reduces refresh time?

- A. Switch the data source to a live connection and pause auto updates
- B. Configure an incremental refresh using Log ID as the identifying column
- C. Hide all unused fields and keep the existing full extract refresh schedule running nightly
- D. Save the data source as a .tds so the extract refreshes faster

**Answer:** B

**Explanation:** Incremental refresh adds only rows whose identifying column is greater than the highest value already in the extract, which suits append-only data with an increasing key. Live connections avoid refreshes but can be slow and do not meet the extract requirement. Hiding fields helps a little but still rebuilds everything, and a .tds file does not change refresh behaviour.

### Question 2 of 10

A workbook relates an Orders table to a Returns table using a relationship (noodle) on Order ID. Many orders have no return. What happens to orders without a return when a view uses only fields from the Orders table?

- A. They are excluded, because relationships default to an inner join between Orders and Returns
- B. They are duplicated once for each row in the Returns table
- C. They are shown as Null for every Orders measure in the view
- D. They are included, because only tables used by fields in the view are queried

**Answer:** D

**Explanation:** Relationships are context-aware: Tableau builds a query using only the tables whose fields are in the view, so all Orders rows are kept when no Returns fields are used. Relationships do not fix a join type up front, so there is no forced inner join. Rows are not duplicated by unrelated tables, and the Orders measures keep their real values rather than becoming Null.

### Question 3 of 10

A view shows SUM(Sales) by Order Date month with a Region filter and a context filter on Category. The analyst also has a Top 5 Sub-Category filter by Sales. Users notice the top 5 list changes when Category changes, but not when Region changes. Why?

- A. Context filters are applied before Top N filters, while regular dimension filters are applied after them
- B. Region is a measure filter, which Tableau evaluates after table calculations
- C. Top N filters are always applied after every other filter in the view, regardless of whether context is set
- D. Regular dimension filters are applied before context filters, so Region is ignored

**Answer:** A

**Explanation:** In Tableau's order of operations, context filters run before Top N filters, so the top 5 is computed within the chosen Category, while regular dimension filters such as Region are applied after the Top N filter and only remove members from the already-ranked list. Regular dimension filters do not run before context filters, and Top N is not applied after every other filter. Region is a dimension, not a measure, and measure filters run before table calculations, not after them.

### Question 4 of 10

An analyst adds a Top 10 filter on Customer by Sales and a regular filter on Region = West. The view shows fewer than 10 customers. Which change ensures the view shows the top 10 customers within the West region?

- A. Add the Region filter to context
- B. Change the Top 10 filter to Top 20
- C. Change the Region filter to a wildcard filter
- D. Move the Region filter to the Detail shelf

**Answer:** A

**Explanation:** Top N filters are evaluated before regular dimension filters, so the top 10 is computed across all regions and then the Region filter removes some of those customers. Adding Region to context applies it before the Top N filter, so the top 10 is computed within the West region. Increasing N, moving Region to Detail, or using a wildcard does not change the order of evaluation.

### Question 5 of 10 (choose 2)

Which TWO statements about groups and sets in Tableau Desktop are true? (Choose two.)

- A. A group combines dimension members into higher-level categories
- B. A group must always contain exactly two members
- C. A group can be updated automatically by a Top N condition
- D. A set can only be created from a measure
- E. A set defines a subset of members and can be shown as In or Out

**Answer:** A, E

**Explanation:** Groups combine members of a dimension, such as merging several product names into one category, and sets define a subset of data that can be displayed as In or Out of the set. Conditions and Top N rules belong to computed sets, not groups. Sets are created on dimensions, and groups can contain any number of members.

### Question 6 of 10

An analyst builds a filter card for Sub-Category that should only list sub-categories that belong to the Category selected in another filter. Which setting should be used on the Sub-Category filter card?

- A. Include Values
- B. Only Relevant Values
- C. All Values in Database
- D. All Values in Context

**Answer:** B

**Explanation:** Only Relevant Values limits the filter card to values that remain after other filters are applied, so it shows only sub-categories of the selected category. All Values in Database lists every sub-category. All Values in Context works only when the Category filter is added to context, and Include Values decides whether selections are kept or excluded rather than which values are listed.

### Question 7 of 10

On a dashboard, selecting a region on a map should filter a bar chart to that region's products. What is the simplest way to configure this?

- A. Add a Highlight action from the bar chart to the map
- B. Add a Region parameter control and reference it in a calculated filter on both sheets
- C. Use the map's Use as Filter option or add a Filter dashboard action
- D. Add a URL action on the map that opens the bar chart sheet

**Answer:** C

**Explanation:** The Use as Filter button on a dashboard sheet creates a filter action that sends selected values to the other sheets, and a Filter action can also be created manually. A Highlight action only emphasises matching marks without removing others, and it runs in the wrong direction here. A URL action opens a web page, and a parameter requires users to pick from a control rather than clicking the map.

### Question 8 of 10

A presenter wants to walk an audience through four insights in sequence, each with a short caption, using views already built in a workbook. Which Tableau feature fits this requirement best?

- A. A device layout with one sheet per phone screen
- B. A story with one story point per insight
- C. Four worksheets organised in a worksheet group
- D. A dashboard with four floating text objects

**Answer:** B

**Explanation:** Stories are sequences of story points, each capturing a sheet or dashboard with a caption, designed for guided narratives. A single dashboard shows everything at once rather than in sequence. Worksheets on their own do not carry captioned navigation, and device layouts change the dashboard arrangement for phones and tablets rather than creating a narrative.

### Question 9 of 10

A dashboard on a phone shows charts too small to read. The designer wants a different arrangement only for phones while keeping the desktop layout unchanged. What should the designer do?

- A. Add a Phone device layout in the Dashboard pane and arrange the sheets for it
- B. Create a duplicate dashboard sized for phones and hide the original
- C. Change the dashboard size to Automatic so the sheets stack vertically on narrow screens
- D. Use the Format menu to reduce font sizes on every worksheet

**Answer:** A

**Explanation:** Device layouts let you customise how a dashboard appears on phones or tablets while the default layout stays the same. A duplicate dashboard doubles maintenance and does not switch automatically by device. Automatic sizing scales but does not rearrange sheets, and shrinking fonts makes the desktop view worse without fixing the phone layout.

### Question 10 of 10

An analyst drags a Quantity measure into a view that contains Region on Rows. Tableau displays SUM(Quantity). What determines the level of detail at which Quantity is aggregated?

- A. The default number format set on the Quantity field
- B. The dimensions placed in the view, in this case Region
- C. The data type of Quantity, which is a whole number
- D. The order in which the fields were dragged into the view

**Answer:** B

**Explanation:** Measures are aggregated at the level of detail defined by the dimensions in the view, so SUM(Quantity) is computed for each Region. Number format affects display only, and the data type affects which aggregations are possible but not the grouping level. The order fields are added does not change the level of detail.

Ready for a timed run? Take the free 15-question Analytics-101 mini exam: https://devopscodelab.com/app/exams/tableau-desktop-foundations/mini/

DevOpsCode Lab is not affiliated with Salesforce. Analytics-101 and related names are trademarks of their owners. We write every question ourselves; these are not real exam questions.
