[Oct 07, 2026] Analytics-DA-201 Exam Dumps, Analytics-DA-201 Practice Test Questions [Q38-Q52]

Q38. You have a data source that contains the following columns.

You have the following view that shows the percentage of total sales by category:

You want to change the calculation to show the percentage of total sales within the categories of every region annually. Which Compute Using option should you use? (Click the appropriate Option in the Answer Area.)

Q39. A Data Analyst has the following chart that shows the number of song downloads per year since the release of the song.

The required result is a cumulative progression of downloads across the years.
Which quick table calculation should the analyst use?

Q40. A Data Analyst is creating an annual report in Microsoft Word.
In Tableau Desktop, the analyst built a chart in a worksheet.
The analyst wants to create an image of the chart to add to the annual report.
Which two options should the analyst use to create the image? (Choose two.)

Q41. You conned to a Microsoft SQL Server database
You need to create a custom SQL query that retrieves rows from a table named Students Only students m the city of Berlin must be returned How should you complete the query? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

Q42. You have the following table.

You need each record to alternate between grey and white.
What should you change in the Format Shading pane?

Q43. 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?

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

Q45. You have the following visualization.
The Last() calculation is set to compute using Table (across)
Which value will appear in the crosstab for the Consumer segment of the year 2018 if you change compute to use Oder Dale?

Q46. A Data Analyst creates a parameter named Choose Region that contains values from a field named Region.
The analyst wants users to be able to use the Choose Region parameter to interact with a chart by toggling between different regions.
What should the analyst do next?

Q47. You have the Mowing dashboard.

Which two elements are floating? Choose two.

Q48. A Data Analyst has the following dataset that contains sales for the month of May.
The analyst plans to create a data extract from the dataset. The analyst wants to extract data only from stores that have $500 or more in total sales.
What should the analyst do?

Q49. A Data Analyst is frequently asked to report on events that have a single row per day but may have missing days in the dataset. The analyst needs to fill the gaps in the data between two dates.
What should the analyst use to do this in Tableau Prep?

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

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?

Q51. You have a table that contains the following data.

How should you complete the formula? (Drag the appropriate Options to the Answer Area and drop into the correct locations.)

Q52. You use a quick table calculation lo calculate the moving average of a measure named Sales.
You need to calculate the moving averages of the last three years.
Which setting should you change in the Table Calculation dialog box? {Click the appropriate Option in the Answer Area)