1. Exam 70-461 – Querying lub Microsoft SQL neeg rau zaub mov 2012 : Microsoft Certified nyob rau hauv Lag luam txawj ntse

The first exam tests your ability to query a Microsoft SQL neeg rau zaub mov 2012, uas txhais tau tias nws yuav mas kuaj koj cov kev txawj ntse SQL.

Cov nram no yog cov kev txawj ntsuas:

  • Tsim database khoom (24%)
    • Ntxhuav – Hloov; TEE; Hloov lub kem; Tsim
    • Views – Tsim, Hloov, TEE
    • Cov txheej txheem thiab kev khiav dej num
    • Yuam – txhais tuav tseg; cim tuav tseg; neej ntawd tuav tseg; thawj thiab txawv teb chaws yuam sij
    • DML mob – nested chiv; hom chiv; update zog; lis ntau kab nyob rau hauv ib tug kev sib kho; kev ua tau zoo uas siv cov chiv
  • Ua hauj lwm nrog cov ntaub ntawv (27%)
    • Xaiv
    • Sub lus nug – query kev npaj; pivot thiab unpivot; thov neeg teb xov tooj; CTE daim ntawv qhia; nrog daim ntawv qhia
    • Cov ntaub ntawv Hom – Siv cov ntaub ntawv hom, feem ntawm GUID (kev hloov, newsequentialid) on database kev ua tau zoo
    • Aggregate lus nug – Tshiab analytic zog; grouping poob lawm; ntsig txog aggregates; thov duas zog
    • Lus nug thiab tswj cov ntaub ntawv XML
  • Hloov cov ntaub ntawv (24%)
    • Tsim thiab hloov cov txheej txheem cia
    • Hloov cov ntaub ntawv los ntawm kev siv INSERT, Hloov tshiab, thiab RHO TAWM nqe lus
    • Union thiab Union TXHUA
    • Ua hauj lwm nrog kev khiav dej num – To taub deterministic, uas tsis yog-deterministic zog; scalar thiab rooj qhov tseem ceeb; Thov built-nyob rau hauv scalar zog; tsim thiab hloov muab neeg siv txhais zog (UDFs)
  • Troubleshoot thiab optimize
    • Optimize lus nug – To taub statistics; nyeem lus nug kev npaj; txoj kev npaj ntawm cov; DMVs; piv txwv; statistics IO; dynamic vs. parameterized lus nug; piav qhia txog qhov sib txawv tuaj koom nrog hom (Hash, Hauj lwm ua ke, Loop) thiab piav qhia txog cov scenarios lawv yuav siv nyob rau hauv
    • Tswj muas – Kos ib tug lw; to taub pib tran, txhaum, thiab rollback; Implicit vs tsi ntsees muas; rho tawm theem; Scope thiab hom xauv; trancount
    • Soj ntsuam kev siv cov kab-based ua hauj lwm vs. teem-based ua hauj lwm – Thaum siv cursors; feem ntawm scalar UDFs; ua ke ntau DML ua hauj lwm
    • Kev yuam kev tuav – Kev zaug / catch / muab; siv teeb raws li es tsis kab raws logic; lw kev tswj

Xov tooj ntawm cov lus nug: 45-55
Hom Lus nug: Multiple Xaiv (Tej zaum yuav muaj cov lus nug scernario)
Dua cov qhab-nees: 700 (This does not mean 70%. Each question is given a score.)
Lub sij hawm Tsis txhob: 120 feeb

Rov qab mus rau lub ntsiab zaub mov

Sau ntawv cia Ncua