Tableau Intermediate Quiz

 



1) In which case is in-memory connection not suitable?

1. When your database is too slow for interactive analysis
2. when you need to take off a transactional database
3. when you require real time analysis of data
4. when you need to be offline

Show Answer

 
 
2) Which one of the following doesn’t fall under Tableau’s server security?

1. Trusted Authentication
2. Active Directory Integration
3. Multi Tenancy Implementation
4. Section Access

Show Answer

 
 
3) Which one is not possible on Tableau map functionality?

1. wrapped map
2. combined mark types using map
3. ESRI map integration
4. filled map

Show Answer

 
 
4) Which data source is not supported by Tableau

1. SAP BW
2. Hadoop
3. Oracle Essbase
4. SAP R3

Show Answer

 
 
5) Which one of these is not a product of Tableau

1. Tableau Server
2. Tableau Digital
3. Tableau Management Console
4. Tableau Reader

Show Answer

 
 
6) Next Generation Dashboards  provides

1. rich visualization
2. predictive modeling
3. data from multiple data source
4. Only A & C

Show Answer

 
 
7) Personalized views of Next Generation dashboards allow users to view data based on

1. Security & Access
2. Technology
3. Time
4. Database Type

Show Answer

 
 
8) which is true in case of Next Generation Dashboards ?

1. combines summary and detail data analysis
2. Parameterization enables a single dynamic dashboard to replace hundreds of static designs
3. requires no prior BI literacy
4. All of the above

Show Answer

 
 
9) How do you connect to Spluk with Tableau?

1. via ODBC driver
2. via SQL Connector
3. via MDX Connector
4. via Odata Connector

Show Answer

 
 
10) In Which layer of tableau server ‘table calculation’ happens?

1. Data Model Layer
2. Application Server
3. VizQL Server
4. Repository

Show Answer

 
11) Tableau Reader can read if the tableau application is saved in

1. .twb format
2. .tde format
3. .twbx format
4. none of the above

Show Answer

 
 
12) MDX connector in tableau server is meant for connecting with

1. bigdata
2. OLAP cubes
3. no SQL database
4. none of the above

Show Answer

 
 
13) In Tableau ‘table joins’ happen in

1. Application server
2. Data Engine
3. VizQL Model
4. Semantic Layer

Show Answer

 
 
14) Which One is not there in Tableau 7

1. Heat Map
2. Show Me
3. Area Chart
4. Colored Tab

Show Answer

 
 
15) Tableau 8 has a direct connector to Google Analytics

1. TRUE
2. FALSE

Show Answer

 
 
16) You can define data source filters in Tableau 8

1. FALSE
2. TRUE

Show Answer

 
 
17) According to Tableau, visual analytics is not just dashboards and charts. Name three very important key differentiators in visual analytics

1. exploration, analysis, collaboration
2. presentation, analysis, collaboration
3. data analysis, data discovery, dashboard performance
4. Real-time data, user interaction, what-if analysis

Show Answer

 
 
18) What happens to my original data (source data) when I change an alias in Tableau view?

1. Tableau creates the change and makes corresponding change to the original data
2. Tableau creates the change internally and remembers your changes without affecting original data
3. Changes are maintained as long as the session is active.
4. Tableau makes temporary change to your original data, but will revert to previous state once the view is refreshed.

Show Answer

 
 
19) What is a URL action?

1. is a specific character string that constitutes a reference to a resource. In most web browsers, the URL of a web page is displayed in the address bar.
2. It is the URL address of your dashboard where parameters can be passed
3. It is a hyperlink that points to a web page, file or other web-based resource outside of Tableau. It be used to link your dashboards to other dashboards or use it to look up facts about your data.
4. It is another way to open up your dashboard in another browser window. If you do not want it to open another browser window, put web objects in your dashboard

Show Answer

 
 
20) When in the workbook, which filter has the highest precedence of all Tableau filters

1. Context Filter
2. Local Filter
3. Global Filter
4. Data Source Filter

Show Answer

 
21) What is the maximum number of rows of data per workbook can you publish to Tableau Public

1. 65000
2. 100000
3. 120000
4. 130000

Show Answer

 
 
22) Allows a user or group to view the workbook on the server, edit workbook views, apply filters, view underlying data, export images, and export data.

1. Viewer
2. Interactor
3. Data Source Connector
4. Publisher

Show Answer

 
 
23) A workbook permission that allows a user to see all raw data behind each row in the data source, as restricted by any marks the user has selected, and allows data download as text file

1. View Underlying Data
2. View Summary Data
3. View row data
4. Filter raw data view

Show Answer

 
 
24) Name three types of reference lines and bands.

1. Entire table, per pane, per cell
2. Maximum, Median, Minimum
3. Average, constant, sum
4. Line, Band, Distribution

Show Answer

 
 
25) In the add reference line dialog box, under scope window, three different options may be selected to represent how reference line should be presented.

1. Entire table, per pane, per cell
2. Maximum, Median, Minimum
3. Average, constant, sum
4. Line, Band, Distribution

Show Answer

 
 
26) Sometimes you want to pull in data from an outside source for quick analysis. Rather than create a whole new data source and then connect in Tableau, you can copy and paste the data directly into Tableau desktop.  Name this type of data source.

1. Clipboard Data Source
2. Temporary Data Source
3. Copied Data Source
4. Static Data Source

Show Answer

 
 
27) Whenever you place a field on a shelf, Tableau generates the view by querying the data source and depending on the size of the data source, this process can be time consuming. Which tool in Tableau allows you to turn this feature on and off.

1. Hold (F6)
2. Run Update (F9)
3. Refresh (F5)
4. Automatic updates (F10)

Show Answer

 
 
28) In Tableau desktop, you want to cancel a query that is taking a long time to complete due to the size of the data source. When a query takes a long time to complete, a progress dialog box opens. What happens to the view after you cancel this query?

1. Tableau desktop will crash
2. The query will continue to run until the view is fully rendered
3. The view becomes invalid because it is in an in-between state
4. The view returns to its previous state

Show Answer

 
 
29) Precision warning icon pops up when a field  value contains more precision (decimal places) than Tableau can model. Please indicate in your answer Tableau’s precision limit.

1. 20
2. 10
3. 15
4. 5

Show Answer

 
 
30) What is the main differentiating factor between relational and multidimensional data in Tableau?

1. There is no major difference between relational and multidimensional data source
2. By default, multidimensional data source contains pre-configured filters for dimensions
3. By default, multidimensional data source contains hierarchies for dimensions
4. Allows creation of sets and hierarchies

Show Answer

 
31) What do you call this indicator that shows up if your data contains null values, unknown geographic locations, or negative or zero values on a logarithmic axis.

1. Cancel Query Indicator
2. Precision Warning
3. Special Values Indicator
4. Status Bar

Show Answer

 
 
32) If you want to display a summary and details at the same time in your view, which option will work best

1. Data blending
2. Joining tables
3. Connect live to data source
4. Create data extract

Show Answer

 
 
33) Occasionally, it is useful to organize the values of a measure into bins. There are certain limitations in using bin. You can bin data only for ___________ data sources and this feature is not supported for _______________ data sources.

1. relational, multidimensional
2. multidimensional, relational
3. .twb, .twbx
4. .twbx, .twb

Show Answer

 
 
34) When saving your work as a bookmark, which file extension will this represent

1. .twb
2. .twbx
3. .tbm
4. .tdb

Show Answer

 
 
35) How do you unpackage a packaged workbook file (.twbx)

1. Right-click the packaged workbook file (.twbx) in windows explorer and select unzip
2. You cannot unpack a packaged workbook
3. Right-click the packaged workbook file in windows explorer and select unpackage
4. Open the packaged workbook in Tableau desktop and save the workbook file and data sources separately.

Show Answer

 
 
36) When working with dates or numberic bins. For example, you have data for January through May and September through December. There was no data recorded for June, July and August. If you create a line chart, the missing months will not be shown.  Which opt

1. Show Empty Rows
2. Show Empty Columns
3. Show Missing Values
4. Show underlying values

Show Answer

 
 
37) In which condition creates a new workbook and uses a temporary data source name that is prefixed with a word ‘clipboard’ followed by a series of numbers and text that are internally generated by Tableau.

1. When copying data from anywhere (web sites, pdfs, MSWord, MSExcel, etc.) to Tableau is unsuccessful.
2. when copying data from anywhere (web sites, pdfs, MSWord, MSExcel, etc.) and pasting it in tableau using Data>Paste Data.
3. When using ODBC to open a data source
4. When a data source becomes unavailable

Show Answer

 
 
38) Name  three tabs available in the Tableau desktop format menu (used for font, alignment, shading)

1. Field Labels, Rows, Columns
2. Sheet, Rows, Columns
3. Title, body, details
4. Color, Size, Label

Show Answer

 
 
39) In Tableau desktop, you can duplicate any view as a crosstab. Name one condition where this option does not work.

1. When in a map view
2. When in a crosstab
3. When view is disaggregated
4. When in a bar chart

Show Answer

 
 
40) When you drag a dimension to the color shelf. What type of color scheme is generated?

1. Multicolor
2. Categorical
3. Quantitative
4. Spectrum

Show Answer

 
41) When you drag a measure to the color shelf. What type of color scheme is generated?

1. Multicolor scheme
2. Categorical
3. Quantitative color
4. Color spectrum

Show Answer

 
 
42) Overlapping text in a crosstab occurs when multiple data source values contribute to a single text table cell. Please select the correct statement about overlapping text.

1. If you disaggregate a measure placed on the text shelf, overlapping text occurs if multiple data source rows contribute to a text table cell.
2. If you place a dimension on the level of details overlapping text occurs if you also use page shelf.
3. Overlapping text occurs if you place multiple data source dimension on the filter shelf.
4. Over lapping text occurs if you use groups and bins together.

Show Answer

 
 
43) Tableau does not use chart types (like excel) to build data views. Instead, data are displayed with marks. Every mark corresponds to a ________________ in your data source.

1. a number of overlapping text
2. columns
3. row or group of rows
4. joins

Show Answer

 
 
44) Dimensions can be converted to measures by aggregating them as a _________.

1. summary
2. new field
3. count
4. measure

Show Answer

 
 
45) You may have data in two separate data sources that you want to analyze together on a single worksheet.  Identify from the list which one does not constitute or help identify the primary & secondary data source.

1. The connection that you first use in the view becomes the primary data source.
2. After you drag fields to the view, the primary connection is marked with a blue check mark.
3. When you switch to the secondary data source, the data window is marked with an orange color.
4. Data extract option becomes unavailable (right click on the secondary data source and select data extract)

Show Answer

 
 
46) From the extract dialog window, one of the ways to reduce the data extract size is to filer your data extract. Choose from the list another method that can help reduce the size of your extract file

1. Show hidden fields
2. Refresh extract
3. Hide all unused fields
4. Hide captions

Show Answer