An operator monitors which bike stations are empty right now. Which dashboard genre is this?
Q3
A dashboard shows "1,333 trips/day" with no other information. What is missing?
Q4
Daily trips: last 7 days average 1,333; previous 7 days average 1,226; target 1,500. Which statement is correct?
Q5
In Streamlit, how do you show a PM2.5 KPI whose increase should appear red (bad)?
Q6
What is a sparkline?
Q7
Why does Stephen Few recommend bullet graphs instead of gauges and speedometers?
Q8
Where should the most important panel of a dashboard usually be placed (for left-to-right readers)?
Q9
What happens in Streamlit when the user changes a st.selectbox?
Q10
Which Streamlit decorator should cache a database connection or an ML model shared by all users?
Q11
@st.cache_data(ttl=300) caches a query. A user loads the page at t = 0 s and again at t = 299 s and t = 300 s. When is the database queried?
Q12
What is the trade-off of a long cache TTL on an operational dashboard?
Q13
Where should a Streamlit app read its database password?
Q14
What does st.session_state provide?
Q15
How can a Streamlit dashboard be tested automatically?
Q16
In Dash (Plotly), interactivity is implemented with:
Q17
Which tool is designed primarily for time-series monitoring dashboards of systems and sensors?
Q18
When might a BI tool (Tableau, Power BI, Superset) be a better choice than a Streamlit app?
Q19
A dashboard has 14 panels, including two charts answering the same question and a large logo in the top-left corner. Which design principles are violated?
Q20
Why must a dashboard show "last updated" information?
Q21
An AI copilot builds a "sales dashboard" that computes "active customers" differently from the finance team's report. What organizational practice prevents this?
Q22
A Streamlit page loads 3 million rows from the database on every rerun and filters them in pandas. What is the best fix?
Q23
A Streamlit KPI shows the latest PM2.5 and the delta from iloc[-1] - iloc[-2]. For a district with only one reading, what happens?
Q24
Which statement about information density on dashboards is most accurate?
Q25
For a public air-quality dashboard on phones, which is the best primary element?
Q26
What does a bullet graph's target marker show?
Q27
A dashboard on an internal server must show each department only its own buildings' energy data. Which concern is this?
Q28Short answer
Design the first screen of a strategic CityPulse dashboard for the city's environment committee (monthly meeting). Give the panels in priority order with their position, idiom, task and the context each KPI needs; state data freshness and what you deliberately leave out.
Q29Short answer
Explain Streamlit's execution model and show how you would make this app fast and correct: the app reads a 2-million-row trips table from MySQL, lets the user choose a station and a date range, and shows trips per hour plus two KPIs.
Q30Short answer
Compare Streamlit, Dash and Power BI for three CityPulse needs: (a) a prototype for a research project with an ML model; (b) the city's official monthly air-quality report used by many departments; (c) an operations wall screen with live bike data. Recommend one tool per need and justify.