Design a Schema to Support Cube Architecture

Practice Labs Module
Time
30 minutes
Difficulty
Intermediate

The "Design a Schema to Support Cube Architecture" module provides you with the instruction and Server hardware to develop your hands on skills in the defined topics. This module includes the following task: Schema for Cube Architecture.

Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

Overview

Introduction

The Design a Schema to Support Cube Architecture 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:

  • Schema for Cube Architecture

Exercise 1 - Design a Schema for Cube Architecture

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

  • Multi-dimensional modelling from a star schema
  • Relational modelling for a data source view
  • Choose or create a topology
  • Identify the appropriate data types with correct precision and size
Learning Partner
Comprehensive Learning

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