C2090-180 Online Practice Questions and Answers

Which service is required when a user views saved report output?

A. presentation service

B. report data service

C. report service

D. batch report service

You are tasked with administering theCognos BIsystem to perform batch reporting in a waythat maximizes the use of available system resources. Given the following information, how manyjobs should be created to perform this task?

480 reports must run

6 report processes are available

Each process is configured to use 4 low affinity connections

A. 20

B. 24

C. 48

D. 12

Which of the following statements best describes the Iterative Approach of applicationdevelopment?

A. A prototype solution is developed after the initial user interviews. This prototype is then usedas a basis for refining specific design requirements.

B. The design step is repeated multiple times before proceeding to the development step. Eachpass through the design step further refines the eventual solution.

C. The solution is developed and delivered to the users. After approximately 2 weeks, the usersare interviewed for any missing requirements and any new requirements form the basis for thenext iteration.

D. A prototype is created that addresses 80 to 90% of the business requirements. This isdemonstrated to the users and their feedback is used to refine the prototype in subsequentiterations.

Which of the following allows greatest flexibility in formatting but generally has the lowestinteractivity with the users?

A. Analysis

B. Query

C. Dashboards

D. Managed Reports

Which of the following issues is Iterative Development specifically designed to address?

A. The very act of developing a system or solution will change the business requirements.

B. Users understand their business processes but they don't usually understand applicationdevelopment.

C. No developed solution will satisfy all users equally.

D. Users often feel that IT does not understand the business.

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

A. Report Studio and Query Studio

B. Analysis Studio and Report Studio

C. Data Manager and Analysis Studio

D. Planning, Data Manager, and Report Studio

Which of the following is NOT a critical feature or function of a scorecard?

A. Targets

B. Projections

C. Tolerances

D. Histories

When considering the differences between Analysis, Reporting, and Querying, which of thefollowing is NOT a user who needs Analysis?

A. A user who takes answers from one question as a starting point for other questions

B. A user who needs to understand multiple factors influencing performance

C. A user who needs to identify and understand trends from multiple perspectives

D. A user who views detailed data, which is optionally totaled and subtotaled

Which statement is true about the BI Bus?

A. It is the name of the report process that is spawned and viewed in Windows Task Managerwhen a report execution request is processed.

B. It monitors all http traffic flowing through the gateways and dispatchers.

C. It is a set of protocols that govern communications amongCognos BIservices.

D. It uses a JDBC driver to connect to Content Stores in Sybase, SQLServer, Oracle and DB2.

A multi-server installation ofCognos BImust be performed.

Which of the following is a validstrategy for installing across multiple servers?

A. Separate the gateway component from other server components to restrict report requestprocessing to the Web server tier.

B. Enable dedicated request processing, by installing a dispatcher in the Web server tier to act asa primary dispatcher for routing requests to other dispatchers.

C. Scale the system vertically by installing one instance of all Cognos 8 services on a largercomputer capable of managing more concurrent request threads.

D. Enable load balancing of requests for content management services by installing multipleinstances of Content Manager.

Companies often create a collection of summary tables as their first attempt at a data warehouse.While there are several drawbacks to this approach, there are also some advantages.

Which ofthe following is an advantage of this approach over reporting from an operational database?

A. It is easier to understand because there are fewer summary tables.

B. Specific reports for which the summary tables were created will run faster.

C. It is easy to leverage many new reports from the summary tables.

D. Over time summary tables often naturally group into business subject areas.

Which of the following describes a disadvantage of using the dimensionally modeled relational(DMR) technique to access a normalized data structure?

A. does not allow access to all relational items in Query and Report Studio

B. may increase the time needed to fetch required data

C. does not allow access to member functions

D. may bypass aggregate aware tables

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 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.

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.