1. Imtixaanka 70-461 – Querying ee Server Microsoft SQL 2012 : Microsoft Certified ee Business Sirdoonka

The first exam tests your ability to query a Microsoft Server SQL 2012, taas oo macnaheedu yahay in ay inta badan tijaabin doonaa aqoonta SQL aad.

The soo socda ayaa xirfadaha qiyaasay:

  • Create waxyaabaha database (24%)
    • Shaxan – Bedelo; SEEXO; Column bedelo; SAMEYSO
    • Views – SAMEYSO, Bedelo, SEEXO
    • Nidaamka iyo Functions
    • Qasab ah – qeexo caqabadaha; caqabadaha u gaarka ah; caqabadaha default; Furaha hoose iyo kuwa shisheeye
    • DML Kiciyaasha – kiciya nested; nooc ka mid ah waxyaabaha kiciya; update hawlaha; xamili saf badan kalfadhi; saamaynta waxqabadka kiciya
  • La shaqee xogta (27%)
    • Select
    • Sub Wixii su'aalo ah – qorshaha su'aal; Pivot iyo unpivot; codsan shaqaale; war CTE; bayaanka
    • Noocyada Data – Isticmaalka nooc data, saameynta GUID (isbedelka, newsequentialid) on qaab database
    • Weydiimo Aggregate – Hawlaha analytic Cusub; nooc kooxaynta; celceliyo la ollogga; codsan hawlaha darajada
    • Su'aal iyo maareeyo xogta XML
  • Dib u habeynta xogta (24%)
    • Abuur iyo bedelo nidaamka kaydiyo
    • Dib u habeynta xogta adigoo isticmaalaya INSERT, UPDATE, iyo Delete statements
    • MIDOWGA iyo MIDOWGA ALL
    • Shaqo la hawlaha – Faham deterministic, hawlaha aan deterministic; scalar iyo miiska qiyamka; dabiqi karin dhisay-in hawlaha scalar; abuuro iyo bedelo hawlaha user-qeexay (UDFs)
  • Dhibta iyo tayadoodii
    • Tayadoodii weydiimo – Faham statistics; akhri qorshaha su'aal; hagtaa; DMVs; Tilmaamo; statistics Ports; dynamic vs. weydiimo parameterized; qeexaan noocyada kala duwan ee ku biiro (HASH, Midowdo, Loop) iyo tilmaamo sinnaariyooyinka iyaga la isticmaali lahaa in
    • Maareyn karaan dhaqdhaqaaqa – Waxaad calaameysaa jibinayaa; fahmi kartaa bilaabi abdi, samayn, iyo soo celiyo; awaamiir vs dhaqdhaqaaqyadii ugu cad; heerarka go'doomin; baaxadda iyo nooca qufulo; trancount
    • Qiimee isticmaalka hawlgallada isku xigta ku salaysan vs. dhigay ku salaysan hawlaha – Marka si ay u isticmaalaan cursors; saameynta UDFs scalar; isu geeyo hawlgallada DML badan
    • Hirgeli qalad u maaraysay – Hirgeli Isku day / qabsado / tuuro; ku salaysan isticmaalka set halkii ay isku xigta ku salaysan macquulka ah; maamulka macaamilka ganacsi

Number of Su'aalo: 45-55
Nooca Su'aalo: Choice Multiple (Qabto su'aalo scernario May)
Score Gudbinta: 700 (This does not mean 70%. Each question is given a score.)
Time Limit: 120 daqiiqo

Back to main menu

Leave a Reply