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