NEW
Font size
WorksheetsBootcamp Week1
Total questions: 20
Worksheet time: 20mins
Which Power BI view is used to manage relationships between tables?
Report View
Data View
Power Query Editor
Model View
Which of the following is a Measure?
Segment
Sales
Category
Region
What is the main purpose of Dimensions in analysis?
To speed up performance
To perform calculations
To group and categorise data
To store numeric values
What happens if a date column is stored as text?
Reports become faster
Sorting and time analysis may break
Nothing changes
It improves charts
What does SUM aggregation do?
Counts rows
Finds average
Adds values together
Removes duplicates
Which Power BI component shows raw rows of data?
Report View
Data View
Model View
Filters Pane
Which mode typically provides faster dashboard performance in analytics tools?
Live connection without caching
Import mode for cached datasets
Hybrid mode syncing on demand
DirectQuery pulling live records
A key disadvantage of DirectQuery is most closely related to what factor?
Data never updates in reports
Filters cannot be applied to visuals
No ability to write SQL queries
Performance depends on source database
Which pane is used to choose fields that appear in a visual?
Model pane for table relations
Fields pane listing dataset columns
Filters pane for scoped slicers
Visualisation pane for chart types
In Tableau, which shelf primarily controls level of detail in a view?
Filters shelf for records exclusion
Rows shelf for axis placement
Pages shelf for animation frames
Marks card for detail and encoding
Converting a measure from continuous (green) to discrete (blue) most directly affects what?
Chart validity across worksheets
Applied filters and slicers
Visual structure such as headers
Rendering engine stability
When favoring Import mode over DirectQuery, what trade-off are you making?
Higher speed with storage usage
Lower speed with zero storage
Real-time freshness with caching
No caching with instant joins
If a dashboard must reflect real-time changes from the database, which connection is more suitable?
DirectQuery for live data retrieval
Hybrid mode without refreshes
Offline extract stored locally
Import mode using static extracts
To quickly adjust how marks encode attributes like color and size, where should you focus?
Model pane relationship view
Marks card controls and shelves
Filters pane configurations
Fields pane column selection
Changing a measure to discrete in Tableau commonly turns an axis into what element?
A filter selection drop-down
A parameter control input
A numeric continuous scale
A categorical header labels
Which Tableau feature allows users to switch between different values dynamically (similar to a variable)?
Extract
Parameter
Set
Context filter
What is the key difference between a Tableau Extract and a Live Connection?
Extracts are slower than Live connections
There is no difference
Extracts store data locally and improve performance
Live connections work offline
In Tableau, which type of filter is applied first in the Order of Operations?
Dimension filter
Measure filter
Context filter
Table calculation filter
What is a common use case for a Set in Tableau?
To refresh data automatically
To group top-performing vs other items
To format colours
To manage joins
Why choose a data extract over a live connection when working with very large datasets in a BI dashboard?
Extracts prevent using calculated fields entirely
Live connections cannot be filtered at all
Extracts improve interactive dashboard responsiveness
Extracts make visualizations less reliable overall
