Kedis ku xidhan hagaha · Adag Heerka

AI ee Falanqeeyaha Xogta Kediska

Tijaabooyin AI-qorshay SQL khataraha sida ku biirista taageere-out, hababka lagu hubiyo falanqaynta AI, iyo sababta schema macnaha guud iyo qoraallada la soo saari karo muhiim.

Wadooyinka haga ee la xidhiidhaAI ee Falanqeeyayaasha Xogta
Su'aal 1 ee 8

Maxay ahayd sifada falanqaynta xogta ChatGPT markii hore la odhan jiray, maxayse qabataa?

Horudhac su'aal kasta8 su'aalo

Jawaabaha iyo sharraxaadaha waxay soo baxayaan markaad qaadanayso kediska.

  1. Maxay ahayd sifada falanqaynta xogta ChatGPT markii hore la odhan jiray, maxayse qabataa?
    • 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. Maxaa dhacaya marka weydiintu ku biirto furaha aan gaarka ahayn?
    • All null values are dropped
    • Time zone problems are fixed
    • Rows are duplicated and totals are inflated
    • The query runs faster
  3. Muxuu samayn karaa moodalku marka aanu garanayn qorshahaaga?
    • Invent plausible column or table names
    • Refuse to write any SQL
    • Always ask a clarifying question first
    • Return an empty result
  4. Qaabkee hubinta ayaa hagaha ku talinaya natiijooyinka AI-abuuray?
    • 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. Muxuu Simpson's paradox qeexayaa?
    • 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?
    • Had iyo jeer aad bay u gaaban yihiin
    • 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