Module 8 Quiz – Analytics Engineering

1. The core purpose of dashboards in analytics engineering is to: *

A) Replace data warehouses

B) Bridge technical data models and business stakeholders

C) Store raw logs

D) Eliminate KPI definitions

2. An effective KPI should be: *

A) Broad, inspirational, and aesthetic

B) Specific, measurable, actionable, and tied to business objectives

C) Hidden from stakeholders to avoid bias

D) Constantly changing each week

3. Which is the best example of an operational dashboard? *

A) Annual strategy summary

B) Marketing brand guidelines

C) Daily ETL pipeline health and job status

D) Quarterly executive revenue overview

4. A strategic dashboard is primarily designed for: *

A) Executive overviews and quarterly progress

B) Deep ad-hoc analysis by analysts

C) Data engineering backlog tracking

D) Schema change reviews

5. Which platform integrates modeling via LookML and connects directly to cloud warehouses? *

A) PowerPoint

B) Looker

C) Excel

D) Tableau

6. A major strength of Tableau highlighted in the module is: *

A) Mandatory coding for every chart

B) Exclusive real-time streaming support

C) Free licensing and Google-only connectors

D) Powerful drag-and-drop visuals with built-in analytics

7. Looker Studio is especially well-suited for: *

A) Only on-prem data sources

B) Heavy semantic modeling and governed, versioned metrics

C) Rapid prototyping and lightweight reporting, free and web-based

D) GPU-accelerated ML dashboards

8. A key component of an effective dashboard layout is: *

A) Logical visual hierarchy with critical KPIs prominent (e.g., top-left)

B) Hiding labels to save space

C) Randomized widget placement to reduce bias

D) Maximizing chart density per page

9. Which of the following is a common mistake called out in the module? *

A) Applying consistent color schemes

B) Using tables for drill-down details

C) Providing clear metric labels

D) Using pie charts to show multi-period trends

10. For filtering and controls, the best practice is to: *

A) Avoid date filters on operational dashboards

B) Add as many filters as possible for flexibility

C) Ensure filters align with the data model’s grain

D) Use only text search to simplify UI

11. Regarding calculated metrics, the module recommends: *

A) Pre-calculating complex measures in dbt for consistency and performance

B) Calculating complex measures in the BI tool only

C) Storing formulas in slides

D) Avoiding calculations altogether

12. Which chart type is ideal for conveying a single KPI at a glance? *

A) Heatmap

B) Bubble chart

C) Scorecard

D) Line chart

13. For performance optimization, an advised approach is: *

A) Refresh data continuously without schedule

B) Aggregate/preprocess data with dbt and limit heavy visuals

C) Disable caching entirely

D) Use dozens of complex visuals per page

14. As part of dashboard quality assurance, analytics engineers should: *

A) Trust BI outputs without validation

B) Rely on manual checks once a quarter

C) Defer QA to end users

D) Validate metrics against source data and leverage automated tests/alerts (e.g., dbt)

15. An emerging trend in dashboarding mentioned in the module is: *

A) AI-generated anomaly alerts and real-time dashboards via streaming

B) Replacing KPIs with anecdotes

C) Eliminating interactivity to simplify UX

D) Manual CSV uploads for forecasting