Multiple choice technology platforms and products

Select ALL that are in scope of coding & unit testing for an ETL job

  1. Validation of all negative scenarios like handling of incorrect data type

  2. Testing the boundaries of each field to find any limitations

  3. Job not to be aborted at any cause - all abort scenarios must be handled in the code

  4. Cleansing of obvious data for any anomalies (even if its not specified in requirements)

  5. None of the above
Reveal answer Fill a bubble to check yourself
A,B Correct answer
Explanation

Coding and unit testing for ETL jobs must include validating negative scenarios (A) and testing field boundaries (B). Option C is incorrect because jobs SHOULD abort on unrecoverable errors - not all abort scenarios can or should be handled. Option D is out of scope - unit testing should not include unspecified data cleansing.

Keep practicing — related questions