AI for Data Analysts Quiz

Answers and explanations appear as you take the quiz.

1. What was ChatGPT's data analysis feature originally called, and what does it do?
   • Excel Copilot, which edits spreadsheets
   • Code Interpreter, which writes and runs Python on uploaded files
   • Tableau Pulse, which builds dashboards
   • SQL Studio, which hosts databases
2. What happens when a query joins on a non-unique key?
   • All null values are dropped
   • Time zone problems are fixed
   • Rows are duplicated and totals are inflated
   • The query runs faster
3. What may a model do when it does not know your schema?
   • Invent plausible column or table names
   • Refuse to write any SQL
   • Always ask a clarifying question first
   • Return an empty result
4. Which checking method does the guide recommend for AI-generated results?
   • Trust the result if the query ran without errors
   • Ask the AI whether its answer is correct
   • Rerun the query to make it faster
   • Reconcile against a known total, such as monthly revenue from the finance report
5. What does Simpson's paradox describe?
   • Nulls being counted twice
   • A time zone mismatch in dates
   • A trend in aggregated data reversing direction within subgroups
   • Charts exaggerating small differences
6. What risk does the guide flag in AI-written narrative reports?
   • They are always too short
   • They may state causation where the data only shows correlation
   • They refuse to summarize dashboards
   • They use too many charts
7. Why does the guide prefer asking AI for a cleaning script instead of cleaned data?
   • Scripts are always shorter
   • AI tools cannot output data
   • Pasted data is always larger than a script
   • A script can be inspected, rerun and version-controlled, while pasted output may contain silent alterations
8. What most improves text-to-SQL accuracy according to the guide?
   • Showing the schema: tables, column types, keys, example rows and business definitions
   • Writing shorter questions
   • Hiding table names for privacy
   • Typing the question in uppercase