Guide-yakabatana mibvunzo · Zvakaoma Nhanho

AI yeData Analysts Quiz

Miedzo AI-yakadhirowewa SQL njodzi sekujoinha fan-out, nzira dzekutarisa AI ongororo, uye nei schema mamiriro uye reproducible scripts zvine basa.

Nzira dzekutungamira dzinoenderanaAI Yevaongorori veData
Mubvunzo 1 ye 8

What was ChatGPT's data analysis feature originally called, and what does it do?

Tarisa mubvunzo wese8 mibvunzo

Mhinduro uye tsananguro zvinoonekwa paunenge uchitora bvunzo.

  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?
    • Vanogara vari vapfupi
    • 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