As part of our training at The Data School we must pass the Tableau Data Analyst certification. In order to increase my chances of passing, I am getting ready and trying to review as much content as I can.
There is a vast amount of resources in our internal network and on the internet on how to prepare and on what kind of questions are asked in the exam. In this post I decided to gather some insights from all these resources and create some mock questions to practice the relevant questions. This way, I intend to memorise some key concepts at the same time I help other candidates who are also preparing for the exam.
At the end of this post, I will post the answers to the questions.
Question 1
Select all options that are true about Rank Functions in Tableau:
A. Nulls are ignored in ranking functions.
B. The default order of a Rank function is ascending.
C. If a field Age has the values (6, 9, 9, 14) , then if you use a calculated field with RANK([Age]), you would get (4, 2, 2, 1).
D. The default order of a Rank function is descending.
Question 2
In the image below you see the customers of the Superstore Sample dataset ranked by the number of orders they placed. A, B, C and D refer to the following rank functions, respectively:
A. RANK_DENSE(), RANK(), RANK_UNIQUE, RANK_MODIFIED.
B. RANK(), RANK_DENSE(), RANK_MODIFIED, RANK_UNIQUE.
C. RANK_MODIFIED, RANK_DENSE(), RANK(), RANK_UNIQUE.
D. RANK_DENSE(), RANK_UNIQUE, RANK_MODIFIED, RANK().
Question 3
A packaged Tableau Workbook has the following extension:
A. .tbm
B. .twb
C. .tds
D. .twbx
Question 4
Which of the following are data types in Tableau? (Choose more than one)
A. Geographic Value
B. Polygons
C. Unstructured Data
D. Date and Time Values
Question 5
You are using Windows and clicked the Worksheet menu and chose to export your data. In which file type will the data be exported?
A. .csv
B. .mdb
C. .hyper
D. .tds
Question 6
In Tableau Desktop, you can connect to the following spatial file types (choose more than one):
A. Shapefiles,
B. MapInfo tables,
C. KML (Keyhole Markup Language) files,
D. GeoJSON files,
E. TopoJSON files,
F. Esri File Geodatabases.
Question 7
_________ are used to distinguish marks and call out their position in the view.
A. Trend Lines
B. Drop Lines
C. Reference Bands
D. Reference Lines
Question 8
You have a dataset with ages of students. When age is missing, you would like to replace null with zero. To achieve that, you could use (choose all that apply):
A. ZN([Age])
B. ISNULL([Age])
C. IF(ISNULL([Age]), 0)
D. ZN(LOOKUP([Age], 0))
Question 9
Tableau Prep might output data in the following formats (select all that apply):
A. Tableau Extract (.hyper)
B. .twbx
C. .csv
D. xlsx
Question 10
Select the false statement about the Data Interpreter:
A. The Data Interpreter can detect things like titles, notes, footers, empty cells, and so on and bypass them to identify the actual fields and values in your data set.
B. You can check the actions carried out by the Data Interpreter to make sure it captured the data that you wanted and identified it correctly. Then, you can make any necessary adjustments.
C. Connectors that support the Data Interpreter are: Excel spreadsheets, .csv files, PDF files or Google sheets.
D. It works if your data contains more than 2000 columns.
Answers:
Question 1. A, C and D;
Question 2. B;
Question 3. D;
Question 4. A and D;
Question 5. B;
Question 6. A, B, C, D, E, F;
Question 7. B;
Question 8. A and D;
Question 9. A, C and D;
Question 10. D;