IBM CognosBI Professional v3.0 (C2020-180)

Page:    1 / 5   
Total 69 questions

The partial diagram below is an example of what type of database schema design?

  • A. star schema
  • B. snowflake schema
  • C. normalized schema
  • D. de-normalized schema


Answer : B

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


Answer : C

Which of the following describes the design goals of a reporting database?

  • A. provide fast access to corporate data for analysis and reporting
  • B. provide near real time access to summarized corporate data for analysis and reporting
  • C. provide fast access to corporate data and act as a system of record
  • D. provide near real time access to summarized transactional data


Answer : A

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.


Answer : C

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


Answer : A

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.


Answer : C

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


Answer : C

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.


Answer : D

Which of the following is a critical component in delivering Corporate Performance
Managementthroughout an enterprise?

  • A. Drill down from summary to detailed information within individual subject areas.
  • B. Drill across from one subject area to another through conformed dimensions.
  • C. Star schema data marts designed to facilitate analysis and reporting.
  • D. Event management designed to monitor the status of Key Performance Indicators.


Answer : B

Which of the following describes Key Performance Indicators (KPI)?

  • A. Specific metrics, usually derived, by which a company measures its progress and success.
  • B. Strategic goals, typically specified by executives, which describe the direction and objectives ofthe organization.
  • C. Industry standards by which organizations measure themselves against others in their marketspace.
  • D. Core, atomic level data items that provide input into higher level derived items which thenappear on scorecards.


Answer : A

Which of the following statements is true about the Waterfall Approach?

  • A. The five steps in the process are considered valid for BI software development projects.
  • B. Each step is performed in sequence but you return to previous steps at specific points in thedevelopment cycle.
  • C. It is designed so that requirements that are not discovered in the Analysis step will cascadeout during the design phase.
  • D. Project management tools no longer encourage the Waterfall Approach.


Answer : A

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.


Answer : D

How are Key Performance Indicators (KPIs) tracked?

  • A. By aligning them to strategic and tactical goals and the business objectives of the enterprise.
  • B. By comparing them against other KPIs in a balanced scorecard.
  • C. By examining anomalies that appear in BI reporting and analysis.
  • D. By comparing their values to acceptable minimum and maximum levels of performanceagainst a target.


Answer : D

Which of the following describes the models contained in the '24 Ways' book referenced in the BIProfessional Workshop course?

  • A. Framework Manager models that map over an example normalized database, which one mightfind in a manufacturing enterprise.
  • B. Physical, star schema data models for constructing data marts for the various departments in ageneric business enterprise.
  • C. Logical models that contain dimensions and key tactical metrics for the various departments ina generic business enterprise.
  • D. Cognos 8 OLAP Modeler (Transformer) models that describe how to map data from amanufacturing database into a PowerCube.


Answer : C

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


Answer : B

Page:    1 / 5   
Total 69 questions