Free IBM C2090-625 Exam Dumps Questions & Answers

What distinguishes an OLTP system from a data warehouse? (choose two)

• A.A data warehouse captures and processes original business transactions, while an OLTP system does not.
• B.An OLTP system captures and processes original business transactions, while a data warehouse does not.
• C.A data warehouse is fully normalized, while an OLTP system is fully denormalized.
• D.An OLTP system is used to transform, clean, and combine operational data, while a data warehouse is not.
• E.A data warehouse is fully denormalized, while an OLTP system is fully normalized.

The following hierarchy has been created:

Before executing the dimension build, the developer wants to ensure that duplicate rows are
excluded from each hierarchy level. If any duplicates are encountered, the developer only wants to keep the row from DataSource1. The data sources will be executed in series. What should be done?

• A.Specify that duplicate rows are to be rejected on the Audit tab of the dimension build's properties.
• B.Create a data integrity lookup for the hierarchy that will flag duplicate rows at each level.
• C.Specify that duplicate rows are to be rejected on the Features tab of the hierarchy's properties.
• D.Modify the SQL statement for the dimension build to use the SELECT DISTINCT clause.

A lookup has been created to enable translation of incoming currency values (such as the US dollar) into another currency (such as the Euro). What should be done?

• A.Create a derivation which uses the reference atttributes of the lookup.
• B.Create a measure dimension which references the conversion rate.
• C.Reference the lookup in the properties of the affected dimension build(s).
• D.Move the lookup to a fact build conversion map.

A DataStream includes two different data sources: "Golf Equipment" and "Other Equipment." For each incoming row, the developer wants to add a value that indicates the data source that the row comes from. What should the developer do?

• A.Add a literal to each data source that references the data source name.
• B.Specify the source identity property for each data source in the DataStream.
• C.Create a static member for each data source in the underlying hierarchy.
• D.Add a derivation to the transformation model to create a new column.

Which of the following is true of the Navigator?

• A.Components from different catalogs can be compared.
• B.Library components (such as hierarchies) cannot be navigated.
• C.When searching for components, wildcards are not supported.
• D.When a component is selected, dependent components are shown.