Implement Storage Design in a Multidimensional Model

Introduction

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