Back
0

SSAS Basics Quiz

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

What is Microsoft SQL Server 2005 Analysis Services used for?

ssas

  1. Delivers online analytical processing (OLAP)

  2. Delivers data mining functionality

  3. Both 1 and 2

Show answer
Correct Option: C

_________________ 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
- Hide questions
ADVERTISEMENT

Find more quizzes from top tags

general knowledge
3615 Quizzes
119858 Questions
 technology
307 Quizzes
36705 Questions
 sports
961 Quizzes
19148 Questions
 history
1187 Quizzes
13475 Questions
 physics
550 Quizzes
11687 Questions
 biology
1078 Quizzes
11791 Questions
 science & technology
551 Quizzes
11015 Questions
 chemistry
462 Quizzes
9309 Questions
 maths
457 Quizzes
8210 Questions
 softskills
0 Quizzes
7131 Questions