1.
Difference
b/w SSAS and AS 2000.
2.
Fact table
and dimension table
3.
Data Sources
& Data Source Views -
4.
Cube
Dimensions
a.
Standard
Dimension
b.
Time
Dimension
c.
Parent-Child
Dimension
5.
Measures
a.
Adding
Measure Group
b.
Measures
c.
Semi-Additive
Measures
d.
Distinct
Count
e.
Calculations
6.
Aggregations
7.
Partitions
8.
Hierarchies
- User Hierarchy, parent child hierarchy. What are user hierarchies and
attribute hierarchies?
9.
Dimension
Relationships – Dimension Usage Tab
10.
How do u
reference an attribute in VBScript – [$Student].[Personnel ID]
11.
Key
Performance Indicators (KPIs)
12.
Actions
13.
Perspectives
14.
Cube Browser
View
15.
Proactive
Caching
16.
Deploying/Processing
of Cube.
17.
Storage
Methods – MOLAP, ROLAP & HOLAP
18.
Error
handling/configurations
19.
NULL
Processing/Unknown Member
20.
Translations
21.
What type of
objects can u have in a DSV?
22.
What is the
difference between Star schema and Snowflake schema?
23.
What are the
basic things that you consider before designing a cube?
24.
How do you
improve performance of a SSAS OLAP DB?
25.
How do you
implement security in SSAS?
26.
What are
slowly changing dimensions (SCD)? When do you use them?
27.
What are the
different relationships used in dimension usage?
28.
How do you
process a single partition without processing other dimensions and measures in
production?
29.
What is fact-less-fact dimension? When do you
use such dimension?
30.
Explain
about calculated members and drill through actions.
