KnowledgeAreaQuestion Number

Data Managem 16
Data Governan 18
Data Managem 19
Data Managem 20
Data Managem 21
Data Managem 22
Data Managem 23
Data Managem 24
Data Managem 25
Data Managem 27
Data Managem 29
Data Managem 30
Data Managem 31
Data Managem 32
Data Governan 33
Data Governan 34
Data Governan 35
Data Governan 36
Data Governan 37
Data Governan 38
Data Managem 39
Data Managem 40
Data Governan 41
Data Governan 42
Data Handling E 43
Data Quality 44
Data Managemen 45
Reference & Ma 46
Data Governan 48
Data Governan 49
Data Governan 50
Data Governan 51
Reference & Ma 52
Big Data and Da 53
Data Security 54
Data Governan 55
Data Managem 56
Data Managem 57
Data Governan 58
Data Architectu 59
Data Governan 60
Data Security 83
Data Architectu 130
Data Integration 131
Data Integration 132
Data Modeling 133
Data Architectu 134
Data Modeling 135
Data Modeling 136
Metadata 137
Metadata 138
Metadata 139
Metadata 140
Metadata 141
Reference & Ma 142
Metadata 143
Metadata 144
Metadata 145
Metadata 147
Data Architectu 148
Metadata 149
Data Integration 150
Metadata 151
Metadata 152
Metadata 153
Metadata 154
Metadata 155
Metadata 156
Metadata 157
Metadata 158
Metadata 159
Metadata 160
Data Architectu 161
Data Architectu 162
Data Architectu 163
Data Architectu 164
Data Architectu 165
Data Architectu 166
Data Modeling 167
Data Architectu 168
Data Integration 169
Big Data and Da 200
Data Warehousin 201
Data Warehousin 203
Big Data and Da 204
Data Warehousin 205
Data Warehousin 206
Big Data and Da 207
Big Data and Da 208
Big Data and Da 209
Metadata 210
Data Warehousin 211
Data Warehousin 212
Data Integration 214
Data Warehousin 215
Data Warehousin 216
Data Warehousin 217
Data Storage a 219
Data Warehousin 220
Data Warehousin 222
Data Warehousin 223
Data Warehousin 224
Data Warehousin 225
Data Warehousin 226
Data Warehousin 227
Data Warehousin 228
Data Modeling 229
Data Modeling 230
Data Warehousin 231
Data Modeling 232
Data Modeling 234
Data Modeling 236
Data Modeling 237
Data Modeling 238
Data Modeling 239
Data Modeling 240
Data Modeling 241
Data Storage a 288
Data Security 320
Data Security 321
Data Security 322
Data Security 324
Data Security 325
Data Managem 326
Data Security 327
Data Security 328
Data Security 329
Data Security 330
Data Security 331
Document and 360
Document and 361
Document and 362
Metadata 363
Document and 364
Document and 365
Document and 366
Document and 367
Document and 368
Document and 369
Data Storage a 370
Data Modeling 534
Data Architectu 600
Data Governan 601
Data Integration 602
Document and 603
Data Storage a 604
Data Quality 605
Data Modeling 606
Data Storage a 607
Data Security 608
Data Storage a 609
Data Integration 610
Data Quality 611
Data Storage a 612
Data Storage a 613
Data Integration 614
Data Integration 615
Reference & Ma 616
Reference & Ma 617
Data Quality 618
Data Integration 619
Data Storage a 620
Metadata 621
Data Architectu 622
Data Governan 623
Data Security 624
Data Modeling 625
Reference & Ma 626
Data Architectu 627
Data Storage a 628
Data Integration 629
Data Architectu 630
Data Security 631
Data Modeling 632
Reference & Ma 633
Data Managem 634
Data Warehousin 635
Data Quality 636
Reference & Ma 637
Metadata 638
Big Data and Da 639
Data Security 640
Data Integration 641
Data Security 642
Data Security 643
Reference & Ma 644
Data Modeling 645
Reference & Ma 646
Data Governan 647
Data Quality 648
Data Storage a 649
Reference & Ma 650
Data Security 651
Data Integration 652
Data Modeling 653
Data Modeling 654
Document and 655
Reference & Ma 656
Data Modeling 657
Data Storage a 658
Data Security 659
Data Modeling 660
Data Governan 661
Data Quality 662
Metadata 663
Data Storage a 664
Data Modeling 665
Data Quality 666
Data Quality 667
Data Storage a 668
Reference & Ma 669
Metadata 670
Data Integration 671
Data Quality 672
Data Integration 673
Data Security 674
Reference & Ma 675
Reference & Ma 676
Document and 677
Data Quality 678
Data Integration 679
Reference & Ma 680
Reference & Ma 681
Reference & Ma 682
Data Modeling 683
Reference & Ma 684
Data Modeling 685
Data Managem 686
Document and 687
Data Storage a 688
Data Storage a 689
Data Integration 691
Data Modeling 692
Data Quality 693
Data Architectu 694
Reference & Ma 695
Document and 696
Data Governan 697
Data Governan 698
Reference & Ma 699
Data Quality 700
Data Modeling 701
Data Quality 702
Data Quality 703
Big Data and Da 704
Metadata 705
Data Modeling 706
Data Governan 707
Reference & Ma 708
Data Security 709
Data Storage a 710
Data Quality 711
Data Security 712
Data Storage a 713
Data Modeling 714
Data Architectu 715
Document and 716
Data Handling E 717
Reference & Ma 718
Data Modeling 719
Data Security 720
Data Managem 721
Data Warehousin 722
Data Quality 723
Document and 724
Data Modeling 725
Reference & Ma 726
Data Managem 727
Data Quality 728
Data Warehousin 729
Data Security 730
Reference & Ma 731
Data Integration 732
Data Quality 733
Data Integration 734
Document and 735
Data Storage a 736
Reference & Ma 737
Data Architectu 738
Metadata 739
Data Security 740
Data Quality 741
Data Modeling 742
Document and 743
Data Security 744
Data Quality 745
Document and 746
Data Storage a 747
Data Integration 748
Reference & Ma 749
Data Quality 750
Data Quality 751
Data Integration 752
Reference & Ma 753
Data Modeling 754
Data Architectu 755
Data Modeling 756
Reference & Ma 757
Metadata 758
Reference & Ma 759
Data Integration 760
Data Integration 761
Data Quality 762
Data Security 763
Data Integration 764
Data Managem 765
Reference & Ma 766
Data Managem 767
Data Integration 768
Data Modeling 769
Data Integration 770
Data Quality 771
Data Quality 772
Data Quality 773
Data Modeling 774
Big Data and Da 775
Data Security 776
Data Modeling 777
Data Storage a 778
Document and 779
Data Security 780
Metadata 781
Question
Data is an organizational asset. What international standard is concerned with asset management?
According to the DMBoK2, which items are not a consideration in a data valuation?
According to the DMBOK, which of the following are included as Data Management goals?
What is NOT a discipline of Data Management according to the DAMA DMBoK?
The DAMA Wheel contains?
SMART is an acronym for objectives in projects and programs. SMART stands for?
Which of the following is NOT a goal of Data Management?
In the data lifecycle, the DMBoK recommends minimizing ROT data. ROT stands for?
Information is:
Data differs with regards to other assets because
Which is a valid Environmental component of data management?
Which of these is not a Knowledge Area in DMBoK v2?
The Data Management Body of Knowledge is produced by?
According to the DMBoK, which is not a component of a Data Management strategy?
According to the DAMA DMBoK, the Data Governance Council (DGC) is the highest-authority organization for Data Govern
What are the primary responsibilities of a data steward?
Which of these are NOT true of Data Governance?
Who is most responsible for communicating and promoting awareness on the value of Data Governance in the organizatio
Communicating the value of Data Governance can be approached in a number of ways. Which of the following approache
When considering a Data Governance program, communication is a key element. There are many ways of managing this co
How do Data Management professionals maintain commitment of key stakeholders to the Data Management initiative?
Data standards used by the enterprise must?
When new governmental and industry regulations are formulated and enacted, Data Governance plays a key role in the pr
The Data Governance Steering Committee is best described as?
The right to be forgotten is
Data Quality rules and standards are a form of data. To be effective, they need to be managed as data and rules should be
What area do you not consider when developing a Data Governance Operating Model?
For countries, is there an internationally recognized set of codes to use?
Every enterprise is subject to many governmental and industry regulations, many of which regulate how data and informa
What organization structure should set the overall direction for Data Governance?
Data Governance touch points throughout the project lifecycle are facilitated by this organization?
In the Information Management Lifecycle, the Data Governance activity Define the Data Governance Framework is in whic
As part of the reference Data Stewardship process, it is helpful to capture basic data about each reference data set. Which
Data for big data ingestion can also be called the data lake. This needs to be carefully managed or the data lake will becom
Obfuscation or redaction of data is the practice of?
Which of these is NOT a standard motivation for Data Governance?
Information needs to be managed because
The Information Lifecycle
Information Governance and Data Governance should be?
In the common enterprise architecture model coded BIAT, the 'I' stands for?
Which of these does NOT characterize an effective data steward?
Which of these are increasingly driving legislation for information security and data privacy?
Data flows can be represented by
Preparation and operational activities associated with data interchange include
Critical data interchanges are involved in
When a project specification is reviewed by the enterprise data architect, which of the following is not a consideration?
An enterprise data model would be composed of
The role of the Physical data model in the Metadata repository is
The role of the Conceptual data model in the Metadata repository is
Updating the Metadata repository is a recommended activity during project close out in the SDLC
What type of Meta-Data provides developers and administrators with knowledge and information about systems?
These are examples of which type of Meta-Data: Data Stores & Data Involved, Government/ Regulatory Bodies; Roles & Re
Which of the following is a Meta-Data scheme focused specifically on documents?
Which of the following contain metrics associated with Meta-Data Management?
Are the ISO (International Standards Organization) codes for countries and languages interchangeable?
Business drivers for managing metadata include the following
The number of artifacts that must be searched in the metadata repository for all business change projects are
By setting, enforcing, and auditing metadata standards, organizations hope to
Where is the best place to find the following metadata: database table names, column names, and indexes?
An organization's data model contains information (metadata) about which of the following?
What is the difference between an industry and a consensus meta-data standard?
Discovering and documenting metadata about physical data assets provides
The ISO metadata registry standard that provides a framework for defining a metadata registry is
Data provenance and data lineage are examples of
We would expect to consult the Metadata Library when
To which of the following initiatives was the establishment of an industry Meta-Data Standard essential?
We do not expect to consult the MetaData repository when
The MetaData repository enables us to establish multiple perspectives of data. These are:
What would you not expect to find in the MetaData repository?
A business perspective product in the MetaData repository is
The library of information about our data (our metadata) is built so that
Which of these statements are true about Metadata?
The key architecture domains include
The implementation of data architecture exposes the transformation of data as it moves across the landscape. A common
A data architect is best deployed
The goal of Data Architecture is to be?
A Data Architecture team is best described as?
The necessity of representing organizational data at different levels of abstraction is?
Identify who has primary responsibility for data capture and usage design within programs.
A CRUD matrix helps organisations map responsibilities for data changes in the business process work flow. CRUD stands f
A data lineage tool enables a user to
Which of the following uses for a Data Mining tool is not optimal?
Which of the following is not a good example of BI?
When performing an evaluation of analytic applications, which of the following questions is least relevant to identify the le
You need to discover possible relationships or to show data patterns in an exploratory fashion when you do not necessaril
Slice, Dice, Roll-up and Pivot are terms used in what kind of data processing?
A comparatively new architectural approach is where volatile data is provisioned in a data warehouse structure to provide
Big data is often defined by three characteristics. They are:
Big data management requires
A 'Data Lake' is an environment where a vast amount of data can be
A 'Data Swamp' is a data lake that has become
Which of the following is a typical metric in data warehouse/BI projects?
Which of the following is NOT an activity that would enable business acceptance and user satisfaction?
One of the difficulties when integrating multiple source systems is?
During the implementation of a data warehouse, a roadmap is used to
What factors should you consider when choosing data warehouse tools?
The data dictionary describes
Which approach is considered most effective when supporting multi-dimensional business report requests?
One of the key differences between operational systems and data warehouses is
Critical to the incremental development of the data warehouse is
A data integration approach that updates a data warehouse with small changes from operational systems is called
Which of these is a common OLAP operation?
The main part of a data vault that houses and integrates data from various source systems is referred to as
Which users in an organization are more likely to be the recipients of business performance management reporting?
To answer questions like "What does this report mean?" or "What does this metric mean?", the data warehouse/BI team
In its broadest context, the data warehouse includes
What are relationship labels?
Which of these statements has the most meaningful relationship label?
Dimension tables
All of the following are TRUE statements on relationship types except
In Dimensional data models, which of these is NOT true regarding Measures?
In a non-identifying relationship
Which of these is NOT a type of key found in a data model?
In the conceptual data model an instantiation of a particular business entity is described as
In a recursive relationship
The highest level of these data model types is the
Components of logical data models include
The acronym ACID stands for
Definition of Data Security Policies should be
What is the role of the Data Governance Council in defining an Information Security policy?
Which of these are characteristics of an effective data security policy?
A RACI matrix is a useful tool to support the ______ in an outsourced arrangement.
Stakeholders whose concerns must be addressed in data security management include
When outsourcing information management functions, organisations can
How does Data Security contribute to competitive advantage?
The needs of data protection require us to ensure that
Apart from security requirements internal to the organisation, what other strategic goals should a Data Security Managem
Which of these statements best defines Data Security Management?
Which of the following define the data security touch points in an organisation?
Which of the following are primary deliverables of proper document and record management?
A document management system is an application used to track and store electronic documents and electronic images of
Which of these describes activities in the document/record management lifecycle?
An umbrella term for any classification or controlled vocabulary is
Non value-added information is often not removed because
Documents and records should be classified based on the _______ level of confidentiality for information found in the reco
Which statement best describes the relationship between documents and records?
Which of the following is not a step in the 'document and content management lifecycle'?
In 2009, ARMA International published GARP for managing records and information. GARP stands for
A goal of 'Document and Content Management' is to ensure effective and efficient retrieval and use of
When defining your business continuity plan, which of the following should one consider doing?
What is the difference between cardinality rules and data integrity rules?
The repeated implementation of different CRM Technologies with different data structures is mostly a failure of
What is the definition of a business rule in the context of Data Governance?
We need to ensure that all data interchange scenarios are managed securely to ensure we?
Ontology is the study of
Which of the following should a DBA (database administrator) do if a database schema change is failing?
A Data Quality Dimension is
What is the definition of cardinality?
If two data stores are able to be inconsistent during normal operations, then the integration approach is
Data Security policies should be developed and communicated to ensure that ____?
Data that is used infrequently or not at all may be moved to an alternative data store. This is called
In Data Integration, the goal of data discovery is to
The Data Quality Management cycle has four stages. Three are Plan, Monitor, and Act. What is the fourth stage?
Which of the following activities are performed by data operations staff?
The goals of data operations include which of the following
What is the correct definition for change data capture?
What is NOT part of Data Integration and Interoperability?
A strong argument for pursuing a Reference Data and/or Master Data management initiative is
Which of the following is NOT a primary Master Data Management area of focus?
Which of these is NOT a primary deliverable of Data Quality Management?
What is the advantage of using point-to-point interaction model instead of a hub-and-spoke model?
The data operations team assures that data is recoverable by which of the following methods
Metadata repository processes will not include
What is the purpose of the Conceptual Data Model?
Which framework component of Data Governance includes education, training, and awareness?
A security mechanism that searches for customer bank account details in outgoing emails is achieving the goal of
All of the following are properties of a logical data model except
Is the data model important in establishing Master Data Management?
Data architects create metadata artifacts that constitute valuable _____.
A Content Distribution Network supporting a multi-national website is likely to use
The acronym ETL most commonly stands for
Which of the following activities is NOT a way that enterprise data architecture influences the scope boundaries of project
In data security, which of the following is not one of the four "A's"?
Which of the following is NOT true of a super-type or sub-type entity relationship?
Master data differs from reference data in which following way?
What causes data redundancy or data rot?
What technique will identify the system of record for the data?
Which of the following is NOT a stage of the Data Quality Management Cycle?
The "consumer" of master data content received from a Master Data Management platform can also be referred to as a
Data consumers will get more value out of data when they are provided more
What does data mining determine?
Legislation and Regulation for information security usually focusses on the ___ and not the ___?
When Integrating two data stores using batch or real-time synchronous approaches, results in a difference in
An effective Data Security Strategy needs to consider ____ as well as technical security.
What is the benefit of using role groups to implement Data Security policies?
At any given point, master data values should represent what?
Star and Snowflake are concepts of which Data Modeling Scheme?
Which of these is a valid definition of reference data?
A document that stipulates the responsibilities and acceptable use of data to be exchanged, is commonly referred to as a
Which of these is NOT a typical activity in Data Quality Management?
Database monitoring tools measure key database metrics, such as
Which one of the following statements is true?
The implementation and administration of Data Security policies is primarily the responsibility of
An example of an incoming formatted dataset is
Which of the following is NOT a Data Modeling style?
What is the purpose of the Logical Data Model?
An Enterprise Content Management systems (ECM) stores the following
According to the DMBOK, the system that contains the "best version" of the master data is the
Which of the following is NOT a key?
In the BASE vs ACID model for transaction processing, "E" is best described by which of these statements
Obfuscation of data is to
In the relational data model, what is the best synonym for a "relation"?
What position is responsible for the quality and use of their organization's data assets?
Which of the following is NOT a stage in the Shewhart - Deming Cycle that drives the Data Quality Improvement Lifecycle?
Which type of Metadata focuses on the content and condition of the data and includes details related to Data Governance
Periodic archiving of transaction data from a production CRM system is critical for
What are relationship labels in database technology?
Which of these statements is true?
What is the goal of collecting and documenting business rules?
What should a business continuity plan include?
A dataset comprised of X, Y coordinates of company stores would be an example of
When Metadata activities are focused on documents, the information is referred to as
What kind of interface is in place when systems are tightly coupled?
When defining Data Quality indicators, care must be taken to ensure that they have what?
Which integration approach has a higher latency than event-driven?
The percentage of enterprise computers having the most recent security patch installed is a metric of which knowledge ar
Plant equipment is an example of
Reference Data
Which of the following is a reason why organizations do not dispose of non-value-adding information?
You are facilitating a committee that is developing data quality metrics. Some of the committee members think that SMAR
Data sent and received between people or systems within an organization e.g. a report, a document, GIS dataset, drawing
What is a common motivation for Reference and Master Data Management?
Master and reference data are forms of
A common driver for initiating a Reference Data Management program is
Complete the following statement: A business rule _____
Which of the following is NOT a way of storing Master Data?
A database uses foreign keys from code tables for column values. This s a way of implementing
Which is the most accurate definition of the term data life cycle?
XML provides a language for representing both structured and unstructured data and information
Database performance depends upon two independent facets. These are
What is the technique for log-based change of data capturing?
Implementing a Services-Oriented Architecture (SOA) will often use
A project scope includes the collection, exchange, and reporting of data from multiple systems. Conceptual, logical and ph
Top-down and Bottom-up data analysis and profiling are best done in concert because
Since data technology is rapidly becoming more diverse, one should consider which of the following when acquiring a new
Why would an organization choose to purchase Reference Data?
Users continue to use a shared drive instead of a new Document Management System
A ______ is used for detailing collaboration principles, escalation, and dispute resolution process between Master Data Ma
What position should be responsible for leading the Data Governance Council (DGC)?
Master Data Management
Which of these is NOT an expected role of a Data Quality Oversight Board?
What is the definition of a surrogate key?
According to the DMBoK, which of these is NOT a valid dimension of Data Quality?
What is the purpose of a data lineage tool?
A sandbox is a type of database environment used for
What process describes controlling versions of the organization's datasets?
Which of the following statements about business rules is FALSE?
Who is responsible for communicating and promoting awareness of the value of Data Governance in the organization?
A dataset comprised of customer credit reports purchased from a third-party vendor would be an example of
HTTPS indicates that the website is
A database whose index is updated with a crawler program is an example of
Which of the following is NOT usually a feature of Data Quality improvement tools?
What is the difference between a Data Security Policy and an information technology security policy?
Which technique is used to provide access to a combination of individual data stores, regardless of structure?
Which of the following business rules should NOT appear on a logical data model?
Enterprise Data architecture defines standard terms for things that are necessary to run the organization, These things are
Which of these is the best definition of an Ontology?
Which of the following is not included in the opinion of the European Data Protection Supervisor (EDPS) on data ethics?
True or False: All organizations have master data even if it is not labeled master data
The purpose for adding redundancy to a data model (denormalisation) is to
What is the name of the legislation that protects educational records in the United States?
Which one of the following is NOT a part of the Strategic Alignment Model?
According to Henry Morris of IDC, Analytical Applications provide business with a pre-built solution to optimize a functiona
A Data Quality Service Level Agreement (SLA) would normally include which of these
An enterprise organization chart has multiple levels, each with a single reporting line. This is an example of a
The 'x' in the information engineering subtype discriminator symbol means
The biggest challenge to implementing Master Data Management will be
The DMBoK identifies which of the following as common stages in the lifecycle of the information asset
Data quality measurements can be taken at three levels of granularity. They are:
Which is the best definition of a Data Warehouse?
The process of translating plain text into complex codes to hide privileged information is
What statement is most accurate about master data metadata?
What is NOT an example of an external outgoing data interchange?
When the DMBOK calls Data Quality Management a program, not a project, it means
What is one of the benefits of Service-Oriented Architecture (SOA)?
Taxonomy refers to
True or False: Causes of poor Database Management include memory allocation errors, poor SQL coding, and database vo
A type of Master data architecture
Data Architecture compliance rate measures
Creation and maintenance of metadata should include
What is a hash?
Whose responsibility should it be to identify and report occurrences of defects in information and data?
Which of the following is true of a recursive relationship?
The addition of workflow to a Content Management System (CMS) will do which of the following
The stakeholder requirements for privacy and confidentiality are goals found in
What is manual directed Data Quality correction?
Ontology asks ___ while metaphysics ask ____
Which of the following should staff do to guarantee optimum database performance of database operations?
What is the purpose of ISO 8000?
Which of the following statements regarding a value domain is FALSE?
Which one of these is a key process in defining Data Quality business rules?
Which of the following is NOT a goal of Data Quality?
The ability of a photo app to share images with various social media applications, is an example of
Reference data _____
A bank applies the business rule that each Customer may own one or many Accounts and each Account must be owned by
The ability of an organization to respond to changes in product configuration is easier due to generalization in the ____?
Examples of data model components
Which of these is a valid definition of master data?
What process directly involves assessing the impact of proposed changes to existing data product entries?
A dataset comprised of county-level statistics provided by the national government would be an example of
What is essential to the successful integration of data?
Mapping requirements and rules for moving data from source to target enables
What is the definition of a root cause of a problem?
A staff member has been detected inappropriately accessing client records from usage logs. The security mechanism being
Which of the following is a goal of data discovery?
In the Data Management Practices Hierarchy, advanced data practices include the following except:
Reference Data Management includes defining relationships within and across domain value lists
According to the DAMA DMBoK, what parts of the Data Lifecycle are integral parts of the SDLC
Three common interaction models for data integration are
What is an alternate key?
Which is the best use case to use point-to-point interfaces?
Which of the following is the best example of the Data Quality dimension of consistency?
What is the purpose of referential integrity?
The sequence for the Shewhart - Deming improvement cycle in DMBoK is
An employee may work for one other employee and may manage one or more employees. There is an indeterminate num
Sentiment analysis of call centre voice files is performed by text analysis and stored in a relational database. Which of the
The requirement to enter a username, a password and then a code sent to an authentication app is called
The most common term for "entity" in the physical level of a model is
In computer programming, data types can be divided into two categories. What are they?
Which is the best example of a Taxonomy?
Information security begins by classifying an organization's data in order to
Which international initiative established a Metadata Standard?
Correct A B C
C ISO 27001 ISO 8000 ISO 55000/55001
E has the same stages as the Systems Impact
D to the organization if da Benefits of higher quality d
E Big Data goals need to change to reflData Quality goals must be alig Data Management goals shoul
C Data Quality Management Document and Content ManageData Virtualization
B Data Management process Knowledge areas Data Strategy initiatives
E Specific, Manageable, Agile, RealistiSystems, Management, ArchitectSpecific, Measureble, Achie
D Capturing, storing, protecting, and eEnsuring the quality of data and Ensuring the privacy and con
B Data that is not Relational, OperatioData that is Redundant, Obsolete, Data that is not Realistic,
A Data in context A management discipline Always stored in a compute
B It uses automation It can be used yet still retain val It has value
C Motivation Hardware Management Practices & Tecniques
E Data Governance Master & Reference Data Mana Data Quality Management
E The Data Analysis Association The Data Practitioner Associatio The Project Management Ins
A Identifying individuals for Data Ma A compelling vision for Data M Descriptions of Data Manage
B The Chief Information Officer (CIO) Chief Data Steward (Business)/ChThe chair should rotate acr
A A business role appointed to take res Analyzing Data Quality The manager responsible for
C DG is a continuous process of data IT is a key stakeholder in DG A DG initiative should alwa
E Central Communications and CorpoData stewards The Chief Executive Officer
A Providing only negative communicatiMaintaining an intranet websitePublishing a regular newslet
D Description of the DG organization, Executive message regarding sigThe Data steward team prof
D Weekly email reports showing metriRely on the stakeholder group toIt is not necessary, as the
A Promote consistent results but peri Promote consistent results so t Be a guideline for the organ
A Working with business and technicalProvide access to any possible Work in isolation and mine
E The community of interest focused on The local or divisional council The representatives of data
A A person's right to have all their i A person's right to have imperf A person's right for all searc
C Managed outside of the repository aOrganized with metrics so the d Documented consistently, ti
D The value of data to the organizatioThe business model – decentraCultural factors such as acc
D No, you should use whatever your oYes, the standards set are the coNo, organizations should dev
B Enforce enterprise-wide mandatoryMonitor and ensure that organizThis is a risk and audit resp
C Data Quality Board Data Governance Office Data Governance Council
D The Project Management Office The Master Data Office The Data Stewards Office
D Specify Enable Create and aquire
B Enterprise Architecture, programminSteward name, originating organMaturity models that access
E An organizational statistic A biased report A level of data not usable by
A Making information available to theReducing the size of large datab Selling data
E Pre-emptive governance Proactive governance Reactive governance
A It is an asset of the organization The volumes are large It contains financial facts
D has the same stages as the Systems Is D used primarily for Data archiv Is only important in regulat
A Managed as a single function Managed as separate functions Managed as integrated func
A Information Integration Interoperability
E Is a recognized subject matter experHe / She is an effective communHe / She works collaborativ
B A desire for economic protectionis A recognition of Ethical issues A resistance to open data a
A Two-dimensional matrices showing Tt wo-dimensional matrices showin Two-dimensional matrices s
E Specification for dataset creation Design, build, and test of dataseSpecification and design of
E RRP submissions to a regulator Issue of contracts and ITTs for b Business specific informati
C Whether enterprise-wide entities c What entities in the requirementWhether entities on invidid
B Conceptual models, logical models, Conceptual models, subject areaLogical models, physical mo
B Which version of COTS software (E. To describe how and where our d What the business definition
B To determine the primary, alternateTo summarize the key data subjec To agree the cardinality and
A 1 False.
E Unstructured Meta-Data Process Meta-Data Business Meta-Data
C Technical Meta-Data Business Meta-Data Process Meta-Data
D Administrative Meta-Data Structural Meta-Data Descriptive Meta-Data
A Steward Representation / CoverageMeta-Data Management Maturity; Steward Representation / Co
C Yes, the two codes were developed Yt es, the codes can be interchan No, the two codes were dev
D Provide a starting point for customi Translate business needs into daStrategically prepare organi
C Conceptual data models and the busConceptual, logical, and physic There is no mandatory numbe
B Ease of understanding data dictionaSimplify integration and enable Provide activities for the D
C Logical data model Enterprise data model Database catalog
A Information an organization is inter All information available both inInformation about physical
D Industry standards refer to interna Consensus standards are formedIndustry
b standards are dete
A Information on how data is transfo An estimation of balance sheet vScoping boundaries of the d
D ISO 9001 ISO 4590 ISO 4-20-99
B Technical metadata Business metadata Operational metadata
A Assessing the impact of change Formulating a Governance polic Implementing a Data Quality
B Internet Protocols EDI Proprietary XML
B Investigating a data issue Updating the operating system tUndertaking a data quality
B 3rd normal form and un normalisedBusiness and Technical PerspectStructured and Unstructure
B Data Lineage diagrams and models Data storage devices Data Requirements
E ETL flow Systems Inventory Data Dictionary
E We can have a shared formalized vieWe can better understand it We can be consistent in our
D The repository is always a decentralThe repository is always a centraA Metadata repository and
D Zachman, TOGAF, COBIT, and Healthbusiness, strategy, application, business, data, infrastructu
E data discovery data interfacing extract, transformation and
A during the early stages of a project after the project completes to i by project managers to sign
D A bridge between technology strateA bridge between business analyA bridge between business
E A well-managed project of architec A group of strong database admiAn operational data provisi
A Because most organizations have mo Because most organizations needBecause most architectures
A Software Architects, Developers Data Architects, Data Analysts, DM Executives, BI Analysts,
D Cost, Revenue, Uplift, Depreciate Create, Review, Use, Destroy Confidential, Restricted, Un
C Line up the data to support sophis Visualize how the data gets to thTrack the historical changes
C Analyze supermarket scanner data tFraud Detection Identification of data quali
D Strategic Analytics for Business DeciDecision Support Systems Supporting Risk Managemen
E How much of the tool infrastructureThe Standard source systems forNumber of source systems we
D ETL Jobs Data Quality Profiler Meta-Data Data Lineage Vi
A OLAP OLTP ODS
C Operational Data Store Behavioural Decision Support S Active Data Warehousing
A Volume, Variety, and Velocity Complexity, Compliance and Co Size, Speed, and Sensitivity
B less discipline than relational dat more discipline than relational no discipline at all
E updated, obfuscated, nullfied and c digested, processed, deletedandingested, screened, obfusc
A messy, unclean and inconsistent modelled, managed and muddy suitable for frogs, toads a
C Number of differente metadata useNumber of fact tables connecte Number of concurrent users
D Ensuring perceptions of the quality Understanding the data and defin Promoting scheduled meetin
D Completing the Data Architecture onMaintaining documentation descHaving a Data Quality rule a
A Demonstrate progress towards the dDemonstrate alignment to the prArticulate user requirement
E Build vs. buy vs. rent Current and future requirement Current and future costs
B Mainly extract, transform, and acce Mainly data in business terms diMainly source, target, and
C OLTP ODS OLAP
B Operational systems focus on historOperational systems focus on curOperational systems focus o
B A strong incident management procA strong release management prA strong capacity managem
E ETL ELT EII
E Slice and dice Pivot Drill up and drill down
E Metrics mart Business data vault Information mart
E Operations Data scientists BI team members
E Data lineage Conceptual data model Predictive and prescriptive
C Either an Inmon or Kimball approac All the data in the enterprise Any data stores or extracts
A The verb phrases describing the busiThe nullability setting on a forei A foreign key that has bee
E An order line contains orders An order is associated with orderAn order is related to order
C Are the same as Facts Have few columns but many rowHave many columns but fe
D A many-to-many relationship says thA one-to-one relationship says t A one-to-many relationship
B Measures are found in Fact tables Measures can always be added ac Measures should be numeric
D The primary key of the child entity The foreign key of the parent entThe primary key of the paren
B Foreign Key Local Key Primary Key
E Dataset Record Rule
E All of the above The relationship could be an idenThe relationship could be m
D Dimensional model Physical model Conceptual Model
D Keys Relationships Entities
E Atomicity, Consistency, Independe Additive, CAP, Independence, D Atomicity, Cardinality, Insta
A A collaborative effort between Busi Reviewed by external RegulatorsConducted by external cons
D The Data Governance Council shouldThe Data Governance Council sho The Data Governance Council
A The defined procedures ensure thatThe t policies are specific, measurThe procedures defined are
C Transfer of access controls Alignment of Business goals Segregation of duties
A Clients, Patients, Citizens, Suppliers External Standards organisationsMedia analysts, Internal Ri
D Reduce cost of compliance and imp Align strategy and control privacImprove controls while redu
D Data Security makes it harder for y Data Security makes your competi Governments do not allow or
C Data is secured with a password Data can always be freely used i Data is processed only in w
C Compliance with ISO29100 and PCI-Compliance with ISO27001 and Regulatory requirements for
C The definition of controls, technical The implementation and execution The planning, development,
D Risk Assessment Legislation Internal Audit
A Managed records in many media form Spreadsheets, company library bo Local drives of laptops, tran
C Scanning and transcoding of documLocal disk storage and indexing Storage, versioning, securi
A Identification, management of policie Storage, disposal, managing acc Acquisition, classification,
D Data model Metadata Dictionary
E Legislation is unclear on what shoul Data is an asset. It is likely to b We might need the informati
C Average Overall Highest
C Documents and records are the samDocuments are written and recorRecords are a sub-set of d
A Create a content strategy Manage versions and control Capture records and conten
D G20 Approved Recordkeeping PrinciGenerally Available RecordkeepiGregarious Archive of Reco
C Information, but not data in unstru Data and information in structu Data and information in un
E Make sure that the data is retained W s rite a report and discuss wit Determine the risk, probab
A Cardinality rules define the quantityReferential integrity rules only There is no difference. Card
B Data Warehousing Data Architecture Data Security
C Outlines the steps to take when a b Clarifies an organization's objectDefines constraints on what
C Are using the most up to date technAre monitoring the activities of Comply with legal and regula
B Beginning Being and existence Reality
B Call the software vendor of the dataApply the backout plan to restorInstruct the software designe
D The value of a particular piece of daA core concept in dimensional mA valid value in a list
E Qualitative description of the relat Measurement specifications for Count of data tables in a s
D Streaming Synchronous Faulty
C External consultants can be used ef Standards and templates can be it is easier to comply that
C replication analysis archiving
E Assign data glossary terms and dataAssign data glossary terms and Identify potential sources
D Improve Prepare Reiterate
C Tune the file systems Grant access to tables and rewr Implement and control datab
E Assuring the quality of the structur Providing the right database accAssuring the performance of
E A Data Integration approach that u A Data Warehousing approach toA Data Quality Initiative t
B Integrating structured and unstruct Data Quality monitoring Archiving data
D It will not require a lot of time or effThey are essential functions i Job security for the data pe
C Generating a golden record / best veIdentifying duplicate records Producing read-only version
A Data attribute definitions Data Quality strategy and fram Analysis from data profiling
C Improved data lineage The data is automatically sent toLower latency
A Defining and executing the data recMaking sure the disks are checked Guaranteeing the applicatio
A Selecting Data Management library M s anaging change to data productsControlling versions of a da
B To provide an outlook of the organi To provide a data-centric perspeTo provide an experimental
B Roles Processes Communication
A ensuring stakeholder requirements fensuring stakeholder requiremenensuring stakeholder requi
E contains relationship cardinality technology-independent contains attributes
D Only if Master Data Management nee No, within a given source, data No, not if the data model is
E Database that contain metadata Business requirements Opportunities for new marke
A A replication solution An extract, transform, and load A database backup and rest
B Export Transform Log Extract Transform Load Extend Trim Load
C performing design reviews to ensureproviding enterprise data requir ensuring enterprise busines
D Authentication Audit Access
B A sub-type inherits all attributes an Sub-type entities must be mutualAttributes and relationship
D Master data does not require a dat Master data do not require businMaster data should be held
E Poor assimilation of collected data Poor data management practiceServer and human error
C data discovery Definition of Data Integration a Analysis of lineage
D Plan Check Act
B System of record Subscriber Master Data Management p
D Tools Stewards Master data
E The process of collecting data elemeThe process of finding correlatedThe process of manipulatin
A End/Means Technology/Data Data/Technology
E Data Quality lethargy source of truth
B Operational (function, flexibility) Physical (devices, hard copy) Conceptual (metadata, Busi
D It allows users to by typecast by theIt simplifies revoking individual It allows for iterative repor
B The organizations best understandinThe organizations best understa The organizations best und
C Object-oriented Time-based Dimensional
B Data that is fixed and never changesData used to classify or categori Data that provides metadata
B Data model Data Sharing Agreement Interface Contract
E Defining business requirements andAnalyzing Data Quality Creating inspection and mon
B Capacity, availability, backup insta Capacity , availability, cache per Capacity, design, normalizat
D Business data stewards maintain lists Managing reference data requireReference Data Management
C Knowledge Workers All staff Security administrators
E Content formatted for external sendData e sent and received within anSpecified data extract sent
E ORM UML IDEF1X
A To define the structure of data ele To compare data elements To define data elements
B Backups of the enterprise's data w Information to be displayed on Documents and images, but
A System of record Golden record Source system
A Logical Key Surrogate Key Primary Key
C End to End data consistency Eventual Availability of Data as Eventual Data Consistency
E Put it in different databases Use synonyms for the same ter Collect data from obscure s
B Association Table Relationship
C Data Architect Data Modeler Data Steward
C Plan Do Investigate
D Technical metadata Operational Metadata Structural Metadata
D Training junior DBAs Managing deleted customer rec Enabling the distribution of
D Verb phrases describing how to takeVerb phrases comparing businessVerb phrases linking busines
B Data Quality Management is a syno Data Quality Management is a c Data Quality Management on
E To identify potential sources of dataTo reuse existing Data IntegratioTo direct when to manually
B Defines unplanned disruptions that Outlines how a business will conPrecedes Business rules
B Metadata Master Data Reference Data
D Legal Metadata Reference Metadata Administrative Metadata
C A batch interface An independent interface A synchronous interface
A Measurability, Relevance, and AccepA direct link to the Data Govern Items in the dashboard sho
E Application interface Real-time synchronous across s Webservices
A Data Security Data Storage and Operations Metadata Management
B Reference Data Master Data Transaction Data
D Has obvious definitions Has limited value Is always supplied by outsi
D Data Modeling the content is difficuThe organization's Data Quality The information is never ou
D Unless you use business terms the eBusiness relevance needs to be cAny IT Program must have so
D External incoming data interchange External outgoing data intercha Regulatory data interchang
A The need to improve Data Quality anThe need to build a data dictionar Regulatory acts such as BC
C Data Security Data Quallity Data Integration
A It will improve Data Quality and faciIt can be a one-time-only projectManaging codes and descripti
C Defines an Entity Only exists at the level of the p Defines constraints on wha
B Transaction Hub Repository Virtual
C Temporal data Master Data Reference Data
A It represents the path along which da It represents managing the risks It represents the data used
A 1 FALSE
A Availability and speed Number of users and number of Hardware and network
B The source system populates specifiSource Database Management syst The source system processes
C A data lake ETL Servers An enterprise service bus
A More physical data models than logMore logical data models than pMore conceptual data models
E It gets everyone involved It gives something for the archit It allows the profilers to sh
A The problem for which technology me The current data retention polic The performance levels of t
C To summarize basic information abou To set up data compliance and To enhance data quality and
E A failure to back up the shared driv Concern about the ability to ve Concurrent updates to the
C Warranty Business requirements documenOperational level agreemen
C DGC Chair should rotate among execChief Data Architect or Chief Da Chief Data Steward or Chief
A Controls the definition of business eAllows applications to define b Is synonymous with Refer
C Setting Data Quality Improvement prEstablishing communications a Data Profiling and Analysis
D A unique alphanumeric sequence is Aa key that links records in a dat A set of data records that
A Relevance Timeliness Currency
D List of potential data integration op Formal Data Quality AssessmentDescription of a dataset's p
E User Acceptance Testing Low-budget projects Production backups
E Data Quality Master Data Reference Data
C Data rules constrain how data relateAction rules are difficult to defi Data rules cannot be shown
E Central Communications and CorpoData stewards The Chief Executive Officer
C Transactional Data Protected Data Reference Data
A Equipped with a security layer Equipped with a content manag Equipped with third party c
A Database transaction technology caDatabase transaction technologyDatabase technology called
C Data profiling Parsing Data Modeling
D There is no difference Information technology security The Data Governance Council
A Data Federation Complex Event Processing Cloud-based integration
B Each Person can work for zero to Customer Last Name requires a nEach Company must employ
B Artefacts Entities Taxonomies
A A set of concepts and categories in An index of terms to enable rapiThe classification of someth
A Right to request removal of personaAccountable controllers who detPrivacy-conscious engineeri
A 1 False.
A optimise overall database performafully utilise all the indexes avoid the loss of data by s
E SOX BASEL II EPA
B Business Strategy Stakeholder Management IT Strategy
A 1 False.
A Roles and responsibilities for Data QA business case for data impro An enterprise data model
C compound taxonomy flat taxonomy hierarchical taxonomy
D Exhaustive Inclusion Expanded
E The inability to get the DBAs to provDefining requirements for master Indexes and foreign keys
D Plan, Obtain, Store/Share, Maintain,Get, Store, Fix, Use, Purge Acquire, Integrate, Apply,
E Departmental data, regional data, aPerson data, location data, and Fine data, coarse data, and
A Any data stores or extracts used to An explanation of how data is li A data system based on inc
A encryption encapsulation exaggeration
C Can either be related to technical o Secures the content Provides the who, what, an
D Outgoing formatted dataset Outgoing data extract Response to external reque
E Data Quality is more tightly scoped Data Quality practices can stop aData Quality managers can
A Enables application independence and Provides an optimized user expeIs the fastest way to develo
A Any classification or controlled voc Classification of organizational Arrangement of controlled
A 1 False.
E Hybrid Registry Virtualised
B How fast the database can retrieve How closely projects comply witHow complete an attribute lis
C Identifying and classifying sensitiv Summarizing and optimizing lastHolding process owners acco
A An algorithm that converts encodedAvpublic key that is freely avail A clearing house for encryp
B The information quality team any employee The IT department
D It is unary It is also referred to as self-refe It involves only one entity
D Enforce the controlled review and aAllow the approval of system ac Restructure an enterprise g
A Data Security Data Architecture Data Quality
B The automation of all data cleanse The use of automated cleanse anThe use of spreadsheets to
A What/How Why/How How/Why
C Reduce the number of rows in the tDiscuss the amount of time a useDiscuss performance requir
A Enable the exchange of complex infoCreate, collect, store, maintain, Promote timely and cost-eff
B A value domain is a set of allowed vValue domains are defined by exMore than one set of refer
C De-duplicating data records Producing Data Management polSeparating data that does n
E Develop a governed approach to mak Define standards, requirements,Implement process to measu
A Interoperability Integration Replication
D Is also known as external data Usually has more attributes tha Is more difficult to govern
A many-to-many one-to-many many-to-one
A Data Architecture Business Architecture Data Warehousing
E Files, Folders, Links CPU, GPU, RAM, ROM Monitor, Keyboard, Mouse,
E Data that if missing or incorrect wil Data that is only held in one dat Data that other data sits hi
B Data Governance Metadata Master data
A Reference Data Master Data Historical Data
A Understanding data content and strUnderstanding the organizationsPerforming Data Discovery
A Load Extract Transformation
B The part of the problem that is invi A factor, that if eliminated, rem A multi-factor influencer
B Access Audit Authorization
D Understanding the organization's buAssessing the quality of data Having well-defined intera
E Analytics Mining Big Data
A 1 False.
A Plan, Specify, Enable Plan, Create & Acquire, Purge Specify, Maintain & Use, Pu
A point to point, hub and spoke, publ Point to point, wheel and spoke,point to point, harvest and
C A key is a relational database that i A sequentially generated uniqueA candidate key not selecte
E To track changes made to a dataset To create historical snapshots ofTo lower the complexity of
B The source data for the end of montAll the records in the CRM have The revenue data in the dat
B Rules that ensure data completenesRules that ensure data validity Rules that ensure data accu
C Design, Build, Test, Deploy Plan, Document, Implement, AudPlan, do, check, act
A recursive one-to-one subtyping
C The voice files are structured data They are both unstructured dataThe voice files are unstruct
B 3-factor 2-factor biometric authentication
C Index Primary Key Table
A Value types and reference types Coded types and value types Technical types and referen
E Customer status codes Customer master records ISO3166
D Identify which subject area the dataIdentify which systems need betIentiy which departments
B BASEL I BASEL II BASEL III
D E DMBOK Section
ISO 25000 ANSI 859.
What the data could be sold for How much we can be ransomed for by a malware attack.
Data Management goals must focus We f should ensure that data can be used effectively to add value to the enterprise.
Data Security Management Data Governance.
Maturity model dimensions Data Management deliverables.
Structured, Manageable, Accurate,Specific, Measurable, Achievable, Realistic, Timely.
Understanding the process needs oPreventing unauthorized access, manipulation, or use of data and information.
Data is Routine, Obsolete, Tiny Data that is not Requested, Orchestrated, Technology supported.
A byproduct of IT systems.
It is big It is regulated .
Project Management Database Management.
Data Security Management Big Data & Data Science.
The Data Management Authority The Data Management Association.
A summary business case for Data A draft implementation roadmap with projects and action items.
The Chief Data Architect Any executive/c-level participant in the DGC.
Identifying data problems and issu The data analyst who is the subject matter expert (SME) on a set of reference data.
There are different organization m DG is the exercise of authority and control over the management of data assets.
Senior Management Executive Fo Everyone in the Data Management community.
Promoting participation in a DM Creating a series of "elevator pitches" for the appropriate audience.
Raw data results of an investigatio Link to a “raise an issue” log.
Continuous communication, education, and promotion of the importance and value of data and information assets.
Set by a standards organization an Only be necessary for the Data Governanc 2.1
Create a Data Governance “in-ho Take no part in any project at all, declaring it an audit and risk project.
A burden to the agile delivery in a The primary and highest authority responsible for the oversight and support of Data Go
A person's right to have their inf A person's right to change their name.
Focused on managing relationshipsFocused on rules that can be integrated into application services.
The availability of industry data m Impact of regulation.
Yes, ISO 3166 is the internationall No, there is no internationally recognized set of codes because each country wants to d
Perform ad-hoc audits of possible This is about data. Data Governance is accountable for the whole process, with risk and
IT Leadership Team PMO.
The Data Governance Office The Data Governance Steering Committee.
Plan Maintain and use.
The names of everyone who is a bus Metrics to quantify reference data's value to the organization.
A data model A data swamp.
Organizing data into meaningful g Making information anonymous or removing sensitive informa
Decentralised Governance Devolved Governance.
It is stored in Database systems.
Exists beyond the Systems DeliveryIs not relevant in an Agile environment.
Managed as integrated functions, Managed by the Chief Information Office.
Instance Identification.
He / She works in association with Is a highly experienced technical expert in a variety of data management disciplines & to
An objective of making life more c ANSI 859.
Two-dimensional matrices showingTwo-dimensional matrices showing the rela 1.3.3
Operation All of the above
GIS datasets published to support All of the above
Whether entities and definitions n Whether to reuse existing or develop new data delivery architectures .
Conceptual models, star schema mo Enterprise models, data models, and comp1.3.3.1
How many master data records areWhen the duplicated records were merged.
All of these None of these.
Data Stewardship Meta-Data Technical Operational Meta-Data.
Data Stewardship Meta-Data Operational Meta-Data.
Preservation Meta-Data Business Meta-Data.
Meta-Data Repository Availability; No. Data Governance Meetings held annually; No. Meta-Data Repositories.
No, because there are more languaNo because one uses four digits and one uses five digits for the code.
Reduce data-oriented research timMeet data requirements for multiple initiatives and reduce the risk and costs of data int
The business data glossary and da The business data glossary and systems inventory must be consulted.
Ensure the appropriate classificat Standardize business rules in operational processes.
Detailed business processes Security access authorization.
Only the information needed for Surrogate keys.
The terms are used interchangeably to describe the same concept.
Effective project scope managemeInsights into the temporal data quality.
ISO / IEC 11179 ISO MD 1.
Strategic metadata Industry metadata.
Selecting a Data Storage device Accessing the internet.
JSON BASEL II/SOX.
Assessing the impact of change None of these.
Internal and External Dimensional and non dimensional perspective.
Data Models Data Dictionary.
Physical Data Model Data Glossary.
We can better manage it All of these.
Data models are components of a The repository is always a hybrid architecture.
business, data, application, and te process, database, software, and technology architectures.
data modeling data lineage.
to manage the delivery of all the d to build the database solution.
A bridge between business strategA bridge too far. 1.1
The authors of reference data A strategic planning and compliance team.
Because most database administrato Because most Chied Data Officers don't have the technical background to be held accou
Business Data Stewards, Subject MSuppliers, Consumers.
Create, Read, Update, Delete Create, React, Utilise, Delegate.
Enables rapid development of dashTrack the data from source system to a target database; understanding its trasformatio
Predictive Analysis Customer Segmentation and Scoring.
Statutory reporting to a Regulator Trend Analysis.
How much do the canned processes Annual costs such as license, maintenance, etc. .
Data Mining Data Visualization Application.
EDI EIEIO. 3.3.3.1
On Line Transactional Processing On Line Analytical Processing Cube.
Direction, Depth and Details Expansive, Engaged and Enormous.
a certification in data science big ideas with big budgets.
purged, sorted, split and scanned ingested, shared, assesed and analysed.
overly catalogued, holding informaa data asset that uses machine learning.
Number of indexes used in the factNumber of snowflake dimensions used in the projects.
Defining different types of reporti Furnishing and end-to-end verifiable data lineage.
Determining valid links or equiva Modifying the source systems to align to the enterprise data model.
Articulate Data Quality checkpoint Construct intricate security authorization.
Professional service offerings All of the above.
Mainly availability and integrity quaMainly data in XML, JSON, and text forms.
EDI BI. 3.3.3.1
Operational systems are available Operational systems focus on Data Quality; data warehouses focus on data security.
An agile development team The assurance to include velocity, variety, and veracity measurements.
SOA CDC 1.3.7.3
Roll up All of the above.
Persistent staging area Raw data vault.
IT team Executives. 3.3
Data Quality applications End-to-end metadata.
An integrated data store, ETL logic Data stores and extracts that can be transformed into star schemas.
A relationship without cardinality A non-identifying relationship.
An order is connected with order l An order is composed of order lines.
Do not contain hierarchies Contain measures.
A one-to-many relationship says thA recursive relationship relates instances of an entity to other instances of the same enti
Care must be taken if a measure isJust because a value is numerical does not mean it is a measure.
The primary key of the parent entitThe primary key of the child entity is removed.
Alternate Key Surrogate Key
Row Entity occurrence.
None of these, recursive relations The foreign key must have a role name to avoid attribute duplication.
Logical model Database model.
All of the above Attributes.
Arity, Cardinality, Instance, Devel Atomicity, Consistency, Isolation, Durabilit1.3.5.1
Based on defined standards and t Determined by external Regulators.
The Data Governance Council should The Data Governance Council should have no role in Data Security
None of these The defined procedures are tightly defined, with rigid and effective enforcement sanctio
Service level Agreement Attributing Costs.
The Internal Audit and Risk commitAll of these.
Transfer accountability but not conTransfer control but not accountability.
Data Security helps to protect propData security stops organisations going out of business due to an information leak.
Data is encrypted at all times Data is frequently backed up so that it can be recovered in all cases.
Ensuring the organisation doesn't engage in SPAM marketing
None of these The planning, implementation, and testing of security technologies, authentication mec
Business rules and process workfl TIndustry standards. 2.1.1
Relational databases, database lo Data from tracking devices, building sensor data.
Securing forwarding of documents Wiki, collaboration, online editing.
Encryption, backup, disposal, extraAcquisition, editing, storage, printing, backup, disposal.
Taxonomy English.
It should not be removed. All data The policies are unclear of what is defined as non-value-added, storage is cheap so ther
General. Consensus
Documents are a sub-set of recordDocuments and records are not related.
Audit documents and records Manage retention and disposal.
Generally Acceptable RecordkeepinGlobal Accredited Recordkeeping Principles.
Data, but not information in unstr Data and information in relational formats.
Have the contracts in place to acquConsider written policies and procedures, impact mitigating m
Referential integrity rules quantif Referential integrity rules define the quantity of each entity instance that can participat
data modeling Data Quality
Contains an organization's conting Clarifies an organization's goal
Have created hash totals on data sHave backed up data regularly
Knowledge Existence
Call IT support to restore a previo Remove all the content of the tables and try again
A measurable feature or characteris One aspect of Data Quality used extensively in Data Governance
Classifies variables within a datase Defines how many instances of one entity are related to instances of another entity
Asynchronous Uncontrolled
External regulatory reviews and aud Data that is not Requested, Orchestrated, Technology supported.
auditing Authentication
identify key users and perform a h Identify potential sources and perform a high-level assessment of Data Quality
Deploy Manage Version 1 12.2.1
Clean data that is of bad quality Manage the tape libraries
Assuring backups are taken, managAssuring availability of the data throughout its lifecycle, protection, and integrity assura
A Metadata document that describA Data Integration apporach that updates a Data Warehouse
Data consolidation into hubs or maEnterprise Application Integration
By centralizing the management ofIt will not require a lot of time
Providing access to golden data re Producing clear data definitions for master data
Data Quality service level agreemeData Quality reports
Management of the number of inter Significant reduction of the complexity of Data Interoperability
Analyzing database error logs Maintaining a test, development, and production environment
Assessing impact where a change to existing data product entries are proposed e.g. the impact of change on related data o
To define the structure of data el Documents how data are to be stored and accessed on stora
Data Tools
ensuring stakeholder requirements for concise definitions are usage are met
contains primary keys technology dependent
Yes, Master Data Management needs No, not if the organization has complex systems with multiple ways of capturing data
Support for user interfaces Support for entire organization or enterprise
An archiving solution A records disposal solution
Efficient Trace Logging Extract Transpose Leverage
ensuring sufficient data replicationenforcing data architecture standards
Available
Attributes and relationships share The subtype relationships should have a discriminator attribute
Unlike reference data, master data is not usually limited to predefined domain values
Dataset inaccuracies developed ovAll of the above
Data profiling Collection of business rules
Intervene Do
Single version of the truth Metadata repository
Context or metadata Business rules
The process of describing the resulThe process of finding anomalies, patterns, and correlations w
Organization/Data
time stamping latency
Functional (timing, structures)
It reduces the amount of effort to assign access rights to users if they inherit rights from their group
The organizations best understandin The organizations best understanding of its conceptual entities
Fact-based NoSQL.
Data that is widely accessed and r Data that has a common and widely understood data definition
Data Quality Assessment Project Charter
Identifying data problems and issu Enterprise Data Modelling
Create, read, update and delete Create, read, normalization, and user access
Master Data Management requiresMaster te Data Management involves identifying and maintaining approved coded values
The CIO
Outgoing content examples could be Received content formatted e.g. into excel tables as a formatted file
CHEN CRUD
To document how data should be sTo provide a data-centric perspective of the organization by
Code and scripts for enterprise d Kanban boards
Consuming system Spoke
Alternate Key Foreign key
Extra Validation Business Availability of Secure data ELEMENTS
Make the results clear Make it obscure or unclear
Row Tuple
Chief Information Officer Data Scientist
Check Act
Business Metadata
The maintenance of database per Providing alternate sources for reporting systems
Verb phrases describing business rVerb phrases describing relationships between data tables
Data Quality Management is the apData Quality Management is usually a one-off project
To design user-experience To identify the requirements for the Data Quality
Explains to external stakeholders Provides explanation to customers during an unplanned disrup
Temporary Data Historical Data
Preservation Metadata Descriptive Metadata
A legacy interface A user interface 1.3.2.5
The core dimensions of Data Quali Timeliness, Validity, and Accuracy 4.4
Streaming access to data Batch data integration 2.2.4
Data Warehousing and Business IntData Quality 4.4.2
Inverted Data None of these
Is used to categorize and classify o When incorrect has a greater impact that errors in master and transaction data
Storage is cheap and easily expan The metadata repository cannot be updat2.2.4
The value of the metric is limited Expressing business relevance in requirem 4.4
Internal data interchange All of the above
The need to consolidate all data inBusiness Intelligence and data warehousing
Data Architecture Data Mapping
It will consolidate the process of s It fosters the creative use of data
Measures a business process Identifies an entity instance
Consolidated Registry
Event data Star schema data
It represents a range of perspect It represents the theory of data being cros2.5.9

Choice of DBMS and programming Distance to data center and network ban 2.2.4
The source system processes copy Cdompare the current state of the source s1.3.2.2
Data Visualization tools A Data Modeling tool 3.3
The same number of each of the mOnly 1 conceptual data model, 1 logical data model, and 1 physical data model
Data Quality tools are more producIt balances business relevance and the actual state of the data
The number of users that are conneThe number of servers that are currently in use
To define how data will be captureTo document transactional data systems
The document management system Onerous classification requirements when adding documents
Metadata catalog Operations run book
Chief Information Officer or Chief Any executive can chair the DGC 1.3.5
Is time-consuming with questionabEnsures coded values are always used
Producing certification and compliaDevelopment and maintaining Data Quality
A unique identifier attached to ea A document that identifies how data is lin1.3.3.3.2.1
Completeness Reasonableness
Tracking Historical changes to a daCollection of all the metadata related to a1.3.10.2
Remote users Proofs of concept and to test hypotheses 1.3.7.2.3
data modeling Metadata
Action rules are instructions on w All business rules must be identified prior to the start of the Data Modeling process
Senior Management Executive Fo Everyone in the Data Management community.
Master Data Metadata
Equipped with an underlying data Equipped with a foreign language translated
Database technology called SQL Database technology called NoSQL
Transformation Standardization
Data Security policies are more granular in nature and take a data-centric approach
Enterprise service bus Enterprise Application Integration
Each Order can contain one or manEach Policy must belong to one Policy Owner
Metadata Relationships
A mythical creature from ancient The theory and science of collating structure of living things
Future-oriented regulation of data Empowered individuals

ensure surrogate keys are retainingmake it easier for developers to join tables
GDPR FERPA
Information Systems Organization and Process

Detailed technical specifications foA breakdown of the costs of Data Quality improvement
hybrid taxonomy ecological taxonomy
Exclusive Exchange
Complex queries The disparity between sources
Plan, Specify, Enable, Create and Build/Buy, Mix/Merge, Apply, Delete
Historical data, current data, and Data element value, data instance or record, and data set
A data system in which data is sto Any data store that can be accessed by business users and dat
elimination
Does little to improve fit0for-pur Includes a sample of content
Purchased prebuilt data Outgoing content or document
Data quality management is really Data Quality has both project and maintenance work along with communications and tr
Provides oversight and control to tAllows access to the underlying data structures
Constrained set of organizational Categorization of controlled phrases

Repository All of the above

How closely projects are meeting tHow closely projects comply with the development lifecycle
Identifying rich data sources, alig The impact on people, potential for misuse, and the economic value of data
A method for masking sensitive data
Regulatory compliance officers Customers
All of the above None of the above
Enable the controlled review and Implement a data warehouse landing zone
Metadata Management Document and Content Management
Teams of data creators supervised Using a Data Quality improvement manual to guide data cleanse and correction activitie
How/What What/Who
Decide what type of storage will b Revoke the access rights of heavy users No reference. Strange question
Report on potential data security rEnsure that data can only be used or read using a specific lic
Conforming value domains across the organization facilitates Data Quality
Matching data from different data Producing Data Quality reports and dashboards
Advocate for opportunities to imprThe delivery of a Data Quality Strategy and framework
Metadata Rendering
Usually has fewer attributes than Is free
one-to-one recursive
Data Quality Technical Architecture
Iteration, Decision, Input, Output Keys, Relationships, Attributes, Entities, Facts
Data that rarely, if ever, changes Data about business entities that provide context for business transactions
Reference Data Data Architecture
Metadata Transactional Data
Collecting Business rules Designing user presentation
Analysis Backups
An incomplete requirement's stat The most obvious aspect of the problem
Authentication Entitlement
Identifying potential sources of datMaking data available in the format and timeframe needed by data consumers, both hu
Warehousing Data Quality

Enable, Maintain & Use, Archive & Specify, Enable, Create & Acquire
straight copy, curved copy, rondabrecord and pass, copy and send, read and write
A key in a relational database that Another term for a surrogate key
To encourage reuse of integration aIntegrating two systems with data only needed by those systems
The customer file has 50% duplicatThe phone numbers in the customer fle do not adhere to the
Rules that ensure data is fit for or Rules that ensure data accessibility
Vision, Creation, Evaluation, OptimPlan, Act, Design, Comply
identifying non-identifying
They are both structured data Structured and unstructured data are the same things
proactive authentication
Diagram Database
Structured types and reference typMetadata types and reference types
Well completion codes The Dewey Decimal System for libraries
Identify which data needs protecti Identify the metadata classification values
BASEL IV BASEL V
 DMBOK Page

y to add value to the enterprise.

use of data and information.

ogy supported.

d action items.

(SME) on a set of reference data.

e management of data assets.

opriate audience.

of data and information assets.

udit and risk project.

the oversight and support of Data Governance activities.

cation services.

odes because each country wants to develop their own.

e for the whole process, with risk and audit reporting to Data Governance.

rganization.

60

y of data management disciplines & tools.

livery architectures .
 Meta-Data Repositories.
digits for the code.
d reduce the risk and costs of data integration through the use of consistent reference data.
must be consulted.

echnical background to be held accountable for complex data diagrams.

abase; understanding its trasformations.

rprise data model.

402

warehouses focus on data security.

acity measurements.
 404

nto star schemas.

164

tity to other instances of the same entity

t is a measure.

ttribute duplication.

in Data Security
gid and effective enforcement sanctions, and alignment with technology capabilities.

ness due to an information leak.

vered in all cases.

rity technologies, authentication mechanisms, and other controls to prevent access to information.

value-added, storage is cheap so there is no cost driver, and it takes more effort to dispose than to keep.

327
ach entity instance that can participate in a relationship between two entities, and cardinality rules ensure valid values.

464

ta Governance
ted to instances of another entity

ogy supported.

l assessment of Data Quality

 12.2.1 p293

cycle, protection, and integrity assurance of structured data assets, and performance optimization of database transactions
190

eroperability
environment
he impact of change on related data on other systems
145
75

ith multiple ways of capturing data

ator attribute

29

507

om their group
ptual entities

ata definition

d maintaining approved coded values

as a formatted file

146

133

78
 422

164

327
363
425

master and transaction data

369

WARNING: This answer is wrong. It is the definition of Data Lineage, not Lifecycle. This is the required answer in the CDM
334

el, and 1 physical data model

e of the data

393

76

134

471
184
423
art of the Data Modeling process

356
 52

36

384

ork along with communications and training

312

he economic value of data

227

131

e data cleanse and correction activities

ence. Strange question

435

452

for business transactions

427
354

275

e needed by data consumers, both human and system

 25

those systems
457
468

87
re valid values.
tabase transactions
he required answer in the CDMP exam !!!