1. Exam 70-461 – Uinga i te Server Microsoft SQL 2012 : Microsoft whaimana i roto i te Business Intelligence

The first exam tests your ability to query a Microsoft Tūmau SQL 2012, e te tikanga, ka whakamatautau reira te nuinga o koutou te matauranga SQL.

Ko te whai ake nei te whanganga i nga pūkenga:

  • Waihanga ngā pātengi raraunga (24%)
    • Ripanga – ALTER; Maturuturu; ALTER COLUMN; FA'U
    • Views – FA'U, ALTER, Maturuturu
    • Ngā tukanga me ngā Taumahi
    • Whakaū – te tautuhi i herenga; herenga ahurei; herenga taunoa; mau taviri tuatahi me te ke
    • DML pāngia e – tāpae tauroto; momo o tāpae; mahi whakahou; hapai i nga rarangi maha i roto i te wātū; pānga mahi o tāpae
  • Mahi ki te raraunga (27%)
    • Tīpakohia
    • Uiui iti – mahere rapu; kaurori me te unpivot; te tono kaiwhakahaere; tauākī cte; ki te faahitiraa
    • Momo Raraunga – Mā te momo raraunga, pānga o takaua (huringa, newsequentialid) i runga i te mahinga pātengi raraunga
    • Uiui hiato – Mahi analytic New; huinga whakarōpū; Ngā mokowā; te tono rangatira mahi
    • Uiui, me te whakahaere i ngā raraunga XML
  • Whakakē raraunga (24%)
    • Waihanga me te whakarereketia ngā tukanga rongoatia
    • Whakakētia raraunga mā te whakamahi i WHAKAURUA, WHAKAHOU, a ka MUKU tauākī
    • UNION, ko UNION KATOA
    • Mahi ki te mahi – Kia mohio deterministic, mahi kore-deterministic; uara scalar me te tepu; ia faaohipa hanga-i roto i te mahi scalar; te waihanga me te whakaputa ke mahi tautuhi-kaiwhakamahi (UDFs)
  • Raparongoā ka arotautia
    • Arotau uiui – Kia mohio ngā tatauranga; tai'o mahere rapu; ārahi ana te māhere; DMVs; tīwhiri; ngā tatauranga IO; hihiri vs. uiui parameterized; whakaahua i te rerekē uru atu ngā momo (Hash, Hanumi, Koropiko) me te whakaahua i te wheako e whakamahia ratou i roto i
    • Whakahaere moni – Waitohutia te hoko; mohio timata tran, tukua atu nei e, me te huriwhakamuri; paruhi vs whakawhitinga rawa; taumata motuhake; te whānuitanga me te momo o raka; trancount
    • Te arotake i te whakamahi o ngā mahi e hāngai ana rarangi-vs. whakaturia ā-ngā mahi – A, no te ki te whakamahi Pehu; pānga o UDFs scalar; whakakotahi maha ngā mahi DML
    • Whakatinana hapa whāwhā – Whakatinana i piro / te hopu / taunga; whakamahi huinga e hāngai ana, kaua ki te rarangi e hāngai ana arorau; te whakahaere tauwhitinga

Tau o Pātai: 45-55
Momo o Pātai: Choice Maha (Kia whai pātai scernario)
Haere ana Score: 700 (This does not mean 70%. Each question is given a score.)
Time Tepe: 120 meneti

Hoki ki te tahua matua

Leave a Reply