Thursday, 24 January 2019

Tableau - III

The questions in this article and following posts are oriented more towards Desktop Specialist credential that is the first of the Tableau Desktop Exams series. These questions may be helpful for preparation for other Tableau Certification Exams as well

We continue with the next set of questions on Tableau in this post.

Answers to previous post are given below:

16. c
17. a,b,d
18. b
19. b
20. a,b,c,d
21. a
22. a,b,c,e
23. a
24. b
25. c
26. e
27. a,b,c,d
28. a
29. a,c,d,e
30. b,d

For all the questions below, we will be using TableauDesktop-64bit-2018-3-2 or Tableau Public 2018.3.0

The next set of questions are:

31. Where in Tableau can you change the data type of a field? (Choose all that qualify)

a) on Data Source tab
b) on Sheet tab
c) on Dashboard tab
d) on Story tab

32. Where in Tableau can you rename a field? (Choose all that qualify)

a) on Data Source tab
b) on Sheet tab
c) on Dashboard tab
d) on Story tab

33. Which is not a valid geographical role in Tableau? (Choose all that qualify)

a) Zone
b) Territory
c) Nation
d) Prefecture

34. It is possible to change the data type of Number (whole) to Number (decimal) without any loss of data

a) True
b) False

35. It is possible to change the data type of Number (decimal) to Number (whole) without any loss of data

a) True
b) False

36. Where in Tableau can you perform joins or unions?

a) on Data Source tab
b) on Sheet tab
c) on Dashboard tab
d) on Story tab

37. Where in Tableau can you perform blending?

a) on Data Source tab
b) on Sheet tab
c) on Dashboard tab
d) on Story tab

38. What are the different types of joins shown in Join window in Tableau? (Choose all that qualify)

a) Inner
b) Left
c) Right
d) Equijoin
e) Cross
f) Full Outer

39. Which is not a valid operator when setting up joins in Tableau?

a) >=
b) !=
c) <
d) =

40. It is possible to join on calculated fields in Tableau

a) True
b) False

41. It is not possible to filter the data on Data Source tab in Tableau. So, data must be filtered before import into Tableau

a) True
b) False

42. Which of the following are valid operations on Data Source tab? (Choose all that qualify)

a) Merge Mismatched Fields
b) Pivot
c) Create Set...
d) Create Group...
e) Create Bins...

43. It is possible to perform cross-database joins in Tableau

a) True
b) False

44. Data from different data sources can be combined either by cross-database joins or blending. The difference between the two is that data is joined at the row level in cross-database join while in blending separate queries are sent to data sources and the results fetched from these queries are aggregated to a common level in Tableau

a) True
b) False

45. It is possible to change the relationship set up automatically by Tableau when blending is performed

a) using Data -> Edit Data Source Filters... on Data Source tab
b) using Data -> Replace Data Source... on Sheet tab
c) using Data -> Edit Relationships... on Sheet tab
d) setting the correct join relationship in Data Source tab

Answers in later posts ...