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.

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

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

B. Job responsibilities, objectives, what information they need to get their work done, and copiesof key reports

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

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

A company wishes to coordinate the anticipated hiring activities of all of the departments in agiven division of the organization. The CEO has mandated a limit of 50 total new hires for thecoming fiscal year. The various departments must coordinate future hiring. The CEO would alsolike to see reports comparing the projected hiring vs. the actual number of new hires bydepartment.

Which set of Cognos 8 components BEST supports the company's needs?

A. Planning and Report Studio

B. Report Studio and Analysis Studio

C. Event Studio and Report Studio

D. Planning and Data Manager

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

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

A. record the day to day operations of the company

B. maximize the speed of inserts and updates to the database

C. enhance reporting through foreign keys and indexes

D. facilitate performing specific functional tasks

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.

When comparing two differently grained facts directly against one another, the developer must:

A. either write a union query or two reports that roll both facts up to a common level

B. either roll up the lower grained fact to the higher level or allocate the higher grained fact to thelower level

C. declare determinants at multiple levels in the dimensions of a DMR Framework Managermodel

D. ensure that all conformed dimensions shared by the facts have the same number of levels