Implement Storage Design in a Multidimensional Model

Practice Labs Module
Time
30 minutes
Difficulty
Intermediate

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

Join over 3 million cybersecurity professionals advancing their career
Sign up with
Required fields are marked with an *
or

Already have an account? Sign In »

Overview

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
Learning Partner
Comprehensive Learning

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