C2090-180 Online Practice Questions and Answers

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

A. Conduct a readiness assessment

B. Analyze solution scope

C. Determine detailed requirements

D. Create a logical data model

A consultant realizes after determining business requirements, that a complete solution willrequire several related but separate projects. The consultant must choose one project to deliverfirst. Which of the following describes the considerations that should govern that choice?

A. Priority of IT, ease of development, resource availability, and data availability

B. Business impact, ease of development, resource availability, and number of target users

C. Data availability, ease of development, resource availability, and position of project sponsor inthe organization

D. Business impact, data availability, ease of development, and resource availability

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."Based on this request, the following metrics have been identified: Flight count, andminutes early or late. Large carriers operate signifigantly more flights than small carriers.

Which of the following additional metrics or calculations would provide the MOST value to the user?

A. Average number of flights 15 minutes early or late

B. Percentage of flights 15 minutes early or late

C. Average minutes early or late

D. Origin/Departure airport count

Which of the following BEST describes the group of users who would typically use these Cognos8 components: Metric Studio, Analysis Studio, and Query Studio?

A. Executives

B. Analysts and Authors

C. Knowledge workers and decision makers

D. Information Consumers

Which combination of Cognos 8 components is considered the BEST fit for addressing the needsof company executives?

A. Analysis Studio reports and Query Studio

B. Metric Studio scorecards and Event Studio jobs

C. Report Studio reports and Query Studio

D. Metric Studio scorecards and Report Studio dashboards

Which of the following MOST clearly states the value of using a methodology?

A. It provides a philosophy of development that maximizes return on investment.

B. It helps consultants progress in a systematic way to insure all critical steps are addressed.

C. It helps project managers estimate the cost and effort in developing a solution.

D. It ensures that early mistakes are avoided in developing a solution.

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.

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.

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.

In the Key Performance Indicator (KPI) process flow diagram shown below, which Cognos 8components are normally associated with the 'Source Information' step?

A. Enterprise Planning and Data Manager

B. Enterprise Planning and Report Studio

C. Analysis Studio and Metric Studio

D. Analysis Studio and Data Manager