C2090-180 Online Practice Questions and Answers

Which of the following describes the major steps in the deployment process for aCognos BIapplication and their proper order?

A. Plan, verify, and customize

B. Move, customize, and verify

C. Plan, move, and secure

D. Plan, move, and verify

Which of the following is correct regarding the processing of a PageDown high affinity request?

A. The request is routed to the same process that served up the originating low affinity request ifthe process is available and if there is an available high affinity connection.

B. The request is given priority and is always processed by the same process that served up theoriginating low affinity request.

C. The request is load-balanced and is sent to any available dispatcher in the system.

D. The request is automatically queued and is processed by the first available low affinityconnection in the system.

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

A company has a manufacturing database they wish to interrogate. They know there are issuesthat have affected production quality over the last year but they are unsure exactly what factorsare contributing to the problem. They would like to be able to quickly examine manufacturedbatches from multiple perspectives and, if there are any anomalies or any unusual trends overtime, they would then like to focus on specific batches to understand the details.

Which of thefollowing Cognos 8 Components would BEST address their needs?

A. Analysis Studio and Report Studio

B. Report Studio and Query Studio

C. Event Studio and Report Studio

D. Analysis Studio and Metric Studio

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

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 is a key difference between MDX and SQL?

A. MDX is used for dimensional style reporting while SQL is incapable of dimensional stylereporting.

B. MDX has built in functions to support relative date calculations while SQL cannot performrelative date calculations.

C. Dimensionally Modeled Relational (DMR) retrieves data using MDX, not SQL.

D. MDX can reference metadata that SQL cannot.

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

Which of the following is true regarding hierarchies and dimensions?

A. Hierarchies help users understand the data through rollup levels within dimensions.

B. All dimensions must have hierarchies.

C. All hierarchies are defined by the inherent nature of their dimensional data.

D. It is considered poor design to split a hierarchy across multiple dimensions.