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
- Data Profiling
- Data Cleansing
- Data Archiving
- Data Standardization
2) Columns on which matching would be performed:
- Match group
- Match column
- Match Key
- None of the Above
3) What is the prerequisite for Data Profiling
- Data Sampling
- Data Standardization
- Data Enrichment
- All of the above
4) What are the Key Business Benefits of Data Quality Management
- Increases Operational Efficiency
- Driver for Sales Growth
- Better Relationship with Customers(Customer Relationship Management)
- All of the above
5) what is the Process of selecting certain data from a huge data set to perform data profiling termed as:
- Data consolidation
- Data sampling
- Data masking
- Data archiving
6) What does Term ‘Data Profiling’ Refers to :
- Cleaning Up of Data
- Identifying Issues in the data
- Loading of Data
- Consolidation of Data
7) What does the Term ‘Data Conformity’ Refers to :
- To check for Data adhering to defined standards (Patterns)
- To check if data is present or not
- To check if data contains duplicates
- To check if data has any junk values
8) What does data quality dimension-Data Accuracy measures :
- Junk data
- Non usable data for Business
- Data that is unavailable
- A & B
9) Which of the listed one is not a standard Data Profiling Metric:
- Data Velocity
- Data Completeness
- Data Accuracy
- Data Consistency
10) The process of finding and removing similar and closely matched records using a data quality routine is known as:
- Matching
- De-duplication
- Duplication
- None
11) What does the Term ‘Data Completeness’ Refers to :
- Availability of the data in a column
- Data without Duplicates
- Data without Junk values
- Standardized Data
12) What does ‘Data Parsing’ Refers to:
- Splitting a field value into multiple fields based on a set of rules to interpret the data in a meaningful way
- Loading data from two columns into one column
- consolidating data from different sources
- None of the Above
13) What follows a match exercise in a Data quality Cycle
- Merge
- Standardization
- Cleansing
- None of the Above
14) Process of correcting inconsistent data
- Data Standardization
- Data Merging
- Data Consolidation
- Data Migration
15) Process of removing Junk Data
- Data Standardization
- Data Merging
- Data Consolidation
- Data cleansing
16) Which of the following is a Data quality tool
- Cognos
- Microstrategy
- Trillium
- All of the above
17) Key Functionality of Data Quality that is also present in MDM
- Match & Merge
- Address Standardization
- Data Profiling
- All of the above
18) Which is not a standard capability of Data quality Tool
- Data Profiling
- Data cleansing
- Data Standardization
- Record Version
19) Which is a standard capability of Data quality Tool
- Data cleansing
- Data Archiving
- Data Security
- All of the above
20) Transformation that is used to cleanup Inconsistent Data in Informatica Data Quality
- Standardizer
- Match
- Merge
- Expression
21) Which among the following Tools is not a Data Quality Tool
- Microstrategy
- Trillium
- IBM Information Analyzer
- Dataflux
22) Component generally used to consolidate data coming from two data sets
- Joiner
- Union
- Router
- Match
23) Which of the following is a 3rd party Data provider(Used for Data enrichment)
- Oracle
- IBM
- Salesforce
- Duns & Bradstreet
24) Which of the following is a Data quality Tool offered by Informatica
- Informatica Developer
- Informatica Analyst
- Both 1 & 2
- Information Analyzer
25) The main purpose of a Master Data Management system is
- Host transactional data
- Host duplicate instances of master data
- Host single version of master data
- None of above
26) Which of the following is a not a characteristic of master data
- Static or Slowly Changing
- Low Risk
- Shared
- Governed
27) Which of the following Is not a key feature of an MDM tool
- Transaction Processing
- Hierarchy Management
- Workflow
- Data Consolidation
28) Which of the following is an MDM tool
- SAP ECC
- IBM DataStage
- Oracle Product Data Hub
- Informatica PowerCenter
29) The process of separating two combined records is called
- Unmerge
- De-duplication
- None of the above
- Both of the above
30) Which one of the following can be considered as MDM Best Practice
- Business and IT teams work as different units, not related
- Business and IT team work together
- None of the above
- Both of the above
31) In Master Data Management, SSOT Stands for
- Single Source of Truth
- Simple Source of Truth
- Single Source of Transactions
- Single Source of Tables
32) Following are the supporting tools/processes for MDM:
- A) Database
- B) Data Model
- C) Metadata
- A
- B
- None of the above
- All of the above
33) Master Data should be owned by the technical team to keep it as a single unified record of truth.
- TRUE
- FALSE
34) MDM is a discipline to bring people, process and ………… together to address enterprise master data challenges and improve operational efficiency. Choose appropriate answer.
- Employees
- Technology
- References
- None of above
35) Apart from data management, which other aspect of data is addressed by MDM system
- Data Quality
- Data Archival
- Data Mining
- All of above
36) Which of the following is not considered as a Master Data entity.
- Customer
- Vendor
- Invoices
- Product
37) Master Data assets are owned by
- Data owner
- Organization
- Data steward
- Data Manager
38) MDM system can also host reference data
- TRUE
- FALSE
- –
- –
39) MDM system can also host transaction data
- TRUE
- FALSE
- –
- –
40) MDM system can also host metadata for master data entities
- TRUE
- FALSE
- –
- –
41) The following can data entities can be part of MDM
- Product Data
- Customer Data
- Supplier Data
- All the above
42) MDM enables organizations to centralize product information from ____________ systems
- Heterogeneous
- Homogeneous
- Both
- None of the above
43) Which MDM Style is referred as “System of reference”
- Transaction
- Consolidation
- Coexistence
- Registry
44) EIM Stands for
- Enterprise infrastructure Management
- Enterprise Information Management
- Enterprise Information Master
- Enterprise Identity Management
45) It is this __________ Data on which enterprise business transactions are executed.
- Meta
- Master
- Transactional
- None of the above
46) True or False : Reference data is a subset of Master data
- TRUE
- FALSE
47) Which one of the following is NOT a core Master Data entity
- Parties
- Price
- Places
- Things
48) True or False : Data Warehouse is the best place to store master data
- TRUE
- FALSE
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
- TRUE
- FALSE
50) True or False : A MDM “program” is seldom an one-time/do-it-and-forget-it implementation
- TRUE
- FALSE
51) True or False : Metadata is an essential component of a MDM System
- TRUE
- FALSE
52) Which of the following is an attribute of MDM
- Data Completeness
- Data Consistancy
- Consolidated view of master data
- All of the above
53) Change Management is an important part of a MDM implementation
- TRUE
- FALSE
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.
- Unstructured
- Transactional
- Hierarchical
- Meta