1. Jarrabawa 70-461 – Querying da Microsoft SQL Server 2012 : Microsoft Certified a Business Intelligence

The first exam tests your ability to query a Microsoft SQL Server 2012, wanda yake nufin zai yafi jarraba ku SQL sani.

Wadannan suna da basira auna:

  • Create database abubuwa (24%)
    • Tables – Canza; Drop; Canza shafi; Create
    • Views – Create, Canza, Drop
    • Hanyoyin da Functions
    • Tilasta – ƙayyade constraints; musamman constraints; tsoho constraints; firamare da kuma kasashen waje keys
    • DML Triggers – nested triggers; iri triggers; ta karshe ayyuka; rike mahara layuka a wani taro; yi abubuwan da triggers
  • Aiki tare da bayanai (27%)
    • SELECT
    • Sub Queries – tambaya da tsare-tsaren; pivot da unpivot; shafi sadarwarka; cte bayani; tare da bayani
    • Data Types – Ta yin amfani da bayanai iri, bugu na GUID (canji, newsequentialid) on database yi
    • Tara queries – New na nazari ayyuka; grouping sets; na sarari aggregates; shafi ranking ayyuka
    • Tambaya da kuma sarrafa XML bayanai
  • Gyara bayanai (24%)
    • Create da kuma gyara man adana hanyoyin
    • Gyara bayanai ta amfani saka, UPDATE, da kuma share maganganun
    • UNION da UNION ALL
    • Aiki tare da ayyuka – Fahimci deterministic, wadanda ba deterministic ayyuka; scalar da kuma tebur dabi'u; Aiwatar gina-in scalar ayyuka; ƙirƙiri da kuma canza mai amfani-tsare ayyuka (UDFs)
  • Troubleshoot da kuma inganta
    • Inganta queries – Fahimci statistics; karanta tambaya da tsare-tsaren; shirin Ya shiryar; DMVs; alamu; statistics IO; tsauri vs. parameterized queries; bayyana daban-daban shiga iri (HASH, Ci, Madauki) da kuma bayyana hanyar al'amura za su iya amfani da
    • Sarrafa Ma'amaloli – Alama a ma'amala; fahimci fara Tran, aikata, da kuma rollback; a fakaice vs bayyane ma'amaloli; warewa matakan; ikon yinsa da kuma irin kwa'di; trancount
    • Kimanta da amfani da layi na tushen aiki vs. ya kafa tushen aiki – A lokacin da yin amfani da cursors; bugu na scalar UDFs; hada mahara DML aiki
    • Yi kuskure tarbiyyar – Aiwatar gwada / kama / jħfa; amfani sa bisa maimakon jere bisa dabaru; ma'amala management

Yawan Tambayoyi: 45-55
Irin Tambayoyi: Mahara Choice (Zan iya samun scernario tambayoyi)
Wucewa Score: 700 (This does not mean 70%. Each question is given a score.)
Time Yawan: 120 minutes

Back to main menu

Leave a Reply