SSAS Basics Quiz

Description: SSAS Basics Quiz
Number of Questions: 6
Created by:
Tags: ssas
Attempted 0/6 Correct 0 Score 0

What is Microsoft SQL Server 2005 Analysis Services used for?

  1. Delivers online analytical processing (OLAP)

  2. Delivers data mining functionality

  3. Both 1 and 2

Correct Option: C

_________________ Feature is used to copy database from one source server to a destination server.

  1. Synchronization

  2. Replication

  3. Collation

  4. Copy

Correct Option: B

What is the source of the OLAP cube’s metadata?

  1. Star schema

  2. Snow flake schema

  3. Both a and b

  4. Database

Correct Option: C

What are the applications of OLAP?

  1. Business reporting for sales and marketing

  2. Budgeting

  3. Forecasting

  4. All of the above

Correct Option: D

The basic unit of storage and analysis in Analysis Services is __________

  1. Dimension

  2. Cube

  3. Fact

  4. None

Correct Option: B
- Hide questions