1. Which of the following would be a reason to use a live connection rather than an extract?
2. Which file type(s) are used for extracts?
3. You have two tables with exam scores. Which operation should be used to combine the tables?
Name Gender Exam Score Fabio Dethloff Female 60 Garret Crossby Male 56 Leela Hanaby Male 60 Markus Dacke Male 56
Name Gender Exam Score Daryl Balding Female 55 Hewe Rawdales Female 59 Inge Gladdolph Female 56 Boycie Clows Female 59
4. Which Tableau function would be best for converting data in this format:
Name January February March Daryl Balding 55 58 57 Hewe Rawdales 59 60 56 Inge Gladdolph 56 60 51 Boycie Clows 59 51 52
to this format
Name Month Score Daryl Balding January 55 Hewe Rawdales January 59 Inge Gladdolph January 56 Boycie Clows January 59 Daryl Balding February 58 Hewe Rawdales February 60 Inge Gladdolph February 60 Boycie Clows February 51 Daryl Balding March 57 Hewe Rawdales March 56 Inge Gladdolph March 51 Boycie Clows March 52
5. What steps should you take to change "Customer Name" to "Customer Full Name"
Nice website for Tableau exam Preparation.
4. Which Tableau function would be best for converting data in this format
The answers to this question are incorrect – the starting data is already pivoted, UNpivot would be the correct transformation, not pivot
Hi,
The question refers to the Tableau function, in Tableau there is no Unpivot function. The pivot function transforms multiple columns (in our case month names) into a single dimension (Month column in our case) with a single measure.
Hope this makes it clear.