IBM C2020-180 Online Practice Questions and Exam Preparation

IBM C2020-180 Online Questions & Answers

• Question 61:

  Which of the following describes Key Performance Indicators (KPI)?

  A. Specific metrics, usually derived, by which a company measures its progress and success.
  B. Strategic goals, typically specified by executives, which describe the direction and objectives ofthe organization.
  C. Industry standards by which organizations measure themselves against others in their marketspace.
  D. Core, atomic level data items that provide input into higher level derived items which thenappear on scorecards.
  A. Specific metrics, usually derived, by which a company measures its progress and success.

• Question 62:

  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
  B. snowflake schema

• Question 63:

  A table is in Third Normal Form if it is already in Second Normal Form, plus:

  A. All attributes are determined only by the primary key
  B. All attributes are determined by all segments of the primary key
  C. All foreign keys are determined by the primary key
  D. All surrogate keys are determined by the primary key
  A. All attributes are determined only by the primary key

• Question 64:

  All of the following are considered part of the analyze phase of a BI development project EXCEPT:

  A. Conduct a readiness assessment
  B. Analyze solution scope
  C. Determine detailed requirements
  D. Create a logical data model
  D. Create a logical data model

• Question 65:

  Which of the following is a significant cause of failure when using the technology- focusedapproach to BI Application development?

  A. Users often have difficulty understanding new technology.
  B. New technology often contains internal flaws and errors that affect the delivered solution.
  C. The solution is focused on a single subject area.
  D. Developers often focus on just the data.
  D. Developers often focus on just the data.

• Question 66:

  Which of the following statements is true about the Waterfall Approach?

  A. The five steps in the process are considered valid for BI software development projects.
  B. Each step is performed in sequence but you return to previous steps at specific points in thedevelopment cycle.
  C. It is designed so that requirements that are not discovered in the Analysis step will cascadeout during the design phase.
  D. Project management tools no longer encourage the Waterfall Approach.
  A. The five steps in the process are considered valid for BI software development projects.