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 report execution requests?

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

B. A low affinity request can be processed using a high affinity connection when a low affinityconnection is not available.

C. An absolute affinity request does not require a connection because it has priority.

D. A high affinity request can be processed using a low affinity connection if there are no highaffinity connections available.

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.

Which of the following is a common mistake made by designers when creating dimensionmodels?

A. Including alternatehierarchies.

B. Including multiple date/timehierarchies.

C. Splitting a single dimension into multiple dimensions.

D. Adding dimensions and measures from other subject areas.

A user makes the following request:"I need to see actual sales compared with projected sales,and margin range for branches within each division, by product line, sales rep by sales manager,and cost center over time." Based on the user's request, Actual Sales and Projected Sales havebeen identified as required measures.

Which of the following other measures would be includedin an initial dimension map?

A. Unit Cost

B. Average Sales

C. Discount Amount

D. Sales Variance

Which of the following statements describes the critical differences between a managed reportand a query?

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

B. A managed report is authored by trained developers whereas a query is authored by eithertrained developers or end users.

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

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

Which of the following issues is Iterative Development specifically designed to address?

A. The very act of developing a system or solution will change the business requirements.

B. Users understand their business processes but they don't usually understand applicationdevelopment.

C. No developed solution will satisfy all users equally.

D. Users often feel that IT does not understand the business.

A company records when customers check into a service center. If there are too many customerswaiting for the number of service representatives on hand, a manager wishes to be notified by ane-mail that contains a report showing the current condition.

Which of the following Cognos 8Components would BEST address their needs?

A. Office Connection and Report Studio

B. Data Manager, Event Management, and Office Connection

C. Office Connection and Query Studio

D. Event Management and Report Studio

Which of the following is NOT a critical feature or function of a scorecard?

A. Targets

B. Projections

C. Tolerances

D. Histories

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.

Companies often create a collection of summary tables as their first attempt at a data warehouse.While there are several drawbacks to this approach, there are also some advantages.

Which ofthe following is an advantage of this approach over reporting from an operational database?

A. It is easier to understand because there are fewer summary tables.

B. Specific reports for which the summary tables were created will run faster.

C. It is easy to leverage many new reports from the summary tables.

D. Over time summary tables often naturally group into business subject areas.

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 an advantage of using the dimensionally modeled relational(DMR) technique to access a normalized data structure?

A. eliminates the need for aggregate tables

B. reduces the time needed to fetch the required data

C. enables drill up/down functionality in reports and ad hoc queries

D. enables creation of IQDs for creating Power Cubes

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.

Which of the following is the recommended method of implementing a regular backup plan for aBI Application?

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

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

C. Copy the BI application to a duplicate environment.

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