Tableau L2 Question Answers


Hello Friends if you are looking for Tableau L2 Question With Answers | Tableau L2 Wipro MySkillz TrendNXT Questions with Answers | Tableau L2 Wipro Objective Type Questions| Tableau L2 Multiple Choice Questions with Answers

In which case is in-memory connection not suitable?

A) When your database is too slow for interactive analysis

B)when you need to take off a transactional database

C)when you require real time analysis of data

D)when you need to be offline

Ans: C

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

A)Trusted Authentication

B)Active Directory Integration

C)Multi Tenancy Implementation

D)Section Access

Ans: D

Which one is not possible on Tableau map functionality?

A)wrapped map

B)combined mark types using map

C)ESRI map integration

D)filled map

Ans: C

Which data source is not supported by Tableau

A)SAP BW

B)Hadoop

C)Oracle Essbase

D)SAP R3

Ans: D

Which one of these is not a product of Tableau

A)Tableau Server

B)Tableau Digital

C)Tableau Management Console

D)Tableau Reader

Ans: C

Next Generation Dashboards  provides

A)rich visualization

B)predictive modeling

C)data from multiple data source

D)Only A & C

Ans: D

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

A)Security & Access

B)Technology

C)Time 

D)Database Type

Ans: A

which is true in case of Next Generation Dashboards ?

A)combines summary and detail data analysis

B)Parameterization enables a single dynamic dashboard to replace hundreds of static designs 

C)requires no prior BI literacy

D)All of the above

Ans: D

How do you connect to Spluk with Tableau?

A)via ODBC driver

B)via SQL Connector

C)via MDX Connector D)via Odata Connector

Ans: D

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

A)Data Model Layer

B)Application Server

C)VizQL Server

D)Repository

Ans: C

Tableau Reader can read if the tableau application is saved in

A).twb format

B).tde format

C).twbx format

D)none of the above

Ans: C

MDX connector in tableau server is meant for connecting with

A)bigdata

B)OLAP cubes

C)no SQL database

D)none of the above

Ans: B

In Tableau ‘table joins’ happen in

A)Application server

B)Data Engine

C)VizQL Model

D)Semantic Layer

Ans: A

Which One is not there in Tableau 7

A)Heat Map

B)Show Me

C)Area Chart

D)Colored Tab

Ans: D

Tableau 8 has a direct connector to Google Analytics

A)TRUE

B)FALSE

Ans: A

You can define data source filters in Tableau 8

A)FALSE

B)TRUE

Ans: B

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

A)exploration, analysis, collaboration B)presentation, analysis, collaboration C)data analysis, data discovery, dashboard performance

D)Real-time data, user interaction, what-if analysis

Ans: A

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

A)Tableau creates the change and makes corresponding change to the original data B)Tableau creates the change internally and remembers your changes without affecting original data

C)Changes are maintained as long as the session is active.

D)Tableau makes temporary change to your original data, but will revert to previous state once the view is refreshed.

Ans: b

What is a URL action?

A)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.

B)It is the URL address of your dashboard where parameters can be passed 

C)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. 

D)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

Ans: C

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

A)Context Filter

B)Local Filter

C)Global Filter

D)Data Source Filter

Ans: D

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

A)65000

B)100000

C)120000

D)130000

Ans: B

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. 

A)Viewer

B)Interactor

C)Data Source Connector

D)Publisher

Ans: B

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

A)View Underlying Data

B)View Summary Data

C)View row data

D)Filter raw data view

Ans: A

Name three types of reference lines and bands.

A)Entire table, per pane, per cell B)Maximum, Median, Minimum


C)Average, constant, sum

D)Line, Band, Distribution

Ans: D

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

A)Entire table, per pane, per cell B)Maximum, Median, Minimum

C)Average, constant, sum

D)Line, Band, Distribution

Ans: A

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.

A)Clipboard Data Source

B)Temporary Data Source

C)Copied Data Source

D)Static Data Source

Ans: A

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.

A)Hold (F6)

B)Run Update (F9)

C)Refresh (F5)

D)Automatic updates (F10)

Ans: D

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?

A)Tableau desktop will crash

B)The query will continue to run until the view is fully rendered

C)The view becomes invalid because it is in an in-between state

D)The view returns to its previous state

Ans: C

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.

A)20

B)10

C)15

D)5

Ans: C

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

A)There is no major difference between relational and multidimensional data source

B)By default, multidimensional data source contains pre-configured filters for dimensions

C)By default, multidimensional data source contains hierarchies for dimensions

D)Allows creation of sets and hierarchies

Ans: C

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.

A)Cancel Query Indicator

B)Precision Warning

C)Special Values Indicator

D)Status Bar

Ans: C

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

A)Data blending  

B)Joining tables

C)Connect live to data source

D)Create data extract

Ans: A

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.

A)relational, multidimensional B)multidimensional, relational

C).twb, .twbx

D).twbx, .twb

Ans: A

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

A).twb

B).twbx

C).tbm

D).tdb

Ans: c

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

A)Right-click the packaged workbook file (.twbx) in windows explorer and select unzip

B)You cannot unpack a packaged workbook C)Right-click the packaged workbook file in windows explorer and select unpackage D)Open the packaged workbook in Tableau desktop and save the workbook file and data sources separately.

Ans: C

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 option allows you to display the months with missing data?

A)Show Empty Rows

B)Show Empty Columns

C)Show Missing Values

D)Show underlying values

Ans: C

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.

A)When copying data from anywhere (web sites, pdfs, MSWord, MSExcel, etc.) to Tableau is unsuccessful.

B)when copying data from anywhere (web sites, pdfs, MSWord, MSExcel, etc.) and pasting it in tableau using Data>Paste Data.

C)When using ODBC to open a data source D)When a data source becomes unavailable

Ans: B

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

A)Field Labels, Rows, Columns

B)Sheet, Rows, Columns

C)Title, body, details

D)Color, Size, Label

Ans: B

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

A)When in a map view

B)When in a crosstab

C)When view is disaggregated

D)When in a bar chart

Ans: C

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

A)Multicolor

B)Categorical

C)Quantitative 

D)Spectrum

Ans: B

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

A)Multicolor scheme

B)Categorical

C)Quantitative color

D)Color spectrum

Ans: C

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.

A)If you disaggregate a measure placed on the text shelf, overlapping text occurs if multiple data source rows contribute to a text table cell.

B)If you place a dimension on the level of details overlapping text occurs if you also use page shelf.

C)Overlapping text occurs if you place multiple data source dimension on the filter shelf.

D)Over lapping text occurs if you use groups and bins together.

Ans: A

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.

A)a number of overlapping text

B)columns

C)row or group of rows

D)joins

Ans: C

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

A)summary

B)new field

C)count

D)measure

Ans: C

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.

A)The connection that you first use in the view becomes the primary data source. B)After you drag fields to the view, the primary connection is marked with a blue check mark.

C)When you switch to the secondary data source, the data window is marked with an orange color.

D)Data extract option becomes unavailable (right click on the secondary data source and select data extract)

Ans: D

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

A)Show hidden fields

B)Refresh extract

C)Hide all unused fields

D)Hide captions

Ans: C


Leave a Reply

Your email address will not be published. Required fields are marked *