Two Pipelines (A & B) Are Entering a Joiner Transformation

question 10

Multiple Choice

Two pipelines (A & B) are entering a Joiner transformation with each having a record size of 100 bytes. Pipeline A has a total of 1000 records and Pipeline B has a total of 1,000,000 records. Which pipeline should be designated the master pipeline?

• A) Pipeline A
• B) Pipeline B
• C) Both Pipelines should be cached for performance reasons
• D) Pipeline B if and only if Pipeline A is sorted

---

Definitions:

Skill Level

A measure of the competence or proficiency of an individual in performing specific tasks, often categorized into beginner, intermediate, and advanced.

National Occupational Classification

A system used in Canada to categorize and describe occupations in order to facilitate job searches, career information, and labor market analysis.

Education Level

The highest degree of academic achievement an individual has completed, such as high school, bachelor's degree, or doctorate.

Job Descriptions

A formal account of an employee's responsibilities, duties, and the scope of work expected from a particular position.