AI and Public Health Dashboards: Querying SQL You Don't Quite Know

End-of-lesson check

15 questions · take it digitally for instant feedback at tendril.neural-forge.io/learn/quiz/end-creators-healthcare-AI-and-public-health-data-dashboard-r13a6-adults

1. An epidemiologist is building a measles dashboard using AI-generated SQL queries. What is the primary responsibility the epidemiologist must retain?

   1. Monitoring the server performance metrics
   2. Writing the actual SQL syntax from scratch
   3. Deciding which database columns to create
   4. Validating that the cohort logic matches the case definition

2. A county health department needs to publish a communicable disease dashboard. Why should small-cell suppression be implemented as a post-processing step rather than within the AI-generated SQL query?

   1. Suppression thresholds vary by jurisdiction and change over time
   2. Post-processing automatically sends alerts to stakeholders
   3. SQL queries run faster without suppression logic
   4. The AI needs full dataset access to learn patterns

3. Which task is within AI's demonstrated capability when assisting with a public health SQL query?

   1. Translating a written case definition into WHERE clause logic
   2. Determining whether the underlying data contains systematic biases
   3. Enforcing legal requirements for data retention
   4. Deciding which diseases should be included in the dashboard

4. What does the lesson identify as a key limitation of using AI to generate surveillance SQL queries?

   1. AI cannot generate queries using window functions
   2. AI cannot write queries involving multiple JOIN operations
   3. AI cannot validate that the underlying data is clean and accurate
   4. AI cannot connect to cloud-based database systems

5. When AI generates a SQL query for measles surveillance, what should accompany the query for the methods section of a report?

   1. A list of alternative database systems that could be used
   2. Plain language annotations explaining each WHERE clause
   3. A recommendation for the dashboard color scheme
   4. A Python script to run the query automatically

6. An epidemiologist receives an AI-generated query that correctly identifies measles cases by week and age band. However, the published dashboard shows a county with 3 confirmed cases. What is the most likely problem?

   1. The AI used the wrong case definition version
   2. The query returned zero results but was displayed incorrectly
   3. Small-cell suppression was not applied before publication
   4. The database connection timed out during execution

7. A health department asks AI to generate a query for their surveillance database. The AI produces a complex query with multiple subqueries. What should the epidemiologist verify before using this query in production?

   1. That the query can be converted to Excel formulas
   2. That the query uses the most recent SQL standard
   3. That each WHERE clause correctly implements the case definition criteria
   4. That the database has at least 1 million records

8. The lesson notes that AI can suggest pivot and aggregation patterns an epidemiologist may not know. What is an example of this capability?

   1. AI recommends storing data in a new table structure
   2. AI suggests using ROLLUP to generate weekly, monthly, and yearly summaries in one query
   3. AI decides which employees should have database access
   4. AI writes the privacy policy for the health department

9. Why is the CSTE case definition important when generating measles surveillance SQL?

   1. It specifies exactly which SQL keywords to use
   2. It calculates the budget for the surveillance project
   3. It determines which database vendor to use
   4. It provides the clinical and laboratory criteria that define a confirmed case

10. What is the purpose of a surveillance database in public health?

    1. To backup electronic health records from hospitals
    2. To systematically collect health data for monitoring disease trends
    3. To store employee payroll information
    4. To host the public-facing health department website

11. An AI generates a SQL query and includes comments explaining that a particular condition implements 'laboratory-confirmed IgM positivity.' What is the purpose of this annotation?

    1. To document which part of the case definition the condition implements
    2. To prevent SQL injection attacks
    3. To format the output for chart display
    4. To improve query execution speed

12. A junior epidemiologist asks why they can't just let AI decide what to display on the public measles dashboard. What is the best response?

    1. AI cannot access the internet to see what other jurisdictions display
    2. AI generates dashboards faster than humans can review them
    3. AI will always choose to show more data for transparency
    4. AI lacks the legal authority to make public health communication decisions

13. What distinguishes a confirmed measles case from a probable case in standard epidemiological case definitions?

    1. Confirmed cases are counted differently by insurance
    2. Confirmed cases require hospitalization
    3. Confirmed cases are reported faster
    4. Confirmed cases must have laboratory verification

14. An AI generates a query that returns measles cases by week, age band, and vaccination status. The epidemiologist notices the query returns cases with 'unknown' vaccination status. What should the epidemiologist consider?

    1. Whether the AI should be replaced with a different tool
    2. Whether the query syntax is valid SQL
    3. Whether the database needs to be replaced entirely
    4. Whether unknown status should be included or excluded based on the case definition

15. The lesson mentions that AI can generate visualization configuration for tools like Tableau or Power BI. What is the primary benefit of this capability?

    1. It eliminates the need for any human involvement in dashboard creation
    2. It automatically publishes the dashboard to the internet
    3. It speeds up the process of connecting query results to visual representations
    4. It guarantees the dashboard will be accessible to people with disabilities