Learning Tableau

Certified Associate Free Practice Exam

This practice exam is half the length of the full Certified Associate exam. 18 questions rather than 36. One hour rather than two hours.

If you would like to simulate the exam experience, allow yourself one hour to complete the test. The timer will show you have 60 minutes (as in the official exam), but you can submit after the time is up if you wish.

You can use a web browser to search for questions or to do calculations, but you should not use Excel or other software beside Tableau.

Click "Next" to go to the first question.

1. Use Netflix_titles and Netflix_titles_countries sheet from Netflix Movies and TV Shows . How many different countries had TV shows on Barbie?

2. From EMSI_MillenialsvsBabyBoomers Metropolitan Areas sheet, find the city in Florida(FL) which had 3000 or lesser jobs in 2013 than in 2007 for Millennial generation?

Deltona-Daytona Beach-Ormond beach

Ocala

Cape Coral-Fort Myers

Palm coast

3. Choose all that is True regarding Extracts.

Users can choose to extract either by .tde or .hyper formats

when you perform an extract task on a .tde extract, the .tde extract is upgraded to a .hyper format

Extraction process using .hyper are slower compared to .tde

Workbook created using extract data can be shared as a .twbx

4. Which of the following is not true about Union of tables.

To perform Union, the tables must come from same connection.

Tables that are in union can be used in a join.

Tables in a union are combined by matching field names.

Merge mismatched fields in the union removes non-matching rows from the result.

5. Use Netflix_titles and Netflix_titles_directors sheet from Netflix Movies and TV Shows . Which year had highest releases by new directors?

2016

2017

2018

2019

6. From Orders sheet of the Sample Superstore data, find the day of the week when most orders were shipped through ‘Delivery Truck’ (ship mode)?

Monday

Tuesday

Wednesday

Saturday

7. Table calculation ‘Size()’ returns:

Number of rows * columns

Number of rows

Number of columns

None of the above

8. From Titanicpassengerlist dataset create a histogram for Age with bin size of 5. Which of the following age groups had the biggest difference between the number of females who survived and the number of males who survived?

15-20

20-25

75-80

0-5

9. From Orders sheet of the Sample Superstore data, construct a box and whisker plot for shipping cost using the disaggregated data. Which Ship mode and Order priority has same IQR and median?

Delivery Truck Critical and Delivery Truck High

Express Air Low and Regular Air Low

Express Air Critical and Express Air Low

Regular Air High and Regular Air Low

10. A scatter plot is created with a dimension and 2 measures. How can multiple trend lines be added for different values of dimension?

Scatter plot cannot have multiple trend lines.

Multiple Trend lines are automatically added only if measures are aggregated.

If measures are disaggregated and dimension is added to color card, multiple trend line distinguish different values of measure.

Measures are disaggregated and dimension is added to shapes, multiple trend line distinguish different values of measure.

11. Using Sample-Superstore dataset, create a hierarchy of Customer Segment, Product Category & Product Sub-Category. Identify the combination with highest total Sales.

Consumer-Furniture-Chairs&Chairmats

Corporate-Technology-Office Machines

Home Office-Furniture-Tables

Consumer-Furniture-Chairs&Chairmats

12. What happens to the fields that are already on the color mark, when a visual grouping is done on a scatter plot?

They are moved to Detail marks card.

Nothing happens. They are retained in color marks.

They are moved to Shapes marks card.

Existing color card is retained, and group field is also added to color card

13. From USHomeSalesMonthlyReport.twbx dashboard, which week had highest average median home sales price in 100 days prior to 10/7/2016?

week of Sep25, 2016

week of Aug28, 2016

week of March27, 2016

week of June26, 2016

14. To toggle the visibility of a filter in a dashboard using Show/Hide buttons,

Filter cannot be hidden in a dashboard.

It must be in a floating layout container.

Filter needs to be directly added to dashboard without container.

It must be inside a tiled layout container.

15. From Netflix Movies and TV Shows ,what is the estimated number of titles for United States in 2025?(Forecast with default options)

751

922

556

579

16. Select all that are true about reference lines.

A reference line can be a discrete field that needs be in the view.

A reference line can only be a continuous field or a parameter that needs to be in the view.

A continuous field that is not in view but in details in marks card can be used in reference line.

A reference line can be based on which elements are in or out of a Set.

17. Using spatial files in Japan_Waterfowl sites, find how many unique species of waterfowls were recorded in the basin that includes the city of Shizuoka. (“As Bas id” identifies the Basins).

1368

18. Use dashboard1 in Volcano . In Indonesia which Stratovolcano is closest to the only Submarine volcano?

Awu

Ruang

Mahawu

Karanegetang[Api Siau]

Learning Tableau