MSBI Objective type Questions and Answers pdf download

11.       Explain ETL process?
A. Extract, Translation, Loading. 
  B. Extract, Transformation , Loading 
  C. Both a and b.
  D. None.
Ans: b 

12.       Difference between for loop and for each loop container?
A. For loop based on conditions and for each loop based on objects collections.
  B. For loop based on objects collections and for each loop based on objects collections.
  C. None.
  D. Both a and b.
Ans: a 

13.       What does a control flow do?
  A. To control workflow. 
  B. To control events.
  C. To control data flows.
  D. To control lookup.
Ans: a

14.       Explain event handlers? 
  A. To handle data validations. 
  B. To handle errors.
  C. To handle events. 
  D. None.
Ans: c 

15.       SSIS 2008 configuration types?
  A. Five. 
  B. Four.
  C. Three.
  D. One.
Ans: a 

16.       Define Lookup transformation?
  A. Used as reference table. 
  B. Used as master table.
  C. Used as fact table
  D. None.
Ans: a 

17.       Define synchronous transformations?
A. Input rows count and Output rows count are same. 
  B. Input rows count and Output rows count are not same.
  C. None.
  D. Input rows count and Output rows count are different.
Ans: a

18.       How to rename file using SSIS tasks?
  A. Using lookup. 
  B. Using Data flow.
  C. Using File system task. 
  D. None.
Ans: c 

19.       What does mean by data auditing?
  A. To maintain data load statistics in ETL process. 
  B. To know the errors.
  C. To know the Primary keys.
  D. None.
Ans: a 

20.       How many container tasks available in SSIS?
  A. One. 
  B. Two.
  C. Three.
  D. Four. 
Ans: d 
Read More Posts =>

Part1 Part2 Part3 Part4 Part5 Part6