Download Tableau Desktop Specialist and more Exams Advanced Education in PDF only on Docsity!
Tableau Desktop Specialist
What will this create: SUM(Profit)? (T1) -Horizontal Header -Vertical Header -Horizontal Axis -Vertical Axis - correct answer Horizontal Axis We can join a maximum of ______ tables in Tableau. (T1) 64 128 16 32 - correct answer 32 Which of the following can you use to create a Histogram? (T1) 2 measures 2 dimensions 1 dimension 1 measure - correct answer 1 measure Which of the following are valid dashboard objects when creating a dashboard in Tableau? Choose 4. (T1) -Text -Extension -Web Page -Video -Image - correct answer -Text -Extension
-Web Page -Image Tableau Filter Order of Operations (T1) - correct answer Extract Filters Data Source Filters Context Filters Sets, conditional filters, top N, Fixed LOD Dimension Filters Include/Exclude LOD, data blending Measure Filters Forecasts, table calcs, clusters, totals Table Calc Filters Trend lines, reference lines Which of the following represent a valid method to create a Bullet Graph with the LEAST number of fields possible? (T1) -Using 2 dimensions -Using 1 measure -Using 2 measures -Using 2 dims and 3 measures - correct answer Using 2 measures True or False : Bins can be created on dimensions (T1) - correct answer True Which of the following are stored in a .tds file? Choose 3. (T1) -Data Extracts
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? (T1) -Data source filter -Extract filter -Context filter -None of the these - correct answer Context filter Which of the following shapes does a Heat Map use by default? (T1) -Text -Line -Square -Circle - correct answer Square Tableau auto-generates ____________ dimension(s) and _____________ measure(s) for us. (T1) 2, 3 1, 2 2, 2 1, 4 - correct answer 1, 4 (Latitude, Longitude, Number of Records, Measure Values, _____________ charts are typically used to represent accumulated totals over time and are the conventional way to display stacked lines. (T2) -Bullet -Area -Gantt -Line - correct answer Area Which of the following are valid ways to show Mark Labels in the visualization? (T2) -Click on Analysis in the Menu bar and choose Show Mark Labels -Click on the Show mark labels icon in the Toolbar
-Click on Data in the Menu bar and Choose Show Mark Labels -Drag the measure to the Text label in the Marks Card - correct answer -Click on Analysis in the Menu bar and choose Show Mark Labels -Click on the Show mark labels icon in the Toolbar Drag the measure to the Text label in the Marks Card Which of the following are valid ways of Grouping Data? (T2) -Using Marks in the view -From the Dimensions Shelf -Using Labels in the View -From the Analytics Pane - correct answer -Using Marks in the view -From the Dimensions Shelf -Using Labels in the View For a ____________ sort, no matter how the data changes, the values will always stay in the sort order we kept stuff in. (T2) -Topological -Manual -Random -Hierarchical - correct answer Manual You may create a context filter to: (T2) -To create a dependent filter -Create a dependent numerical or top N filter -To replace a data source filter -Improve performance - correct answer Create a dependent numerical or top N filter Improve performance Which of the following are correct ways to define a join in Tableau version 2020. and above? (T2)
-It replaces all the contents in the extract -It only adds rows that are new since the previous refresh - correct answer It only adds rows that are new since the previous refresh Which of the following is an example of a Date Part? (T1) -November -March 2019 -September 2020 -Q4 2017 - correct answer November When exporting a worksheet as an image in Tableau, which of the following file formats are available? -Portable Network Graphic (.PNG) -Tagged Image File Format (.TIFF) -Windows Bitmap (.BMP) -JPEG Image (.JPEG) - correct answer -Portable Network Graphic (.PNG) -Windows Bitmap (.BMP) -JPEG Image (.JPEG) Which of the following URL prefixes are permitted when creating a URL Action in Tableau? (T2) -FTP -SMTP -HTTP -HTTPS - correct answer -FTP -HTTP -HTTPS To connect Tableau to a CSV data source what type of connection should you use? (T2) -Spatial
-JSON
-Text -Excel - correct answer Text Broadly speaking, when users connect to Tableau, the data fields in their data set are automatically assigned a ____________ and a ____________. (T2) -ID, Key -type, role -dimension, measure -Data type, Value - correct answer type, role When creating a dashboard for multiple devices, which of the following Device options are available in the Device Preview section? (T2) -Monitor, Default, Phone, Tablet -Default, Phone, Tablet, Desktop -Phone, Monitor, Laptop, Default -Phone, Tablet, Laptop, Desktop - correct answer Default, Phone, Tablet, Desktop 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? (T2) -Parameters -Sets -Groups -Calculation - correct answer Parameters Which of the following are valid ways to copy a worksheet visualization as an image? (T2) -By simply clicking Control +V on the keyboard -By right clicking on the worksheet visualization and selecting Copy -> Image -By clicking on the Worksheet in the Tableau Main Menu above, and choosing Copy - > Image
0.2s 0.5s 0.3s - correct answer 0.3s Which of the following is NOT a valid official data source in Tableau Desktop? (T2) -SAP HANA -PostgreSQL -Google Firebase -Amazon Redshift - correct answer Google Firebase The View Data window displays as much of the data as possible by default, up to _______________ rows. (T2) 5, 20, 15, 10,000 - correct answer 10, How can you change the Default Aggregation for a measure in Tableau? (T2) -By double clicking on the measure, and then choosing Window->Default Aggregation -By changing its properties manually every time we need to use it -By right clicking the dimension ->Default properties and choosing Aggregation -By right clicking the measure ->Default properties and choosing Aggregation - correct answer By right clicking the measure ->Default properties and choosing Aggregation Which of the following are valid way(s) to make either of Rows or Columns Bold without affecting the other? (T3) -Select Text Label on the Marks Card, choose Rows or Columns, and then select Bold -Choose Format from the Menu bar, select Row or Column, and then select Bold under the header option -Right click on Rows or Columns, and choose format. In the Font option click on Bold.
-Choose Format then Font from the Menu bar, and select Bold under the Header option - correct answer -Choose Format from the Menu bar, select Row or Column, and then select Bold under the header option -Right click on Rows or Columns, and choose format. In the Font option click on Bold. Which of the following are valid Dashboard size options? (T3) -Range -Scaled -Automatic -Fixed Size - correct answer -Range -Automatic -Fixed Size Which of the following are true about dimensions? (T3) -Dates are mostly placed in dimensions by default for relational data sources -They affect the level of detail in the view -The contain numeric, quantitative values -They contain qualitative values (such as names, dates, or geographical data) - correct answer -Dates are mostly placed in dimensions by default for relational data sources -They affect the level of detail in the view -They contain qualitative values (such as names, dates, or geographical data) When is an axis created for the visualization in Tableau? (T3) -When we drag a dimension to the row/column shelf -When we drag a continuous field to the row/column shelf -When we drag a discrete field to the row/column shelf -When we drag a measure to the row/column shelf - correct answer When we drag a continuous field to the row/column shelf
-Floating items can be layered over other objects -Tiled items don't overlap Which of the following are valid Layout Container types when using Dashboards in Tableau? (T3) -Diagonal Container -Horizontal Container -Split Container -Vertical Container - correct answer -Horizontal Container -Vertical Container Beginning in version 10.5, when you create a new extract, it uses the _________ format instead of the .tde format. (T3) .tds .tdex .twbx .hyper - correct answer .hyper For which of the following charts, does the Size option on the Marks card not work? (T3) -Tree Map -Gantt Chart -Pie Chart -Bar Chart - correct answer Tree Map Which of the following are valid ways to export a dashboard with multiple visualizations as an image? (T3) -Click on Worksheet in the Menu bar followed by Export, then choose Image -Using the floating export worksheet option on the Dashboard -Click on Dashboard in the Menu bar followed by Copy Image
-Right click on the dashboard, and choose Copy, then image. - correct answer Click on Dashboard in the Menu bar followed by Copy Image Which of the following are valid reasons to use a Tableau Data Extract (.tde) over Live Connections? (T3) -To support additional functionality such as count distinct -Fast to create -To have access to the freshest possible data at all times -Help improve performance - correct answer -To support additional functionality such as count distinct -Fast to create -Help improve performance Which of the following describes the best way to change the formatting at a workbook level? (T3) -It is only possible to specify formatting at a worksheet level, not at the workbook level -Choose Format from the menu on top and then specify the formatting in the new Format workbook pane -Right click anywhere in the view, choose format, and then specify the formatting in the new Format workbook pane -Click on Text in the Marks card, choose format, and then specify the formatting in the new Format workbook pane - correct answer Choose Format from the menu on top and then specify the formatting in the new Format workbook pane Creating a scatter plot requires a minimum of how many measures? (T3) 4 3 2 1 - correct answer 2 When field names in the Union do not match, then: (T3)
A Tableau Data Source File (.tds) contains which of the following? (T3) -Copy of any local file-based data -Default Field Properties -Data Source Type -Calculated Fields - correct answer -Default Field Properties -Data Source Type -Calculated Fields True or False: Physical tables remain distinct (normalized), not merged in the data source whereas logical tables are merged into a single, flat table. (T3) - correct answer False Which of the following calculations DO NOT need a quick table calculation? (T3) -Standard Deviation -Rank -Variance -Moving Average - correct answer -Standard Deviation -Variance What do the colors Blue and Green represent in Tableau? (T3) -Dimensions and Measures -Measures and Dimensions -Continuous and Discrete -Discrete and Continuous - correct answer -Discrete and Continuous Which of the following are valid ways to Bold the Tooltip content in Tableau? (T3) -Click on Tooltip in the Marks card, and select bold -Click on Worksheet in the Menu bar, followed by Tooltip and select the bold option -Click on Analysis, Tooltip options, and select bold
-Right click, click format and then under the default worksheet formatting, choose Tooltip and make it bold - correct answer -Click on Tooltip in the Marks card, and select bold -Click on Worksheet in the Menu bar, followed by Tooltip and select the bold option -Right click, click format and then under the default worksheet formatting, choose Tooltip and make it bold Which of the following sets would you use to compare the members? (T3) -None of these -Static Sets -Dynamic Sets -Combined Sets - correct answer -Combined Sets Which of the following options best describe measures? (T3) -They are numerical, quantitative -They are categorical, quantitative -They are categorical, qualitative -They are numerical, qualitative - correct answer -They are numerical, quantitative Which of the following points are True about Viz Animations? (T4) -Animations work well with maps, polygons, and density marks in web browsers -They can be turned on for certain worksheets only -Sequential animations take more time but make complex changes clearer by presenting them step-by-step -It is possible to turn them on for the entire workbook at once - correct answer -They can be turned on for certain worksheets only -Sequential animations take more time but make complex changes clearer by presenting them step-by-step -It is possible to turn them on for the entire workbook at once Is it possible to deploy a URL action on a dashboard object to open a Web Page within a dashboard rather than opening the system's web browser? (T4)
True or False: A LEFT JOIN or INNER JOIN creates a row each time the join criteria is satisfied, which can result in duplicate rows. One way to avoid this is to use relationships instead. (T4) - correct answer True We can use ______________ as a static tool to open and interact with packaged workbooks with extracted data sources that have been created in Tableau Desktop. (T4) -Tableau Server -Tableau Reader -Tableau Desktop -Tableau Online - correct answer -Tableau Reader Which of the following are interactive elements that can be added to a dashboard for users? (T4) -URL Action -Filter Action -Highlight Action -Edit Tooltip Action - correct answer -URL Action -Filter Action -Highlight Action Which of the following are the options to export the data used to build the view / visualizations? (T4) -PDF File -CSV File -JSON Format -MS Access Database - correct answer -CSV File -MS Access Database For creating variable sized bins we use __________________ (T4) -Groups
-Table Calculations -Sets -Calculated Fields - correct answer -Calculated Fields _____________ is a snapshot of the data that Tableau stores locally. Good for very large datasets of which we only need few fields. (T4) -Tableau Data Extract (.tde) -Tableau Packaged Workbook (.twbx) -Tableau Workbook (.twb) -Tableau Data Source (.tds) - correct answer -Tableau Data Extract (.tde) Which of the following are True for Measure Names? (T4) -When working with a text table showing Profit for each Category, when you add Sales to the text table (by dragging it and dropping it in the view), the measure names field is automatically dragged to the row and filter shelves -When you add it to a view, all of the measure names appear as row or column headers in the view -It contains all the measures in your data, collected into a single field with continuous values -It contains the names of all measures in your data, collected into a single field with discrete values - correct answer -When working with a text table showing Profit for each Category, when you add Sales to the text table (by dragging it and dropping it in the view), the measure names field is automatically dragged to the row and filter shelves -When you add it to a view, all of the measure names appear as row or column headers in the view -It contains the names of all measures in your data, collected into a single field with discrete values Which of the following is the correct way to calculate Profit Ratio in Tableau? (T4) -SUM(Profit)/SUM(Sales) -SUM(Sales)/SUM(Profit) -Sales/Profit -Profit/Sales - correct answer -SUM(Profit)/SUM(Sales)
