Download Tableau Desktop Specialist and more Exams Advanced Education in PDF only on Docsity!
Tableau Desktop Specialist
What is the best description of how Tableau makes a live connection to your data? -Tableau extracts all your data into its custom data structure at regular intervals. -You manually load file extracts into Tableau's database. -Tableau maintains a connection to the data source, so data refreshes in the workbook. -You manually load data files into Tableau's database. - correct answer Tableau maintains a connection to the data source, so data refreshes in the workbook. Why does Tableau create a live data connection by default? -Live connections maximize efficiency because they include the entire contents of the data source. -Connecting live means that as new source data is added, it can be incorporated into your analysis. -A live connection will query the data source and rebuild it as an extract. - correct answer Connecting live means that as new source data is added, it can be incorporated into your analysis. To connect to data with Tableau Desktop, where in the interface do you first click from? -Data Source page -Connect pane -Data pane -File menu - correct answer -Connect Pane With Tableau Cloud, to connect to a published data source, you must: -Upload a workbook. -Request an unused data source.
-Create a new workbook. -Rename the data source. - correct answer -Create a new workbook Which area of the Tableau workspace displays the data source name and its available fields as dimensions and measures? -Pages shelf -Marks card -Data pane -Filters shelf - correct answer -Data pane Where on the Data Source page would you drag a table that you want to add to your visualization? -Preview area -Data pane -Canvas -Connection area - correct answer -Canvas Why would you change a field's data role once you've brought data into Tableau? -To give the field a new name. -To give the field a new name and join the renamed field with another field. -To create a relationship between the original data role and the data source represented by its original data role. -To make sure the field behaves in the way we expect or to make the field clearer in the context of the analysis. - correct answer -To make sure the field behaves in the way we expect or to make the field clearer in the context of the analysis. You are analyzing sales of children's toys. The toy list is very long and has three spellings of Plush: Plushie Plush plush
How do you expand and contract the display of related fields in a hierarchy? -Drag the hierarchy to the Marks card. -Drag all related fields to Rows or Columns. -Add the hierarchy to the Filters shelf. -Use the [+] and [-] to drill down and up. - correct answer Use the [+] and [-] to drill down and up. You have created a hierarchy in the Data pane, but some of the fields are in the wrong order. What can you do to reorder the fields? -Delete the hierarchy and start over. -Filter the fields in the hierarchy. -Drag each field onto the shelf in the correct order. -Drag the fields into the proper order in the Data pane. - correct answer Drag the fields into the proper order in the Data pane. What is the filter type to reduce the amount of data being fed into Tableau? - correct answer Datasource / Extract filter What type of filter would you use to filter for a customer with the last name starting with "J"? - correct answer Dimension filter What type of filter would you use to control sensitive data? - correct answer Data source filter What type of filter would you use to show customers by their region? - correct answer Dimension filter What type of filter would you use to show customers with sales >5,000 units? - correct answer Measure filter
What type of filter would you use to show top 10 selling products in chicago? - correct answer Context filter What is the filtering order of operations? filter types include... measure, context, extract, data source, dimension, table calculation - correct answer Extract Data source Context Dimension Measure Table Calc The QA team in your company has shared a view that shows all the bugs logged against the new features for your next product launch. The bug review by your team only triages bugs logged in the last 30 days. Which date filter is most ideal to quickly see this data? -Range of Dates -Relative Date -Start Date -End Date - correct answer -Relative Date Which of the following is true for a computed sort? A) Computed sort organizes the data by applying rules. B) Computed sort allows users to specify the sort order. C) Computed sort is dynamic. A and C A and B - correct answer A & C
How can you display the top 5 and bottom 5 sales in the same view? -Create the view using a dynamic set that includes the top 5 items. Items out of the set can be considered as bottom items. -Create the view using a dynamic set that includes the bottom 5 items. Items out of the set can be considered as top items. -Create the view using a combined set to include all members from the top 5 and bottom 5 sets. -Use a filter because views do not allow you to show items from multiple sets. - correct answer -Create the view using a combined set to include all members from the top 5 and bottom 5 sets. A set can be used as a: Dimension Measure Bin Hierarchy - correct answer Dimension To display a set control for a set, it must be: A) A fixed set B) A dynamic set C) Not be used in a calculation D) Used in the view E) A and C F) B and D - correct answer F What is the Measure Names field?
-It is a measure containing the values of the measures. -It contains measures with default aggregations other than CNT. -It is a dimension that contains the names of the measures. -It is a filter for the measures in the view. - correct answer It is a dimension that contains the names of the measures. What is the Measure Values field? -It is a measure containing the values for the measures. -It contains the measures with a default aggregation of SUM. -It is a dimension containing the names of the measures. -A filter for the measures in the view. - correct answer -It is a measure containing the values for the measures. How many measures can you have in a text table? -Sixteen on Rows and fifty on Columns. -Fifty on Rows and sixteen on Columns. -Unlimited, but they all must have the same default aggregation. -Unlimited, but they all need to use the same units of measurement. - correct answer Fifty on Rows and sixteen on Columns. What do you need to do so two or more measures share an axis? -Connect a data source to a workbook. -Add Measure Values to Rows or Columns and display at least two values. -Add Measure Names to Rows or Columns and display at least two measures. -Filter on Measure Names - correct answer -Add Measure Names to Rows or Columns and display at least two measures. What do you need to create a dual axis chart?
-Size, Detail and Text - correct answer -Color, Text and Mark type You're working with a data source with quantitative values (with a wide variation in those values) and latitude and longitude coordinates. Which would be a good map type to use to analyze this data geographically? -Filled map -Spider map -Flow map -Symbol map - correct answer -Symbol map Symbol maps can show up to two quantitative values per location. Which of the following is a good way to represent those two values? -Encode both values in shades of the same color. -Encode the first value with size and the second value with color. -Convert the values to geocodes and drag them to the Marks card. -Convert the values to latitude and longitude and drag them to the Marks card. - correct answer -Encode the first value with size and the second value with color. You can resolve ambiguous geocoded location data by: -Removing the geocoding from the data. -Specifying the Country/Region and/or State/Province for your data. -Reapplying the geocoding to the data. -Deleting all items marked as ambiguous. - correct answer -Specifying the Country/Region and/or State/Province for your data. To create a filled map, which mark type should you select on the Marks card? -Map
-Line -Circle -Shape - correct answer Map If you want to keep the map's currently displayed data from changing, which button on the View toolbar would you click? -Pan -Fix Map -Rectangle Selection -Zoom Area - correct answer Fix Map Which of the terms below best completes the following sentence? Density marks work best when the specific locations ____ -are constrained to discrete locations like city or zip code. -are spread out over a large area. -are color coded. -change continuously and smoothly across a limited space. - correct answer -change continuously and smoothly across a limited space. Which of the terms below best completes the following sentence? By adjusting the combination of Color, ____, and Size, you can make the trends in a density map much more apparent. -Halo -Intensity -Detail -Border - correct answer Intensity Which of the following scenarios requires a calculated field?
-They are replaced in both the Data pane and in the original data source. - correct answer -They remain in the Data pane and in the original data source. Which of the following date functions will allow you to find the date of the beginning of the week for any existing date value? DATETRUNC DATEADD DATEDIFF MAX - correct answer DATETRUNC f you create a calculated field with the formula SUM([Profit]) / SUM([Sales]), how will Tableau perform the aggregation for the calculation? -Tableau will sum the Profit and Sales values separately for the level of detail in the view and then divide the total of Profit by the total of Sales. -Tableau will perform the division at the row level first and then sum the ratios for the level in the view. -Tableau will sum the Profit and Sales values together and then divide that total by the sum of Sales. -Tableau will sum the Profit and Sales values together and then divide that total by the sum of Profit. - correct answer -Tableau will sum the Profit and Sales values separately for the level of detail in the view and then divide the total of Profit by the total of Sales. Which built-in table calculation should you use if you want to see sales for three years displayed with each month's sales added to all previous months' sales? -Percent Difference -Rank -Running Total -Year Over Year Growth - correct answer Running total
Which area of the view would you click to start creating a reference line? - correct answer Analytics pane Use a parameter in a view to: -Add interactivity and flexibility to a report. -Filter data across multiple data sources. -Structure and group fields in your data. -Optimize your workbook performance. - correct answer -Add interactivity and flexibility to a report. Why is it helpful to give a parameter an actionable title? -The title can tell the user how to use the parameter control. -The title can help distinguish the parameter from less actionable fields. -The title limits how the parameter can be used within the workbook. - correct answer -The title can tell the user how to use the parameter control. Which of the following statements is true for a parameter? -Allows users to select multiple values -Shows a subset of the data -Can be used in a calculated field -Has slower performance than quick filters - correct answer -Can be used in a calculated field If you had a dynamic parameter with a data type of Date, the dates would: -Update as soon as the data refreshes. -Update when the user reopens the workbook.
-Left -Primary -Right -Secondary - correct answer Primary Which of the following is a reason to build a dashboard? -Explore relationships in data. -Publish your views to the web. -Reduce questions asked of the data. -Reduce the effort in maintaining separate sheets in a workbook. - correct answer - Explore relationships in data. Which of the following should you consider when planning a dashboard? -How to fit in as many views as you can. -How to always include a map. -If the dashboard will be viewed on a mobile device. -If lots of colors can be used to make the dashboard vibrant. - correct answer -If the dashboard will be viewed on a mobile device. You are creating a dashboard that has three worksheets. You want to use an existing filter to apply to all three worksheets. Which option would you select? -Only This Worksheet -Show Apply Button -All Using This Data Source -Edit Filter - correct answer -All Using This Data Source Which of the following is best suited to use the hover option to run an action?
-For highlight actions, where data points are highlighted. -For any type of actions. -For URL actions, where the user is connecting to web resources. -For filter actions, where data points are selected. - correct answer -For highlight actions, where data points are highlighted. What does a filter action do? -It calls attention to marks of interest by retaining color for specific marks and dimming all others. -It uses the data from one view to narrow down data in another to help guide analysis. -It creates hyperlinks to external resources. -It creates an email link for additional information about your data. - correct answer -It uses the data from one view to narrow down data in another to help guide analysis. A horizontal layout container: -Resizes the width of the views and objects it contains. -Dynamically updates the data within the views. -Automatically adds borders and padding to the views within the container. -Ensures that the views it contains are the most prominent in the dashboard. - correct answer -Resizes the width of the views and objects it contains. When planning for instructions in a dashboard, which of the following design principles should you follow? -Don't give away too much information upfront; surprise the user. -Provide instructions only for the main sheet. -Ensure that the dashboard is self-explanatory. -Use annotations for as many marks and points as possible - correct answer -Ensure that the dashboard is self-explanatory.
Which of the following is a best practice for creating stories? -Create as many story points as you can. -Never resize a dashboard in a story. -Always include a map. -Keep it simple. - correct answer -Keep it simple. A successful story: -Allows the audience to guess the answer to the main question -Does not digress by drilling down into additional data and highlighting outliers -Does not show trends -Has a clear purpose - correct answer -Has a clear purpose To use an existing story point as a basis for a new one, use the following option: -Blank -Duplicate -Story point -Update - correct answer Duplicate You want to select a specific product version for a downloaded workbook. Which approach should you take? -You have to use the Download option on either the Actions or More actions menu. -You have to use Download on the view's toolbar. -You can use either Download on the view's toolbar OR the Download option on either the Actions or More actions menu. - correct answer -You have to use Download on the view's toolbar.
