IBM C2020-180 Online Practice Questions and Exam Preparation

IBM C2020-180 Online Questions & Answers

• Question 1:

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

  Which of the following describes the benefits of Cognos Application Firewall (CAF)?

  A. It protects the application by monitoring all HTTP requests sent through the Web server toensure the gateway is receiving valid requests.
  B. It allowsCognos BIto run over the Internet.
  C. It monitors and validates all input requests to prevent parameter manipulation, SQL injection,and buffer overflow.
  D. It encrypts all input requests for validation before they are sent to the dispatcher.
  C. It monitors and validates all input requests to prevent parameter manipulation, SQL injection,and buffer overflow.

• Question 3:

  When considering the differences between Analysis, Reporting, and Querying, which of thefollowing is NOT a user who needs Analysis?

  A. A user who takes answers from one question as a starting point for other questions
  B. A user who needs to understand multiple factors influencing performance
  C. A user who needs to identify and understand trends from multiple perspectives
  D. A user who views detailed data, which is optionally totaled and subtotaled
  D. A user who views detailed data, which is optionally totaled and subtotaled

• Question 4:

  A company has several operational data stores. They wish to compare data from the various datastores against one another. The data in the various stores must be manipulated to match.Eventual report performance is more important than development time.

  Which of the followingCognos 8 components would BEST address their requirements?

  A. Report Studio and Query Studio
  B. Analysis Studio and Report Studio
  C. Data Manager and Analysis Studio
  D. Planning, Data Manager, and Report Studio
  C. Data Manager and Analysis Studio

• Question 5:

  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.

• Question 6:

  Which of the following describes how Cognos 8 works with aggregate aware tables in relationaldata sources?

  A. Cognos 8 can create aggregate aware tables within the database.
  B. Cognos 8 redirects its generated SQL to take advantage of aggregate aware tables.
  C. Cognos 8 does not make any specific adjustments for aggregate aware tables.
  D. Cognos 8 can monitor reports that are run and suggest aggregate aware tables.
  C. Cognos 8 does not make any specific adjustments for aggregate aware tables.

• Question 7:

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

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

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

  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.