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
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.