IBM C2090-180 Online Practice Questions and Exam Preparation

IBM C2090-180 Online Questions & Answers

• Question 1:

  Which of the following must be moved manually instead of as part of a Cognos 8 deploymentpackage?

  A. report output versions
  B. run history
  C. schedules
  D. system.xml
  D. system.xml

• Question 2:

  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.
  A. The number of affinity connections per BI Bus is set too high.

• Question 3:

  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. Small or medium because Cognos 8 can only allocate 2 GB of memory per process.

• Question 4:

  In the Key Performance Indicator (KPI) process flow diagram shown below, which Cognos 8components are normally associated with the 'Source Information' step?

  A. Enterprise Planning and Data Manager
  B. Enterprise Planning and Report Studio
  C. Analysis Studio and Metric Studio
  D. Analysis Studio and Data Manager
  A. Enterprise Planning and Data Manager

• Question 5:

  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 6:

  Which of the following is true regarding hierarchies and dimensions?

  A. Hierarchies help users understand the data through rollup levels within dimensions.
  B. All dimensions must have hierarchies.
  C. All hierarchies are defined by the inherent nature of their dimensional data.
  D. It is considered poor design to split a hierarchy across multiple dimensions.
  A. Hierarchies help users understand the data through rollup levels within dimensions.

• Question 7:

  When examining an operational (transactional) database, which of the following is considered agood indicator as to which tables contain fact data?

  A. Tables with the fewest number of columns
  B. Tables with the greatest number of rows
  C. Tables with the greatest number of foreign keys
  D. Tables with the fewest number of foreign keys
  B. Tables with the greatest number of rows

• Question 8:

  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 9:

  How are Key Performance Indicators (KPIs) tracked?

  A. By aligning them to strategic and tactical goals and the business objectives of the enterprise.
  B. By comparing them against other KPIs in a balanced scorecard.
  C. By examining anomalies that appear in BI reporting and analysis.
  D. By comparing their values to acceptable minimum and maximum levels of performanceagainst a target.
  D. By comparing their values to acceptable minimum and maximum levels of performanceagainst a target.

• Question 10:

  Which of the following is a key difference between MDX and SQL?

  A. MDX is used for dimensional style reporting while SQL is incapable of dimensional stylereporting.
  B. MDX has built in functions to support relative date calculations while SQL cannot performrelative date calculations.
  C. Dimensionally Modeled Relational (DMR) retrieves data using MDX, not SQL.
  D. MDX can reference metadata that SQL cannot.
  D. MDX can reference metadata that SQL cannot.