IBM Cognos 10 BI Data Warehouse Developer - C2020-625 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

A developer has created a fact build with two fact deliveries. What should be done to include only some of the elements of the transformation model in one of the deliveries, and some in the other delivery?

A. Modify the SQL to exclude the relevant elements from each delivery. B. Create an output filter to exclude the relevant elements from each delivery. C. Modify the properties of each fact delivery to exclude the relevant elements. D. Create a level filter to exclude the relevant elements from each delivery.

Discussion 0

Correct Answer: C Vote an answer

Question 2

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. Add a derived dimension element to the fact build to store the missing product codes and unsubscribe the element from the delivery module. B. Accept unmatched member identifiers in the dimension element properties and save unmatched member details via reference structure. C. Modify the SQL for the reference structure to exclude the missing product codes. D. Accept unmatched member identifiers in the measure element properties.

Discussion 0

Correct Answer: B Vote an answer

Question 3

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?

A. Hierarchy B. Derived dimension C. Derivation D. Lookup E. Dimension

Discussion 0

Correct Answer: A Vote an answer

Question 4

A fact build has been created that will extract data for all of Europe. All of the data will be delivered to fact tables. The developer wants to direct United Kingdom-specific data into its own fact table. What must be created on the fact delivery?

A. DataStream filter B. Output filter C. Level filter D. Data source filter

Discussion 0

Correct Answer: B Vote an answer

Question 5

Why would an index be created on a fact table?

A. To make it easier to drop and recreate the fact table. B. To improve update performance on a relational delivery. C. To enable the merging of duplicate rows. D. To enable the rejecting of duplicate rows.

Discussion 0

Correct Answer: B Vote an answer

Question 6

A developer wants to copy data from one table to a table in another database. What type of fact build would be the most appropriate for the developer to specify in the Fact Build wizard?

A. Data transfer B. Cognos BI Mart (Star) C. Cognos BI Mart (Snowflake) D. Relational datamart

Discussion 0

Correct Answer: A Vote an answer

Question 7

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

A. A derivation has been added to the lookup. B. Data must be accessed from more than one table. C. The lookup attribute names are different from the source column names. D. The build will perform automatic surrogate key substitution.

Discussion 0

Correct Answer: D Vote an answer

Question 8

Which of the following is a potential challenge when developing conformed dimensions?

A. A developer may need to manually track changes to dimensional history by creating derivations. B. A DataStream must be manually created for each conformed dimension's data source. C. Dimensional keys may be different across source systems and need to be standardized. D. A developer may need to manually track changes to dimensional history by creating derived dimensions. E. A developer needs to build an operational data store (ODS) to contain the conformed dimensions.

Discussion 0

Correct Answer: C Vote an answer

Question 9

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. Create a static member for each data source in the underlying hierarchy. B. Specify the source identity property for each data source in the DataStream. C. Add a literal to each data source that references the data source name. D. Add a derivation to the transformation model to create a new column.

Discussion 0

Correct Answer: C Vote an answer