Online Access Free C2090-625 Exam Questions

Some incoming fact data has invalid product codes. The developer wants to accept this fact data and assign the necessary surrogate keys in the dimension table. What can be done to accomplish this?

• A.Accept unmatched member identifiers in the measure element properties.
• B.Modify the SQL for the reference structure to exclude the missing product codes.
• C.Add a derived dimension element to the fact build to store the missing product codes and unsubscribe the element from the delivery module.
• D.Accept unmatched member identifiers in the dimension element properties and save unmatched member details via reference structure.

What can Data Manager be used for?

• A.To build an IBM Cognos Planning application.
• B.To create a content store.
• C.To create a metric store.
• D.To extract operational data from multiple sources.

A developer wants to move a selection of components from a development environment to a production environment. What should the developer do?

• A.Create a catalog backup file (.ctg).
• B.Create a SQL script to transfer the components.
• C.Create a JobStream to transfer the components..
• D.Create a package file (.pkg).

A developer is working with the following relational table data source:

What should be done?

• A.Define how the data will be pivoted in the DataStream of the fact build.
• B.Create an output filter to flip the rows and columns.
• C.Create a user-defined function to flip the rows and columns.
• D.Define how the data will be pivoted in the Delivery of the fact build.

A developer has added a data source connection to a Data Manager catalog. This connection points to a relational database. The developer wants to view the contents of this database, such as the number of tables that it contains. What tool could the administrator use?

• A.SQLTXT Designer
• B.Reference Explorer
• C.SQLTerm
• D.ODBC Administrator