IBM C2090-180 Online Practice Questions and Exam Preparation

IBM C2090-180 Online Questions & Answers

• Question 51:

  Which of the following is a common mistake made by designers when creating dimensionmodels?

  A. Including alternatehierarchies.
  B. Including multiple date/timehierarchies.
  C. Splitting a single dimension into multiple dimensions.
  D. Adding dimensions and measures from other subject areas.
  D. Adding dimensions and measures from other subject areas.

• Question 52:

  Which of the following is correct regarding the processing of a PageDown high affinity request?

  A. The request is routed to the same process that served up the originating low affinity request ifthe process is available and if there is an available high affinity connection.
  B. The request is given priority and is always processed by the same process that served up theoriginating low affinity request.
  C. The request is load-balanced and is sent to any available dispatcher in the system.
  D. The request is automatically queued and is processed by the first available low affinityconnection in the system.
  A. The request is routed to the same process that served up the originating low affinity request ifthe process is available and if there is an available high affinity connection.

• Question 53:

  Which of the following describes a disadvantage of using the dimensionally modeled relational(DMR) technique to access a normalized data structure?

  A. does not allow access to all relational items in Query and Report Studio
  B. may increase the time needed to fetch required data
  C. does not allow access to member functions
  D. may bypass aggregate aware tables
  B. may increase the time needed to fetch required data

• Question 54:

  Which of the following describes Key Performance Indicators (KPI)?

  A. Specific metrics, usually derived, by which a company measures its progress and success.
  B. Strategic goals, typically specified by executives, which describe the direction and objectives ofthe organization.
  C. Industry standards by which organizations measure themselves against others in their marketspace.
  D. Core, atomic level data items that provide input into higher level derived items which thenappear on scorecards.
  A. Specific metrics, usually derived, by which a company measures its progress and success.

• Question 55:

  A multi-server installation ofCognos BImust be performed.

  Which of the following is a validstrategy for installing across multiple servers?

  A. Separate the gateway component from other server components to restrict report requestprocessing to the Web server tier.
  B. Enable dedicated request processing, by installing a dispatcher in the Web server tier to act asa primary dispatcher for routing requests to other dispatchers.
  C. Scale the system vertically by installing one instance of all Cognos 8 services on a largercomputer capable of managing more concurrent request threads.
  D. Enable load balancing of requests for content management services by installing multipleinstances of Content Manager.
  B. Enable dedicated request processing, by installing a dispatcher in the Web server tier to act asa primary dispatcher for routing requests to other dispatchers.

• Question 56:

  A user makes the following request:"I need to see actual sales compared with projected sales,and margin range for branches within each division, by product line, sales rep by sales manager,and cost center over time." Based on the user's request, Actual Sales and Projected Sales havebeen identified as required measures.

  Which of the following other measures would be includedin an initial dimension map?

  A. Unit Cost
  B. Average Sales
  C. Discount Amount
  D. Sales Variance
  D. Sales Variance

• Question 57:

  A company records when customers check into a service center. If there are too many customerswaiting for the number of service representatives on hand, a manager wishes to be notified by ane-mail that contains a report showing the current condition.

  Which of the following Cognos 8Components would BEST address their needs?

  A. Office Connection and Report Studio
  B. Data Manager, Event Management, and Office Connection
  C. Office Connection and Query Studio
  D. Event Management and Report Studio
  D. Event Management and Report Studio

• Question 58:

  Which of the following is the recommended method of implementing a regular backup plan for aBI Application?

  A. Implement a BI application backup plan separate from other production applications.
  B. Back up the production application into the test environment.
  C. Copy the BI application to a duplicate environment.
  D. Integrate the BI application into existing production backup plans.
  D. Integrate the BI application into existing production backup plans.

• Question 59:

  Which of the following describes the models contained in the '24 Ways' book referenced in the BIProfessional Workshop course?

  A. Framework Manager models that map over an example normalized database, which one mightfind in a manufacturing enterprise.
  B. Physical, star schema data models for constructing data marts for the various departments in ageneric business enterprise.
  C. Logical models that contain dimensions and key tactical metrics for the various departments ina generic business enterprise.
  D. Cognos 8 OLAP Modeler (Transformer) models that describe how to map data from amanufacturing database into a PowerCube.
  C. Logical models that contain dimensions and key tactical metrics for the various departments ina generic business enterprise.

• Question 60:

  A company has a manufacturing database they wish to interrogate. They know there are issuesthat have affected production quality over the last year but they are unsure exactly what factorsare contributing to the problem. They would like to be able to quickly examine manufacturedbatches from multiple perspectives and, if there are any anomalies or any unusual trends overtime, they would then like to focus on specific batches to understand the details.

  Which of thefollowing Cognos 8 Components would BEST address their needs?

  A. Analysis Studio and Report Studio
  B. Report Studio and Query Studio
  C. Event Studio and Report Studio
  D. Analysis Studio and Metric Studio
  A. Analysis Studio and Report Studio