The package includes a Data Flow task that copies several million rows. The data flow requires a match against a reference table that contains 10,000 rows. Each row in the reference table will be used during the data flow.Same row are not matching due to a mismatched case typeYou need to ensure that the data flow executes to match all rows correctly.Which data flow component should you select?

• A. A Fuzzy Lookup transformation
• B. A Lookup transformation along with the Full cache option
• C. A Lookup transformation along with the No cache option
• D. A Lookup transformation along with the Partial cache option