Alien head

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

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


Correct Option: A
+ View questions