Slide 1: Exam1pass
Exam Title : :
Easiest way to pass IT exams
IBM COG-135 IBM Cognos 8 BI OLAP Developer
Version :
V1.13
1. For performance reasons, what is the best parent-child ratio for categories in each level?
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Slide 2: Exam1pass
A. 1:10 or less B. 1:11 or more C. 5:1 or less D. 3:1 or more Answer: A
Easiest way to pass IT exams
2. Transformer is unable to locate one of the source files for a data source in the model, and the model update fails. Which type of files can be used to restart the processing at the point of failure? A. .py? B. .qy? C. .mdl D. .mdx Answer: B
3. How can the cube build flexibility and performance be maximized? A. Enable Consolidation. B. Enable the AutoSummarize property. C. Combine Structural and Transactional data into one data source. D. Preprocess the data. Answer: D
4. Where should fact queries against OLAP sources come from? A. A flat file B. An .iqd file C. A Cognos 8 report D. A Cognos 8 package Answer: A
5. A Cognos 8 report with prompts is used as a data source. What must be done to create
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Slide 3: Exam1pass
mandatory prompts?
Easiest way to pass IT exams
a second query that is based on the same report but provides different values for
A. Add the second query to the report data source. B. Refresh the source when adding the second query. C. Add prompt values to the cache in the Transformer data source. D. Add the same report as another Transformer report data source. Answer: D
6. To add dimensional data to an existing model, how can metadata be leveraged from other published OLAP packages? A. Insert an OLAP package in the data source list. B. Import a PowerCube as a data source. C. Add dimensions from an OLAP package in the dimension map. D. Add a data source query using a Cognos 8 OLAP report. Answer: C
7. Which of the following can be done to improve performance when dealing with large volumes of data? A. Include multiple data sources. B. Use a single large data source. C. Include data sources of the same type. D. Use Cognos 8 reports as the data sources. Answer: A
8. Which of the following will help improve processing time when Transformer queries the data? A. Use Cognos 8 packages and reports as structural data sources. B. Separate structural and transactional information in multiple data sources. C. Combine structural and transactional information into one data source. D. Define dimensions with one transactional data source.
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Slide 4: Exam1pass
Answer: B
Easiest way to pass IT exams
9. What does unique mean when applied to a level in a dimension map? A. The level is designated as a convergence level. B. The level must be the bottom level of the dimension. C. No two categories in the level can be derived from the same source value. D. The data history does not move with the categories as they move in the level. Answer: C
10. What should a developer do if some levels appear red after validating the model using Show Scope? A. Ensure the level exists in the data source. B. Specify a valid relationship between the level and the data source. C. Re-attach the categories in the Dimension Diagram. D. Apply unique move to the level and regenerate the categories. Answer: B
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
