Tableau Beginner Quiz
1) TableauSoftware company was founded in
- 2001
- 2002
- 2003
- 2004
2) Tableau is the best fit for which of the following cases?
- visual drag and drop operation
- data discovery
- statistical modeling
- ETL operation
3) Which one of the following doesn’t fall under Tableau’s capabilities?
- wizard driven visual analysis
- transposing
- centralized server
- ad-hoc discovery
4) Which one is incorrect with respect to parameter?
- Top N conditional filtering
- Dynamic bins
- Dynamic reference bands
- None of the above
5) Which one is not the best fitment for Tableau
- Mobile enablement
- Self Service BI
- Enterprise Deployment
- Big Data connectivity
6) Which type of chart is not available in Tableau V8
- Bubble Chart
- Speed Dial
- Bullet Chart
- Pie Chart
7) Tableau supports in memory as well as live-data connection
- TRUE
- FALSE
8) Tableau can connect to data in a file. Identify which file type that Tableau cannot connect to or use as a data source.
- Text File
- MS Excel
- MS Access
- MS Power Point
9) In Gartner’s magic quadrant latest release, where does Tableau fit?
- Challenger’s Quadrant
- Leader’s Quadrant
- Niche Player’s Quadrant
- None Of the Above
10) Which one of the following is a valid license type of Tableau
- Tableau Desktop License
- Tableau Public License
- Tableau CAL License
- Tableau Viewer License
11) Which one of the following extract database types are supported in Tableau?
- Microsoft Sql Server
- Postgres
- MySql
- All of the Above
12) Which one is newly added feature in Tableau 8?
- Show Me
- One click sort
- Word Cloud
- Heat Map
13) Among them, which one is not considered as an information discovery tool?
- Tableau
- WebFOCUS
- Endecca
- None of the Above
14) Which one brings the census information in geocoding in Tableau
- Metadata
- longitude, lattitude information
- data layer in geospatial analysis
- tableau server
15) If geographic data is not supported with the built-in roles, custom geocoding can be used to plot the data on a map
- TRUE
- FALSE
16) Tableau supports connection to a Web Map Server (WMS)
- FALSE
- TRUE
17) Tableau 8.0 provides built-in statistical models to forecast your data including models that account for seasonality and trends.
- FALSE
- TRUE
18) A good BI tool should possess the following features
- Cross Tabs
- Dashboards with KPI reports
- Integration with DW appliance
- ans) A and B
19) Which tool is significantly different from others?
- Oracle BI
- Tableau
- Cognos
- Business Object
20) In Tableau Mobile Views themselves are touch-optimized with dynamic scrolling
- TRUE
- FALSE
21) Tableau Mobile has got rapid IT-free authoring
- TRUE
- FALSE
22) Tableau in general follows which schema?
- snow-flake
- star
- hybrid
- none of the above
23) which one is referred by .twbx format file in Tableau?
- Tableau Data Extract
- Tableau WorkBook
- Tableau Packaged Workbook
- Tableau Data Files
24) Tableau Public supports all browsers without plug-ins– it’s pure AJAX right in the browser
- FALSE
- TRUE
25) Map Options in Tableau 8 are shown in
- Menu bar
- Sub Menu Bar
- Side Pane
- Top Pane
26) What does .twbx file extension mean?
- Tableau Packaged Workbook
- Tableau Workbook Extension
- Tableau Workbook With Extracts
- Tableau Zipped Workbook
27) What is the primary advantage of working with .twbx files?
- Analysis can be performed without network/internet connections because data is already loaded on your computer embedded in the packaged file.
- Security restrictions are always maintained even in offline mode. Users are always prompted for credentials before access to data source is granted.
- It contains Tableau’s instructions for interacting with a data source.
- It supports better interactive visualizations and data accuracy.
28) What is tableau tool tip and what purpose does it serve?
- These are the available tools in the menu bar that can be customized for specific user needs.
- A feature in Tableau that provides the ability to quickly view the underlying data of a mark
- A Tableau feature that provides a pop up when a mouse hovers over on any part of your workbook.
- Lets you define rich html tool tips that are embedded directly inside your web page and that appears when the mouse rolls over.
29) Choose the answer that best describes a Tableau data source
- A live connection to a database
- A Tableau data extract
- Records from which data are obtained
- A reusable connection to data
30) Which type of filter is applied to the data source first and then the other filters are applied only to the resulting records.
- Global Filter
- Local Filter
- Context Filter
- Quick Filters
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
- Groups
- Bins
- Hierarchy
- Summary
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
- Sets
- Groups
- binning measures
- Hierarchy
33) This method helps you group dimensions into similar categories. One way to do this is to drag a dimension on top of another.
- Sets
- Groups
- binning measures
- Hierarchy
34) Which table calculation type shows the rate of change
- Percent difference from
- difference from
- Percent from
- Percent of total
35) Which table calculation type shows a cumulative total
- Moving calculation
- Running total
- Percent of total
- Difference from
36) What is an invisible filter?
- a filter that can be applied to a view that is not exposed to your user
- Is a type of Tableau filter that can be used during dashboard design
- a filter that is only displayed with the correct data blending
- a filter that works in tandem with context filter
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.
- Calculated fields
- Captions
- Parameters
- Tooltips
38) Hold one or more worksheets and dashboards
- Workbooks
- Bookmarks
- Packaged Workbooks
- Data Extract Files
39) Contain a single worksheet and are an easy way to quickly share your work
- Workbooks
- Bookmarks
- Packaged Workbooks
- Data Extract Files
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
- Workbooks
- Bookmarks
- Packaged Workbooks
- Data Extract Files
41) Are local copies of a subset or entire data source that you can use to share data, work offline, and improve database performance
- Workbooks
- Bookmarks
- Packaged Workbooks
- Data Extract Files
42) If I am to add a company logo to my dashboard, which dashboard object will I use?
- Horizontal
- Vertical
- Text
- Image
43) Dashboard layout containers allow you to __________.
- create an area in the dashboard where objects automatically adjust their size and position based on the other objects in the container
- create an area in the dashboard where objects maintain its predetermined size and position.
- add sheets and other objects in the dashboard without affecting any formatting
- add a dashboard within a dashboard
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
- Any sheets that are not selected are hidden on the server when users view the dashboard.
- The views on the server is overwritten
- All workbook views are displayed on a row of tabs in each individual view
- Any selections you’ve made in the workbook will be published to the server
45) Describe what happens if the ‘show selections’ option is selected before a dashboard is published to the Tableau server
- 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.
- 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.
- Selections you’ve made on the dashboard will not be retained.
- When this option is selected, any selections you’ve made in the workbook will be published to the server as default.
46) Which of the following describes the various options in saving your visualizations.
- You can save your work as a workbook, packaged workbook, bookmark only.
- You can save your work as workbook and packaged workbook
- You can save your work as workbook only
- You can save your work as workbook, packaged workbooks and dashboard
47) Which of these methods in saving your work saves the current worksheet only
- Save as workbook
- Save as packaged workbook
- Save as bookmark
- Save as worksheet
48) Which of these methods saves all worksheets in your visualization
- Worksheets
- Workbooks
- Bookmarks
- Dashboards
49) Which formula in Tableau best calculates the overall gross margin for every product in the data source
- sum([Profit]/[Sales])
- sum ([Profit])/[Sales]
- sum ([Profit])/sum([Sales])
- [Profit]/[Sales]
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.
- Automatic
- Show on hover
- Hide
- Prompt
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.
- Use a parameter in a filter
- Use a parameter in binned measures
- Use a parameter in reference line
- Pages
52) A __________ field on a shelf indicates a discrete field
- blue
- green
- bold
- italic
53) A __________ field on a shelf indicates a continuous field
- blue
- green
- bold
- italic
54) A __________ name indicates a sorted field.
- blue
- green
- bold
- italic
55) Identify the false statement about a data source
- Is a fast way to quickly connect to data and start authoring
- Contains a layer of workbook customizations such as calculations
- Database drivers are stored within the data source
- You can alter customized fields that come with the data source and create additional ones.
56) This dashboard object allows you to add a ___________ that describes the dashboard. Default value is the dashboard name.
- Text
- Legend
- Title
- View
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.
- Show Caption
- Show Summary
- Describe Sheet
- Show Cards
58) These are containers for shelves, legends, and other controls in Tableau desktop
- Cards
- Shelves
- Marks
- Page
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.
- Color shelf
- Size shelf
- Filters shelf
- Page shelf
60) Which shelf allows you to encode data by assigning different shapes to the marks in a data view
- Icon shelf
- Shape shelf
- Label shelf
- Page shelf
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?
- Point
- Area
- Mark
- Page
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
- Data Window
- Dashboard
- Data Source
- Bookmarks
63) Another name for text table. It provides an easy way to display the numbers associated with dimension members.
- Cross-tab
- caption
- Axis
- Cell
64) Is a representation of your data in a Tableau worksheet or dashboard.
- Dimensions
- Data Window
- Data view or view
- Data source
65) What is presentation mode?
- 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.
- Removes legends, quick filters, parameter controls to allows easy integration with Power Point
- Read only version of your view
- Hides the data window, toolbards, workspace controls, and view cards.
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?
- x
- x
- x
- x
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?
- Connecting live to data source
- Import all data
- Export Packaged workbook
- Save as Tableau workbook
68) What is a secondary Table calculations
- Calculations performed from the results of the previous calculations
- Calculations that applies to all of the data in the table
- Another name for calculated field
- Calculations performed at the data source level
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.
- Synchronize Axis
- Dual Axis
- Format reference lines
- Edit Axis
70) There are benefits to adding comments to your field properties. Identify one that is not.
- Displays more information about the field in the tooltip
- A good way to give more context to the data in your data source
- Useful when you are building a workbook for others to use
- updates source data with new comments
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.
- Show Me
- Drag and Drop
- Tableau Wizard
- none of the above
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.
- Publish dashboard to mobile app server
- No need to do anything special
- Design dashboard using the mobile authoring app
- Limit the number of views to fit dashboard in a mobile device