Wednesday 2 September 2015

Latest Top ETL Testing Multiple Choice Questions And Answers

21    Two methods to ensure data integrity.
A.    Sources, Transformation, Destination
B.    Data inspection
C.   Row Count Inspection, Data Inspection
D.   Row Count Inspection
Ans:  C

22    Transformation
A.    Data is pulled from multiple sources to be merged into one or more destinations.
B.      It is used to import text files for ETL processing.
C.     Process to move data from a source to destination.
D.     It is used to massage data in transit between the source and destination.
Ans:  D

23    Three common usages of ETL.
A.  Data Scrubbing
B.    Sources, Transformation, Destination
C.     Merging Data
D.    Merging Data, Data Scrubbing, Automation
Ans:  D

24     Load in Parallel
A.  A value of delimited shou;d be selected for delimited files.
B.    Data is pulled from multiple sources to be merged into one or more destinations.
C.  This will reduce the run time of ETL process and reduce the window for hardware failure to affect the process.
D.  this should be check if column name have been included in the first row of the file.
Ans:  C

25   This can be computationally expensive excluding SSD.
A. Hard Drive I/O
B.   Mainframe
C.  Tool Suite
D. Data Scrubbing
Ans:  A

26   A value of delimited shou;d be selected for delimited files.
A.  Sort
B.   Format
C.  String
D.  OLTP
Ans:  B

27   this should be check if column name have been included in the first row of the file.
A.   Row Count Inspection, Data Inspection
B.    Format of the Date
C.   Column names in the first data row checkbox
D.     Do most work in transformation phase
Ans:  C

More Questions & Answers:-
Page1 Page2 Page3 Page4 Page5

No comments:

Post a Comment