The Implement Storage Design in a Multidimensional Model module provides you with the instruction and Server hardware to develop your hands on skills in the defined topics. This module includes the following tasks:

  • Storage Design for Multidimensional model

Exercise 1 - Storage Design for Multidimensional Model

In this exercise, you will learn the following in Microsoft SQL Server 2012 R2:

  • Create aggregations
  • Create partitions, storage modes
  • Define proactive caching
  • Manage write-back partitions
  • Implement linked cubes
  • Implement distributed cubes

Comprehensive Learning

See the full benefits of our immersive learning experience with interactive courses and guided career paths.