IBM Cognos 10 BI Data Warehouse Developer Set 2

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 developer wants to ensure that each incoming row of fact data has a corresponding location code from a dimension table. What should the developer create?

A developer has created a hierarchy that uses multiple data sources. The developer wants to know if there are multiple parents or children without parents. What tool should the administrator use?

What can be seen with Reference Explorer that cannot be seen when using SQLTerm to examine the data?

A developer has geographical data from a data source where cities roll up into states, and states roll up into regions. What should the developer create in order to allow Data Manager to aggregate fact data to the region level?

Without modifying any of the settings, what is the lowest level of granularity that will be shown in the Reference Explorer?

A developer has created a date hierarchy using the Date Hierarchy wizard. Which of the following is true of all the members in this hierarchy?

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 lookup has been created to enable translation of incoming currency values (such as the US dollar) into another currency (such as the Euro). If the incoming currency is not available through the lookup, what can be done to prevent the fact row from being rejected?

A developer has created a lookup using a template (not a data source) for data access. Why would the developer do this?