Tableau Quiz

Tableau Beginner Quiz

 



1) TableauSoftware company was founded in

  1. 2001
  2. 2002
  3. 2003
  4. 2004

Answer : B

 
 
2) Tableau is the best fit for which of the following cases?

  1. visual drag and drop operation
  2. data discovery
  3. statistical modeling
  4. ETL operation

Answer : A

 
 
3) Which one of the following doesn’t fall under Tableau’s capabilities?

  1. wizard driven visual analysis
  2. transposing
  3. centralized server
  4. ad-hoc discovery

Answer : A

 
 
4) Which one is incorrect with respect to parameter?

  1. Top N conditional filtering
  2. Dynamic bins
  3. Dynamic reference bands
  4. None of the above

Answer : D

 
 
5) Which one is not the best fitment for Tableau

  1. Mobile enablement
  2. Self Service BI
  3. Enterprise Deployment
  4. Big Data connectivity

Answer : C

 
 
6) Which type of chart is not available in Tableau V8

  1. Bubble Chart
  2. Speed Dial
  3. Bullet Chart
  4. Pie Chart

Answer : B

 
 
7) Tableau supports in memory as well as live-data connection

  1. TRUE
  2. FALSE

Answer : A

 
 
8) Tableau can connect to data in a file. Identify which file type that Tableau cannot connect to or use as a data source.

  1. Text File
  2. MS Excel
  3. MS Access
  4. MS Power Point

Answer : D

 
 
9) In Gartner’s magic quadrant latest release, where does Tableau fit?

  1. Challenger’s Quadrant
  2. Leader’s Quadrant
  3. Niche Player’s Quadrant
  4. None Of the Above

Answer : B

 
 
10) Which one of the following is a valid license type of Tableau

  1. Tableau Desktop License
  2. Tableau Public License
  3. Tableau CAL License
  4. Tableau Viewer License

Answer : A




 
11) Which one of the following extract database types are supported in Tableau?

  1. Microsoft Sql Server
  2. Postgres
  3. MySql
  4. All of the Above

Answer : D

 
 
12) Which one is newly added feature in Tableau 8?

  1. Show Me
  2. One click sort
  3. Word Cloud
  4. Heat Map

Answer : C

 
 
13) Among them, which one is not considered as an information discovery tool?

  1. Tableau
  2. WebFOCUS
  3. Endecca
  4. None of the Above

Answer : A

 
 
14) Which one brings the census information in geocoding in Tableau

  1. Metadata
  2. longitude, lattitude information
  3. data layer in geospatial analysis
  4. tableau server

Answer : C

 
 
15) If  geographic data  is not supported with the built-in roles, custom geocoding can be used  to plot the data on a map

  1. TRUE
  2. FALSE

Answer : A

 
 
16) Tableau supports connection to a Web Map Server (WMS)

  1. FALSE
  2. TRUE

Answer : B

 
 
17) Tableau 8.0 provides built-in statistical models to forecast your data including models that account for seasonality and trends.
 

  1. FALSE
  2. TRUE

Answer : B

 
 
18) A good BI tool should possess the following features

  1. Cross Tabs
  2. Dashboards with KPI reports
  3. Integration with DW appliance
  4. ans) A and B

Answer : D

 
 
19) Which tool is significantly different from others?

  1. Oracle BI
  2. Tableau
  3. Cognos
  4. Business Object

Answer : B

 
 
20) In Tableau Mobile Views themselves are touch-optimized with dynamic scrolling

  1. TRUE
  2. FALSE

Answer : A




 
21) Tableau Mobile has got rapid IT-free authoring

  1. TRUE
  2. FALSE

Answer : A

 
 
22) Tableau in general follows which schema?

  1. snow-flake
  2. star
  3. hybrid
  4. none of the above

Answer : B

 
 
23) which one is referred by .twbx format file in Tableau?

  1. Tableau Data Extract
  2. Tableau WorkBook
  3. Tableau Packaged Workbook
  4. Tableau Data Files

Answer : C

 
 
24) Tableau Public supports all browsers without plug-ins– it’s pure AJAX right in the browser

  1. FALSE
  2. TRUE

Answer : B

 
 
25) Map Options in Tableau 8 are shown in

  1. Menu bar
  2. Sub Menu Bar
  3. Side Pane
  4. Top Pane

Answer : C

 
 
26) What does .twbx file extension mean?

  1. Tableau Packaged Workbook
  2. Tableau Workbook Extension
  3. Tableau Workbook With Extracts
  4. Tableau Zipped Workbook

Answer : A

 
 
27) What is the primary advantage of working with .twbx files?

  1. Analysis can be performed without network/internet connections because data is already loaded on your computer embedded in the packaged file.
  2. Security restrictions are always maintained even in offline mode. Users are always prompted for credentials before access to data source is granted.
  3. It contains Tableau’s instructions for interacting with a data source.
  4. It supports better interactive visualizations and data accuracy.

Answer : A

 
 
28) What is tableau tool tip and what purpose does it serve?

  1. These are the available tools in the menu bar that can be customized for specific user needs.
  2. A feature in Tableau that provides the ability to quickly view the underlying data of a mark
  3. A Tableau feature that provides a pop up when a mouse hovers over on any part of your workbook.
  4. Lets you define rich html tool tips that are embedded directly inside your web page and that appears when the mouse rolls over.

Answer : B

 
 
29) Choose the answer that best describes a Tableau data source

  1. A live connection to a database
  2. A Tableau data extract
  3. Records from which data are obtained
  4. A reusable connection to data

Answer : D

 
 
30) Which type of filter is applied to the data source first and then the other filters are applied only to the resulting records.

  1. Global Filter
  2. Local Filter
  3. Context Filter
  4. Quick Filters

Answer : C




 
31) If you are working on a dimension that contains thousands of products, you can use ________________ to combine those products into higher level categories. This  is useful in cleaning up data inconsistencies or combine several dimension members into a sin

  1. Groups
  2. Bins
  3. Hierarchy
  4. Summary

Answer : A

 
 
32) Which method would best be used if you want to organize values of a measure into discrete groups. Let us say, you want to organize a measure that holds the ages of community volunteers ranging from 18 to 75 into age groups of 18 to 25, 26 to 33, and so on

  1. Sets
  2. Groups
  3. binning measures
  4. Hierarchy

Answer : C

 
 
33) This method helps you group dimensions into similar categories. One way to do this is to drag a dimension on top of another.

  1. Sets
  2. Groups
  3. binning measures
  4. Hierarchy

Answer : D

 
 
34) Which table calculation type shows the rate of change

  1. Percent difference from
  2. difference from
  3. Percent from
  4. Percent of total

Answer : A

 
 
35) Which table calculation type shows a cumulative total

  1. Moving calculation
  2. Running total
  3. Percent of total
  4. Difference from

Answer : B

 
 
36) What is an invisible filter?

  1. a filter that can be applied to a view that is not exposed to your user
  2. Is a type of Tableau filter that can be used during dashboard design
  3. a filter that is only displayed with the correct data blending
  4. a filter that works in tandem with context filter

Answer : A

 
 
37) Which of the following allow users to select or input a value in a view and that value can then in turn be used in calculations, and subsequently, filters.

  1. Calculated fields
  2. Captions
  3. Parameters
  4. Tooltips

Answer : C

 
 
38) Hold one or more worksheets and dashboards

  1. Workbooks
  2. Bookmarks
  3. Packaged Workbooks
  4. Data Extract Files

Answer : A

 
 
39) Contain a single worksheet and are an easy way to quickly share your work

  1. Workbooks
  2. Bookmarks
  3. Packaged Workbooks
  4. Data Extract Files

Answer : B

 
 
40) Contains a workbook along with any supporting local file data sources and background images. This format is the best way to package your work for sharing with others who don’t have access to the data

  1. Workbooks
  2. Bookmarks
  3. Packaged Workbooks
  4. Data Extract Files

Answer : C




 
41) Are local copies of a subset or entire data source that you can use to share data, work offline, and improve database performance

  1. Workbooks
  2. Bookmarks
  3. Packaged Workbooks
  4. Data Extract Files

Answer : D

 
 
42) If I am to add a company logo to my dashboard, which dashboard object will I use?

  1. Horizontal
  2. Vertical
  3. Text
  4. Image

Answer : D

 
 
43) Dashboard layout containers allow you to __________.

  1. create an area in the dashboard where objects automatically adjust their size and position based on the other objects in the container
  2. create an area in the dashboard where objects maintain its predetermined size and position.
  3. add sheets and other objects in the dashboard without affecting any formatting
  4. add a dashboard within a dashboard

Answer : A

 
 
44) On the publish workbook to server window, one of the options to choose from is the “Views to Share.” Select the best answer that best describes the purpose for this option

  1. Any sheets that are not selected are hidden on the server when users view the dashboard.
  2. The views on the server is overwritten
  3. All workbook views are displayed on a row of tabs in each individual view
  4. Any selections you’ve made in the workbook will be published to the server

Answer : A

 
 
45) Describe what happens if the  ‘show selections’ option is selected before a dashboard is published to the Tableau server

  1. A list of dashboard publish options window will appear. Options like include external files or display worksheet as tabs in the dashboard will be visible to the user.
  2. An option to whether include authentication in the dashboard. Each data source, regardless of whether or not it is active in the worksheet, may require authentication.
  3. Selections you’ve made on the dashboard will not be retained.
  4. When this option is selected, any selections you’ve made in the workbook will be published to the server as default.

Answer : D

 
 
46) Which of the following describes the various options in saving your visualizations.

  1. You can save your work as a workbook, packaged workbook, bookmark only.
  2. You can save your work as workbook and packaged workbook
  3. You can save your work as workbook only
  4. You can save your work as workbook, packaged workbooks and dashboard

Answer : A

 
 
47) Which of these methods in saving your work saves the current worksheet only

  1. Save as workbook
  2. Save as packaged workbook
  3. Save as bookmark
  4. Save as worksheet

Answer : C

 
 
48) Which of these methods saves all worksheets in your visualization

  1. Worksheets
  2. Workbooks
  3. Bookmarks
  4. Dashboards

Answer : B

 
 
49) Which formula in Tableau best calculates the overall gross margin for every product in the data source

  1. sum([Profit]/[Sales])
  2. sum ([Profit])/[Sales]
  3. sum ([Profit])/sum([Sales])
  4. [Profit]/[Sales]

Answer : C

 
 
50) Tableau has a set of zoom controls that displays in the upper left corner of a view. By default, these controls only display when you hover over a map view.  Which of the following is not an option for zoom controls.

  1. Automatic
  2. Show on hover
  3. Hide
  4. Prompt

Answer : D




 
51) Parameters are user defined variables that can be used to create a dynamic visualization. Example, you can use parameters in a calculated field rather than using a fixed value.  Select from the list where parameters cannot be used.

  1. Use a parameter in a filter
  2. Use a parameter in binned measures
  3. Use a parameter in reference line
  4. Pages

Answer : D

 
 
52) A __________ field on a shelf indicates a discrete field

  1. blue
  2. green
  3. bold
  4. italic

Answer : A

 
 
53) A __________ field on a shelf indicates a continuous field

  1. blue
  2. green
  3. bold
  4. italic

Answer : B

 
 
54) A __________ name indicates a sorted field.

  1. blue
  2. green
  3. bold
  4. italic

Answer : C

 
 
55) Identify the false statement about a data source

  1. Is a fast way to quickly connect to data and start authoring
  2. Contains a layer of workbook customizations such as calculations
  3. Database drivers are stored within the data source
  4. You can alter customized fields that come with the data source and create additional ones.

Answer : D

 
 
56) This dashboard object allows you to add a ___________ that describes the dashboard. Default value is the dashboard name.

  1. Text
  2. Legend
  3. Title
  4. View

Answer : C

 
 
57) When selected, this option shows the description of the workbook, data sources, fields, layout of the current worksheet, marks, shelves, rows, columns, dimensions, measures, etc.

  1. Show Caption
  2. Show Summary
  3. Describe Sheet
  4. Show Cards

Answer : C

 
 
58) These are containers for shelves, legends, and other controls in Tableau desktop

  1. Cards
  2. Shelves
  3. Marks
  4. Page

Answer : A

 
 
59) Which shelf allows you to break a view into a series of pages so you can better analyze how a specific field affects the rest of the data in a view.

  1. Color shelf
  2. Size shelf
  3. Filters shelf
  4. Page shelf

Answer : D

 
 
60) Which shelf allows you to encode data by assigning different shapes to the marks in a data view

  1. Icon shelf
  2. Shape shelf
  3. Label shelf
  4. Page shelf

Answer : B




 
61) Annotations are used to call out specific marks or points on an axis, line or scatter marks. Which of these is not a type of annotation?

  1. Point
  2. Area
  3. Mark
  4. Page

Answer : D

 
 
62) Displays the fields of the data sources to which Tableau is connected. The fields are divided into dimensions and measures. It also displays custom fields such as calculations, binned fields, and groups

  1. Data Window
  2. Dashboard
  3. Data Source
  4. Bookmarks

Answer : A

 
 
63) Another name for text table. It provides an easy way to display the numbers associated with dimension members.

  1. Cross-tab
  2. caption
  3. Axis
  4. Cell

Answer : A

 
 
64) Is a representation of your data in a Tableau worksheet or dashboard.

  1. Dimensions
  2. Data Window
  3. Data view or view
  4. Data source

Answer : C

 
 
65) What is presentation mode?

  1. Hides everything on the sheet except for the view and its associated legends, quick filters, and parameter controls. A view from a user’s perspective.
  2. Removes legends, quick filters, parameter controls to allows easy integration with Power Point
  3. Read only version of your view
  4. Hides the data window, toolbards, workspace controls, and view cards.

Answer : A

 
 
66) If you have two data sources with related (linked) dimensions, you must use one of those primary dimensions in the view before you can blend data from secondary data source. This is no longer true starting in which version of Tableau?

  1. x
  2. x
  3. x
  4. x

Answer : D

 
 
67) When connecting to a data source you get a prompt asking you to choose which method you want to connect to your data. Which of the following creates a .tde file?

  1. Connecting live to data source
  2. Import all data
  3. Export Packaged workbook
  4. Save as Tableau workbook

Answer : B

 
 
68) What is a secondary Table calculations

  1. Calculations performed from the results of the previous calculations
  2. Calculations that applies to all of the data in the table
  3. Another name for calculated field
  4. Calculations performed at the data source level

Answer : A

 
 
69) When using dual axes in your view, you should make sure that the two axes scales align with each other so that correct comparison can be made. Which method accomplishes this.

  1. Synchronize Axis
  2. Dual Axis
  3. Format reference lines
  4. Edit Axis

Answer : A

 
 
70) There are benefits to adding comments to your field properties. Identify one that is not.

  1. Displays more information about the field in the tooltip
  2. A good way to give more context to the data in your data source
  3. Useful when you are building a workbook for others to use
  4. updates source data with new comments

Answer : D

 
 
71) Sometimes you know precisely the data you want to look at, but don’t know how to generate an effective view. Tableau can help you quickly choose alternate views using this option.

  1. Show Me
  2. Drag and Drop
  3. Tableau Wizard
  4. none of the above

Answer : A

 
 
72) Tableau’s mobile BI solutions focus on usability and consistency that takes advantage of the unique features of mobile. Name special authoring or design changes required to make your visualization work on tablets.

  1. Publish dashboard to mobile app server
  2. No need to do anything special
  3. Design dashboard using the mobile authoring app
  4. Limit the number of views to fit dashboard in a mobile device

Answer : B