IBM Cognos 8 BI Data Warehouse Developer
Exam Questions, Answers,
Friends, Believe me its
no more easy .I am really thankful to www.exams.ws for
the best summary of the questions.
What can be done to minimize memory consumption?
A. Remove elements from the delivery.
B. Add the fact build to a JobStream.
C. Enable dimension breaking on the fact build.
D. Enable auditing on the fact build.
Why would an index be created on a fact table?
A. To enable the rejecting of duplicate rows.
B. To make it easier to drop and recreate the fact table.
C. To enable the merging of duplicate rows.
D. To improve update performance on a relational delivery.
A developer has created a fact build where separate
summary tables will be created for monthly and quarterly
datA. What should be created on these fact deliveries
to prevent monthly data from being delivered to the
quarterly summary table?
A. User-defined functions
C. Level filters
D. Output filters
A developer wants to be able to re-use a gross profit
calculation in multiple builds. What should be created?
A. Derived dimension
B. User-defined function
D. Output filter
Where can a variable be declared?
A. In a build specification.
B. In a hierarchy.
C. In a data source connection.
D. In a Data Manager folder.
How can a developer nest a JobStream within another
A. Execute the first JobStream from the command line,
and reference the second JobStream in the command.
B. Add a procedure node to the JobStream.
C. Execute the first JobStream using the Data Movement
Service, and include the second JobStream in the resulting
D. Add a JobStream node to the JobStream.
Where can a developer define variables in Data Manager?
A. Metadata dimensions
D. Metadata collections
A fact build is being manually created. What must the
developer do to deliver the fact data to a relational
A. Add a relational table delivery module to the Connections
B. Create a relational table delivery using SQLTerm.
C. Add a relational table delivery module to the fact
D. Modify the fact build DataStream to include a relational
Incoming fact data includes an audit reference column
for each row. This column has been identified as an
attribute in the transformation model. When executed,
the fact build should designate this element as a key
in the resulting fact table. This fact table will be
created (not updated) by the fact build. What should
the developer do?
A. Convert the attribute element into a derived dimension
B. Specify the column as a key in the table delivery
C. Specify the column as a key in the data source properties.
D. Convert the attribute element into a derivation element.