ETL Testing Multiple Choice Questions And Answers

11    Mainframe systems use this. This requires a conversion to the more common ASCII format.
A.     ETL
B.      XML
C.     Sort
D.     EBCDIC
Ans:  D

12      Ultimate flexibility, unit testing is available, usually poor documentation.
A.     ETL
B.     Custom
C.     OLTP
D.     Sort
Ans:  B

13      Conditional Split
A.  Many routines of the Mainframe system are written in this.
B.    Data is pulled from multiple sources to be merged into one or more destinations.
C.    It allows multiple streams to be created from a single stream. Only rows that match the criteria for a given path are sent down that path.
D.    This is used to create multiple streams within a data flow from a single stream. All records in the stream are sent down all paths. Typically uses a merge-join to recombine the streams later in the data flow.
Ans:  C

14     Flat files
A.  The easiest to consume from the ETL standpoint.
B.    Three components of data flow.
C.   Three common usages of ETL.
D.    Two methods to ensure data integrity.
Ans:  A

15     This is used to create multiple streams within a data flow from a single stream. All records in the stream are sent down all paths. Typically uses a merge-join to recombine the streams later in the data flow.
A.  OLTP
B.    Mainframe
C.   EBCDIC
D.   Multicast
Ans:  D

More Questions & Answers:-
Page1 Page2 Page3 Page4 Page5