This interview questionnaire consists of three components and has been structured using tools tailored to the requirements of the position we aim to fulfill: Two CSV data transformation methods and performance benchmarking. Demonstrate your coding, testing, and benchmarking skills, using Visual Studio 2022 only.
Part One: Implement and test SimpleTransformCsv method in the CsvManager class. This method should remove "NULL" rows, retaining the header.
Part Two: Extend CsvManager to include a second method, TransformCsv, that performs the same task as the SimpleTransformCsv method, but with a new distinct approach. Implement the provided unit test.
Part Three: Benchmark SimpleTransformCsv and TransformCsv with your chosen tool. Provide insights to the benchmark(s).