IBM C2090-180 Online Practice Questions and Exam Preparation

IBM C2090-180 Online Questions & Answers

• Question 21:

  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
  B. either roll up the lower grained fact to the higher level or allocate the higher grained fact to thelower level

• Question 22:

  Which of the following is a significant cause of failure when using the technology- focusedapproach to BI Application development?

  A. Users often have difficulty understanding new technology.
  B. New technology often contains internal flaws and errors that affect the delivered solution.
  C. The solution is focused on a single subject area.
  D. Developers often focus on just the data.
  D. Developers often focus on just the data.

• Question 23:

  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.
  C. It is a set of protocols that govern communications amongCognos BIservices.

• Question 24:

  If anonymous access is disabled, when a user accessesCognos BI, what is the correct flow ofthe request?

  A. To Cognos Access Manager which queries the content store for user information and displaysthe log on page through the dispatcher and the gateway
  B. To the monitoring service which monitors the user authentication request and displays the logon page through the dispatcher and the gateway
  C. To the presentation service which displays the log on page through the dispatcher and thegateway
  D. To Cognos Application Firewall which monitors the user authentication request and displaysthe log on page through the dispatcher and the gateway
  C. To the presentation service which displays the log on page through the dispatcher and thegateway

• Question 25:

  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.
  C. It monitors and validates all input requests to prevent parameter manipulation, SQL injection,and buffer overflow.

• Question 26:

  A consultant realizes after determining business requirements, that a complete solution willrequire several related but separate projects. The consultant must choose one project to deliverfirst. Which of the following describes the considerations that should govern that choice?

  A. Priority of IT, ease of development, resource availability, and data availability
  B. Business impact, ease of development, resource availability, and number of target users
  C. Data availability, ease of development, resource availability, and position of project sponsor inthe organization
  D. Business impact, data availability, ease of development, and resource availability
  D. Business impact, data availability, ease of development, and resource availability

• Question 27:

  When considering the differences between Analysis, Reporting, and Querying, which of thefollowing is NOT a user who needs Analysis?

  A. A user who takes answers from one question as a starting point for other questions
  B. A user who needs to understand multiple factors influencing performance
  C. A user who needs to identify and understand trends from multiple perspectives
  D. A user who views detailed data, which is optionally totaled and subtotaled
  D. A user who views detailed data, which is optionally totaled and subtotaled

• Question 28:

  The partial diagram below is an example of what type of database schema design?

  A. star schema
  B. snowflake schema
  C. normalized schema
  D. de-normalized schema
  B. snowflake schema

• Question 29:

  Which of the following issues is Iterative Development specifically designed to address?

  A. The very act of developing a system or solution will change the business requirements.
  B. Users understand their business processes but they don't usually understand applicationdevelopment.
  C. No developed solution will satisfy all users equally.
  D. Users often feel that IT does not understand the business.
  A. The very act of developing a system or solution will change the business requirements.

• Question 30:

  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
  D. Create a logical data model