IBM C2090-180 Online Practice Questions and Exam Preparation

IBM C2090-180 Online Questions & Answers

• Question 61:

  A user makes the following request:"I need to see the number of flights throughout the year thatarrived or departed more than 15 minutes early or late by origin and destination airport, by carrier,and by time of day. I want to see if the number of flights delayed is greater for large carriers orsmall carriers."Based on this request, the following metrics have been identified: Flight count, andminutes early or late. Large carriers operate signifigantly more flights than small carriers.

  Which of the following additional metrics or calculations would provide the MOST value to the user?

  A. Average number of flights 15 minutes early or late
  B. Percentage of flights 15 minutes early or late
  C. Average minutes early or late
  D. Origin/Departure airport count
  B. Percentage of flights 15 minutes early or late

• Question 62:

  Which of the following BEST describes the relationship or differences between Iterative Approachand Cognos SIM?

  A. The Iterative Approach is a specific technique used to iterate through the Design phase.
  B. The Iterative Approach is a series of steps defined in the Analysis and Development phases ofCognos SIM.
  C. The Iterative Approach is a philosophy of development while Cognos SIM is a collection oftasks, documents, and techniques to guide development.
  D. Cognos SIM is the current Cognos development standard and is intended to replace theIterative Approach for development of BI applications.
  C. The Iterative Approach is a philosophy of development while Cognos SIM is a collection oftasks, documents, and techniques to guide development.

• Question 63:

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

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

  A user makes the following request:"I need to see the number of flights throughout the year thatarrived or departed more than 15 minutes early or late by origin and destination airport, by carrier,and by time of day. I want to see if the number of flights delayed is greater for large carriers orsmall carriers."This request requires clarification to make the user's intention clear.

  Which of thefollowing will NOT further clarify the user's request?

  A. Determine if origin and destination airports should be considered joined pairs (for example,from DFW to ORD) or as separate dimensions.
  B. Determine if 15 minutes is the only significant grouping of late or early departures or arrivals.
  C. Determine the definition of a large and small carrier.
  D. Determine if Date and Time of Day should be split into separate dimensions.
  D. Determine if Date and Time of Day should be split into separate dimensions.

• Question 66:

  Which of the following is NOT a critical feature or function of a scorecard?

  A. Targets
  B. Projections
  C. Tolerances
  D. Histories
  B. Projections