Ab Initio Software Company Trivia Quiz!

50 Questions | Total Attempts: 4533

SettingsSettingsSettings
Please wait...
Ab Initio Software Company Trivia Quiz!

Ab Initio Software is an American multinational enterprise software corporation it specializes in high-volume data processing applications and enterprise application integration. Most techies are well informed about the products of this company, Test your knowledge of abinito by taking the simple quiz below. All the best as you tackle it.


Questions and Answers
  • 1. 
    Replicate supports which parallelism?
    • A. 

      Data parallelism

    • B. 

      Component parallelism

    • C. 

      ETL parallelism

    • D. 

      Pipeline parallelism

    • E. 

      All the above

  • 2. 
    Broadcast component support which parallelism?
    • A. 

      Data parallelism

    • B. 

      Component parallelism

    • C. 

      Pipeline parallelism

  • 3. 
    Which is the system admin which is installed in Unix or Windows NT?
    • A. 

      GDE

    • B. 

      CO>OP

    • C. 

      EME

    • D. 

      None of the above

  • 4. 
    Which compoment is advanced version of Aggregate?
    • A. 

      Scan

    • B. 

      Rollup

    • C. 

      Normalise

    • D. 

      Redefine

  • 5. 
    Types of Layout.
    • A. 

      $AI_SERIAL

    • B. 

      $AI_MFS

    • C. 

      A & B

    • D. 

      None of the above

  • 6. 
    Max core is used in which component?
    • A. 

      Sort

    • B. 

      Join

    • C. 

      Rollup

    • D. 

      All the above

    • E. 

      None of the above

  • 7. 
    Mx how many count values can be used in join component?
    • A. 

      10

    • B. 

      20

    • C. 

      30

    • D. 

      40

    • E. 

      50

  • 8. 
    Vector field is used in which component?
    • A. 

      Rollup

    • B. 

      Join

    • C. 

      Normalize

    • D. 

      Scan

    • E. 

      Reformat

  • 9. 
    Command to generate DML:
    • A. 

      M_dm .dml

    • B. 

      M_dump .dml

    • C. 

      M_db .dml

    • D. 

      M_db gendml

    • E. 

      None of the above

  • 10. 
    Which belongs to multistage component?
    • A. 

      Redefine

    • B. 

      Rollup

    • C. 

      Trash

    • D. 

      Multiple read

    • E. 

      Gather

  • 11. 
    Which belongs to de partition components
    • A. 

      Gather

    • B. 

      Partition by key

    • C. 

      Concatenate

    • D. 

      Broadcast

    • E. 

      None of the above

  • 12. 
    Relation of sandbox and project:
    • A. 

      1 sandbox, 1 project

    • B. 

      1 sandbox, multiple project

    • C. 

      Multiple sandbox, 1 project

  • 13. 
    Maximum how many components can be included in Phasing?
    • A. 

      5

    • B. 

      10

    • C. 

      15

    • D. 

      20

    • E. 

      25

  • 14. 
    How many inputs and how many outputs in join as default?
    • A. 

      1 input 1 output

    • B. 

      2 input 1 output

    • C. 

      2 input 2 output

    • D. 

      None of the above

  • 15. 
    What is the use of checkpoint?
    • A. 

      Re run the graph

    • B. 

      Recovery

    • C. 

      Stop the graph

    • D. 

      Abort the run

    • E. 

      None of the above

  • 16. 
    Which is used for version control?
    • A. 

      GDE

    • B. 

      CO>OP

    • C. 

      EME

    • D. 

      None of the above

  • 17. 
    Is it possible to run a graph without EME?
    • A. 

      YES

    • B. 

      NO

  • 18. 
    Is it possible to run a graph without co>op?
    • A. 

      Yes

    • B. 

      No

  • 19. 
    What are the ways of MFS?
    • A. 

      2

    • B. 

      3

    • C. 

      4

    • D. 

      8

    • E. 

      All the above

  • 20. 
    Are phasing and checkpoint interrelated?
    • A. 

      Yes

    • B. 

      No

  • 21. 
    Which component is used to avoid duplicate records?
    • A. 

      Rollup

    • B. 

      Dedup

    • C. 

      Join

    • D. 

      Redefine

    • E. 

      Replicate

  • 22. 
    Which is the partition component?
    • A. 

      Gather

    • B. 

      Replicate

    • C. 

      Broadcast

    • D. 

      Trash

    • E. 

      Leading record

  • 23. 
    Which is the advanced version of the Aggregate component?
    • A. 

      Replicate

    • B. 

      Normalize

    • C. 

      Rollup

    • D. 

      Filter by expression

  • 24. 
    When the graph is executed what happens?
    • A. 

      Dml

    • B. 

      Xfr

    • C. 

      Deployed script is generated

    • D. 

      Run

  • 25. 
    Which is a key based component?
    • A. 

      Merge

    • B. 

      Gather

    • C. 

      Concat

    • D. 

      Interleave

Related Topics
Back to Top Back to top