Analytics-DA-201 sample questions

Question 1

A data analyst is designing a data model in Tableau Desktop using two tables: 'Orders' and 'Returns'. The goal is to analyze all orders, regardless of whether they were returned or not, while also identifying which orders have associated return records. Performance is a priority, and the analyst wants to ensure that queries are optimized by culling unnecessary joins when the 'Returns' data is not specifically requested in the visualization.

Which modeling approach should the analyst use?

Accepted Answer

Establish a logical Relationship (noodle) between Orders and Returns.

Answer

Create a physical Left Join between Orders and Returns.

Answer

Use Data Blending with Orders as the primary source and Returns as the secondary source.

Answer

Create a Database View using Custom SQL to perform a Left Outer Join.

Question 2

A multinational retailer stores sales data in separate Excel files for each region (North, South, East, West). Each file has the same column structure but different file names. The data analyst needs to combine these files into a single table for analysis in Tableau Prep Builder. The solution must automatically include new regional files added to the folder in the future.

Which step should the analyst take?

Accepted Answer

Configure a Wildcard Union in the Input step to search for files matching a pattern in the directory.

Answer

Add an Input step for the North region and perform a Join with the other three files.

Answer

Manually drag each file into the Flow pane and connect them to a Union step.

Answer

Use the Data Interpreter to merge the sheets within a single Excel workbook.

Question 3

You are analyzing a dataset containing 'Product ID' and 'Sales'. You want to calculate the total sales for each product, but you want this calculation to ignore any dimension filters applied in the view, such as 'Region' or 'Segment'. However, you still want the calculation to respect Context filters.

Which Level of Detail (LOD) expression should you use?

Accepted Answer

{FIXED [Product ID] : SUM([Sales])}

Answer

{INCLUDE [Product ID] : SUM([Sales])}

Answer

{EXCLUDE [Region], [Segment] : SUM([Sales])}

Answer

{FIXED : SUM([Sales])}

Question 4

A dashboard contains a scatter plot showing 'Profit' vs. 'Sales'. The analyst wants to allow users to click a button to toggle the visibility of a 'Parameters' container that holds several control settings. The container should appear floating over the chart when needed and disappear to save screen space when not in use.

Which feature should the analyst implement?

Accepted Answer

Add a Show/Hide button to the floating layout container.

Answer

Dynamic Zone Visibility controlled by a parameter.

Answer

Use a Filter Action to exclude all data in the container.

Answer

Create a Navigation button to switch to a duplicate dashboard.

Question 5

You have a Tableau Prep flow that processes monthly sales data. The output is a .hyper file used by several dashboards. You need to configure the Output step so that every time the flow runs, the new monthly data is added to the existing .hyper file without removing the historical data.

Which Write Option should you select in the Output step?

Accepted Answer

Append to table

Answer

Create table

Answer

Replace data

Answer

Update table

Question 6

A data analyst creates a dual-axis chart comparing 'Sales' (Bar) and 'Profit Ratio' (Line) over 'Order Date'. The Sales axis ranges from 0 to 1,000,000, while the Profit Ratio axis ranges from -0.5 to 0.5. The analyst observes that the zero lines for the two axes are not aligned, making the visual comparison difficult.

What should the analyst do to align the zero lines?

Accepted Answer

Right-click the axes and select 'Synchronize Axis', ensuring both measures have compatible data types.

Answer

Right-click the secondary axis and select 'Synchronize Axis'.

Answer

Edit the Sales axis to include a fixed start of -0.5.

Answer

Add a constant reference line at 0 for both axes.

Top vendors

Top exams

Free Analytics-DA-201 sample questions

6 more free samples are waiting