Data Quality v1.0

Page:    1 / 7   
Exam contains 100 questions

You are running a data governance program for your enterprise. One of the data stewards is confused about the different dimensions of data quality. Identify the example that best describes what consistency is.

  • A. The set of customers defined in the billing system can be correlated to the customers in the product fulfillment system.
  • B. The monthly hours billed to a client doesn't exceed the average billed by more than 50%.
  • C. There are no products defined in the billing system with the same name and categorization.
  • D. The transactions for a client in the operational system are transferred into the data warehouse within 24 hours.
  • E. The list of products in the billing system is all the products sold by the company.


Answer : A

You have been asked to conduct an analysis into why reports generated from two tables do not produce consistent results.
What Technical Metadata would you prioritize as an input to your analysis?
1. Field names and formats
2. The opinion of the IT staff
3. Definition of the entities in each system
4. History of Load Dates

  • A. 1 and 2
  • B. 1 and 3
  • C. 1, 2, 3, and 4
  • D. 1, 2, and 3
  • E. 2 and 4


Answer : B

Which of the following techniques is most appropriate for generating continuous improvement ideas?

  • A. Brainstorming
  • B. Interrelationship graph
  • C. Tree Diagrams
  • D. Prioritisation matrix
  • E. Force-field analysis


Answer : A

For data to be fit for purpose, we must ensure that:

  • A. A logical data model is developed
  • B. A process to data CRUD matrix is developed for the data
  • C. Every usage (purpose) of the data is documented before the data is made available
  • D. Every data quality criteria throughout the life of the data is defined
  • E. Data Quality criteria are developed where we know the use that the data is to be put to, and data quality metrics are calculated to allow business users to make informed decisions on the suitability of the data


Answer : E

An organisation has major issues in country of birth with over 300 different spellings of Czechia. What might the first question a DQM asks?

  • A. Can we periodically check the values in the database are valid.
  • B. Can we stop collecting this data and remove it from the system?
  • C. Can we add more security over the field to restrict its variations?
  • D. Can we just leave it there, since they do not matter?
  • E. Can we add validation to the front end systems and block the creation of bad data?


Answer : A

What is the MEAN of this set of numbers: 12, 36, 9, 44, 100, 11?

  • A. 12
  • B. 35.33
  • C. 6
  • D. 91
  • E. 41


Answer : B

High quality data is not an end in itself, but is a means to:

  • A. Improved efficiency, decisions and customer service
  • B. Reduced efficiency, poor decision making, but extra ordinary customer
  • C. Improved efficiency, project selection and customer churn
  • D. Staff spending more time trying to figure out if the data is right
  • E. Improved response times, ideas and customer service


Answer : A

Master Data promotes high data quality by:

  • A. Establishing repositories of reliable and trustworthy of commonly reused data.
  • B. Simplifying the construction of data warehouses
  • C. Establishing conflicting sources of commonly used data
  • D. Establishing multiple sources of reliable, commonly reused data.
  • E. Establishing clear separation of master and reference data definitions


Answer : A

One principle of data quality management is to focus improvement efforts on data that is:

  • A. Has the highest confidentiality requirement
  • B. Most accessible and easy to fix
  • C. Unstructured
  • D. Purchased from 3rd parties
  • E. Most important to the organisation and customers


Answer : E

'The separation of character strings or free-form text fields into their component parts, meaningful patterns, or attributes, and moves the parts into clearly labelled and distinct fields'. This describes which Information Quality process/activity?

  • A. Matching
  • B. Standardisation
  • C. Scorecarding
  • D. Enrichment
  • E. Parsing


Answer : E

A phone number in a country has 9 digits. They are 2 digits for the country code, 3 digits for the area code and 4 digits for the phone number (with a space between each part). A valid phone number is:

  • A. +23 657 3561
  • B. +23 657 39561
  • C. +283 657 3961
  • D. 236539561
  • E. +23 67 39561


Answer : A

A Data Quality metric should have these characteristics:

  • A. Uncontrollability
  • B. No business impact upon failure
  • C. Always green
  • D. Trending upward
  • E. Controllability


Answer : E

A soil geologist is analysing the conductivity of different beach sands. What data set is useful for his analysis.

  • A. Sea bird nesting sites in the vicinity of beaches.
  • B. Beach umbrella safety incident reports.
  • C. Water pollution levels and longitudinal trends.
  • D. The 20 different types of silicon that compose beaches within his area of interest.
  • E. Vegetation growth statistics of the surrounding areas.


Answer : D

A bowl contains 10 marbles: 3 red, 3 green, 4 blue. Two draws are taken, with the marbles being replaced each time. What is the probability of getting a RED marble on the first draw and a BLUE marble on the second draw?

  • A. 12%
  • B. 25%
  • C. 2%
  • D. 50%
  • E. 98%


Answer : A

When engaging in Merger and Acquisition activities, which of these should be the first step to be taken to avoid Information Quality problems?

  • A. Send staff from both organisations on team building training
  • B. Select target shared technology platform for the merged organisation
  • C. Launch a Data Migration project to bring the data together
  • D. Avoid data migration or system consolidation activities
  • E. Review the metadata of the organisations and identify gaps in definition, business rules, and meaning


Answer : E

Page:    1 / 7   
Exam contains 100 questions

Talk to us!


Have any questions or issues ? Please dont hesitate to contact us

Certlibrary.com is owned by MBS Tech Limited: Room 1905 Nam Wo Hong Building, 148 Wing Lok Street, Sheung Wan, Hong Kong. Company registration number: 2310926
Certlibrary doesn't offer Real Microsoft Exam Questions. Certlibrary Materials do not contain actual questions and answers from Cisco's Certification Exams.
CFA Institute does not endorse, promote or warrant the accuracy or quality of Certlibrary. CFA® and Chartered Financial Analyst® are registered trademarks owned by CFA Institute.
Terms & Conditions | Privacy Policy | Amazon Exams | Cisco Exams | CompTIA Exams | Databricks Exams | Fortinet Exams | Google Exams | Microsoft Exams | VMware Exams