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

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 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 describes the benefits of Cognos Application Firewall (CAF)?

A. It protects the application by monitoring all HTTP requests sent through the Web server toensure the gateway is receiving valid requests.

B. It allowsCognos BIto run over the Internet.

C. It monitors and validates all input requests to prevent parameter manipulation, SQL injection,and buffer overflow.

D. It encrypts all input requests for validation before they are sent to the dispatcher.

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

The partial diagram below is an example of what type of database schema design?

A. star schema

B. snowflake schema

C. normalized schema

D. de-normalized schema

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.

A table is in Third Normal Form if it is already in Second Normal Form, plus:

A. All attributes are determined only by the primary key

B. All attributes are determined by all segments of the primary key

C. All foreign keys are determined by the primary key

D. All surrogate keys are determined by the primary key

What is the recommended configuration size for Cognos 8 on a Windows 2003 Serverenvironment, and why?

A. Small or medium because Cognos 8 can only allocate 2 GB of memory per process.

B. Small because Java consumes half of the 2GB of RAM that can be allocated per process.

C. Small or medium because Cognos 8 can take advantage of the switch that allows 3GB of RAMper process.

D. Medium or large because Windows 2003 can allocate up to 4 GB of RAM per process.