IBM Cognos BI Professional (COG-180) Free Practice Test

Question 1

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

A. Physical, star schema data models for constructing data marts for the various departments in a generic business enterprise.

B. Framework Manager models that map over an example normalized database, which one might find in a manufacturing enterprise.

C. Cognos 8 OLAP Modeler (Transformer) models that describe how to map data from a manufacturing database into a PowerCube.

D. Logical models that contain dimensions and key tactical metrics for the various departments in a generic business enterprise.

Correct Answer: D

Question 2

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

A. Project management tools no longer encourage the Waterfall Approach.

B. It is designed so that requirements that are not discovered in the Analysis step will cascade out during the design phase.

C. Each step is performed in sequence but you return to previous steps at specific points in the development cycle.

D. The five steps in the process are considered valid for BI software development projects.

Correct Answer: D

Question 3

The V-Model testing process specifies that developers should both verify and validate each test. Which of the following describes how developers would validate their tests in the design step of the V-model?

A. Check the design against the business requirements.

B. Check the design against the developed components.

C. Check the design by conducting a component test.

D. Check the design by conducting an assembly test.

Correct Answer: A

Question 4

Which of the following is a significant cause of failure when using the technology-focused approach to BI Application development?

A. Users often have difficulty understanding new technology.

B. The solution is focused on a single subject area.

C. Developers often focus on just the data.

D. New technology often contains internal flaws and errors that affect the delivered solution.

Correct Answer: C

Question 5

Which of the following statements describes the critical differences between a managed report and a query?

A. A managed report is intended to be run on a regular execution schedule from a background batch process whereas a query is run interactively.

B. A managed report is authored by trained developers whereas a query is authored by either trained developers or end users.

C. A managed report is intended to be run on a regular execution schedule whereas a query is intended to be authored and run on-demand.

D. A managed report prompts users for run-time parameters whereas a query does not.

Correct Answer: C

Question 6

When following the Information Focused approach, what should the users bring to the initial interview?

A. List of reports they desire, what information they need to get their work done, and structure of database tables

B. Copies of key reports, structure of database tables, job responsibilities, and objectives

C. Job responsibilities, objectives, and a list of reports they desire

D. Job responsibilities, objectives, what information they need to get their work done, and copies of key reports

Correct Answer: D

Question 7

A company has several operational data stores. They wish to compare data from the various data stores 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 following Cognos 8 components would BEST address their requirements?

Welcome to TestSimulate

IBM Cognos BI Professional (COG-180) Free Practice Test