Tag: ssas basics

Questions Related to ssas basics

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

ssas basics

  1. Synchronization

  2. Replication

  3. Collation

  4. Copy

Show answer
Correct Option: B

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

  1. Star schema

  2. Snow flake schema

  3. Both a and b

  4. Database

Show answer
Correct Option: C

What are the applications of OLAP?

ssas basics

  1. Business reporting for sales and marketing

  2. Budgeting

  3. Forecasting

  4. All of the above

Show answer
Correct Option: D

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

ssas basics

  1. Dimension

  2. Cube

  3. Fact

  4. None

Show answer
Correct Option: B

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

  1. Perspective

  2. Attribute

  3. Dimension

  4. All

Show answer
Correct Option: A