C2090-180 Online Practice Questions and Answers

All of the following are considered part of the analyze phase of a BI development project EXCEPT:

A. Conduct a readiness assessment

B. Analyze solution scope

C. Determine detailed requirements

D. Create a logical data model

Which of the following describes common methods for enriching an initial dimension map?

A. Add exception and range band dimensions and include additional metrics and calculations.

B. Merge dimensions and include additional metrics and calculations.

C. Include additional metrics and calculations and core metrics and dimensions from relatedbusiness areas.

D. Include additional metrics, calculations, and hierarchy levels, and dimensions from relatedsubject areas.

Which statement is true about the BI Bus?

A. It is the name of the report process that is spawned and viewed in Windows Task Managerwhen a report execution request is processed.

B. It monitors all http traffic flowing through the gateways and dispatchers.

C. It is a set of protocols that govern communications amongCognos BIservices.

D. It uses a JDBC driver to connect to Content Stores in Sybase, SQLServer, Oracle and DB2.

Which of the following describes the benefits of Cognos Application Firewall (CAF)?

A. It protects the application by monitoring all HTTP requests sent through the Web server toensure the gateway is receiving valid requests.

B. It allowsCognos BIto run over the Internet.

C. It monitors and validates all input requests to prevent parameter manipulation, SQL injection,and buffer overflow.

D. It encrypts all input requests for validation before they are sent to the dispatcher.

Which of the following BEST describes the relationship or differences between Iterative Approachand Cognos SIM?

A. The Iterative Approach is a specific technique used to iterate through the Design phase.

B. The Iterative Approach is a series of steps defined in the Analysis and Development phases ofCognos SIM.

C. The Iterative Approach is a philosophy of development while Cognos SIM is a collection oftasks, documents, and techniques to guide development.

D. Cognos SIM is the current Cognos development standard and is intended to replace theIterative Approach for development of BI applications.

Which of the following MOST clearly states the value of using a methodology?

A. It provides a philosophy of development that maximizes return on investment.

B. It helps consultants progress in a systematic way to insure all critical steps are addressed.

C. It helps project managers estimate the cost and effort in developing a solution.

D. It ensures that early mistakes are avoided in developing a solution.

Which of the following is a critical component in delivering Corporate Performance Managementthroughout an enterprise?

A. Drill down from summary to detailed information within individual subject areas.

B. Drill across from one subject area to another through conformed dimensions.

C. Star schema data marts designed to facilitate analysis and reporting.

D. Event management designed to monitor the status of Key Performance Indicators.

When comparing two differently grained facts directly against one another, the developer must:

A. either write a union query or two reports that roll both facts up to a common level

B. either roll up the lower grained fact to the higher level or allocate the higher grained fact to thelower level

C. declare determinants at multiple levels in the dimensions of a DMR Framework Managermodel

D. ensure that all conformed dimensions shared by the facts have the same number of levels

What is the recommended configuration size for Cognos 8 on a Windows 2003 Serverenvironment, and why?

A. Small or medium because Cognos 8 can only allocate 2 GB of memory per process.

B. Small because Java consumes half of the 2GB of RAM that can be allocated per process.

C. Small or medium because Cognos 8 can take advantage of the switch that allows 3GB of RAMper process.

D. Medium or large because Windows 2003 can allocate up to 4 GB of RAM per process.

A developer has specified a maximum of two report processes for the application. Whilemonitoring the application, the developer notices that only one report process is running.

Which ofthe following would account for this?

A. The number of affinity connections per BI Bus is set too high.

B. The configuration size for the application is set too low.

C. The number of low affinity connections has been exceeded.

D. The number of report requests is too high.