Tableau Desktop Specialist
creating a scatter plot requires a minimum of how many measures?
2
Dimensions containing _______ and _______ values cannot be continuous. a. string b. date and time c. date d. boolean
a and d
which of the following are valid ways to add totals to a view? multiple choice a. from the analysis tab in the menu bar on top b. using data pane c. using the marks shelf d. using the analytics pane
a and d
which of the following are valid dashboard size options? multiple choice a. scaled b. fixed size c. automatic d. range
b, c, d
we can join a max of _____ tables in tableau. a. 16 b. 128 c. 32 d. 64
c
which of the following is NOT a valid official data source in tableau desktop? a. amazon redshift b. postgreSQL c. google fiberbase d. sap hana
c
the view data window displays as much of the data as possible by default, up to _______ rows a. 15,000 b. 20,000 c. 5,000 d. 10,000
d
how can you format numbers in Tablea as currency?
right click a measure or axis in the view and select Format. Then in the format pane, click the numbers drop-down menu
t/f we get different color palette options if we drop a discrete field on 'color' in the marks card compared to if we drop a continuous field on color
true continuos palette v categorical palette
y/n is it possible to use measures in the same view multiple times (e.g. SUM of the measure and AVG of the measure)?
yes
y/n the number of marks will increase when you increase the number of dimensions in a view
yes
a ______ action is a hyperlink that points to a web page, file, or other web-based resource outside of tableau a. go to sheet b. go to hyperlink c. go to web page d. go to url
d
For a bullet graph, we need at least ______ measures?
2. A bullet graph is a variation of a bar graph developed to replace dashboard gauges and meters. A bullet graph is useful for comparing the performance of a primary measure to one or more other measures.
By default, measures placed in a view are aggregated. The type of aggregation applied ______________ a. depends on the context of the view b. is always COUNT c. is always AVERAGE d. is always SUM
a
How would you calculate GDP per capita? a. SUM([GDP])/SUM([Population]) b. SUM([Population]/[GDP]) c. SUM([GDP]/[Population]) d. SUM([GDP]*[Population])
a
You add SUM(Profit) to the columns shelf, what will it create? a. a horizontal axis b. a horizontal header c. a vertical header d. a vertical axis
a
________ files are shortcuts for quickly connecting to the original data that you use often. data source files do not contain the actual data but rather the info necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on a. .tds b. .tbm c. .tde d. .twb
a
a __________ is a single zip file that contains a workbook along with any supporting local file data and background images. this format is the best way to package your work for sharing with others who don't have access to the original data a. .twbx file b. .twb file c. .tbm file d. .tde file
a
as a general best practice, how many categories can a pie chart display effectively? a. 2 to 5 b. 2 to 8 c. 3 to 7 d. 3 to 5
a
our use case states that we need to create a set showing the bottom 10 products by profit in each region. Which of the following filter types should you apply on region? a. context filter b. extract filter c. measure filter d. dimension filter
a
the default path for all supporting files, data sources, icons, logs, etc is in __________________ a. documents -> My Tableau Repository b. documents -> Tableau Files c. documents -> Tableau Support Files d. documents -> Tableau
a
what is a story point in tableau? a. a single worksheet or dashboard b. a collection of both worksheets and dashboards c. a collection of worksheets d. a collection of dashboards
a
when using animations, which of the following is the default duration for animation? a. 0.3s b. 0.2s c. 0.4s d. 0.5s
a
when using the manage metadata option, we can create custom names for columns where _____________ is the original name of the column whereas ____________ is the custom name we created in Tableau a. remote field name, field name b. local name, actual name c. local field, global field d. column name, actual name
a
which of the following chart type makes use of 'binned' data? a. histogram b gantt chart c. bullet chart d. treemaps
a
which of the following is a benefit of using a tableau packaged workbook (.twbx)? a. to create a single zip file that contains a workbook along with any supporting local file data and background images. this is great for sharing your work with others who don't have access to the original data b. to create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance c. to not contain the actual data but rather the info necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing the default properties, creating calculated fields, etc d. to hold one or more worksheets, plus zero or more dashboards and stories
a
which of the following is an example of a date part? a. november b. march 209 c. Q4 2017 d. September 2020
a
you can create ________ for members in a dimension so that their labels appear differently in the view a. aliases b. duplicates c. renames d. copies
a
relationships are represented by __________ and operate at the ___________ a. noodles, logical layer b. noodles, physical layer c. venn diagrams, logical layer d. venn diagrams, physical layer
a venn diagrams = joins noodles = relationships
When you drop a continuous field on Color, Tableau displays a quantitative legend with a ___________ range of colors. a. continuous b. mixed c. fading d. discrete
a when you drop a DISCRETE field on color, it displays a categorical palette. when you drop a CONTINUOUS field, it displays a quantitative legend with a continuous range of color
which of the following are correct ways to define a join in tableau version 2020.3 and above? multiple choice a. double click a logical table to go to the join/union canvas in the physical layer and add joins or unions b. right click a logical table and click on open to go to the join/union canvas in the physical layer and add joins or unions c. right click a physical table and click on open to go to the join/union canvas in the logical layer and add joins or unions d. double click a physical table to go to the join/union canvas in the logical layer and add joins or unions
a and b
which of the following fields would be best used as dimensions? multiple choice a. names b. categories c. sales d. profit
a and b
which of the following are valid ways of grouping data? multiple choice a. using marks in the view b. from the dimensions shelf c. using labels in the view d. from the analytics pane
a, b, c
which of the following url prefixes are permitted when creating a url action in tableau multiple choice a. ftp b. https c. http d. smtp
a, b, c
which of the following are valid ways to show mark labels in visualizations? multiple choice a. click on the show mark labels icon in the toolbar b. click on analysis in the menu bar and choose show mark labels c. click on data in the menu bar and choose show mark labels d. drag the measure to the text label in marks card
a, b, d
which of the following are benefits of using data extracts of tableau? multiple choice a. faster to work with b. working with the freshest data at all times c. ability to use the data offline d. improved performance
a, c, and d extracts are advantageous for several reasons: 1. support large data sets 2. fast to create 3. help improve performance 4. support additional functionality
which of the following are valid objects when creating a dashboard in tableau? multiple choice a. extension b. video c. image d. text e. web page
a, c, d, e
you have cleaned a data source properly, created some calculated fields and renamed some columns. You want to save these changes for future use cases. Which of the following would BEST satisfy the requirement? a. save it as a .tds file b. save it as a .twbx file c. save it as a .twm file d. save it as a .twb filw
a. to save, go to data menu on top and then choose your current connected data source. next click on add to saved data sources. this will save all calculated fields, changes to fields, etc. It will be saved in 'My Tableau Repository' -> 'Mydatasources.' This will appear on Tableau Home Page under saved data sources like SampleSuperStore. Note: Data source file do not contain the actual data, but rather the info necessary to connect to the actual data as well as any mods you've made on top of the actual data such as changing default properties, creating calculated fields, adding groups, and so on.
__________ refers to the level of detail for a piece of data, wherever you are looking. a. data cleanliness b. data granularity c. data LOD d. data connectivity
b
____________ is useful when you need to change how the data source is configured on a sheet-by-sheet basis, and when you want to combine databases that don't allow relationships or joins a. union b. data blending c. data segregation d. data joining
b
broadly speaking, after importing a dataset in tableau desktop, all fields in it are broken down into _______________ a. labels and values b. dimensions and measures c. rows and columns d. numbers and headers
b
by definition. tableau displays measures over time as a ____________. a. stacked bar b. line c. packed bubble d. bar
b
data blending simulates a traditional ______ join a. full outer b. left c. inner d. right
b
how can you change the default tableau repository location? a. by clicking on help -> change repository location b. by clicking on file -> repository location and choosing a new location c. by clicking on window -> repository location d. by moving the repository location manually to wherever we want
b
in tree maps, the size begins with the largest rectangle on the ________ and the smallest rectangle on the ____________ a. top right, bottom left b. top left, bottom right c. top left, bottom left d. top rights, bottom right
b
to connect tableau to a csv data source what type of connection should you use? a. spatial b. text c. excel d. json
b
what do the colors blue and green represent in tableau a. continuous and discrete b. discrete and continuous c. dimensions and measures d. measures and dimensions
b
which of the following can you use to create a histogram? a. 2 measures b. 1 measure c. 1 dimension d. 2 dimension
b
which of the following is a benefit of using a extract (.hyper or .tde)? a. to create a single zip file that contains a workbook along with any supporting local file data and background images. this is great for sharing your work with others who don't have access to the original data b. to create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance c. to not contain the actual data but rather the info necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing the default properties, creating calculated fields, etc d. to hold one or more worksheets, plus zero or more dashboards and stories
b
which of the following is a valid wat to create sets in tableau a. in the data pane, right click a dimension and select create -> set b. in the tableau main menu, choose worksheet and select create -> set c. in the data pane, right click a measure and select create -> set d. in the tableau main menu, choose dashboard and select create -> set
b
you have just created a histogram and now want to be able to change the size of bins dynamically. using which of the following will easily satisfy your requirement a. groups b. parameters c. calculation d. sets
b
Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us a. 1,2 b. 1,4 c. 2,3 d. 2,2
b 1 Dimension - Measure Names 4 Measures - Latitude, Longitude, # of records, and measure values
You want to save your changes and workbooks. What is the best way to do so? multiple choice a. save it as a .tds file b. save it as a .twbx file c. save it as a .twm file d. save it as a .twb filw
b and d
which of the following are valid ways to copy a worksheet visual as an image? multiple choice a. using the marks shelf and choosing copy > image b. by clicking on worksheet in the tableau main menu above and choosing copy > image c. by simply clicking control + v on the keyboard d. by right clicking on the worksheet visual and selecting copy > image
b and d
when exporting a worksheet as an image, which of the following file formats are available? multiple choice a. tagged image file format (tiff) b. jpeg image (.jpg, .jpeg) c. windows bitmap (.bmp) d. portable network graphic (.png)
b, c, d
_____ is a method for appending values (rows) to tables. you can use this method if both tables have the same columns. the result is a virtual table that has the same columns but extends vertically by adding rows of data a. blending b. joining c. unioning d. combining
c
_______ charts are typically used to represent accumulated totals over time and are the conventional way to display stacked lines a. line b. bullet c. area d. gantt
c
_________ enables us to create workbooks and views, dashboards, and data sources in Tableau Desktop, and then publish this content to our own server a. tableau myServer b. tableau public c. tableau server d. tableau prep
c
broadly speaking, when users connect to tableau, the data fields in their data set are automatically assigned a ________ and a _______ a. data type, value b. id, key c. type, role d. dimension, measure
c
dragging a _____ to color creates distinct colors for each item whereas dragging a __________ to color creates a gradient a. continuous value, discrete value b. geographical value, discrete value c. discrete value, continuous value d. longitude, latitude
c
how can you change the default aggregation for a measure in tableau? a. by double clicking on the measure and then choosing window > default aggregation b. by right clicking the dimension > default properties and choosing aggregation c. by right clicking the measure > default properties and choosing aggregation d. by changing its properties manually every time we need to use it
c
what is the one critical difference between normal calculated fields, and the calculated fields created after data blending? a. the calculated fields created in blends cannot use more than 2 fields b. the calculated fields created in blends cannot be edited once created c. fields used in blends must first be aggregated d. no difference, calculated fields cannot be created in blends
c
which of the following is a benefit of using a tableau data source (.tds)? a. to create a single zip file that contains a workbook along with any supporting local file data and background images. this is great for sharing your work with others who don't have access to the original data b. to create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance c. to not contain the actual data but rather the info necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing the default properties, creating calculated fields, etc d. to hold one or more worksheets, plus zero or more dashboards and stories
c
which of the following is true about 'Incremental refresh' when creating extracts in Tableau? a. there is no difference, both are the same when using extracts. they are different when using live connections b. it replaces all of the contents in the extracts c. it only adds rows that are new since the previous refresh d. they can only be used with large datasets
c
which of the following would you use to connect to multiple tables in a single data source at once? a. a set b. a hierarchy c. a join d. a blend
c
which of the following would you use to edit the shape, color, and text of your visual a. filter shelf b. analytics pane c. marks card d. data pane
c
which of these is NOT a type of quick filter available in Tableau? a. multiple values (dropdown) b. wildcard match c. regex match d. single value (slider)
c
if you use a perfect difference Quick Table Calculation, what value will be the first data value? a. -1 b. 0000 c. null d. 0
c for the first data set, there is no previous value to compare it to, therefore it appears as NULL
which of the following are compelling reasons to use a stacked bar chart? multiple choice a. to visualize each discrete category using a separate bar b. to easily visualize trends over time c. to be able to visualize complex info with fewer bars/ marks d. to visualize parts of a whole
c and d
you may create a context filter to (multiple choice) a. replace a data source b. create a dependent filter c. improve performance d. create a dependent numerical or top n filter
c and d
What is the order of filters according to Tableau's Order of Operations: a. dimension filters b. data source filters c. extract filters d. measure filters e. table calc filters f. context filters
c, b, f, a, d, e (Everyone's Dad Can Do Molly Tonight)
which of the following are stored in a .tds file? multiple choice a. visualizations b. data extracts c. calculated fields d. metadata edits e. data connections info
c, d, e
You want to save these a worksheet to easily and quickly share, what is the best way? a. save it as a .tds file b. save it as a .twbx file c. save it as a .twm file d. save it as a .twb filw
c.
by default, what does tableau do when you connect to a data source? a. loads your actual file into tableau b. creates an extract of the data c. creates a live connection to the data d. sorts the data in descending order
c.
For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in. a. topological b. random c. hierarchical d. manual
d
In order to avoid any confusion, what should you do after creating a dual-axis chart? a. edit the labels b. change the colors c. hide the axis d. synchronize the axis
d
Most viewers scan content starting at the ____________ of a page. a. center b. top right c. bottom left d. top left e. bottom right
d
_____ are a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance a. .twbx files b. .tbm files c. .twb files d. .tde files
d
______ can only create header. ______ will create header and axis both a. dates. strings b. measures, dimensions c. groups, sets d. dimensions, measures
d
how does tableau know at which level to aggregate values? a. values are always aggregated at the level of the date part b. tableau doesn't aggregate values, we do c. aggregation is always done by using tableau special formulas d. values are always aggregated at the level of granularity of the worksheet
d
suppose you create a bar chart by dragging a dimension to the column shelf and a measure to the row shelf. which of the following would create a stacked bar chart? a. by dragging another measure to the columns shelf b. by dragging another measure to color on the marks shelf c. by dragging another dimension to the rows shelf d. by dragging another dimension to color on the marks shelf
d
when creating a dashboard for multiple devices, which of the following device options are available in the device preview selection? a. phone, tablet, laptop, desktop b. phone, monitor, laptop, default c. monitor, default, phone, tablet d. default, phone, tablet, desktop
d
when there are both negative and positive values for a field, the default range of values will use two color ranges. this is known as a ______ palette a. stepped b. reversed c. converging d. diverging
d
when you want to first apply a filter and THEN show the top n or bottom n elements, which of the following filters would you use? a. extract filters b. none of these c. data source filter d. context filter
d
which of the following is a benefit of using a workbooks (.twb)? a. to create a single zip file that contains a workbook along with any supporting local file data and background images. this is great for sharing your work with others who don't have access to the original data b. to create a local copy of a subset or entire data set that you can use to share data with others, when you need to work offline, and improve performance c. to not contain the actual data but rather the info necessary to connect to the actual data as well as any modifications you've made on top of the actual data such as changing the default properties, creating calculated fields, etc d. to hold one or more worksheets, plus zero or more dashboards and stories
d
which of the following shapes does a heat map use by default a. circle b. line c. text d. square
d
you want to add custom shapes to your visual. where can you add these new shapes? a. in program files ? tabelau > shapes b. in my computer > C: > tableau > shapes c. in downloads ? my tableau repository > shapes d. in my documents > my tableau repository > shapes
d
which of the following represent a valid method to create a bullet graph with the least number of fields possible? a. using 2 dimensions and 3 measures b. using 2 dimensions c. using 1 measure d. using 2 measures
d. you need at least 2 measures for a bullet graph and then 0 or more dimensions
if you decide you want to see all of the marks in the view at the most detailed level of granularity, you can ___________ the view. a. split the measures b. aggregate the measures c. sort the measures d. break-down the measures e. disaggregate the measures
e
according to tableau's order of operations, which filter is applied first?
extract filter
t/f all rows from both tables are returned in an inner join
false
t/f it is not possible to blend axes for multiple measures into a single axis?
false charts are called combined-axis/blended axis charts
Y/N is it possible to add both a dashboard and a worksheet at the same time to a story point?
no
y/n are animations enabled by default in tableau
no
y/n is SUM a table calculation
no SUM is an aggregate function
t/f it is possible to add a field to more than one hierarchy
true
t/f the highlighting action can be disables for the entire workbook
true
t/f you get different filtering options for categorical and quantitative data
true
t/f bins can be created on dimensions
true if a dimension is numeric, bins can be created from it
t/f trend lines can only be used with numeric or date fields
true to add a trend line, both axes must contain a filed that can be interpreted as a number
