IBM C2090-180 Online Practice Questions and Exam Preparation

IBM C2090-180 Online Questions & Answers

• Question 11:

  A table is in Third Normal Form if it is already in Second Normal Form, plus:

  A. All attributes are determined only by the primary key
  B. All attributes are determined by all segments of the primary key
  C. All foreign keys are determined by the primary key
  D. All surrogate keys are determined by the primary key
  A. All attributes are determined only by the primary key

• Question 12:

  Which of the following BEST describes the group of users who would typically use these Cognos8 components: Metric Studio, Analysis Studio, and Query Studio?

  A. Executives
  B. Analysts and Authors
  C. Knowledge workers and decision makers
  D. Information Consumers
  C. Knowledge workers and decision makers

• Question 13:

  Which of the following describes the major steps in the deployment process for aCognos BIapplication and their proper order?

  A. Plan, verify, and customize
  B. Move, customize, and verify
  C. Plan, move, and secure
  D. Plan, move, and verify
  D. Plan, move, and verify

• Question 14:

  Which of the following statements best describes the Iterative Approach of applicationdevelopment?

  A. A prototype solution is developed after the initial user interviews. This prototype is then usedas a basis for refining specific design requirements.
  B. The design step is repeated multiple times before proceeding to the development step. Eachpass through the design step further refines the eventual solution.
  C. The solution is developed and delivered to the users. After approximately 2 weeks, the usersare interviewed for any missing requirements and any new requirements form the basis for thenext iteration.
  D. A prototype is created that addresses 80 to 90% of the business requirements. This isdemonstrated to the users and their feedback is used to refine the prototype in subsequentiterations.
  D. A prototype is created that addresses 80 to 90% of the business requirements. This isdemonstrated to the users and their feedback is used to refine the prototype in subsequentiterations.

• Question 15:

  You are tasked with administering theCognos BIsystem to perform batch reporting in a waythat maximizes the use of available system resources. Given the following information, how manyjobs should be created to perform this task? 480 reports must run 6 report processes are available Each process is configured to use 4 low affinity connections

  A. 20
  B. 24
  C. 48
  D. 12
  A. 20

• Question 16:

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

  Companies often create a collection of summary tables as their first attempt at a data warehouse.While there are several drawbacks to this approach, there are also some advantages. Which ofthe following is an advantage of this approach over reporting from an operational database?

  A. It is easier to understand because there are fewer summary tables.
  B. Specific reports for which the summary tables were created will run faster.
  C. It is easy to leverage many new reports from the summary tables.
  D. Over time summary tables often naturally group into business subject areas.
  B. Specific reports for which the summary tables were created will run faster.

• Question 18:

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

  All of the following describe design intent of an operational database EXCEPT:

  A. record the day to day operations of the company
  B. maximize the speed of inserts and updates to the database
  C. enhance reporting through foreign keys and indexes
  D. facilitate performing specific functional tasks
  C. enhance reporting through foreign keys and indexes

• Question 20:

  Which of the following is correct regarding report execution requests?

  A. A low affinity request is directed to the same process that served up the originating low affinityrequest if the process is available and there is an available high affinity connection.
  B. A low affinity request can be processed using a high affinity connection when a low affinityconnection is not available.
  C. An absolute affinity request does not require a connection because it has priority.
  D. A high affinity request can be processed using a low affinity connection if there are no highaffinity connections available.
  D. A high affinity request can be processed using a low affinity connection if there are no highaffinity connections available.