IBM IBM Business Analytics C2090-180 Questions & Answers

• Question 21:

  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.

  Correct Answer: B

• Question 22:

  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

  Correct Answer: B

• Question 23:

  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

  Correct Answer: C

• Question 24:

  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

  Correct Answer: B

• Question 25:

  WhileCognos BIwill support any data warehouse design, which of the following designs doesCognos recommend for new warehouse development?

  A. Operational Data Store

  B. Dimensionally Modeled Relational

  C. Normalized Enterprise

  D. Dimensional Bus

  Correct Answer: D

• Question 26:

  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.

  Correct Answer: B

• Question 27:

  WhichCognos BIarchitectural component is written in C++?

  A. Batch report service

  B. Job service

  C. Monitoring service

  D. Presentation service

  Correct Answer: A

• Question 28:

  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.

  Correct Answer: C

• Question 29:

  A multi-server installation ofCognos BImust be performed.

  Which of the following is a validstrategy for installing across multiple servers?

  A. Separate the gateway component from other server components to restrict report requestprocessing to the Web server tier.

  B. Enable dedicated request processing, by installing a dispatcher in the Web server tier to act asa primary dispatcher for routing requests to other dispatchers.

  C. Scale the system vertically by installing one instance of all Cognos 8 services on a largercomputer capable of managing more concurrent request threads.

  D. Enable load balancing of requests for content management services by installing multipleinstances of Content Manager.

  Correct Answer: B

• Question 30:

  When deploying an application from a development environment to a production environment, which of the following is correct when each environment uses a separate LDAP instance?

  A. There are no issues because the Access Control List (ACL) references the same usernames.

  B. Use theCognos BIsecurity objects.

  C. Do not useCognos BIsecurity unless you are deploying your application using Series 7Cognos Access Manager for authentication.

  D. There are no issues because LDAP objects are always replicated between the environments.

  Correct Answer: B