COG-632 (IBM Cognos 10 BI Metadata Model Developer) Document version: 11.05.07

COG-632
(IBM Cognos 10 BI Metadata Model Developer)
Document version: 11.05.07
COG-632 Exam Questions
Important Note About COG-632 PDF
techeXams’ COG-632 PDF is a comprehensive compilation of questions and answers that have been
developed by our team of certified professionals. In order to prepare for the actual exam, all you
need is to study the content of this exam questions. An average of approximately 10 to 15 hours
should be spent to study these exam questions and you will surely pass your exam. It’s our
guarantee.
Copyright
techeXams holds the copyright of this material. techeXams grants you a limited license to view and
study this material, either for personal or commercial use. Unauthorized reproduction or distribution
of this material, or any portion thereof, may result in severe civil and criminal penalties, and will be
prosecuted to the maximum extent possible under law.
Disclaimer
Neither this guide nor any material in this guide is sponsored, endorsed or affiliated with any of the
respective vendor. All trademarks are properties of their respective owners.
1
© Copyright www.techeXams.ws 2011
COG-632 Practice Exams, COG-632 Audio Trainings, COG-632 Study Guides
COG-632 Exam Questions
Question: 1
When importing metadata into Framework Manager from a relational database, which of
the following can be controlled by the modeler performing the import?
A. Specifying the item names in various languages.
B. Specifying the usage property for generated query items.
C. Converting inner joins in the database to outer joins in the model.
D. Generating relationships based on existing primary and foreign key relationships in the
database.
Answer: D
Question: 2
In Framework Manager, if a modeler tests the Month from Time Dimension and
SALE_TOTAL from Sales Fact and applies Auto Sum, which of the following is a modeler
most likely to see?
A. An XMIN on Month.
B. An XSUM on Month.
C. An XMIN on SALE_TOTAL.
D. An XSUM on SALE_TOTAL.
Answer: D
Question: 3
Which of the following is true of the generated native SQL below?
2
© Copyright www.techeXams.ws 2011
COG-632 Practice Exams, COG-632 Audio Trainings, COG-632 Study Guides
COG-632 Exam Questions
A. The derived table is executed independently, using Pass-Through SQL, and then processed
locally.
B. The derived table is used to retrieve one data set, in order to fulfill the join condition of
another data set.
C. The parent select statement uses an inner join to directly match columns from physical tables
in the database.
D. The outer projection list will return more columns than listed, due to extra columns retrieved
in the derived table.
Answer: B
Question: 4
Which of the following components does a basic Cognos 10 stitch query consist of?
A. SC() function, full outer join, multiple queries that each query exclusive information.
B. SC() function, full outer join, multiple queries that query some of the same information.
C. Coalesce function, full outer join, multiple queries that each query exclusive information.
D. Coalesce function, full outer join, multiple queries that query some of the same information.
Answer: D
Question: 5
In Cognos 10, which of the following is true of multi-fact result sets?
3
© Copyright www.techeXams.ws 2011
COG-632 Practice Exams, COG-632 Audio Trainings, COG-632 Study Guides
COG-632 Exam Questions
A. Only correlated result sets can have repeating fact values.
B. Only contiguous result sets can have repeating fact values.
C. Both contiguous and correlated lists can have repeating fact values.
D. Both contiguous and correlated lists cannot have repeating fact values.
Answer: C
Question: 6
Which column is most likely a non-conformed or non-shared dimension from the SQL
below?
A. D2.DAY_DATE
B. D2.ORDER_METHOD
C. D3.RETURN_QUANTITY
D. D3.REASON_DESCRIPTION
Answer: D
Question: 7
When running an interactive HTML report, which of the following aggregation methods is
used by default?
A. Unspecified
B. Running
C. Unknown
4
© Copyright www.techeXams.ws 2011
COG-632 Practice Exams, COG-632 Audio Trainings, COG-632 Study Guides
COG-632 Exam Questions
D. Extended
Answer: B
Question: 8
An author creates a Report Studio report that contains Month, Product Line and Revenue.
Revenue has a footer to show the overall total. What will the author see in the generated
Cognos SQL for the Revenue footer column?
A. XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line)
as Revenue
B. XSUM(Sales_Fact.Revenue for Time_Dimension.Month1,Product_Dimension.Product_Line)
as Revenue2
C. XSUM(XSUM(Sales_Fact.Revenue for
Time_Dimension.Month1,Product_Dimension.Product_Line) in
Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue
D. XSUM(XSUM(Sales_Fact.Revenue for
Time_Dimension.Month1,Product_Dimension.Product_Line) at
Time_Dimension.Month1,Product_Dimension.Product_Line) as Revenue1
Answer: D
Question: 9
Which of the following join types does the generated SQL below illustrate?
S
A. Inner join
B. Disjointed join
5
© Copyright www.techeXams.ws 2011
COG-632 Practice Exams, COG-632 Audio Trainings, COG-632 Study Guides
COG-632 Exam Questions
C. Outer join
D. Cross join
Answer: D
Get Full Version of Exam COG-632 PDF Q&A
techeXams presents authentic, genuine and valid study material, which promise 100%
success in very first attempt. To take optimal results for COG-632 exam, you need to
buy full version of COG-632 question and answer. An average of approximately 10 to
15 hours should be spent to study these exam questions and you will surely pass your
exam. So come join us and quench your thirst for knowledge.
Get complete COG-632 questions and answers by visiting URL
“http://www.techexams.ws/exams/COG-632.do”
6
© Copyright www.techeXams.ws 2011
COG-632 Practice Exams, COG-632 Audio Trainings, COG-632 Study Guides