Alien head

SSAS Basics Quiz

Description: SSAS Basics Quiz
Number of Questions: 6
Created by:
Tags: ssas

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

Answer: 3

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

  1. Synchronization

  2. Replication

  3. Collation

  4. Copy

Answer: 2

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

  1. Star schema

  2. Snow flake schema

  3. Both a and b

  4. Database

Answer: 3

What are the applications of OLAP?

  1. Business reporting for sales and marketing

  2. Budgeting

  3. Forecasting

  4. All of the above

Answer: 4

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

  1. Dimension

  2. Cube

  3. Fact

  4. None

Answer: 2

In Microsoft SQL Server Analysis Services (SSAS), a ____________ reduces the perceived complexity of a cube in Analysis Services.

  1. Perspective

  2. Attribute

  3. Dimension

  4. All

Answer: 1
+ View questions