1. Ukuhlolwa 70-461 – Querying iseva Microsoft SQL 2012 : Microsoft Aqinisekisiwe e Business Intelligence

The first exam tests your ability to query a Microsoft SQL Server 2012, okusho uzophiwa ikakhulu avivinye SQL benu ulwazi.

Lokhu okulandelayo amakhono kulinganiswa:

  • Yakha yetintfo egciniwe (24%)
    • Amatafula – Alter; Drop; Alter ikholomu; UKUVULA
    • Views – UKUVULA, Alter, Drop
    • Izinqubo kanye Imisebenzi
    • Ngenkani – ichaze izingqinamba; izingqinamba eziyingqayizivele; ezizenzakalelayo izingqinamba; keys aphansi futhi angaphandle
    • DML izibangeli – izinto izidleke; izinhlobo izinto; buyekeza imisebenzi; yokusingatha imigqa multiple in a session; ukusebenza okushiwo izinto
  • Sebenza nge idatha (27%)
    • KHETHA
    • Imibuzo Sub – query amapulani; le-pivot and unpivot; zisebenza opheretha; cte Isitatimende; nge sitatimende
    • Data Izinhlobo – Usebenzisa izinhlobo idatha, umthelela GUID (ushintsho, newsequentialid) on database ukusebenza
    • Imibuzo sesisonke – New ahlaziye imisebenzi; amaqoqo behlukanisa; ngekwendzawo lokubolekwa; zisebenza imisebenzi usezingeni
    • Izikhalazo kanye uphathe idatha XML
  • Shintsha idatha (24%)
    • Yakha futhi ushintshe izinqubo egcinwe
    • Guqula idatha ngokusebenzisa Faka, WAMUVA, futhi susa izitatimende
    • Union INYUNYANA BONKE
    • Work nemisebenti – Qonda deterministic, Imisebenzi non-deterministic; scalar and ithebula namagugu; isicelo eyakhelwe-in nemisebenzi scalar; udale futhi ushintshe imisebenzi ezichazwe umsebenzisi (UDFs)
  • Xazulula inkinga nokwandisa
    • Nokwandisa imibuzo – Qonda izibalo; funda query amapulani; plan Abaqondisi; DMVs; izinkomba; statistics IO; ashukumisayo vs. Imibuzo parameterized; zichaza ezahlukene ukujoyina izinhlobo (Hashi, Hlanganisa, LOOP) futhi bachaza ngezimo babengeke lisetshenziswe
    • Phatha Transactions – Eziwuphawu ukuthengiselana; baqonde uqale tran, yenza, kanye rollback; ngokuphelele vs ukuthengiselana ezicacile; amazinga ngabodwa; Ububanzi uhlobo izingidi; trancount
    • Linganisa ukusebenzisa imisebenzi irowu-based vs. setha esekelwe imisebenzi – Lapho ukusebenzisa cursors; umthelela UDFs scalar; sihlanganise okuphindiwe DML imisebenzi
    • Nokuqalisa Iphutha yokuphatha – Ukuqalisa Zama / catch / nokujikijela; Ukusetshenziswa setha elisekelwe kunokuba logic irowu esekelwe; transaction Ukuphathwa

Number of Imibuzo: 45-55
Uhlobo Imibuzo: Choice Multiple (Kungenzeka unemibuzo scernario)
Score ezidlulayo: 700 (This does not mean 70%. Each question is given a score.)
Isikhathi Linganisela: 120 imizuzu

Emuva menu main

Shiya impendulo