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
In the second segment on Tableau, we give the answers to questions in previous post and more questions follow
Solutions to questions in last post are given below:
1. a,b,c,d
2. c
3. a
4. a
5. b
6. a,b,c,d
7. d
8. a
9. a,d,f
10. c,d
11. a,b,c,d
12. c
13. a,c,d
14. a,c
15. a
For all the questions below, we will be using TableauDesktop-64bit-2018-3-2 or Tableau Public 2018.3.0
The second set of questions are:
16. Which type of data connection is best suited for visualizations that will help users make decisions based on real time data?
a) An extract
b) Extracts taken every week
c) A live connection
d) A snapshot taken every month
17. Rendering of visualizations based on live data connection can be impacted by (Choose all that apply):
a) Number of concurrent users accessing the data
b) Network bandwidth
c) Other visualizations based on extracts without refresh
d) Complexity of SQL issued against data connection
18. The default maximum levels of row labels and columns labels are _ and _, respectively. Fill in the correct values
a) 16 and 16
b) 6 and 6
c) 32 and 32
d) 10 and 10
19. When you import files like Excel into Tableau, Data Interpreter is turned on by Tableau
a) True
b) False
20. Data Interpreter helps in fetching valid data from files. Which of the following are ignored by Data Interpreter (Choose all that apply):
a) Title notes
b) Empty rows
c) Titles
d) Foot notes
In the second segment on Tableau, we give the answers to questions in previous post and more questions follow
Solutions to questions in last post are given below:
1. a,b,c,d
2. c
3. a
4. a
5. b
6. a,b,c,d
7. d
8. a
9. a,d,f
10. c,d
11. a,b,c,d
12. c
13. a,c,d
14. a,c
15. a
For all the questions below, we will be using TableauDesktop-64bit-2018-3-2 or Tableau Public 2018.3.0
The second set of questions are:
16. Which type of data connection is best suited for visualizations that will help users make decisions based on real time data?
a) An extract
b) Extracts taken every week
c) A live connection
d) A snapshot taken every month
17. Rendering of visualizations based on live data connection can be impacted by (Choose all that apply):
a) Number of concurrent users accessing the data
b) Network bandwidth
c) Other visualizations based on extracts without refresh
d) Complexity of SQL issued against data connection
18. The default maximum levels of row labels and columns labels are _ and _, respectively. Fill in the correct values
a) 16 and 16
b) 6 and 6
c) 32 and 32
d) 10 and 10
19. When you import files like Excel into Tableau, Data Interpreter is turned on by Tableau
a) True
b) False
20. Data Interpreter helps in fetching valid data from files. Which of the following are ignored by Data Interpreter (Choose all that apply):
a) Title notes
b) Empty rows
c) Titles
d) Foot notes
21) "Review the results" feature gives the user the option to verify the results of Data Interpreter functionality and decide whether to use the Data Interpreter
a) True
b) False
22) Data Interpreter can be used for following types of files (Choose all that qualify):
a) .pdf files
b) .csv files
c) Excel files
d) .rtf files
e) Google Sheets
23) Irrespective of the different types of files for which Data Interpreter is applicable, "Review the results" will always result in a .xlsx review file that contains Tableau's interpretation of data
a) True
b) False
24) The extra sheet that is added in the review file as a result of using Data Interpreter is called:
a) Data Interpreter Key
b) Key for the Data Interpreter
c) Review Results Key
d) Key for Results Review
25) In the Review file, if a field has green background, then, it means that Tableau has interpreted that field as:
a) Column header
b) Ignored data
c) Values
d) Excluded data
26) Ordinal property in a .tds file identifies the:
a) data type
b) source type
c) column name
d) column type
e) column number
27) Which of the following statements are true (Choose all that apply):
a) .tds and .tdsx files have all the information about the data source
b) .tdsx file contains a copy of the data
c) .tds file contains join details of the columns used in Worksheet
d) For the same data source, .tdsx file is larger than .tds file
28) The process to create a .tds or a .tdsx file is the same and differs only in selection of file type while saving the file
a) True
b) False
29) A .tdsx file contains information on (Choose all that apply):
a) union
b) blending
c) column names
d) column types
e) calculated fields
30) Which of the following statements are true (Choose all that apply):
a) Both .tds and .tdsx are zipped files
b) Both .tds and .tdsx files can be shared among Tableau users
c) Both .tds and .tdsx files can be opened in Tableau Public
d) Both .tds and .tdsx files can hold database connection information as port, etc
Answers in next post
a) True
b) False
22) Data Interpreter can be used for following types of files (Choose all that qualify):
a) .pdf files
b) .csv files
c) Excel files
d) .rtf files
e) Google Sheets
23) Irrespective of the different types of files for which Data Interpreter is applicable, "Review the results" will always result in a .xlsx review file that contains Tableau's interpretation of data
a) True
b) False
24) The extra sheet that is added in the review file as a result of using Data Interpreter is called:
a) Data Interpreter Key
b) Key for the Data Interpreter
c) Review Results Key
d) Key for Results Review
25) In the Review file, if a field has green background, then, it means that Tableau has interpreted that field as:
a) Column header
b) Ignored data
c) Values
d) Excluded data
26) Ordinal property in a .tds file identifies the:
a) data type
b) source type
c) column name
d) column type
e) column number
27) Which of the following statements are true (Choose all that apply):
a) .tds and .tdsx files have all the information about the data source
b) .tdsx file contains a copy of the data
c) .tds file contains join details of the columns used in Worksheet
d) For the same data source, .tdsx file is larger than .tds file
28) The process to create a .tds or a .tdsx file is the same and differs only in selection of file type while saving the file
a) True
b) False
29) A .tdsx file contains information on (Choose all that apply):
a) union
b) blending
c) column names
d) column types
e) calculated fields
30) Which of the following statements are true (Choose all that apply):
a) Both .tds and .tdsx are zipped files
b) Both .tds and .tdsx files can be shared among Tableau users
c) Both .tds and .tdsx files can be opened in Tableau Public
d) Both .tds and .tdsx files can hold database connection information as port, etc
Answers in next post
