IBM Cognos BI Professional - C2090-180 Exam Practice Test

A. All dimensions must have hierarchies.

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

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

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

A. Copy the BI application to a duplicate environment.

B. Back up the production application into the test environment.

C. Integrate the BI application into existing production backup plans.

D. Implement a BI application backup plan separate from other production applications.

A. MDX has built in functions to support relative date calculations while SQL cannot perform relative date calculations.

B. MDX can reference metadata that SQL cannot.

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

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

A. The environment contains customized port and firewall settings for the default http and application server port.

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

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

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

A. A managed report is intended to be run on a regular execution schedule from a background batch process whereas a query is run interactively.

B. A managed report prompts users for run-time parameters whereas a query does not.

C. A managed report is intended to be run on a regular execution schedule whereas a query is intended to be authored and run on-demand.

D. A managed report is authored by trained developers whereas a query is authored by either trained developers or end users.

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

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

C. Job responsibilities, objectives, what information they need to get their work done, and copies of key reports

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

A. Dashboards

B. Analysis

C. Managed Reports

D. Query