Muutke küpsiste eelistusi

Exam Ref 70-768 Developing SQL Data Models [Pehme köide]

4.08/5 (24 hinnangut Goodreads-ist)
  • Formaat: Paperback / softback, 384 pages, kõrgus x laius x paksus: 226x188x18 mm, kaal: 620 g
  • Sari: Exam Ref
  • Ilmumisaeg: 04-Jul-2017
  • Kirjastus: Microsoft Press
  • ISBN-10: 1509305157
  • ISBN-13: 9781509305155
Teised raamatud teemal:
Exam Ref 70-768 Developing SQL Data ModelsSuurem pilt
  • Formaat: Paperback / softback, 384 pages, kõrgus x laius x paksus: 226x188x18 mm, kaal: 620 g
  • Sari: Exam Ref
  • Ilmumisaeg: 04-Jul-2017
  • Kirjastus: Microsoft Press
  • ISBN-10: 1509305157
  • ISBN-13: 9781509305155
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9781509305155.html
Märksõnad:

Direct from Microsoft, this Exam Ref is the official study guide for the new Microsoft 70-768 Developing SQL Data Models certification exam, the second of two exams required for MCSA: SQL 2016 Business Intelligence Development certification.

 

Authored by Microsoft Data Platform MVP Stacia Varga, Exam Ref 70-768 Developing SQL Data Models offers professional-level preparation that helps candidates maximize their exam performance and sharpen their skills on the job. It focuses on the specific areas of expertise modern database and business intelligence professionals need to succeed with SQL Server 2016 Analysis Services. Coverage includes:

  • Designing multidimensional BI semantic models
  • Designing tabular BI semantic models
  • Developing queries using MDX and DAX
  • Configuring and maintaining SQL Server Analysis Services

Microsoft Exam Ref publications stand apart from third-party study guides because they:

  • Provide guidance from Microsoft, the creator of Microsoft certification exams
  • Target IT professional-level exam candidates with content focused on their needs, not "one-size-fits-all" content
  • Streamline study by organizing material according to the exam's objective domain (OD), covering one functional group and its objectives in each chapter
  • Feature Thought Experiments to guide candidates through a set of "what if?" scenarios, and prepare them more effectively for Pro-level style exam questions
  • Explore big picture thinking around the planning and design aspects of the IT pro's job role

For more information on Exam 70-768 and the MCSA: SQL 2016 Business Intelligence Development certification, visit microsoft.com/learning.

Introduction ix
Organization of this book x
Microsoft certifications x
Acknowledgments x
Microsoft Virtual Academy xi
Quick access to online references xi
Errata, updates, & book support xi
We want to hear from you xii
Stay in touch xii
Preparing for the exam xiii
Chapter 1 Design a multidimensional business intelligence (BI) semantic model
1(96)
Skill 1.1 Create a multidimensional database by using Microsoft SQL Server Analysis Services (SSAS)
2(34)
Design, develop, and create multidimensional databases
2(31)
Select a storage model
33(3)
Skill 1.2 Design and implement dimensions in a cube
36(41)
Select an appropriate dimension model, such as fact, parent-child, roleplaying, reference, data mining, many-to-many, and slowly changing dimension
36(30)
Implement a dimension type
66(3)
Define attribute relationships
69(8)
Skill 1.3 Implement measures and measure groups in a cube
77(13)
Design and implement measures, measure groups, granularity, calculated measures, and aggregate functions
77(11)
Define semi-additive behavior
88(2)
Chapter Summary
90(2)
Thought experiment
92(2)
Thought experiment answers
94(3)
Chapter 2 Design a tabular BI semantic model
97(74)
Skill 2.1 Design and publish a tabular data model
97(32)
Design measures, relationships, hierarchies, partitions, perspectives, and calculated columns
98(9)
Relationships
107(17)
Create a time table
124(1)
Publish from Microsoft Visual Studio
125(1)
Import from Microsoft PowerPivot
126(1)
Select a deployment option, including Processing Option, Transactional Deployment, and Query Mode
126(3)
Skill 2.2 Configure, manage, and secure a tabular model
129(26)
Configure tabular model storage and data refresh
129(9)
Configure refresh interval settings
138(5)
Configure user security and permissions
143(5)
Configure row-level security
148(7)
Skill 2.3 Develop a tabular model to access data in near real time
155(8)
Use DirectQuery with Oracle, Teradata, Excel, and PivotTables
155(7)
Convert in-memory queries to DirectQuery
162(1)
Chapter Summary
163(2)
Thought experiment
165(4)
Thought experiment answer
169(2)
Chapter 3 Develop queries using Multidimensional Expressions (MDX) and Data Analysis Expressions (DAX)
171(106)
Skill 3.1 Create basic MDX queries
171(35)
Implement basic MDX structures and functions, including tuples, sets, and TopCount
172(34)
Skill 3.2 Implement custom MDX solutions
206(16)
Create custom MDX or logical solutions for pre-prepared case tasks or business rules
206(13)
Define a SCOPE statement
219(3)
Skill 3.3 Create formulas by using the DAX language
222(46)
Use the EVALUATE and CALCULATE functions
223(14)
Filter DAX queries
237(9)
Create calculated measures
246(12)
Perform analysis by using DAX
258(10)
Chapter Summary
268(4)
Thought experiment
272(3)
Thought experiment answer
275(2)
Chapter 4 Configure and maintain SQL Server Analysis Services (SSAS)
277(72)
Skill 4.1 Plan and deploy SSAS
277(12)
Configure memory limits
278(5)
Configure Non-Union Memory Access (NUMA)
283(3)
Configure disk layout
286(1)
Determine SSAS instance placement
287(2)
Skill 4.2 Monitor and optimize performance
289(37)
Monitor performance and analyze query plans by using Extended Events and Profiler
290(15)
Identify bottlenecks in SSAS queries
305(1)
Monitor processing and query performance
305(3)
Resolve performance issues
308(11)
Configure usability limits
319(1)
Optimize and manage model design
320(6)
Skill 4.3 Configure and manage processing
326(12)
Configure partition processing
326(6)
Configure dimension processing
332(2)
Use Process Default, Process Full, Process Clear, Process Data, Process Add, Process Update, Process Index, Process Structure, and Process Clear Structure processing methods
334(2)
Configure Parallel, Sequential, and Writeback processing settings
336(2)
Skill 4.4 Create Key Performance Indicators (KPIs) and translations
338(6)
Create KPIs in multidimensional models and tabular models
338(2)
Configure KPI options, including Associated measure group, Value Expression, Goal Expression, Status, Status expression, Trend, Trend expression, and Weight
340(3)
Create and develop translations
343(1)
Chapter Summary
344(3)
Thought experiment
347(1)
Thought experiment answer
348(1)
Index 349
Stacia Varga, Microsoft Data Platform MVP since 2011, has been helping organizations and individuals succeed with SQL Server Analysis Services since it launched in SQL Server 2000. She has authored or coauthored multiple books about BI (as Stacia Misner), and co-authored Introducing Microsoft SQL Server 2016. Varga trains and consults through her company, Data Inspirations; speaks frequently at SQL Server events; and leads SQL Server Society of Las Vegas.