Abinitio Fundamental Quiz - Part 1

25 Questions | Total Attempts: 4423

SettingsSettingsSettings
Please wait...
Abinitio Fundamental Quiz - Part 1

This quiz (Part1) tests our basic understanding and knowledge in AbInitio. You may take AbInitio Fundamental Quiz - Part 2 also. Good Luck.


Questions and Answers
  • 1. 
    What are the different types of parallelism in AbInitio?
    • A. 

      Process parallelism, Data parallelism, Component parallelism

    • B. 

      Phase parallelism, Component parallelism, Pipeline parallelism

    • C. 

      Component parallelism, Data parallelism, Pipeline parallelism

    • D. 

      None of the above

  • 2. 
    Replicate component supports which type of Parallelism?
    • A. 

      Data Parallelism

    • B. 

      Component Parallelism

    • C. 

      Pipeline Parellelism

    • D. 

      All of the above

  • 3. 
    What is component parallelism?
    • A. 

      A graph with multiple processes running simultaneously on separate data uses component parallelism.

    • B. 

      A graph that deals with data divided into segments and operates on each segment simultaneously uses component parallelism

    • C. 

      A graph with multiple phases running simultaneously on separate data uses component parallelism.

    • D. 

      A graph with multiple components running simultaneously on the same data

  • 4. 
    What is the notation to specify the URL of a layout?
    • A. 

      Hostname/path/

    • B. 

      Protocol://hostname/path

    • C. 

      Path

    • D. 

      None of the above

  • 5. 
    A configuration file contains the following information:
    • A. 

      The name and version number of the database to which you want to connect

    • B. 

      The name of the computer on which the database instance or server to which you want to connect runs, or on which the database remote access software is installed

    • C. 

      The name of the database instance, server, or provider to which you want to connect

    • D. 

      You generate a configuration file by using the Properties dialog box for one of the Database components

    • E. 

      All of the above

  • 6. 
    For which join type the record-required parameter is used?
    • A. 

      Inner join

    • B. 

      Outer join

    • C. 

      Explicit join

    • D. 

      All of the above

  • 7. 
    Which of the following components need a sorted input?
    • A. 

      Merge

    • B. 

      Interleave

    • C. 

      Gather

    • D. 

      All of the above

  • 8. 
    How is reject-threshold calculated using limit and ramp?
    • A. 

      Ramp * limit + number of records processed so far

    • B. 

      Ramp + (limit * number of records processed so far)

    • C. 

      Limit + (ramp * number of records processed so far)

    • D. 

      Limit/ramp + number of records processed so far

  • 9. 
    What is the maximum number of input ports a join components can have?
    • A. 

      Only one

    • B. 

      2

    • C. 

      4

    • D. 

      20

  • 10. 
    What does the max-core parameter refer to?
    • A. 

      The maximum memory the component can use

    • B. 

      The maximum CPU utilization the component can use

    • C. 

      The maximum time limit the component can use

    • D. 

      The maximum number of rejects the component can alllow

  • 11. 
    Select the correct/true statement from below:
    • A. 

      The transform() parameter of a component cannot be used to specify the select criteria for the records

    • B. 

      Trash component can be used to capture and view the Log Information

    • C. 

      Start scripts manage tasks such as renaming output files

    • D. 

      Gather component is used to append records from multiple flows arbitrarily

  • 12. 
    What does layout of a component mean?
    • A. 

      The place where the component works

    • B. 

      The depth of parallelism

    • C. 

      Number of partitions

    • D. 

      All of the above

  • 13. 
    Which component produces intermediate summary records while aggregating?
    • A. 

      Roll up

    • B. 

      Scan

    • C. 

      Aggregate

    • D. 

      All of the above

  • 14. 
    Which component saves the status information among the following components?
    • A. 

      Phases

    • B. 

      Check points

    • C. 

      Phase breaks

    • D. 

      Commit

  • 15. 
    Which component gives sorted output?
    • A. 

      Merge

    • B. 

      Sort

    • C. 

      Rollup

    • D. 

      All of the above

  • 16. 
    Which of the following has got a deselect port?
    • A. 

      Filter

    • B. 

      Join

    • C. 

      Sort

    • D. 

      Reformat

  • 17. 
    Which component among the following is the most efficient?
    • A. 

      Concatenate

    • B. 

      Interleave

    • C. 

      Gather

    • D. 

      Merge

  • 18. 
    What does a redefine component do?
    • A. 

      It changes the value of the data records according to expression

    • B. 

      It renames the fields in record format and changes its value according to expression

    • C. 

      It renames the fields in the record format without changing its value

    • D. 

      It copies the data records from its input to output record format and changes its values accourding to key expression.

  • 19. 
    Why a gather component is used?
    • A. 

      To reduce data parallelism

    • B. 

      To reduce component parallelism

    • C. 

      To reduce both data parallelism and component parallelism

    • D. 

      None of the above

  • 20. 
    What is the maximum value allowed for max-core?
    • A. 

      2³¹-1

    • B. 

      2²¹-1

    • C. 

      2¹¹-1

    • D. 

      No limit

  • 21. 
    Using which component we can specify the rate of data movement from input to output?
    • A. 

      Throttle

    • B. 

      Fuse

    • C. 

      Scan

    • D. 

      Sample

  • 22. 
    Which of the following component will you use to parse programatically?
    • A. 

      Run program

    • B. 

      Readraw

    • C. 

      Reformat

    • D. 

      Run sql

  • 23. 
    Which parameter specifies the components tolerence for reject events?
    • A. 

      Reject port

    • B. 

      Reject-threshold parameter

    • C. 

      Max-core parameter

    • D. 

      Log-reject parameter

  • 24. 
    How can an explicit join perform inner join?
    • A. 

      Record required parameter for both ports are set to false

    • B. 

      Record required parameter for both ports are set to true

    • C. 

      Record required parameter for port0 is set to true and other port is set to false

    • D. 

      Record required parameter for port0 is set to false and other port is set to true

  • 25. 
    Which one of the following is a miscellaneous component?
    • A. 

      Broadcast

    • B. 

      Merge

    • C. 

      Trash

    • D. 

      Denormalize

Related Topics
Back to Top Back to top