Cognos 8 BI Data
Many thanx to
www.exams.ws for providing help
Q NO: 1
be done to minimize memory consumption?
elements from the delivery.
B. Add the
fact build to aJobStream.
dimension breaking on the fact build.
auditing on the fact build.
Q NO: 2
element does Data Manager use to identify duplicate
Q NO: 3
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?
Q NO: 4
an index be created on a fact table?
enable the rejecting of duplicate rows.
B. To make
it easier to drop and recreate the fact table.
enable the merging of duplicate rows.
improve update performance on a relational delivery.
Q NO: 5
a developer define variables in Data Manager?
Q NO: 6
How can a
developer nest a JobStream within another JobStream?
the firstJobStream from the command line, and reference
the second JobStream in the command.
B. Add a
procedure node to theJobStream.
the firstJobStream using the Data Movement Service, and
include the second JobStream in the resulting task.
aJobStream node to the JobStream.
Q NO: 7
developer wants to be able to re-use a gross profit
calculation in multiple builds. What should be created?
Q NO: 8
build is being manually created. What must the developer
do to deliver the fact data to a relational table?
A. Add a
relational table delivery module to the Connections
a relational table delivery usingSQLTerm.
C. Add a
relational table delivery module to the fact build.
the fact build DataStream to include a relational table
Q NO: 9
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
the attribute element into a derived dimension element.
the column as a key in the table delivery properties.
the column as a key in the data source properties.
the attribute element into a derivation element.
Q NO: 10
the following is true of transformation model
can be created within a static member.
can consist of a string literal.
can be used as sources for an attribute element.
can be used as sources for a measure element.
Q NO: 11
delivering fact data to a text file, what can be
and field delimiters
the file is in ASCII or EBCDIC format
number of rows to be stored in the file
text editor to use with the file