Using functions, scripts, and variables

1.

There are two correct answers.

They are restricted to the job or work flow in which they are created.

They are included as part of the definition of the work flow or data flow, and so are portable between jobs.

Their value can be assigned through a script or at execution.

They are most commonly used to filter data in WHERE clauses.

2.

Choose the correct answer.

True

False

3.

Choose the correct answer.

True

False

4.

Choose the correct answer.

True

False

5.

Choose the correct answer.

To substitute a source value in a Query transform.

To define the name of a source file so it changes depending on the environment.

To define the connection parameter of a datastore so it changes depending on the environment.

To substitute a row with another in the target table.

6.

There are two correct answers.

In a job, before data flows, for initialization steps.

In a work flow, to check for file existence.

In a data flow, to assign values to variables.

In a project, to orchestrate job execution.

Knowledge quiz