0% found this document useful (0 votes)
108 views12 pages

100 MCQ

Uploaded by

Mrs.SANTHOSHI A
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
108 views12 pages

100 MCQ

Uploaded by

Mrs.SANTHOSHI A
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 12

100 MCQs – Data Visualization (with Answers)

1) What is Tableau primarily used for?


a) Coding Applications
b) Creating Databases
c) Data Visualization
d) Antivirus Scanning
✅ Answer: c
2) Which of the following is an advantage of Tableau?
a) Requires complex coding
b) Only works offline
c) Easy drag-and-drop interface
d) No support for real-time data
✅ Answer: c
3) The Tableau Analytics Platform provides:
a) Only chart creation
b) A centralized solution for data analysis
c) Video editing features
d) Code compilation tools
✅ Answer: b
4) Data preparation in Tableau includes:
a) Running Python scripts
b) Cleaning and organizing data
c) Designing databases
d) Compiling programs
✅ Answer: b
5) Which element is part of Tableau Workspace?
a) Control panel
b) Data pane
c) Settings manager
d) Debug window
✅ Answer: b
6) What are dimensions in Tableau?
a) Numerical values
b) Categorical fields
c) Aggregated values
d) Statistical metrics
✅ Answer: b
7) Which of the following is a Tableau measure?
a) Product name
b) Category
c) Sales amount
d) Country
✅ Answer: c
8) What type of data does Tableau NOT support?
a) Boolean
b) XML tree
c) Date
d) Geographic
✅ Answer: b
9) A data connector in Tableau is used to:
a) Create animations
b) Encrypt files
c) Link to external data sources
d) Draw images
✅ Answer: c
10) Which operation stacks data vertically in Tableau?
a) Join
b) Sort
c) Union
d) Filter
✅ Answer: c
11) Joins in Tableau combine tables:
a) Vertically
b) Horizontally
c) Using scripts
d) Randomly
✅ Answer: b
12) Which Tableau file format is used for data extracts?
a) .csv
b) .hyper
c) .docx
d) .exe
✅ Answer: b
13) What is a benefit of using extracts over live connections?
a) Slower performance
b) Real-time updates
c) Faster querying
d) Requires internet
✅ Answer: c
14) What does metadata in Tableau refer to?
a) Actual data
b) Programming code
c) Information about data structure
d) Data storage files
✅ Answer: c
15) What feature in Tableau suggests chart types?
a) Data lens
b) Show Me
c) Chart Wizard
d) Style Panel
✅ Answer: b
16) A Tableau dashboard is a collection of:
a) SQL queries
b) Charts and filters
c) Raw data
d) Programs
✅ Answer: b
17) A Tableau story helps users:
a) Encrypt dashboards
b) Add programming code
c) Present a data-driven narrative
d) Lock files
✅ Answer: c
18) Which of the following is a correct join type in Tableau?
a) Multi-stage
b) Half join
c) Inner join
d) Full link
✅ Answer: c
19) What kind of chart is best for trend analysis?
a) Bar Chart
b) Pie Chart
c) Line Chart
d) Heat Map
✅ Answer: c
20) Highlight tables in Tableau use:
a) 3D graphics
b) Shapes
c) Color
d) Animations
✅ Answer: c
21) Heat maps in Tableau help to identify:
a) Passwords
b) Trends in text files
c) Density and performance visually
d) Email attachments
✅ Answer: c
22) A bullet chart compares actual vs:
a) Average
b) Maximum
c) Target
d) Count
✅ Answer: c
23) Which chart best shows cumulative values over time?
a) Donut chart
b) Scatter plot
c) Waterfall chart
d) Tree map
✅ Answer: c
24) How do you apply a filter in Tableau?
a) Open settings
b) Drag a field to Filters shelf
c) Use SQL query
d) Press F12
✅ Answer: b
25) A dual-axis chart is used to:
a) Merge dashboards
b) Compare two measures
c) Sort data
d) Create filters
✅ Answer: b
26) Which feature provides additional details on hover?
a) Chart Editor
b) Dashboard pane
c) Tooltip
d) Layer
✅ Answer: c
27) In a hierarchy, data is drilled down from:
a) Smaller to larger levels
b) Alphabetically
c) Higher to more detailed levels
d) Random order
✅ Answer: c
28) How is a line chart different from a bar chart?
a) Used for grouping
b) Shows numeric data only
c) Best for comparing dates
d) Better for trends over time
✅ Answer: d
29) Which chart uses rectangles with color intensity?
a) Pie chart
b) Heat map
c) Line chart
d) Histogram
✅ Answer: b
30) To create a hierarchy in Tableau:
a) Use SQL
b) Right-click and drag subfields
c) Insert a macro
d) Use formula editor
✅ Answer: b
31) Which of the following supports drill-downs in Tableau?
a) Sorting
b) Grouping
c) Hierarchies
d) Filtering
✅ Answer: c
32) What does the ‘Show Me’ panel recommend?
a) Joins
b) Chart types
c) Data connectors
d) Security settings
✅ Answer: b
33) Which chart would best show monthly sales growth?
a) Bullet
b) Bar
c) Line
d) Pie
✅ Answer: c
34) What is NOT a type of bar chart in Tableau?
a) Horizontal
b) Vertical
c) Rotational
d) Column
✅ Answer: c
35) To create a chart in Tableau, use:
a) Rows and columns shelf
b) Dashboard filter
c) Legend tab
d) Script runner
✅ Answer: a
36) Which of the following helps in sorting data visually?
a) Measures pane
b) Filter dialog
c) Sorting tool
d) Worksheet title
✅ Answer: c
37) What does a cumulative sum show?
a) Individual values
b) Frequency
c) Running total
d) Minimums only
✅ Answer: c
38) How can you edit a legend in Tableau?
a) Right-click → Edit
b) Use script
c) Modify SQL
d) Hide it permanently
✅ Answer: a
39) Which chart uses reference lines and bars?
a) Bullet chart
b) Pie chart
c) Tree map
d) Highlight table
✅ Answer: a
40) Which field category is typically aggregated in Tableau?
a) Dimensions
b) Strings
c) Measures
d) Dates
✅ Answer: c
41) Which feature allows changing field names in Tableau?
a) Metadata editing
b) SQL Query Editor
c) Format pane
d) Table manager
✅ Answer: a
42) What is the default data structure in Tableau?
a) Object graph
b) Data table
c) Data warehouse
d) Form
✅ Answer: b
43) To update charts with live data, you should use:
a) Data Extract
b) Static File
c) Live Connection
d) Export Wizard
✅ Answer: c
44) Which file type supports faster querying offline?
a) .doc
b) .csv
c) .hyper
d) .json
✅ Answer: c
45) How are unions applied in Tableau?
a) Horizontally
b) Merged by key
c) Stacked vertically
d) Using SQL scripts
✅ Answer: c
46) Which component is NOT part of Tableau workspace?
a) Shelves
b) Data pane
c) Query runner
d) Show Me panel
✅ Answer: c
47) Tableau is most commonly used in which field?
a) Medicine
b) Mechanical Engineering
c) Data Analysis
d) Law
✅ Answer: c
48) Which chart is best for target comparisons?
a) Bullet
b) Pie
c) Tree
d) Line
✅ Answer: a
49) Which feature displays additional info on data points?
a) Tooltip
b) Legend
c) Sort
d) Title
✅ Answer: a
50) The layout that combines charts on a single screen is:
a) Worksheet
b) Chart pane
c) Dashboard
d) Connection view
✅ Answer: c
51) Which Tableau component allows combining multiple charts?
a) Sheet
b) Data Source
c) Dashboard
d) Pane
✅ Answer: c
52) Which of the following is an example of a dimension?
a) Revenue
b) Quantity
c) Region
d) Profit
✅ Answer: c
53) What happens when you drag a dimension into the Rows shelf?
a) It creates a filter
b) It plots a measure
c) It creates headers for rows
d) It hides data
✅ Answer: c
54) What is the result of applying a left join in Tableau?
a) Only matching records
b) All left table records + matched right table
c) Right table only
d) Top 10 records
✅ Answer: b
55) Which feature helps in renaming Tableau fields?
a) Format pane
b) Axis editor
c) Metadata management
d) Data label
✅ Answer: c
56) Which data type is suitable for time-based trend charts?
a) String
b) Date
c) Boolean
d) Integer
✅ Answer: b
57) Highlight tables help emphasize:
a) Data source names
b) Charts inside dashboards
c) Specific values using color
d) Animation effects
✅ Answer: c
58) Which chart uses multiple axes in Tableau?
a) Tree map
b) Pie chart
c) Dual-axis chart
d) Scatter plot
✅ Answer: c
59) Which element appears when hovering over a data point?
a) Mark
b) Filter bar
c) Tooltip
d) Data label
✅ Answer: c
60) Which chart type is ideal for displaying proportions?
a) Bar chart
b) Pie chart
c) Line chart
d) Heat map
✅ Answer: b
61) The visual shelf used to create chart layouts is:
a) Data pane
b) Filters pane
c) Rows/Columns shelf
d) Formatting bar
✅ Answer: c
62) What is Tableau’s 'Show Me' panel based on?
a) Predefined chart styles
b) Selected fields
c) Data extract size
d) Data format
✅ Answer: b
63) To connect Tableau to MySQL, use:
a) REST API
b) Data connector
c) Flat file
d) Web table
✅ Answer: b
64) Tableau filters can be applied at which level?
a) Chart only
b) Data only
c) Sheet, dashboard, or data source
d) Server only
✅ Answer: c
65) What is required to perform a union?
a) Matching keys
b) Equal column structure
c) Common primary key
d) Python code
✅ Answer: b
66) The chart best suited for comparing categories is:
a) Line chart
b) Bar chart
c) Heat map
d) Pie chart
✅ Answer: b
67) Cumulative data can be visualized using:
a) Highlight tables
b) Pie charts
c) Waterfall charts
d) Donut charts
✅ Answer: c
68) Which chart allows time-series trend analysis?
a) Tree map
b) Line chart
c) Bullet chart
d) Scatter plot
✅ Answer: b
69) Which Tableau feature allows conditional formatting?
a) Data Source
b) Format pane
c) Set
d) Filter
✅ Answer: b
70) Which of the following is NOT a Tableau join type?
a) Outer Join
b) Inner Join
c) Cross Join
d) Left Join
✅ Answer: c
71) To display multiple charts in one view, use:
a) Worksheet
b) Metadata
c) Dashboard
d) Filter
✅ Answer: c
72) Which element contains dimension and measure fields?
a) Axis
b) Worksheet
c) Data Pane
d) Format tab
✅ Answer: c
73) What do small circles on a line chart represent?
a) Filters
b) Markers (data points)
c) Zoom controls
d) Chart labels
✅ Answer: b
74) Which chart is good for displaying targets vs actuals?
a) Heat map
b) Bullet chart
c) Line chart
d) Pie chart
✅ Answer: b
75) The canvas for chart creation is called:
a) Worksheet
b) Storyline
c) Show Me
d) Pane
✅ Answer: a
76) What type of data is ideal for geographic visualization?
a) Integer
b) String
c) Geographic
d) Date
✅ Answer: c
77) Which chart is best suited for sales per region?
a) Line chart
b) Bullet chart
c) Bar chart
d) Waterfall chart
✅ Answer: c
78) Which operation is NOT available in Tableau?
a) Drill-down
b) Predictive modeling
c) Data encryption
d) Aggregation
✅ Answer: c
79) The process of hiding unused fields is called:
a) Filtering
b) Sorting
c) Metadata cleanup
d) Collapsing
✅ Answer: c
80) Which field is usually displayed on the X-axis?
a) Measure
b) Date/Dimension
c) Tooltip
d) Legend
✅ Answer: b
81) What is the key difference between extract and live data?
a) Live is faster
b) Extract is dynamic
c) Extract is offline copy
d) Extract uses SQL
✅ Answer: c
82) The central panel for placing chart elements is called:
a) Dashboard
b) Canvas
c) Legend
d) Filter bar
✅ Answer: b
83) Which file format is NOT supported by Tableau?
a) Excel
b) PDF
c) SQL
d) JPG
✅ Answer: d
84) Which function adds color to highlight tables?
a) Color shelf
b) Label shelf
c) Tooltip
d) Size tab
✅ Answer: a
85) Which pane shows field names and types?
a) Metadata
b) Data pane
c) Format pane
d) Dashboard pane
✅ Answer: b
86) How do you compare two numerical values on one chart?
a) Tooltip
b) Pie chart
c) Dual-axis
d) Filters
✅ Answer: c
87) Which operation is used to remove unwanted data points?
a) Union
b) Drill-down
c) Filtering
d) Aggregation
✅ Answer: c
88) Which chart is NOT suitable for categorical comparison?
a) Line chart
b) Bar chart
c) Pie chart
d) Highlight table
✅ Answer: a
89) How do you identify outliers in Tableau?
a) Pie chart
b) Bar chart
c) Box plot
d) Line chart
✅ Answer: c
90) To combine sheets into a data story, use:
a) Data pane
b) Worksheet
c) Story
d) Filter pane
✅ Answer: c
91) What type of data supports drill-down in hierarchies?
a) Continuous data
b) Boolean data
c) Hierarchical data
d) Static data
✅ Answer: c
92) Which component supports interactivity in dashboards?
a) Legend
b) Filter actions
c) Show Me panel
d) Format pane
✅ Answer: b
93) Which join returns unmatched rows with NULL values?
a) Inner join
b) Left join
c) Full outer join
d) Union
✅ Answer: c
94) What are the two axes in dual-axis called?
a) Primary and secondary
b) X and Y
c) Top and bottom
d) Main and sub
✅ Answer: a
95) A dashboard layout includes:
a) SQL views
b) Charts, filters, containers
c) Table joins
d) Programming fields
✅ Answer: b
96) Which field type is used to categorize data?
a) Measures
b) Dimensions
c) Boolean
d) Geographic
✅ Answer: b
97) Which chart can handle large value distributions?
a) Box plot
b) Pie chart
c) Tree map
d) Highlight table
✅ Answer: a
98) The format pane helps adjust:
a) Field names
b) Data types
c) Font, colors, gridlines
d) Filters
✅ Answer: c
99) Which field typically uses aggregation functions like SUM()?
a) Dimension
b) Measure
c) Boolean
d) Date
✅ Answer: b
100) Which visualization emphasizes part-to-whole relationship?
a) Pie chart
b) Line chart
c) Bar chart
d) Bullet chart
✅ Answer: a

You might also like