Knowledge quiz

It’s time to put what you’ve learned to the test, get 5 questions right to pass this unit.

Choose the correct answer.

Add a combined query displaying all stores and revenues using the union operator.

Add a combined query displaying all stores and revenues using the intersection operator.

Add a subquery displaying all stores and revenues with the operator "Greater than or equal to" your store's revenue.

Add a second query displaying all stores and revenues and merge the store name dimensions.

Choose the correct answer.

True

False

There are two correct answers.

Query construction is simpler than complex query filters to achieve the same result.

Better database performance than with a single query.

Identifying overlaps in two datasets with different filters.

Displaying results from multiple data sources in the same report.

Choose the correct answer.

True

False

There are two correct answers.

You can only build combine queries on the same universe.

The Union operator returns all values from both queries, including duplicates.

By default, the Minus operator returns only unique rows.

Combined query display results based upon columns in the first query.

There are three correct answers.

Move a query to the left.

Create a variable.

Add a Database Ranking.

Add a Combined Query.