MDX REAL TIME INTERVIEW QUESTIONS AND ANSWERS

MDX:

1. MDX in SQL Server 2005 Analysis Services brings exciting improvements including query support and expression/calculation language, Explain

MDX in SQL server 2005 Analysis services offers CASE and SCOPE statements. CASE returns specific values based upon its comparison of an expression to a set of simple expressions.

2. Explain about cross join in mdx?

3. How can we do Process Update through AMO?

4. How can identify, how many DB’s are in SQL Server through AMO?

5. What is the difference between a derived measure and a calculated measure?

6. What MDX functions do you most commonly use?

7. How in MDX query can I get top 3 sales years based on order quantity?

8. You want to use a perspective in an MDX query. How do you select the perspective?

9. What is Multi Dimensional Expressions?

10. What is MDX query and SSAS?

SSAS (COMMON QUESTIONS)

1)                  What is difference between Process Add and Process Update?

2)            What is the main use of attribute relationship?

3)            If we use process update, how ssas database identify particular record will be update?

4)            What are the storage modes? How we describe that?

5)            What is a RAGGED hierarchy?

6)            What are the roles of an Analysis Services Information Worker?

7)            What are the different ways of creating Aggregations?  

8)            What is WriteBack? What are the pre-conditions?

9)            What is processing?

10)          Name few Business Analysis Enhancements for SSAS?

11)          Where do you put calculated members?

12)          How do I find the bottom 10 customers with the lowest sales in 2003 that were not null?

13)          How do you extract first tuple from the set?

14)          Symbol philosophy?

15)          What is a measure group?

16)          User wants only to display only pdf as export option in report Manager. How to acheive this?

17)          What type of objects can u have in a DSV?

18)          How do you implement security in SSAS?

19)          If there are 5 facts and 50 dimensions tables tell me various scenarios who u link that and which is best method? How will u analyze which method will be perfect how u choose on which criteria’s?

20)          What is SMDL?

21)          Could you explain one task which you struggle a lot in your current project? And how did you achieve that task?