Download Tableau Desktop Specialist and more Exams Advanced Education in PDF only on Docsity!
Tableau Desktop Specialist
For a bullet graph, we need at least ______ measures? - correct answer 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. Dimensions containing _______ and _______ values cannot be continuous. a. string b. date and time c. date d. boolean - correct answer a and 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 - correct answer a, c, and d extracts are advantageous for several reasons:
- support large data sets
- fast to create
- help improve performance
- support additional functionality 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 - correct answer d
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 - correct answer c. 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 - correct answer d. you need at least 2 measures for a bullet graph and then 0 or more dimensions t/f the highlighting action can be disables for the entire workbook - correct answer true 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 - correct answer 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.
a. histogram b gantt chart c. bullet chart d. treemaps - correct answer a __________ 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 - correct answer b How would you calculate GDP per capita? a. SUM([GDP])/SUM([Population]) b. SUM([Population]/[GDP]) c. SUM([GDP]/[Population]) d. SUM([GDP]*[Population]) - correct answer a we can join a max of _____ tables in tableau. a. 16 b. 128 c. 32 d. 64 - correct answer c if you use a perfect difference Quick Table Calculation, what value will be the first data value? a. - b. 0000 c. null d. 0 - correct answer c
for the first data set, there is no previous value to compare it to, therefore it appears as NULL which of the following can you use to create a histogram? a. 2 measures b. 1 measure c. 1 dimension d. 2 dimension - correct answer b 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 - correct answer a 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 - correct answer c, b, f, a, d, e (Everyone's Dad Can Do Molly Tonight) 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 - correct answer a
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 - correct answer 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 _________ 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 - correct answer c which of the following fields would be best used as dimensions? multiple choice a. names b. categories c. sales d. profit - correct answer a and b which of the following shapes does a heat map use by default a. circle b. line c. text d. square - correct answer d 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 - correct answer a t/f it is not possible to blend axes for multiple measures into a single axis? - correct answer false charts are called combined-axis/blended axis charts Most viewers scan content starting at the ____________ of a page. a. center b. top right c. bottom left d. top left e. bottom right - correct answer d which of the following is an example of a date part? a. november b. march 209 c. Q4 2017 d. September 2020 - correct answer a 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 - correct answer a Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us
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 - correct answer c 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 - correct answer true continuos palette v categorical palette 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 - correct answer e 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 - correct answer c, d, e t/f it is possible to add a field to more than one hierarchy - correct answer true 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) - correct answer c how can you format numbers in Tablea as currency? - correct answer right click a measure or axis in the view and select Format. Then in the format pane, click the numbers drop-down menu _____ 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 - correct answer 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 - correct answer d 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 - correct answer b 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
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 - correct answer a, b, d according to tableau's order of operations, which filter is applied first? - correct answer extract filter data blending simulates a traditional ______ join a. full outer b. left c. inner d. right - correct answer b 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 - correct answer c 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 - correct answer c and d 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 - correct answer a, b, c 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 - correct answer 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 - correct answer d 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 - correct answer 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 - correct answer b
to connect tableau to a csv data source what type of connection should you use? a. spatial b. text c. excel d. json - correct answer b 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 - correct answer 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 - correct answer c the view data window displays as much of the data as possible by default, up to _______ rows a. 15, b. 20, c. 5, d. 10,000 - correct answer d 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 - correct answer a, b, c 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 - correct answer a 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 - correct answer b and 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 - correct answer 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
________ 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 - correct answer a t/f you get different filtering options for categorical and quantitative data - correct answer true 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 - correct answer c y/n the number of marks will increase when you increase the number of dimensions in a view - correct answer yes 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) - correct answer b, c, 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 - correct answer d 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 - correct answer b 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 - correct answer c 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 - correct answer a
