Do You Know How To Do Business?

20 Questions
Business Quizzes & Trivia

Total Questions=20

Sample Question

Define Lookup transformation?

Used as reference table.

Used as master table.

Used as fact table

None.

Number of Questions:

More Options
Please wait...
Questions and Answers
  • 1. 
     Define Lookup transformation?
    • A. 

      Used as reference table.

    • B. 

      Used as master table.

    • C. 

      Used as fact table

    • D. 

      None.

  • 2. 
     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. 

      Input rows count and Output rows count are different.

    • D. 

      None.

  • 3. 
    How to rename file using SSIS tasks?
    • A. 

      Using lookup.

    • B. 

      Using Data flow.

    • C. 

      Using File system task

    • D. 

      None.

  • 4. 
    • A. 

      To maintain data load statistics in ETL process.

    • B. 

      To know the errors.

    • C. 

      To know the Primary keys.

    • D. 

      None

  • 5. 
     How many container tasks available in SSIS?
    • A. 

      One.

    • B. 

      Two.

    • C. 

      Three.

    • D. 

      Four.

  • 6. 
    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.

  • 7. 
    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.

  • 8. 
    MDX stands?
    • A. 

      Memory, Distribution, extensions.

    • B. 

      Memory, dimension, expressions.

    • C. 

      Multi, dimension, expressions.

    • D. 

      None

  • 9. 
    DSV stands?
    • A. 

      Data source View.

    • B. 

      It is view.

    • C. 

      It has relationships and metadata.

    • D. 

      All above.

  • 10. 
     How many types of actions available in the Cube?
    • A. 

      One.

    • B. 

      Two.

    • C. 

      Three.

    • D. 

      None.

  • 11. 
     What do you understand by dynamic named set (SSAS 2008)? 
    • A. 

      To create dynamic set of members.

    • B. 

      To create set of members.

    • C. 

      Both a and b.

    • D. 

      None

  • 12. 
     In which scenario, you would like to go for materializing dimension?
    • A. 

      To increase speed.

    • B. 

      To decrease memory size.

    • C. 

      Both.

    • D. 

      None

  • 13. 
     What are different storage mode options?
    • A. 

      MOLAP, HOLAP and ROLAP.

    • B. 

      Process modes.

    • C. 

      Process options.

    • D. 

      None.

  • 14. 
    • A. 

      Using BIDS.

    • B. 

      Using SSMS.

    • C. 

      Using XMLA.

    • D. 

      All the above.

  • 15. 
    • A. 

      To create files.

    • B. 

      To create tables.

    • C. 

      To create Reports.

    • D. 

      None.

  • 16. 
    • A. 

      To create reports.

    • B. 

      To create reports for users.

    • C. 

      Business users create reports.

    • D. 

      None

  • 17. 
    Explain report model in SSRS 2008? 
    • A. 

      Model used by Report Builder.

    • B. 

      Model used by reports.

    • C. 

      Both.

    • D. 

      None

  • 18. 
    How many architecture components of SSRS 2008?
    • A. 

      Five.

    • B. 

      Six.

    • C. 

      Seven.

    • D. 

      None.

  • 19. 
     Explain on SSRS2008 Reporting Items?
    • A. 

      Tablix,Chart,List

    • B. 

      Sub Report.

    • C. 

      Both A and B.

    • D. 

      None

  • 20. 
    How many command line utilities of SSRS2008?
    • A. 

      Three.

    • B. 

      Four.

    • C. 

      One.

    • D. 

      None