IBM Cognos BI Professional Set 2

1.

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

All attributes are determined only by the primary key All attributes are determined by all segments of the primary key All foreign keys are determined by the primary key All surrogate keys are determined by the primary key

2.

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

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

3.

After a BI application is placed into production, all of the following are considered part of the process to prepare for the next iteration of the application, EXCEPT:

record and track enhancement requests communicate with users to insure the application is delivering value periodically re-apply the V-test model against the developed components enhance application documentation to reflect errors and omissions

4.

Which of the following is the recommended method of implementing a regular backup plan for a BI Application?

Implement a BI application backup plan separate from other production applications. Back up the production application into the test environment. Copy the BI application to a duplicate environment. Integrate the BI application into existing production backup plans.

5.

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

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

6.

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

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

7.

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

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

8.

Which of the following is a key difference between MDX and SQL?

MDX is used for dimensional style reporting while SQL is incapable of dimensional stylereporting. MDX has built in functions to support relative date calculations while SQL cannot performrelative datecalculations. Dimensionally Modeled Relational (DMR) retrieves data using MDX, not SQL. MDX can reference metadata that SQL cannot.

9.

How are Key Performance Indicators (KPIs) tracked?

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

10.

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

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

IBM Cognos BI Professional Set 2

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

IBM Cognos BI Professional Set 2

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner