IBM C2020-180 Online Practice Questions and Exam Preparation

IBM C2020-180 Online Questions & Answers

• Question 11:

  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

• Question 12:

  Which combination of Cognos 8 components is considered the BEST fit for addressing the needsof company executives?

  A. Analysis Studio reports and Query Studio
  B. Metric Studio scorecards and Event Studio jobs
  C. Report Studio reports and Query Studio
  D. Metric Studio scorecards and Report Studio dashboards
  D. Metric Studio scorecards and Report Studio dashboards

• Question 13:

  WhichCognos BIarchitectural component is written in C++?

  A. Batch report service
  B. Job service
  C. Monitoring service
  D. Presentation service
  A. Batch report service

• Question 14:

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

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

  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." Which of the following is a dimension identified by the request?

  A. Cost
  B. Margin Range
  C. Actual / Projected
  D. Sales Range
  B. Margin Range

• Question 17:

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

  A. eliminates the need for aggregate tables
  B. reduces the time needed to fetch the required data
  C. enables drill up/down functionality in reports and ad hoc queries
  D. enables creation of IQDs for creating Power Cubes
  C. enables drill up/down functionality in reports and ad hoc queries

• Question 18:

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

  Why should an application's performance be monitored on an ongoing basis after it goes intoproduction?

  A. Initial performance tests are usually too optimistic.
  B. There is little value in performance tests before a system goes into production.
  C. Usage patterns on applications tend to change over time.
  D. New releases of system and application software usually degrade performance.
  C. Usage patterns on applications tend to change over time.

• Question 20:

  The V-Model testing process specifies that developers should both verify and validate each test.

  Which of the following describes how developers would validate their tests in the design step ofthe V-model?

  A. Check the design by conducting an assembly test.
  B. Check the design by conducting a component test.
  C. Check the design against the business requirements.
  D. Check the design against the developed components.
  C. Check the design against the business requirements.