Free IBM COG-180 Exam Dumps Questions & Answers

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

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

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

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

When examining an operational (transactional) database, which of the following is considered a good indicator as to which tables contain fact data?

• A.Tables with the fewest number of columns
• B.Tables with the greatest number of foreign keys
• C.Tables with the greatest number of rows
• D.Tables with the fewest number of foreign keys

All of the following describe design intent of an operational database EXCEPT:

• A.record the day to day operations of the company
• B.enhance reporting through foreign keys and indexes
• C.facilitate performing specific functional tasks
• D.maximize the speed of inserts and updates to the database

All of the following are considered part of the analyze phase of a BI development project EXCEPT:

• A.Determine detailed requirements
• B.Analyze solution scope
• C.Conduct a readiness assessment
• D.Create a logical data model