14 Sep 100 Tableau MCQ (Multiple Choice Questions) with Answers

Posted at 14:46h in mcq by

 

1) What type of software is Tableau primarily classified as?
  1. Database Management System
  2. Business Intelligence and Data Visualization Tool
  3. Programming Language
  4. Operating System
Show Answer
Answer: b
Explanation
Tableau is a Business Intelligence (BI) and data visualization platform used to connect to data, build interactive views and share dashboards. It is not a DBMS, a programming language or an operating system.

2) Which file extension is used for a Tableau Packaged Workbook?

  1. .twb
  2. .twbx
  3. .tde
  4. .tdsx
Show Answer
Answer: b
Explanation
A Packaged Workbook uses the .twbx extension. It bundles the workbook together with its local data sources and extracts into a single zip-like file.

3) What is the main difference between a .twb and a .twbx file?

  1. .twb contains the external data sources; .twbx does not.
  2. .twbx contains both the workbook definitions and the local data sources.
  3. .twb is for Tableau Server only.
  4. .twbx can only be opened in Tableau Prep.
Show Answer
Answer: b
Explanation
A .twb is just the workbook XML (it references data sources stored elsewhere). A .twbx packages the workbook definition plus the local data sources/extracts, so it can be shared and opened without the original data files.

4) Blue fields in Tableau represent which of the following?

  1. Measures
  2. Discrete fields
  3. Continuous fields
  4. Dimensions only
Show Answer
Answer: b
Explanation
Blue indicates a discrete field — values are treated as separate, distinct categories (usually shown as headers). Green indicates a continuous field.

5) Green fields in Tableau represent which of the following?

  1. Dimensions
  2. Discrete fields
  3. Continuous fields
  4. String values
Show Answer
Answer: c
Explanation
Green indicates a continuous field — values form an unbroken range and produce an axis rather than headers.

6) What does a “Dimension” typically represent in Tableau?

  1. Quantitative numerical data that can be aggregated
  2. Qualitative or categorical data used to slice and dice data
  3. Only Date fields
  4. Geographic coordinates only
Show Answer
Answer: b
Explanation
Dimensions hold qualitative/categorical information (names, categories, dates, locations) and are used to slice and group the data in a view.

7) What does a “Measure” typically represent in Tableau?

  1. Categorical descriptions
  2. Quantitative numeric values that can be aggregated (SUM, AVG, etc.)
  3. Discrete text labels
  4. Data source connection parameters
Show Answer
Answer: b
Explanation
Measures are quantitative numeric fields that can be aggregated with functions such as SUM, AVG, MIN and MAX.

8) Which shelf in Tableau controls visual properties like color, size, shape, and detail?

  1. Pages Shelf
  2. Filters Shelf
  3. Marks Card
  4. Columns Shelf
Show Answer
Answer: c
Explanation
The Marks Card controls how marks are rendered — Color, Size, Shape, Detail, Text, Tooltip and the mark type itself.

9) Which visual view displays automatically suggested chart types based on selected dimensions and measures?

  1. Data Source tab
  2. Show Me panel
  3. Analytics pane
  4. Format menu
Show Answer
Answer: b
Explanation
The Show Me panel suggests appropriate chart types based on the fields currently selected in the view.

10) What file format is used for a Tableau Data Extract (newer engine)?

  1. .tde
  2. .hyper
  3. .csv
  4. .xml
Show Answer
Answer: b
Explanation
The newer extract engine uses the .hyper format. The older .tde format was replaced by Hyper in Tableau 10.5.

11) In Tableau 2020.2 and later, what is the default logical layer connection model called?

  1. Joins
  2. Relationships (Noodle)
  3. Blending
  4. Unions
Show Answer
Answer: b
Explanation
From version 2020.2, the default logical-layer model is Relationships, informally called the “noodle” because of the connecting line drawn between tables.

12) How do Relationships differ from physical Joins in Tableau?

  1. Relationships combine tables into a single flat table before query time.
  2. Relationships query tables independently at their native level of detail based on the fields in the view.
  3. Relationships can only be established using SQL code.
  4. Joins do not support inner or outer join types.
Show Answer
Answer: b
Explanation
Relationships do not merge tables into one flat table. Each table keeps its own level of detail, and Tableau generates the appropriate join at query time based on the fields used in the view.

13) Which connection type fetches data live from the underlying database in real time?

  1. Extract Connection
  2. Live Connection
  3. Hyper Connection
  4. Offline Connection
Show Answer
Answer: b
Explanation
A Live Connection queries the source database in real time, so the view always reflects the current data (subject to the database’s performance).

14) What is a key advantage of using a Tableau Data Extract (.hyper) over a Live Connection?

  1. Automatically updates underlying database tables
  2. Improves query performance and reduces load on production databases
  3. Allows editing raw SQL code in the source database
  4. Disables all aggregation functions
Show Answer
Answer: b
Explanation
Extracts are stored locally in the fast Hyper engine, so queries run faster and the production database is not hit repeatedly.

15) Combining data by appending rows from tables with identical structures is known as what?

  1. Joining
  2. Blending
  3. Unioning
  4. Pivoting
Show Answer
Answer: c
Explanation
A Union stacks rows from tables that have the same structure. Joins add columns instead, and blends combine separate data sources on a linking field.

16) Data Blending in Tableau performs what type of logical join across different data sources?

  1. Inner Join
  2. Left Outer Join
  3. Full Outer Join
  4. Right Outer Join
Show Answer
Answer: b
Explanation
Data blending behaves like a Left Outer Join: all rows from the primary source are retained, and matching values from the secondary source are brought in where available.

17) In Data Blending, what links the primary and secondary data sources?

  1. Foreign key constraint
  2. Common field (Linking Field) indicated by a chain icon
  3. Custom SQL script
  4. Primary Key index
Show Answer
Answer: b
Explanation
Blending uses a common linking field, shown with a chain-link icon in the Data pane. It is usually a dimension present in both sources.

18) What color icon identifies the Primary Data Source in a Data Blending view?

  1. Orange
  2. Blue
  3. Green
  4. Red
Show Answer
Answer: b
Explanation
The primary data source is marked with a blue icon in the Data pane; the secondary source is marked with an orange icon.

19) What color icon identifies the Secondary Data Source in a Data Blending view?

  1. Orange
  2. Blue
  3. Green
  4. Purple
Show Answer
Answer: a
Explanation
The secondary data source is identified by an orange icon in the Data pane.

20) Which feature allows you to reshape data by converting columns into rows?

  1. Split
  2. Pivot
  3. Transpose
  4. Group
Show Answer
Answer: b
Explanation
Pivot converts columns into rows (wide to tall), turning a crosstab-style layout into a normalized field/value structure. Split separates one column into several.

21) Which chart type in Tableau displays parts of a whole as nested rectangles?

  1. Heat Map
  2. Treemap
  3. Box Plot
  4. Bullet Graph
Show Answer
Answer: b
Explanation
A Treemap uses nested rectangles whose size (and often colour) represents the value of a measure within a hierarchy.

22) Which chart type is best suited for showing changes over continuous time?

  1. Pie Chart
  2. Line Chart
  3. Packed Bubble Chart
  4. Treemap
Show Answer
Answer: b
Explanation
A Line Chart plots a continuous measure against a continuous date axis, making trends and changes over time easy to read.

23) What chart type uses marks (dots) on a Cartesian coordinate plane to show the relationship between two continuous measures?

  1. Bar Chart
  2. Histogram
  3. Scatter Plot
  4. Gantt Chart
Show Answer
Answer: c
Explanation
A Scatter Plot places a mark at the intersection of two measures (X and Y), revealing correlation, clusters and outliers.

24) A Histogram requires which feature to be created first in Tableau?

  1. Group
  2. Bin
  3. Set
  4. Parameter
Show Answer
Answer: b
Explanation
A histogram needs a Bin (created from a measure) to divide the continuous values into equal-size intervals.

25) Histograms show the frequency distribution of what kind of data?

  1. Categorical dimensions
  2. Continuous measures partitioned into equal intervals (bins)
  3. Geographic points
  4. Date hierarchies
Show Answer
Answer: b
Explanation
A histogram counts how many records fall into each bin, showing the frequency distribution of a continuous measure.

26) Which chart type is specifically designed to compare a primary measure against a target/goal measure?

  1. Box Plot
  2. Bullet Graph
  3. Gantt Chart
  4. Waterfall Chart
Show Answer
Answer: b
Explanation
A Bullet Graph shows a primary measure as a bar, with a reference line or marker for the target/goal and shaded bands for qualitative ranges.

27) Which chart type displays progress or duration across time using horizontal bars (common in project management)?

  1. Gantt Chart
  2. Line Chart
  3. Pareto Chart
  4. Highlight Table
Show Answer
Answer: a
Explanation
A Gantt Chart uses horizontal bars whose length represents the duration of a task or activity along a time axis.

28) A Heat Map uses which two Visual Marks to encode data values?

  1. Shape and Angle
  2. Size and Color
  3. Length and Height
  4. Position and Line Thickness
Show Answer
Answer: b
Explanation
Heat maps encode values using Size and Color (usually colour intensity on the Marks card).

29) What is a Highlight Table in Tableau?

  1. A Crosstab (text table) with cell background colors based on a continuous measure
  2. A scatter plot with text labels
  3. A treemap showing hierarchy
  4. A line chart with highlighted data points
Show Answer
Answer: a
Explanation
A Highlight Table is essentially a text table (crosstab) where each cell is coloured by a continuous measure, making highs and lows stand out.

30) What rule does a Pareto Chart combine to demonstrate cumulative impact (e.g., 80/20 rule)?

  1. Stacked Bar Chart and Pie Chart
  2. Bar Chart (sorted descending) and a Cumulative Dual-Axis Line Chart
  3. Scatter Plot and Trend Line
  4. Gantt Chart and Box Plot
Show Answer
Answer: b
Explanation
A Pareto chart pairs a descending bar chart with a cumulative percentage line on a dual axis, illustrating the 80/20 principle.

31) Which of the following is a basic Row-Level Calculation syntax in Tableau?

  1. [Sales] / [Profit]
  2. SUM([Sales]) / SUM([Profit])
  3. { FIXED : SUM([Sales]) }
  4. TOTAL(SUM([Sales]))
Show Answer
Answer: a
Explanation
[Sales] / [Profit] operates on each row of data before any aggregation, so it is a row-level calculation. The others are aggregate, LOD or table calculations.

32) What is the difference between [Profit] / [Sales] and SUM([Profit]) / SUM([Sales])?

  1. They return identical results in all views.
  2. [Profit] / [Sales] calculates at row level before aggregating; SUM([Profit]) / SUM([Sales]) aggregates first then divides.
  3. SUM([Profit]) / SUM([Sales]) is a Table Calculation.
  4. [Profit] / [Sales] cannot be formatted as a percentage.
Show Answer
Answer: b
Explanation
Row-level division computes a ratio per row (then aggregates the ratios), whereas the aggregate version sums each measure first and then divides — giving the true overall ratio.

33) What does LOD stand for in Tableau calculations?

  1. Level of Detail
  2. List of Dimensions
  3. Layer of Data
  4. Level of Data
Show Answer
Answer: a
Explanation
LOD stands for Level of Detail. LOD expressions let you compute aggregations at a granularity independent of the dimensions in the view.

34) Which keyword is NOT a valid Level of Detail (LOD) expression type in Tableau?

  1. FIXED
  2. INCLUDE
  3. EXCLUDE
  4. MERGE
Show Answer
Answer: d
Explanation
The three valid LOD keywords are FIXED, INCLUDE and EXCLUDE. MERGE is not an LOD keyword.

35) What does a { FIXED [Region] : SUM([Sales]) } calculation do?

  1. Calculates total sales across the entire dataset regardless of dimension in view.
  2. Calculates total sales strictly at the Region level, ignoring higher or lower dimensions in the view.
  3. Includes Region only if it is explicitly present in the visualization view.
  4. Excludes Region from the total sales calculation.
Show Answer
Answer: b
Explanation
FIXED computes the aggregation at exactly the dimensions listed — here, Region — regardless of what other dimensions are in the view.

36) Which calculation type computes values based on the rendered marks in the visualization view?

  1. Row-level calculation
  2. Aggregate calculation
  3. Table Calculation
  4. Data Source calculation
Show Answer
Answer: c
Explanation
A Table Calculation operates on the values already displayed in the view (the marks), so its result depends on the dimensions in the view and the compute-using settings.

37) Which function returns the running total of a measure across a partition?

  1. TOTAL()
  2. RUNNING_SUM()
  3. WINDOW_SUM()
  4. SUM()
Show Answer
Answer: b
Explanation
RUNNING_SUM() is a table-calculation function that returns the cumulative total of a measure as it moves along the partition.

38) What default direction does a Table Calculation evaluate if left unconfigured?

  1. Table (Down)
  2. Table (Across)
  3. Cell
  4. Pane (Across then Down)
Show Answer
Answer: b
Explanation
By default a table calculation computes Table (Across) — it moves left to right along each row of the table.

39) What function replaces NULL values with a specified default value (e.g., 0)?

  1. ISNULL()
  2. ZN()
  3. IFNULL()
  4. Both b and c
Show Answer
Answer: d
Explanation
Both ZN() (replaces NULL with 0) and IFNULL() (replaces NULL with any specified value) handle nulls. ISNULL() only tests whether a value is null.

40) What does the function ZN([Sales]) return if [Sales] is NULL?

  1. NULL
  2. 0
  3. “Zero”
  4. An error
Show Answer
Answer: b
Explanation
ZN() stands for “zero if null” — it returns 0 when the argument is NULL, and the original value otherwise.

41) Which filter executes FIRST in Tableau’s Order of Operations?

  1. Dimension Filter
  2. Context Filter
  3. Extract Filter
  4. Measure Filter
Show Answer
Answer: c
Explanation
The Extract Filter runs first — it is applied when the extract is created or refreshed, before any other filter in the pipeline.

42) Put the following filters in the correct Order of Operations (from first to last):

  1. Measure Filter → Context Filter → Extract Filter → Dimension Filter
  2. Extract Filter → Data Source Filter → Context Filter → Dimension Filter
  3. Context Filter → Extract Filter → Measure Filter → Table Calc Filter
  4. Dimension Filter → Measure Filter → Context Filter → Data Source Filter
Show Answer
Answer: b
Explanation
The correct order is: Extract Filter → Data Source Filter → Context Filter → Dimension Filter → Measure Filter → Table Calculation Filter.

43) What color indicates that a filter has been set as a “Context Filter”?

  1. Blue
  2. Green
  3. Gray
  4. Yellow
Show Answer
Answer: c
Explanation
Filters added to context turn gray in the Filters shelf, indicating they are evaluated before other filters, LOD expressions and top-N filters.

44) Why would you add a Dimension Filter to Context?

  1. To make the filter run AFTER Level of Detail (FIXED) expressions.
  2. To force FIXED LOD expressions and top-N filters to evaluate AFTER the context filter is applied.
  3. To speed up performance on extracts only.
  4. To convert a discrete field into continuous.
Show Answer
Answer: b
Explanation
Explanation
Adding a filter to context makes it run before FIXED LOD calculations and top-N filters, so those computations are based only on the filtered (context) data.

45) Where in Tableau’s Order of Operations do FIXED LOD calculations evaluate?

  1. Before Context Filters
  2. Between Context Filters and Dimension Filters
  3. After Measure Filters
  4. After Table Calculation Filters
Show Answer
Answer: b
Explanation
FIXED LOD expressions evaluate right after context filters and before dimension filters, which is why context filters affect them.

46) Where do Table Calculation Filters execute in Tableau’s Order of Operations?

  1. First (Top of the pipeline)
  2. Right after Context Filters
  3. At the very end (after measures and table calculations are evaluated)
  4. Before Dimension Filters
Show Answer
Answer: c
Explanation
Table calculation filters run last — only after the measures and table calculations have been computed for the marks in the view.

47) Which filter allows limiting data based on quantitative ranges (e.g., SUM(Sales) > 10000)?

  1. Dimension Filter
  2. Measure Filter
  3. Data Source Filter
  4. User Filter
Show Answer
Answer: b
Explanation
A Measure Filter (aggregate filter) works on aggregated values such as SUM(Sales), AVG(Profit) or COUNTD(Orders).

48) Which option is used to restrict data visibility based on user login attributes on Tableau Server?

  1. Extract Filter
  2. Context Filter
  3. User Filter / Row-Level Security
  4. Measure Filter
Show Answer
Answer: c
Explanation
A User Filter (row-level security) uses functions such as USERNAME() or ISMEMBEROF() to show each logged-in user only the rows they are permitted to see.

49) Which of the following is TRUE about Top N filters in Tableau?

  1. They evaluate after Dimension Filters by default.
  2. They evaluate before Dimension Filters unless the Dimension Filter is added to Context.
  3. They require a table calculation to function.
  4. They only work with continuous date fields.
Show Answer
Answer: b
Explanation
A Top N filter is an aggregate (measure) filter, so it is evaluated before dimension filters by default. Adding the dimension filter to context reverses the order.

50) A wildcard filter applies to which data type?

  1. Measures only
  2. String Dimensions
  3. Date fields only
  4. Geographic continuous fields
Show Answer
Answer: b
Explanation
Wildcard filters (matching patterns with * and ?) apply to string dimensions such as Customer Name or Product.

51) What is a Parameter in Tableau?

  1. A fixed dimension in the dataset
  2. A dynamic input variable (value) that can replace constant values in calculations, filters, and reference lines
  3. A system table storing user metadata
  4. A static visual container in dashboards
Show Answer
Answer: b
Explanation
A parameter is a user-controlled input value that can be substituted into calculations, filters, reference lines and bin sizes.

52) Can a Parameter be used across multiple data sources in the same workbook?

  1. Yes, parameters are global workbook controls.
  2. No, parameters are tied to a single data source.
  3. Only if the data sources are joined using Custom SQL.
  4. Only in Tableau Online.
Show Answer
Answer: a
Explanation
Parameters are workbook-level objects, so the same parameter can be referenced by calculations in any data source within the workbook.

53) What is a “Set” in Tableau?

  1. A folder containing fields from a data source
  2. A custom field that defines a subset of data based on specific conditions (In/Out members)
  3. A dashboard layout template
  4. An aggregation type similar to SUM or AVG
Show Answer
Answer: b
Explanation
A set is a custom field that splits members of a dimension into two groups — IN and OUT — based on a condition, top-N ranking or manual selection.

54) What are the two states of members in a Set?

  1. True / False
  2. Active / Inactive
  3. IN / OUT
  4. Included / Omitted
Show Answer
Answer: c
Explanation
Every member of a set is either IN the set or OUT of it.

55) What type of Set updates dynamically based on underlying data changes?

  1. Fixed Set
  2. Dynamic Set
  3. Static Set
  4. Manual Group
Show Answer
Answer: b
Explanation
A Dynamic Set is defined by a rule (e.g. Top 10 by Sales), so its membership changes automatically as the underlying data changes.

56) How does a “Group” differ from a “Set”?

  1. Groups combine higher-level dimension categories into custom lower-level items; Sets create binary (IN/OUT) rules.
  2. Groups can evaluate across measures; Sets cannot.
  3. Groups require parameters; Sets do not.
  4. Groups are dynamic; Sets are always static.
Show Answer
Answer: a
Explanation
A group merges several dimension members into a single new member, whereas a set only classifies members as IN or OUT.

57) Which control element lets users interactively change the value of a parameter in a view or dashboard?

  1. Parameter Control
  2. Set Action
  3. Legend Filter
  4. Highlighting Rule
Show Answer
Answer: a
Explanation
The Parameter Control (right-click the parameter → Show Parameter Control) displays the parameter in the view so users can change its value.

58) What happens when you use a Set Action in a dashboard?

  1. It publishes the set to Tableau Server.
  2. Interacting with marks updates the members of a set dynamically.
  3. It deletes out-of-set records from the underlying extract.
  4. It creates a parameter automatically.
Show Answer
Answer: b
Explanation
A Set Action lets a user’s click or hover on marks change the IN/OUT membership of a set, which in turn drives related views.

59) Can Parameters be populated automatically from a field when the workbook opens?

  1. No, parameter lists are strictly static.
  2. Yes, by setting “Value when workbook opens” to pull from a field.
  3. Only using Python extensions.
  4. Only for Integer data types.
Show Answer
Answer: b
Explanation
The parameter’s “Value when workbook opens” setting can be pointed at a field, so the parameter is initialised from the current data each time the workbook opens.

60) What data types can a Parameter hold in Tableau?

  1. String, Integer, Float, Date, Date & Time, Boolean
  2. String and Integer only
  3. Spatial objects only
  4. Measures only
Show Answer
Answer: a
Explanation
A parameter can be one of six data types: String, Integer, Float, Date, Date & Time, or Boolean.

61) What geographic roles can Tableau automatically assign to fields?

  1. Country, State, City, Zip Code, Latitude/Longitude
  2. IP Address, URL, Email
  3. Age, Income, Gender
  4. File path, Table name
Show Answer
Answer: a
Explanation
Tableau recognises geographic roles such as Country, State/Province, City, Zip Code/Postcode, and Latitude/Longitude, then plots them on the map.

62) What field types are automatically generated when Tableau recognizes geographic data?

  1. Measure Names and Measure Values
  2. Latitude (generated) and Longitude (generated)
  3. Number of Records and Count
  4. Geometry (generated) and Shape (generated)
Show Answer
Answer: b
Explanation
Tableau creates Latitude (generated) and Longitude (generated) fields from a recognised geographic field and places them on the Rows and Columns shelves.

63) Which visual layer lets you overlay custom map data, points, or filled areas on top of each other in Tableau 2020.4+?

  1. Map Layers Marks Card
  2. Dual Axis only
  3. Show Me Map Tool
  4. Background Graphics Pane
Show Answer
Answer: a
Explanation
The Map Layers pane (Marks card) lets you add and reorder layers — points, lines, polygons, background map layers — on a single map.

64) How do you create a Dual-Axis Map in Tableau?

  1. Drag two measures to rows.
  2. Duplicate Latitude or Longitude on Columns/Rows shelf and select Dual Axis.
  3. Use the Analytics Pane to drop a map layer.
  4. Select Map from the Marks card dropdown menu twice.
Show Answer
Answer: b
Explanation
Duplicate Latitude (or Longitude) on the shelf, then right-click the second axis and choose Dual Axis to overlay two sets of map marks.

65) Which feature in the Analytics Pane adds statistical baseline references (e.g., Average, Constant, Band) to a chart?

  1. Reference Line
  2. Forecast
  3. Cluster
  4. Trend Line
Show Answer
Answer: a
Explanation
A Reference Line can be set to a constant, a computed statistic (average, median, max, min) or a band around a value.

66) What statistical technique does Tableau use by default for Forecasting?

  1. Linear Regression
  2. Exponential Smoothing
  3. Neural Networks
  4. K-Means Clustering
Show Answer
Answer: b
Explanation
Tableau’s forecast uses Exponential Smoothing by default, with optional settings for trend and seasonality.

67) Tableau uses which algorithm to compute statistical Clusters when using the Cluster analytics feature?

  1. Decision Trees
  2. K-Means Clustering
  3. Naive Bayes
  4. Logistic Regression
Show Answer
Answer: b
Explanation
The Cluster feature uses K-Means clustering, with a choice of variables and a specified number of clusters.

68) What requirement must be met to add a Trend Line to a view?

  1. The view must contain two continuous fields (or continuous date).
  2. The view must contain discrete dimensions only.
  3. Data blending must be active.
  4. A parameter must control the axis.
Show Answer
Answer: a
Explanation
A trend line needs at least one continuous measure (and typically a second continuous axis or continuous date) so a mathematical model can be fitted.

69) Which spatial function calculates the linear distance between two spatial points in Tableau?

  1. MAKEPOINT()
  2. MAKELINE()
  3. DISTANCE()
  4. BUFFER()
Show Answer
Answer: c
Explanation
DISTANCE() returns the linear distance between two spatial points, optionally in a specified unit such as ‘km’ or ‘mi’.

70) Which function creates a circular boundary around a spatial point at a specified distance?

  1. BUFFER()
  2. RADIUS()
  3. AREA()
  4. MAKEPOINT()
Show Answer
Answer: a
Explanation
BUFFER() creates a polygon (circle) of a given radius around a spatial point — useful for catchment or proximity analysis.

71) What is a Tableau Dashboard?

  1. A collection of several worksheets and visual components arranged in a single view
  2. A single worksheet exported as PDF
  3. A sequence of sheets displaying a linear narrative
  4. A data model diagram showing relationships
Show Answer
Answer: a
Explanation
A dashboard combines multiple worksheets, filters, legends and other objects on one canvas so users can monitor and interact with several views together.

72) What is a Tableau Story?

  1. A single interactive sheet
  2. A collection of sheets or dashboards arranged in sequential steps (story points) to convey a narrative
  3. A Python script embedded in Tableau
  4. An automated email report configuration
Show Answer
Answer: b
Explanation
A story strings together sheets, dashboards or captured snapshots as story points to walk an audience through a data narrative.

73) What is the main difference between Tiled and Floating objects on a dashboard layout?

  1. Tiled objects overlap; Floating objects snap into a rigid grid.
  2. Tiled objects snap into a single grid matrix without overlapping; Floating objects can overlap and be positioned anywhere.
  3. Floating objects cannot contain worksheets.
  4. Tiled objects can only be rendered on Tableau Mobile.
Show Answer
Answer: b
Explanation
Tiled objects fit neatly into a non-overlapping grid and resize automatically; floating objects can be placed anywhere and may overlap other elements.

74) Which dashboard action triggers a filter on target sheets when a user selects a mark in a source sheet?

  1. Highlight Action
  2. Filter Action
  3. URL Action
  4. Go to Sheet Action
Show Answer
Answer: b
Explanation
A Filter Action uses the selected marks in a source sheet as a filter for one or more target sheets.

75) Which Dashboard Action opens a web page or external link based on data values in the view?

  1. Filter Action
  2. URL Action
  3. Parameter Action
  4. Set Action
Show Answer
Answer: b
Explanation
A URL Action opens a web page (or a web-based image/document) when a user clicks or hovers a mark, and the URL can be built dynamically from field values.

76) What object container type arranges dashboard elements horizontally in a single row?

  1. Vertical Layout Container
  2. Horizontal Layout Container
  3. Grid Layout Container
  4. Freeform Layout Container
Show Answer
Answer: b
Explanation
A Horizontal Layout Container places its child objects side by side in a single row; a vertical container stacks them in a column.

77) How can you set a worksheet to filter all other worksheets on a dashboard with one click?

  1. Enable “Use as Filter” option on the worksheet frame.
  2. Drag the sheet to the Filters shelf.
  3. Group all fields in the view.
  4. Convert the sheet to a legend.
Show Answer
Answer: a
Explanation
Selecting a worksheet frame and choosing Use as Filter makes selections in that sheet filter every other sheet on the dashboard.

78) What feature allows designing customized dashboard layouts specifically tailored for mobile screens?

  1. Mobile Device Preview / Device Layouts
  2. Responsive CSS Grid
  3. Auto-Shrink Mode
  4. Tablet Transformer
Show Answer
Answer: a
Explanation
Device Layouts (with Mobile Device Preview) let you create separate dashboard layouts for phone, tablet and desktop.

79) What happens when you export a dashboard as a “Packaged Reader” format?

  1. It saves as .twb.
  2. It creates an interactive file playable in Tableau Reader (.twbx).
  3. It automatically uploads to Tableau Cloud.
  4. It converts all worksheets into static PNG images.
Show Answer
Answer: b
Explanation
Exporting as a Packaged Workbook for Tableau Reader produces a .twbx file that can be opened and interacted with in the free Tableau Reader.

80) Which dashboard action allows changing a parameter value directly by interacting with marks on a visual?

  1. Set Action
  2. Parameter Action
  3. Highlight Action
  4. Filter Action
Show Answer
Answer: b
Explanation
A Parameter Action sets a parameter’s value from the field value of the mark the user selects or hovers over.

81) What is Tableau Server?

  1. A desktop development tool for building visuals
  2. An enterprise web platform to publish, share, govern, and manage Tableau workbooks and data sources
  3. A standalone ETL data cleaning tool
  4. A mobile viewer application only
Show Answer
Answer: b
Explanation
Tableau Server is the on-premises (or self-managed) enterprise platform for publishing, sharing, securing and scheduling Tableau content.

82) What is Tableau Cloud (formerly Tableau Online)?

  1. A fully cloud-hosted, SaaS version of Tableau Server managed by Tableau/Salesforce
  2. A local database storage engine
  3. A free version of Tableau Desktop
  4. An open-source visualization library
Show Answer
Answer: a
Explanation
Tableau Cloud is the fully managed SaaS edition of Tableau Server, hosted and maintained by Tableau (Salesforce).

83) Which site role on Tableau Server/Cloud allows users to publish workbooks and interact with content, but NOT perform site admin tasks?

  1. Server Administrator
  2. Site Administrator Creator
  3. Creator / Explorer (Can Publish)
  4. Viewer
Show Answer
Answer: c
Explanation
A Creator (or Explorer with publish rights) can build and publish content, but site administration is reserved for Site Administrator and Server Administrator roles.

84) What process is responsible for background tasks such as extract refreshes and scheduled subscriptions on Tableau Server?

  1. VizQL Server
  2. Application Server
  3. Backgrounder
  4. Data Server
Show Answer
Answer: c
Explanation
The Backgrounder handles asynchronous jobs — extract refreshes, subscriptions, flows and other scheduled tasks.

85) Which process on Tableau Server renders visualizations and responds to user queries/interactions?

  1. VizQL Server
  2. Backgrounder
  3. Gateway
  4. Cluster Controller
Show Answer
Answer: a
Explanation
The VizQL Server translates visual interactions into queries against the data and renders the resulting visualizations.

86) What is a “Published Data Source” in Tableau?

  1. A centralized, governed data model hosted on Tableau Server/Cloud that multiple workbooks can connect to
  2. A local CSV file saved in My Tableau Repository
  3. A static table inside a dashboard layout container
  4. An embedded SQL script inside a .twb file
Show Answer
Answer: a
Explanation
A published data source lives on Tableau Server/Cloud and centralises connection details, extracts and metadata so many workbooks can reuse one governed source.

87) What is Tableau Bridge used for?

  1. Translating SQL code into Python
  2. Connecting Tableau Cloud to private, on-premises data sources behind a firewall
  3. Merging Tableau Desktop with Power BI workbooks
  4. Converting .twb files into .pdf files automatically
Show Answer
Answer: b
Explanation
Tableau Bridge acts as a secure relay between Tableau Cloud and on-premises/private-network data sources that cannot be reached directly from the cloud.

88) What is the role of Tableau Prep Builder?

  1. Building interactive dashboards for mobile devices
  2. Visually combining, shaping, cleaning, and preparing data before analysis in Tableau Desktop
  3. Managing Tableau Server user licenses
  4. Rendering 3D spatial models
Show Answer
Answer: b
Explanation
Tableau Prep Builder is the visual data-preparation tool used to clean, pivot, join, union and aggregate data before analysis.

89) Which file extension is produced by Tableau Prep for a packaged flow?

  1. .tflx
  2. .tfl
  3. .hyper
  4. .twbx
Show Answer
Answer: a
Explanation
A packaged flow is saved as .tflx (it bundles the flow plus its local data). A plain flow is .tfl.

90) What feature allows users to receive automated email snapshots of views/dashboards on a set schedule?

  1. Alerts
  2. Subscriptions
  3. Extract Refreshes
  4. Web Editing
Show Answer
Answer: b
Explanation
Subscriptions email a snapshot of a view or dashboard to users on a recurring schedule. Alerts notify only when a data condition is met.

91) What is “Data Blending” aggregate behavior constraint in Tableau?

  1. Data from the secondary data source must ALWAYS be brought in as an aggregate (SUM, AVG, ATTR, etc.).
  2. Data from the secondary source can only be row-level continuous fields.
  3. Secondary data sources do not support string fields.
  4. Primary data sources cannot contain filters.
Show Answer
Answer: a
Explanation
Blending always aggregates the secondary source — its measures appear as SUM, AVG, ATTR and so on, never at row level.

92) What function returns a value if all rows in a group have a single unique value, otherwise returning an asterisk (*)?

  1. UNIQUE()
  2. ATTR()
  3. SINGLE()
  4. FIRST()
Show Answer
Answer: b
Explanation
ATTR() returns the value if there is only one distinct value in the group, and an asterisk (*) if there are multiple values.

93) What does an asterisk (*) indicate when viewing blended data in Tableau?

  1. Data source connection error
  2. Multiple values exist in the secondary data source for a single mark in the primary data source
  3. Missing null fields
  4. Text overflow error
Show Answer
Answer: b
Explanation
In blended views, the asterisk (*) means the secondary source has more than one value for that mark, so no single value can be shown.

94) Which utility built into Tableau Desktop helps diagnose performance bottlenecks in workbook queries and rendering?

  1. Performance Recording
  2. Task Manager
  3. Data Optimizer
  4. Query Profiler
Show Answer
Answer: a
Explanation
Performance Recording (Help → Settings and Performance → Start Performance Recording) captures the time spent on queries, rendering and layout.

95) Which of the following strategies improves Tableau dashboard performance?

  1. Increasing the number of high-cardinality filters set to “Only Relevant Values”
  2. Using Data Extracts instead of complex Live Connections over slow networks
  3. Putting dozens of worksheets on a single dashboard screen
  4. Converting all fields into continuous string parameters
Show Answer
Answer: b
Explanation
Extracts store data in the fast Hyper engine locally, avoiding slow live queries over the network — a classic performance improvement.

96) What type of calculation evaluates faster in Tableau?

  1. Boolean (TRUE/FALSE) and Integer calculations
  2. Complex String manipulations (CONCAT, REGEXP)
  3. Nested IF-THEN statements with multiple string comparisons
  4. Table calculations spanning multiple directions
Show Answer
Answer: a
Explanation
Numeric and Boolean operations are far cheaper to evaluate than string parsing, regular expressions or complex nested conditions.

97) What does the EXCLUDE LOD calculation do?

  1. Omits specified dimensions from the calculation granularity, even if they are present in the view.
  2. Removes null values permanently from the data extract.
  3. Filters out data points matching user permissions.
  4. Excludes measures from the total calculation summary.
Show Answer
Answer: a
Explanation
EXCLUDE removes the listed dimensions from the calculation’s granularity, so the expression is computed at a coarser level of detail than the view.

98) Which field is generated automatically by Tableau to count the total rows in a data table (Tableau 2020.2+ naming)?

  1. Number of Records
  2. [Table Name] (Count)
  3. Row Count
  4. Total Rows
Show Answer
Answer: b
Explanation
Explanation
From 2020.2, Tableau generates a count field named after the table, e.g. [Orders] (Count), replacing the older “Number of Records”.

99) What does the function INDEX() return in a Table Calculation?

  1. The physical row address in the underlying database
  2. The index position of the current row within the partition
  3. The total count of all marks in the view
  4. The memory address of the calculated field
Show Answer
Answer: b
Explanation
INDEX() returns the position of the current row inside its partition, starting at 1 — commonly used for ranking and alternating row colours.

100) Which feature allows Tableau to execute R or Python scripts directly within calculated fields?

  1. Custom SQL window
  2. External Services connection (TabPy / RServe)
  3. Data Source Custom Extensions
  4. Tableau Prep Conductor
Show Answer
Answer: b
Explanation
Analytics Extensions let Tableau call out to an external service — TabPy for Python or RServe for R — via SCRIPT_* functions inside calculated fields.
100 SSC MTS MCQ (Multiple Choice Questions) with Answers
100 Power BI MCQ (Multiple Choice Questions) with Answers
Print page
0 Likes
Studyopedia Editorial Staff
contact@studyopedia.com

We work to create programming tutorials for all.

No Comments

Post A Comment