MDM Quiz

Posted on: | By: – Comments Off

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
2) Columns on which matching would be  performed:

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
3) What is the prerequisite for Data Profiling

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
13) What follows a match exercise in a Data quality Cycle

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
14) Process of correcting inconsistent data

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
15) Process of removing Junk Data

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
16) Which of the following is a Data quality tool

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
18) Which is not a standard capability of Data quality Tool

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
19) Which is  a standard capability of Data quality Tool

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
20) Transformation that is used to cleanup Inconsistent Data in Informatica Data Quality

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
21) Which among the following Tools is not a Data Quality Tool

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
22) Component generally used to consolidate data coming from two data sets

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
23) Which of the following is a 3rd party Data provider(Used for Data enrichment)

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
28) Which of the following is an MDM tool

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
33) Master Data should be owned by the technical team to keep it as a single unified record of truth.

  1. TRUE
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
36) Which of the following is  not considered as a Master Data entity.

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
37) Master Data assets are owned by

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
38) MDM system can also host reference data

  1. TRUE
  2. FALSE
  3. –
  4. –

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
39) MDM system can also host transaction data

  1. TRUE
  2. FALSE
  3. –
  4. –

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
40) MDM system can also host metadata for master data entities

  1. TRUE
  2. FALSE
  3. –
  4. –

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
41) The following can data entities can be part of MDM

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
42) MDM enables organizations to centralize product information from ____________ systems

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 
 
43) Which MDM Style is referred as “System of reference”

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
44) EIM Stands for

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
45) It is this __________ Data on which enterprise business transactions are executed.

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
46) True or False : Reference data is a subset of Master data

  1. TRUE
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
47) Which one of the following is NOT a core Master Data entity

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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
48) True or False : Data Warehouse is the best place to store master data

  1. TRUE
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : B[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
50) True or False : A MDM “program” is seldom an one-time/do-it-and-forget-it implementation

  1. TRUE
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
51) True or False : Metadata is an essential component of a MDM System

  1. TRUE
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : D[/bg_collapse]
 
 
53) Change Management is an important part of a MDM implementation

  1. TRUE
  2. FALSE

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : A[/bg_collapse]
 
 
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

[bg_collapse view=”button-green” color=”#FFF” icon=”arrow” expand_text=”Show Answer” collapse_text=”Hide Answer” ]Answer : C[/bg_collapse]
 



 

Related Articles

Advanced Manufacturing Process Quiz

Web analytics, Adobe Analytics, Google Analytics Quiz

SailPoint Quiz