C2090-180 Online Practice Questions and Answers

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

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 BEST describes the relationship or differences between Iterative Approachand Cognos SIM?

A. The Iterative Approach is a specific technique used to iterate through the Design phase.

B. The Iterative Approach is a series of steps defined in the Analysis and Development phases ofCognos SIM.

C. The Iterative Approach is a philosophy of development while Cognos SIM is a collection oftasks, documents, and techniques to guide development.

D. Cognos SIM is the current Cognos development standard and is intended to replace theIterative Approach for development of BI applications.

Which of the following is a valid strategy for addressing failover for the content store?

A. Install active and passive instances of the content store.

B. Install active and passive instances of the Content Manager service.

C. Take advantage of failover protection in the Applications tier by installing the content store ona server that hosts multiple instances of the report service.

D. Take advantage of database backup and failover strategies and policies already in place in theenvironment.

Which of the following requires additional configuration for installingCognos BIin adevelopment and production environment?

A. The application in the development environment and in the production environment will use the Tomcat servlet container as the application server.

B. The development environment will include workstations hosting Framework Manager andCognos 8 OLAP Modeling, while the production environment will not.

C. The environment contains customized port and firewall settings for the default http andapplication server port.

D. The development and production environment will use data sources that are in Unicode.

WhileCognos BIwill support any data warehouse design, which of the following designs doesCognos recommend for new warehouse development?

A. Operational Data Store

B. Dimensionally Modeled Relational

C. Normalized Enterprise

D. Dimensional Bus

Which of the following describes the design goals of a reporting database?

A. provide fast access to corporate data for analysis and reporting

B. provide near real time access to summarized corporate data for analysis and reporting

C. provide fast access to corporate data and act as a system of record

D. provide near real time access to summarized transactional data

Which of the following describes how Cognos 8 works with aggregate aware tables in relationaldata sources?

A. Cognos 8 can create aggregate aware tables within the database.

B. Cognos 8 redirects its generated SQL to take advantage of aggregate aware tables.

C. Cognos 8 does not make any specific adjustments for aggregate aware tables.

D. Cognos 8 can monitor reports that are run and suggest aggregate aware tables.

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

A. record and track enhancement requests

B. communicate with users to insure the application is delivering value

C. periodically re-apply the V-test model against the developed components

D. enhance application documentation to reflect errors and omissions

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

A. Tables with the fewest number of columns

B. Tables with the greatest number of rows

C. Tables with the greatest number of foreign keys

D. Tables with the fewest number of foreign keys