IBM C2090-180 Online Practice Questions and Exam Preparation

IBM C2090-180 Online Questions & Answers

• Question 1:

  After a BI application is placed into production, all of the following are considered part of theprocess to prepare for the next iteration of the application, EXCEPT:

  A. record and track enhancement requests
  B. communicate with users to insure the application is delivering value
  C. periodically re-apply the V-test model against the developed components
  D. enhance application documentation to reflect errors and omissions
  C. periodically re-apply the V-test model against the developed components

• Question 2:

  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.
  A. Add exception and range band dimensions and include additional metrics and calculations.

• Question 3:

  Which of the following is a valid strategy for addressing failover for the content store?

  A. Install active and passive instances of the content store.
  B. Install active and passive instances of the Content Manager service.
  C. Take advantage of failover protection in the Applications tier by installing the content store ona server that hosts multiple instances of the report service.
  D. Take advantage of database backup and failover strategies and policies already in place in theenvironment.
  D. Take advantage of database backup and failover strategies and policies already in place in theenvironment.

• Question 4:

  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.
  B. It helps consultants progress in a systematic way to insure all critical steps are addressed.

• Question 5:

  When following the Information Focused approach, what should the users bring to the initialinterview?

  A. Copies of key reports, structure of database tables, job responsibilities, and objectives
  B. Job responsibilities, objectives, what information they need to get their work done, and copiesof key reports
  C. List of reports they desire, what information they need to get their work done, and structure ofdatabase tables
  D. Job responsibilities, objectives, and a list of reports they desire
  B. Job responsibilities, objectives, what information they need to get their work done, and copiesof key reports

• Question 6:

  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.

• Question 7:

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

  Which service is required when a user views saved report output?

  A. presentation service
  B. report data service
  C. report service
  D. batch report service
  A. presentation service

• Question 9:

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

  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