Tableau Desktop Specialist Exam
Questions With Correct Answers
Live vs. extracts data connection - CORRECT ANSWER✔✔-LIVE
| | | | | | | |
- changes will be shown automatically
| | | | | |
- creates slower performance for huge data
| | | | | |
- Server availability could be a problem
| | | | | | |
- Best to use when numbers HAVE to be correct
| | | | | | | | |
EXTRACT
- creates a static snapshot of your data
| | | | | | |
- better performance and portability
| | | | |
- save and refresh the snapshot
| | | | |
- best to use when numbers aren't as important
| | | | | | | |
How to save metadata properties in a .TDS - CORRECT ANSWER✔✔-1.
| | | | | | | | | | |
go to the sheet
| | |
2. right click on the data source
| | | | | |
3. select 'Add to Saved Data Sources'
| | | | | | |
4. make sure the end of the file ends in .TDS
| | | | | | | | | |
,When is it best to use a blend? - CORRECT ANSWER✔✔-1. Cross-
| | | | | | | | | | |
database join is not supported | | | |
2. Tables are at different LOD
| | | | | |
3. Joins create duplicate data or data cleaning is required
| | | | | | | | |
4. If you have a lot of data and the join is time consuming
| | | | | | | | | | | | |
How do you rename a data field? - CORRECT ANSWER✔✔-Right click on
| | | | | | | | | | | |
the data field and select 'rename'
| | | | |
How to assign an alias to a data value? - CORRECT ANSWER✔✔-Right
| | | | | | | | | | | |
click a dimension and select 'Aliases". In the edit aliases dialog box,
| | | | | | | | | | | |
under value, select a member and enter a new name
| | | | | | | | |
How to assign a geographic role to a data field? - CORRECT
| | | | | | | | | | | |
ANSWER✔✔-click the data type icon next to the field and select | | | | | | | | | |
'geographic role'.
| | |
then select the geographic role you want to assign to that field
| | | | | | | | | | |
Change data type for a data field (number, date, string, boolean, etc) -
| | | | | | | | | | | | |
CORRECT ANSWER✔✔-A. On the data source page, click on the icon
| | | | | | | | | | |
associated with the field and select the new data type
| | | | | | | | | |
B. In the data pane, if you right click on the field and scroll down to
| | | | | | | | | | | | | | |
'change data type'
| | |
, Change default properties for a data field (number format, aggregation,
| | | | | | | | | |
color, date, format, etc) - CORRECT ANSWER✔✔-In the data pane, right
| | | | | | | | | | |
click on the field, scroll down to 'default properties' and change the
| | | | | | | | | | | |
desired value |
How to create a visual group? - CORRECT ANSWER✔✔-Control click all
| | | | | | | | | | |
of the fields you want created in the group.
| | | | | | | | |
Right click on these values and select the group button
| | | | | | | | |
How to create a group using labels? - CORRECT ANSWER✔✔-Right click
| | | | | | | | | | |
on the field you would like to be grouped, click on 'create' and then
| | | | | | | | | | | | |
'group'. Be sure to select 'include other'
| | | | | | |
How to create a set? - CORRECT ANSWER✔✔-for a static set, select all
| | | | | | | | | | | | |
fields you want included in the set from the view, right click and select
| | | | | | | | | | | | |
|'create set' | |
for a dynamic set, right click on the field you want to create a set for,
| | | | | | | | | | | | | | | |
scroll down to 'create' and select 'set'
| | | | | |
How to add a context filter? - CORRECT ANSWER✔✔-They are executed
| | | | | | | | | | |
before normal filters. | | |
Right click on the field you want to be a context filter and click 'add to
| | | | | | | | | | | | | | | |
context'
Questions With Correct Answers
Live vs. extracts data connection - CORRECT ANSWER✔✔-LIVE
| | | | | | | |
- changes will be shown automatically
| | | | | |
- creates slower performance for huge data
| | | | | |
- Server availability could be a problem
| | | | | | |
- Best to use when numbers HAVE to be correct
| | | | | | | | |
EXTRACT
- creates a static snapshot of your data
| | | | | | |
- better performance and portability
| | | | |
- save and refresh the snapshot
| | | | |
- best to use when numbers aren't as important
| | | | | | | |
How to save metadata properties in a .TDS - CORRECT ANSWER✔✔-1.
| | | | | | | | | | |
go to the sheet
| | |
2. right click on the data source
| | | | | |
3. select 'Add to Saved Data Sources'
| | | | | | |
4. make sure the end of the file ends in .TDS
| | | | | | | | | |
,When is it best to use a blend? - CORRECT ANSWER✔✔-1. Cross-
| | | | | | | | | | |
database join is not supported | | | |
2. Tables are at different LOD
| | | | | |
3. Joins create duplicate data or data cleaning is required
| | | | | | | | |
4. If you have a lot of data and the join is time consuming
| | | | | | | | | | | | |
How do you rename a data field? - CORRECT ANSWER✔✔-Right click on
| | | | | | | | | | | |
the data field and select 'rename'
| | | | |
How to assign an alias to a data value? - CORRECT ANSWER✔✔-Right
| | | | | | | | | | | |
click a dimension and select 'Aliases". In the edit aliases dialog box,
| | | | | | | | | | | |
under value, select a member and enter a new name
| | | | | | | | |
How to assign a geographic role to a data field? - CORRECT
| | | | | | | | | | | |
ANSWER✔✔-click the data type icon next to the field and select | | | | | | | | | |
'geographic role'.
| | |
then select the geographic role you want to assign to that field
| | | | | | | | | | |
Change data type for a data field (number, date, string, boolean, etc) -
| | | | | | | | | | | | |
CORRECT ANSWER✔✔-A. On the data source page, click on the icon
| | | | | | | | | | |
associated with the field and select the new data type
| | | | | | | | | |
B. In the data pane, if you right click on the field and scroll down to
| | | | | | | | | | | | | | |
'change data type'
| | |
, Change default properties for a data field (number format, aggregation,
| | | | | | | | | |
color, date, format, etc) - CORRECT ANSWER✔✔-In the data pane, right
| | | | | | | | | | |
click on the field, scroll down to 'default properties' and change the
| | | | | | | | | | | |
desired value |
How to create a visual group? - CORRECT ANSWER✔✔-Control click all
| | | | | | | | | | |
of the fields you want created in the group.
| | | | | | | | |
Right click on these values and select the group button
| | | | | | | | |
How to create a group using labels? - CORRECT ANSWER✔✔-Right click
| | | | | | | | | | |
on the field you would like to be grouped, click on 'create' and then
| | | | | | | | | | | | |
'group'. Be sure to select 'include other'
| | | | | | |
How to create a set? - CORRECT ANSWER✔✔-for a static set, select all
| | | | | | | | | | | | |
fields you want included in the set from the view, right click and select
| | | | | | | | | | | | |
|'create set' | |
for a dynamic set, right click on the field you want to create a set for,
| | | | | | | | | | | | | | | |
scroll down to 'create' and select 'set'
| | | | | |
How to add a context filter? - CORRECT ANSWER✔✔-They are executed
| | | | | | | | | | |
before normal filters. | | |
Right click on the field you want to be a context filter and click 'add to
| | | | | | | | | | | | | | | |
context'