DQ

DQ practice questions, page 2 of 4, with answer review and explanations.

Question 6

The monthly release of operational software changed the database, removing a column that was no longer required. The data warehouse failed for three weeks. What was missing from the change process?

  1. More signatures on the change form (e.g. the data warehouse manager)
  2. Robust warehouse design that was designed around meaningless column in the operational system
  3. Star schema compliance that would not cause this failure in the data warehouse
  4. The deleted column
  5. Impact analysis that tracked the data value chain to the end

Question 7

Which of the following would be most appropriate for collecting data to study the symptoms of a problem?

  1. An Activity Network Diagram
  2. A flow diagram
  3. A force field analysis
  4. A check sheet
  5. A blank sheet

Question 8

As an Information Quality Professional you have found yourself in a situation where you are being asked to manipulate business rules to improve the performance targets of a Business Steward who is an old friend. What is the best course of action?

  1. Notify your friend's manager that they have made this request.
  2. Inform your parents and ask them what to do
  3. Advise your friend that their request would require you to break the Code of Ethics of your profession, as well as internal disciplinary rules
  4. Make the change once but advise your friend that it must be a one off
  5. Notify your manager that you have been asked to do this and seek their sign off

Question 9

Which of these is a Key Success Factor in Information Quality Improvement?

  1. A comprehensive records management procedure
  2. Exhaustively defined Governance framework in place
  3. Active business stakeholder involvement
  4. Selection of 'best in class' technology or consulting partners
  5. Timely investment in 'best of breed' software

Question 10

Data Stewards are an important part of an organization's Data Quality framework. Define Data Stewardship

  1. A role that is the same as a data quality manager
  2. Ensuring that DQ issues are identified and resolved in a timely and effective manner
  3. A mechanism by which the modelling of data elements can be drawn in reusable tools
  4. A role formalising accountability for managing information resources on behalf of others and for the best interests of the organisation
  5. A set of rights and responsibilities that are embedded in all the job descriptions