Amazon QuickSight is a powerful business intelligence tool for creating dynamic dashboards and visualizations. Chapter 3 delves into building visualizations, understanding visual types, creating dashboards and stories, and configuring filters, parameters, and controls. Test your understanding with these 30 carefully curated MCQs. Each question focuses on core concepts, ensuring comprehensive learning for exam preparation.
Multiple-Choice Questions (MCQs)
Understanding Visual Types
What is the primary purpose of choosing the correct visual type in QuickSight? a) To increase data storage b) To enhance data interpretation c) To restrict user access d) To perform mathematical calculations
Which visual type is best for showing trends over time? a) Pie chart b) Line chart c) Scatter plot d) Bar chart
What does a pie chart in QuickSight represent? a) Sequential data b) Proportional data c) Geographic data d) Time-series data
Heat maps in QuickSight are commonly used to: a) Compare data across categories and time b) Show detailed data rows c) Display binary data d) Perform regression analysis
Which visual is best suited for analyzing relationships between two variables? a) Bar chart b) Line chart c) Scatter plot d) Funnel chart
Creating Dashboards and Stories
Dashboards in QuickSight allow users to: a) Perform coding operations b) Analyze data interactively c) Write SQL queries d) Design machine learning models
What is the function of a story in Amazon QuickSight? a) To display static data b) To narrate data insights over time c) To edit datasets d) To perform advanced analytics
A QuickSight dashboard can include: a) Only one type of visual b) Multiple visuals and filters c) SQL code only d) Python scripts
To publish a dashboard in QuickSight, you must first: a) Save the analysis b) Create a dataset c) Configure filters d) Import external data
Which option is true about QuickSight stories? a) They are real-time dashboards b) They summarize insights from dashboards c) They replace visualizations d) They are used for data modeling
Configuring Filters, Parameters, and Controls
Filters in QuickSight are used to: a) Organize datasets b) Limit data displayed in visuals c) Enhance dashboard performance d) Export data to other applications
What is a key difference between filters and parameters in QuickSight? a) Filters are dynamic; parameters are static b) Filters apply to visuals; parameters can be global c) Parameters are only used in dashboards d) Filters are used for calculations
Which filter type allows users to select multiple values? a) Dropdown single-select b) Dropdown multi-select c) Numeric slider d) Date range
A parameter in QuickSight: a) Automatically updates filters b) Represents a dynamic variable c) Can only have numeric values d) Is always linked to controls
To configure a control for a parameter, you must: a) Delete existing visuals b) Enable control visibility c) Remove all filters d) Export the parameter
Mixed Questions
Which visual is ideal for representing categorical data distributions? a) Line chart b) Bar chart c) Scatter plot d) Pivot table
The “Sort by” option in QuickSight is used to: a) Filter rows b) Rearrange data in visuals c) Add custom parameters d) Create dashboards
Adding a calculated field in QuickSight allows you to: a) Change dataset schemas b) Perform complex calculations on-the-fly c) Connect external databases d) Filter visual types
What role does the “Insight visual” play in QuickSight? a) Creates data stories b) Displays key metrics and trends c) Filters dashboards dynamically d) Enables export to CSV
In QuickSight, a control linked to a parameter can be: a) A fixed value b) A user-selectable input c) A static column d) None of the above
Scenario-Based Questions
If a sales manager wants to view monthly revenue trends, which visual type should they choose? a) Bar chart b) Line chart c) Pie chart d) Heat map
A dashboard contains multiple visuals. How can you ensure all visuals reflect the same time range? a) Add a dataset filter b) Use a date parameter c) Apply a numeric slider d) Modify dataset permissions
When creating a story, how do you move from one scene to the next? a) Use the timeline control b) Switch datasets c) Apply filters d) Export the story
A funnel chart in QuickSight is most appropriate for: a) Sales pipeline analysis b) Time-series data c) Comparing categorical data d) Displaying geographic trends
What is the default aggregation for numeric fields in QuickSight? a) Average b) Sum c) Count d) Median
When would you use a numeric range filter? a) To filter text fields b) To filter date ranges c) To filter continuous numeric values d) To apply categorical filters
A pivot table in QuickSight helps in: a) Summarizing data across rows and columns b) Displaying relationships between variables c) Visualizing geographic data d) Showing trends over time
What must you do before sharing a dashboard with a colleague? a) Publish the dashboard b) Add new dataset fields c) Delete unused visuals d) Save as private
What does the drill-down feature enable in QuickSight? a) Exploring data hierarchies b) Exporting detailed data c) Applying global filters d) Configuring parameters
How can you ensure consistent branding across dashboards? a) Use custom themes b) Add advanced calculations c) Apply dataset transformations d) Disable filter controls
Answers
QNo
Answer
1
b) To enhance data interpretation
2
b) Line chart
3
b) Proportional data
4
a) Compare data across categories and time
5
c) Scatter plot
6
b) Analyze data interactively
7
b) To narrate data insights over time
8
b) Multiple visuals and filters
9
a) Save the analysis
10
b) They summarize insights from dashboards
11
b) Limit data displayed in visuals
12
b) Filters apply to visuals; parameters can be global