MDM Quiz

MDM Beginner Quiz

 



MDM Quiz contain set of 54 MCQ questions for MDM MCQ which will help you to clear beginner level quiz.



 
1) Which of these activities generally doesn’t fall into Data Quality life cycle

  1. Data Profiling
  2. Data Cleansing
  3. Data Archiving
  4. Data Standardization

Answer : C

 
 
2) Columns on which matching would be  performed:

  1. Match group
  2. Match column
  3. Match Key
  4. None of the Above

Answer : C

 
 
3) What is the prerequisite for Data Profiling

  1. Data Sampling
  2. Data Standardization
  3. Data Enrichment
  4. All of the above

Answer : A

 
 
4) What are the Key Business Benefits of Data Quality Management

  1. Increases Operational Efficiency
  2. Driver for Sales Growth
  3. Better Relationship with Customers(Customer Relationship Management)
  4. All of the above

Answer : D

 
 
5) what is the Process of selecting certain data from a huge data set to perform data profiling termed as:

  1. Data consolidation
  2. Data sampling
  3. Data masking
  4. Data archiving

Answer : B

 
 
6) What does Term ‘Data Profiling’ Refers to :

  1. Cleaning Up of Data
  2. Identifying Issues in the data
  3. Loading of Data
  4. Consolidation of Data

Answer : B

 
 
7) What does the Term ‘Data Conformity’ Refers to :

  1. To check for Data adhering to defined standards (Patterns)
  2. To check if data is present or not
  3. To check if data contains duplicates
  4. To check if data has any junk values

Answer : A

 
 
8) What does data quality dimension-Data Accuracy measures :

  1. Junk data
  2. Non usable data for Business
  3. Data that is unavailable
  4. A & B

Answer : D

 
 
9) Which of the listed one is not a standard Data Profiling Metric:

  1. Data Velocity
  2. Data Completeness
  3. Data Accuracy
  4. Data Consistency

Answer : A

 
 
10) The process of finding and removing similar and closely matched records using a data quality routine is known as:

  1. Matching
  2. De-duplication
  3. Duplication
  4. None

Answer : B

 
 
11) What does the Term ‘Data Completeness’ Refers to :

  1. Availability of the data in a column
  2. Data without Duplicates
  3. Data without Junk values
  4. Standardized Data

Answer : A

 
 
12) What does ‘Data Parsing’ Refers to:

  1. Splitting a field value into multiple fields based on a set of rules to interpret the data in a meaningful way
  2. Loading data from two columns into one column
  3. consolidating data from different sources
  4. None of the Above

Answer : A

 
 
13) What follows a match exercise in a Data quality Cycle

  1. Merge
  2. Standardization
  3. Cleansing
  4. None of the Above

Answer : A

 
 
14) Process of correcting inconsistent data

  1. Data Standardization
  2. Data Merging
  3. Data Consolidation
  4. Data Migration

Answer : A

 
 
15) Process of removing Junk Data

  1. Data Standardization
  2. Data Merging
  3. Data Consolidation
  4. Data cleansing

Answer : D

 
 
16) Which of the following is a Data quality tool

  1. Cognos
  2. Microstrategy
  3. Trillium
  4. All of the above

Answer : C

 
 
17) Key Functionality of Data Quality that is also  present in MDM

  1. Match & Merge
  2. Address Standardization
  3. Data Profiling
  4. All of the above

Answer : A

 
 
18) Which is not a standard capability of Data quality Tool

  1. Data Profiling
  2. Data cleansing
  3. Data Standardization
  4. Record Version

Answer : D

 
 
19) Which is  a standard capability of Data quality Tool

  1. Data cleansing
  2. Data Archiving
  3. Data Security
  4. All of the above

Answer : A

 
 
20) Transformation that is used to cleanup Inconsistent Data in Informatica Data Quality

  1. Standardizer
  2. Match
  3. Merge
  4. Expression

Answer : A

 
 
21) Which among the following Tools is not a Data Quality Tool

  1. Microstrategy
  2. Trillium
  3. IBM Information Analyzer
  4. Dataflux

Answer : A

 
 
22) Component generally used to consolidate data coming from two data sets

  1. Joiner
  2. Union
  3. Router
  4. Match

Answer : B

 
 
23) Which of the following is a 3rd party Data provider(Used for Data enrichment)

  1. Oracle
  2. IBM
  3. Salesforce
  4. Duns & Bradstreet

Answer : D

 
 
24) Which of the following is a Data quality Tool offered by Informatica

  1. Informatica Developer
  2. Informatica Analyst
  3. Both 1 & 2
  4. Information Analyzer

Answer : C

 
 
25) The main purpose of a Master Data Management system is

  1. Host transactional data
  2. Host duplicate instances of master data
  3. Host single version of master data
  4. None of above

Answer : C

 
 
26) Which of the following is a not a characteristic of master data

  1. Static or Slowly Changing
  2. Low Risk
  3. Shared
  4. Governed

Answer : B

 
 
27) Which of the following Is not a key feature of an MDM tool

  1. Transaction Processing
  2. Hierarchy Management
  3. Workflow
  4. Data Consolidation

Answer : A

 
 
28) Which of the following is an MDM tool

  1. SAP ECC
  2. IBM DataStage
  3. Oracle Product Data Hub
  4. Informatica PowerCenter

Answer : C

 
 
29) The process of separating two combined records is called

  1. Unmerge
  2. De-duplication
  3. None of the above
  4. Both of the above

Answer : A

 
 
30) Which one of the following can be considered as MDM Best Practice

  1. Business and IT teams work as different units, not related
  2. Business and IT team work together
  3. None of the above
  4. Both of the above

Answer : B

 
 
31) In Master Data Management, SSOT Stands for

  1. Single Source of Truth
  2. Simple Source of Truth
  3. Single Source of Transactions
  4. Single Source of Tables

Answer : A

 
 
32) Following are the supporting tools/processes for MDM:

  1. A) Database
  2. B) Data Model
  3. C) Metadata
  4. A
  5. B
  6. None of the above
  7. All of the above

Answer : D

 
 
33) Master Data should be owned by the technical team to keep it as a single unified record of truth.

  1. TRUE
  2. FALSE

Answer : B

 
 
34) MDM is a discipline to bring people, process and ………… together to address enterprise master data challenges and improve operational efficiency. Choose appropriate answer.

  1. Employees
  2. Technology
  3. References
  4. None of above

Answer : B

 
 
35) Apart from data management, which other aspect of data is addressed by MDM system

  1. Data Quality
  2. Data Archival
  3. Data Mining
  4. All of above

Answer : A

 
 
36) Which of the following is  not considered as a Master Data entity.

  1. Customer
  2. Vendor
  3. Invoices
  4. Product

Answer : C

 
 
37) Master Data assets are owned by

  1. Data owner
  2. Organization
  3. Data steward
  4. Data Manager

Answer : B

 
 
38) MDM system can also host reference data

  1. TRUE
  2. FALSE

Answer : A

 
 
39) MDM system can also host transaction data

  1. TRUE
  2. FALSE

Answer : B

 
 
40) MDM system can also host metadata for master data entities

  1. TRUE
  2. FALSE

Answer : A

 
 
41) The following can data entities can be part of MDM

  1. Product Data
  2. Customer Data
  3. Supplier Data
  4. All the above

Answer : D

 
 
42) MDM enables organizations to centralize product information from ____________ systems

  1. Heterogeneous
  2. Homogeneous
  3. Both
  4. None of the above

Answer : C

 
 
43) Which MDM Style is referred as “System of reference”

  1. Transaction
  2. Consolidation
  3. Coexistence
  4. Registry

Answer : B

 
 
44) EIM Stands for

  1. Enterprise infrastructure Management
  2. Enterprise Information Management
  3. Enterprise Information Master
  4. Enterprise Identity Management

Answer : B

 
 
45) It is this __________ Data on which enterprise business transactions are executed.

  1. Meta
  2. Master
  3. Transactional
  4. None of the above

Answer : B

 
 
46) True or False : Reference data is a subset of Master data

  1. TRUE
  2. FALSE

Answer : A

 
 
47) Which one of the following is NOT a core Master Data entity

  1. Parties
  2. Price
  3. Places
  4. Things

Answer : B

 
 
48) True or False : Data Warehouse is the best place to store master data

  1. TRUE
  2. FALSE

Answer : B

 
 
49) True or False : MDM is the sum of processes, governance, policies, standards and tools that consistently define and manage  critical data of an organization to provide a single point of reference

  1. TRUE
  2. FALSE

Answer : A

 
 
50) True or False : A MDM “program” is seldom an one-time/do-it-and-forget-it implementation

  1. TRUE
  2. FALSE

Answer : A

 
 
51) True or False : Metadata is an essential component of a MDM System

  1. TRUE
  2. FALSE

Answer : A

 
 
52) Which of the following is an attribute of MDM

  1. Data Completeness
  2. Data Consistancy
  3. Consolidated view of master data
  4. All of the above

Answer : D

 
 
53) Change Management is an important part of a MDM implementation

  1. TRUE
  2. FALSE

Answer : A

 
 
54) _______________ data stores the relationships between other data. It may be stored as part of an accounting system or separately as descriptions of real-world relationships, such as company organizational structures or product lines.

  1. Unstructured
  2. Transactional
  3. Hierarchical
  4. Meta

Answer : C