Knowledge check

Completed

1.

Which join kind contains all columns and only matching rows from both tables?

kind=leftouter

kind=inner

kind=fullouter

2.

Which operator returns a table with appended rows from multiple tables?

The lookup operator

The join operator

The union operator

3.

Which function should you use to capture the results of a tabular expression?

The materialize() function

The cache() function

The let statement

You must answer all questions before checking your work.