MSBI SSIS-SSAS-SSRS Multiple choice Questions and Answers pdf download

21.       Define role play dimensions?
  A. One dimension used multiple times in the cube. 
  B. One dimension used in different cubes.
  C. Shared across cubes.
  D. None.
Ans: a

22.       Define dimension usage in SSAS Cube?
  A. To maintain cube data size. 
  B. To know the relationships between dimensions and fact. 
  C. To build business logic.
  D. None.
Ans: b 

23.       MDX stands?
  A. Memory, Distribution, extensions. 
  B. Memory, dimension, expressions.
  C. Multi, dimension, expressions. 
  D. None
Ans: c 

24.       DSV stands?
  A. Data source View. 
  B. It is view.
  C. It has relationships and metadata.
  D. All above. 
Ans: d 

25.       How many types of actions available in the Cube?
  A. One. 
  B. Two.
  C. Three. 
  D. None.
Ans: c 

26.       What do you understand by dynamic named set (SSAS 2008)?
  A. To create dynamic set of members. 
  B. To create set of members.
  C. None.
  D. Both a and b.
Ans: a 

27.       How many types of dimension are possible in SSAS?
  A. Four. 
  B. Five.
  C. Six. 
  D. Seven.
Ans: c 

28.       In which scenario, you would like to go for materializing dimension?
  A. To increase spee
  B. To decrease memory size.
  C. Both.
  D. None.
Ans: a 

30.       What are the options to deploy SSAS cube in production?
A. Using BIDS. 
  B. Using SSMS.
  C. Using XMLA.
  D. All the above. 
Ans: d 
Read More Posts =>

Part1 Part2 Part3 Part4 Part5 Part6