IBM C2020-180 Online Practice Questions and Exam Preparation

IBM C2020-180 Online Questions & Answers

• Question 31:

  When a user requests a certain piece of information, the interviewer may ask what the user woulddo with that information. From the techniques described in the BI Professional Workshop, why isthe interviewer asking this particular question?

  A. To determine if the user is allowed access to that particular information and therefore shouldnot be included in his subject area.
  B. To determine if the user understands how the information is functionally used within theorganization.
  C. To determine if the information is a security concern and should therefore be made unavailableto other users.
  D. To determine if the information is an actionable item for the user and therefore part of abusiness requirement.
  D. To determine if the information is an actionable item for the user and therefore part of abusiness requirement.

• Question 32:

  Which of the following is a critical component in delivering Corporate Performance Managementthroughout an enterprise?

  A. Drill down from summary to detailed information within individual subject areas.
  B. Drill across from one subject area to another through conformed dimensions.
  C. Star schema data marts designed to facilitate analysis and reporting.
  D. Event management designed to monitor the status of Key Performance Indicators.
  B. Drill across from one subject area to another through conformed dimensions.

• Question 33:

  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. The very act of developing a system or solution will change the business requirements.

• Question 34:

  Which of the following describes the design goals of a reporting database?

  A. provide fast access to corporate data for analysis and reporting
  B. provide near real time access to summarized corporate data for analysis and reporting
  C. provide fast access to corporate data and act as a system of record
  D. provide near real time access to summarized transactional data
  A. provide fast access to corporate data for analysis and reporting

• Question 35:

  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
  D. Plan, move, and verify

• Question 36:

  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.
  B. Use theCognos BIsecurity objects.

• Question 37:

  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
  B. Tables with the greatest number of rows

• Question 38:

  Which of the following describes the models contained in the '24 Ways' book referenced in the BIProfessional Workshop course?

  A. Framework Manager models that map over an example normalized database, which one mightfind in a manufacturing enterprise.
  B. Physical, star schema data models for constructing data marts for the various departments in ageneric business enterprise.
  C. Logical models that contain dimensions and key tactical metrics for the various departments ina generic business enterprise.
  D. Cognos 8 OLAP Modeler (Transformer) models that describe how to map data from amanufacturing database into a PowerCube.
  C. Logical models that contain dimensions and key tactical metrics for the various departments ina generic business enterprise.

• Question 39:

  A consultant realizes after determining business requirements, that a complete solution willrequire several related but separate projects. The consultant must choose one project to deliverfirst. Which of the following describes the considerations that should govern that choice?

  A. Priority of IT, ease of development, resource availability, and data availability
  B. Business impact, ease of development, resource availability, and number of target users
  C. Data availability, ease of development, resource availability, and position of project sponsor inthe organization
  D. Business impact, data availability, ease of development, and resource availability
  D. Business impact, data availability, ease of development, and resource availability

• Question 40:

  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
  D. Sales Variance