Knowledge quiz

It's time to put what you've learned to the test, get 7 right to pass this unit.

Choose the correct answer.

To upload data to an existing table

To define an SQL script that derives a result based on existing tables

To combine existing tables by unions and joins

To use fuzzy logic for finding the best matching value from an existing table

Choose the correct answer.

True

False

Choose the correct answer.

To convert a remote table into a local table with disk storage

To identify available table structure updates from the source connection

To encrypt the data transmission between the source and the space

To automatically schedule real-time replication for all virtual objects

Choose the correct answer.

True

False

Choose the correct answer.

True

False

Choose the correct answer.

To increase the performance of a simple inner join between two local tables.

To join entities when a foreign key is incomplete, unreliable, or missing.

To automatically delete duplicate records from a single source table.

To change the data types of columns before they are loaded into a space.

Choose the correct answer.

By deleting the entire analytic model and starting over.

By dragging a different source object on top of the fact source node.

By adjusting the association in the underlying model only.

By using the sharing option to move the model to another Space.

Choose the correct answer.

One attribute in the source fact must be mapped to each target dimension key column.

The fact must be converted into a hierarchy before it can point to a dimension.

All attributes in the target dimension must be mapped to a single identifier in the fact.

The association can only be created if the dimension does not contain any key columns.