Summer Special Sale Limited Time 60% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 713PS592
marks4sure logo
What business function is best aligned to deliver oversight to data architecture ?
A System of Reference is an authoritative system where data consumers can obtain reliable data to support transactions and analysis, even if the information did not originate in the system reference.
A ‘Golden Record’ means that it is always a 100% complete and accurate representation of all entities within the organization.
The creation of overly complex enterprise integration over time is often a symptom
of:
Bold means doing something that might cause short term pain, not just something that looks good in a marketing email.
There are numerous methods of implementing databases on the cloud. The most common are:
Data Integrity includes ideas associated with completeness, accuracy, and consistency.
When constructing models and diagrams during formalisation of data architecture there are certain characteristics that minimise distractions and maximize useful information. Characteristics include:
A pensioner who usually receives a quarterly bill of around $300 was sent a
$100,000,000 electricity bill. They were a victim of poor data quality checks in
which dimension?
When starting a Data Governance initiative it is important to understand what the Business cannot achieve due to data issues because:
Many people assume that most data quality issues are caused by data entry errors. A more sophisticated understanding recognizes that gaps in or execution of business and technical processes cause many more problems that mis-keying.
An image processing system captures, transforms and manages images of paper and electronic documents.
Different levels of policy are required to govern behavior to enterprise security. For example:
The best DW/BI architects will design a mechanism to connect back to transactional level and operational level reports in an atomic DW.
An authoritative system where data is created/captured, and/or maintained through
a defined set of rules and expectations is called:
Business metadata focuses largely on the content and condition of the data and includes details related to data governance.
Which of these best describes the purpose of a Communications Plan in Data Governance?
Data architect: A senior analyst responsible for data architecture and data integration.
Issue management is the process for identifying, quantifying, prioritizing and resolving data governance related issues, including:
Factors that have shown to play a key role in the success in the success of effective data management organizations does not include:
Please select the incorrect item that does not represent a dimension in the Data Values category in Data Quality for the Information age.
A critical step in data management organization design is identifying the best-fit operating model for the organization.
Reference and Master data definition: Managing shared data to meet organizational goals, reduce risks associated with data redundancy, ensure higher quality, and reduce the costs of data integration.
The operational data quality management procedures depend on the ability to measure and monitor the applicability of data.
Emergency contact phone number would be found in which master data
management program?
A weakness or defect in a system that allows it to be successfully attacked and
compromised is a:
Achieving security risk reduction in an organisation begins with developing what?
Data governance program must contribute to the organization by identifying and delivering on specific benefits.
How can the Data Governance process in an organisation best support the requirements of various Regulatory reporting needs?
The accepted tenets of bioethics provide a starting point for the principles of data ethics. Which of the following tenets of bioethics is NOT included in the DMBOK2 Chapter on Data Handling Ethics?
Implementing a BI portfolio is about identifying the right tools for the right user communities within or across business units.
Where is the best place to find the following metadata: database table names,
column names and indexes?
Please select the correct component pieces that form part of an Ethical Handling Strategy and Roadmap.
Which of the following are must-do for any successful Data Governance programme?
Gathering and interpreting results from a DMM or Data Governance assessment are important because:
Controlling data availability requires management of user entitlements and of structures that technically control access based on entitlements.
Repositories facilitate the collection, publishing and distribution of data in a centralized and possibly standardized way. Data is most often used to:
A data model that consists of a single fact table linked to important concepts of the
business is a:
Subtype absorption: The subtype entity attributes are included as nullable columns into a table representing the supertype entity
A goal of data architecture is to identify data storage and processing requirements.
No recorded negative ethical outcomes does not mean that the organization is processing data ethically. Legislation cannot keep up with the evolution of the data environment so how do we stay compliant?
'Planning, implementation and control activities for lifecycle management of data and
information, found in any form or medium', pertains to which knowledge area?
Validity, as a dimension of data quality, refers to whether data values are consistent with a defined domain of values.
Tools required to manage and communicate changes in data governance programs include
The best preventative action to prevent poor quality data from entering an organisation include:
ISO 8000 will describe the structure and organization of data quality management, including:
Differentiating between data and information. Please select the correct answers based on the sentence below: Here is a marketing report for the last month [1]. It is based on data from our data warehouse[2]. Next month these results [3] will be used to generate our month-over-month performance measure [4].
With reliable Metadata an organization does not know what data it has, what the data represents and how it moves through the systems, who has access to it, or what it means for the data to be of high quality.
Which artifact is the highest level of abstraction in the Enterprise Data Model?
You are a reporting Data Analyst. A new Management Report has been requested. What is the most effective way to ensure you receive the appropriate data at the correct level of accuracy to meet the business need?
Data Governance is at the centre if the data management activities, since governance is required for consistency within and balance between functions.
Three classic implementation approaches that support Online Analytical Processing include:
The advantage of a decentralized data governance model over a centralized model is:
The term data quality refers to both the characteristics associated with high quality data and to the processes used to measure or improve the quality of data.
DAMA International’s Certified Data Management Professional (CDMP) certification required that data management professionals subscribe to a formal code of ethics, including an obligation to handle data ethically for the sake of society beyond the organization that employs them.
The biggest business driver for developing organizational capabilities around Big Data and Data Science is the desire to find and act on business opportunities that may be discovered through data sets generated through a diversified range of processes.
Communication should start later in the process as too many inputs will distort the vision.
Data security includes the planning, development and execution of security policies and procedures to provide authentication, authorisation, access and auditing of data and information assets.
As part of its transformation, the organization must identify and respond to different kinds of roadblocks. Please select the answer that is not a roadblock:
When doing reference data management, there many organizations that have standardized data sets that are incredibly valuable and should be subscribed to. Which of these organizations would be least useful?
A data warehouse deployment with multiple ETL, storage and querying tools often
suffers due to the lack of:
Industry is struggling to distinguish the accountabilities of CDO and CIO. The definition of their responsibilities may specify parts of:
A control activity in the metadata management environment includes loading statistical analysis.
To push up the urgency level requires adding of the sources of complacency or increasing of their impact.
It is recommended that organizations not print their business data glossaries for general use, why would you not want to print the glossary?
ANSI 859 recommends taking into account the following criteria when determining which control level applies to a data asset:
Location Master Data includes business party addresses and business party location, as well as facility addresses for locations owned by organizations.
If the target system has more transformation capability than either the source or the intermediary application system, the order of processes may be switched to ELT – Extract Load Tranform.
Decentralized informality can be made more formal through a documented series of connections and accountabilities via a RACI matrix.
Data stewardship is the least common label to describe accountability and responsibility for data and processes to ensure effective control and use of data assets.
Enterprise service buses (ESB) are the data integration solution for near real-time sharing of data between many systems, where the hub is a virtual concept of the standard format or the canonical model for sharing data in the organization.
Data science involves the iterative inclusion of data sources into models that develop insights. Dat science depends on:
A node is a group of computers hosting either processing or data as part of a distributed database.
Operationality and interoperability depends on the data quality. In order to measure the efficiency of a repository the data quality needs to be:
The CAP theorem asserts that the distributed system cannot comply with all the parts of the ACID. A distributed system must instead trade-off between the following properties:
The load step of ETL is physically storing or presenting the results of the transformation in the target system.
An enterprise's organisation chart has multiple levels, each with a single reporting
line. This is an example of a:
Enterprise data architects in an application migration project are primarily concerned with:
The ethics of data handling are complex, but is centred on several core concepts. Please select the correct answers.
There are several reasons to denormalize data. The first is to improve performance by:
Data governance requires control mechanisms and procedures for, but not limited to, escalating issues to higher level of authority.
Quality Assurance Testing (QA) is used to test functionality against requirements.
Integrating data security with document and content management knowledge areas.
guides the implementation of:
Release management is critical to batch development processes that grows new capabilities.
Please select the correct principles of the General Data Protection Regulation (GDPR) of the EU.
Functionality-focused requirements associated with a comprehensive metadata solution, include:
A ‘Content Distribution Network’ supporting a multi-national website is likely to use:
Product Master data can only focus on an organization’s internal product and services.
When constructing an organization’s operating model cultural factors must be taken into consideration.
Risk classifications describe the sensitivity of the data and the likelihood that it might be sought after for malicious purposes.
An information maturity assessment provides a valuable input to Data Governance planning because it provides:
Master data management includes several basic steps, which include: Develop rules for accurately matching and merging entity instances.
A goal of reference and master data is to provide authoritative source of reconciled and quality-assessed master and reference data.
In a data warehouse, where the classification lists for organisation type are
inconsistent in different source systems, there is an indication that there is a lack of
focus on:
Which of the following is a directive that codifies principles and management intent
into fundamental rules governing the creation, acquisition, integrity, security, quality,
and use of data and information?
There are three basic approaches to implementing a Master Data hub environment, including:
All assessments should include a roadmap for phased implementation of the recommendations. This is important because:
An organization has a legitimate interest in commercializing data. So why is the economic value of data a core concept of data handling ethics?
Real-time data integration is usually triggered by batch processing, such as historic data.
A synonym for transformation in ETL is mapping. Mapping is the process of developing the lookup matrix from source to target structures, but not the result of the process.
Changes to reference data do not need to be management, only metadata should be managed.
If data is a governed resource, like other resources (e.g., human resources, finance, property), how is Data Governance different from other types of Governance?
Bias refers to an inclination of outlook. Please select the types of data bias:
Data professionals involved in Business Intelligence, analytics and Data Science are often responsible for data that describes: who people are; what people do; where people live; and how people are treated. The data can be misused and counteract the principles underlying data ethics.
A roadmap for enterprise data architecture describes the architecture’s 3 to 5-year development path. The roadmap should be guided by a data management maturity assessment.
In an information management context, the short-term wins and goals often arise from the resolution of an identified problem.
The implementation of a Data Warehouse should follow these guiding principles:
With respect to health data, what is the difference between the privacy and the security of the data?
When establishing an Organizational Change Management team, what responsibilities and skills should they possess?
Lack of automated monitoring represents serious risks, including compliance risk.
Please select the correct definition of Data Management from the options below.
The number of entities in a relationship is the arity of the relationship. The most common are:
Data management professionals who understand formal change management will be more successful in bringing about changes that will help their organizations get more value from their data. To do so, it is important to understand:
Development of goals, principles and policies derived from the data governance strategy will not guide the organization into the desired future state.
Project that use personal data should have a disciplined approach to the use of that data. They should account for:
If data is not integrated with care it presents risk for unethical data handling. These ethical risks intersect with fundamental problems in data management including: Limited knowledge of data’s origin and lineage; Data of poor quality; Unreliable Metadata; and Documentation of error remediation.
It is unwise to implement data quality checks to ensure that the copies of the attributes are correctly stored.
The information governance maturity model describes the characteristics of the information governance and recordkeeping environment at five levels of maturity for each of the eight GARP principles. Please select the correct level descriptions:
Enterprise data architecture influences the scope boundaries of project and system releases. An example of influence is data replication control.
Resource Description Framework (RDF), a common framework used to describe information about any Web resource, is a standard model for data interchange in the Web.
Please select the option that correctly orders the models in decreasing level of detail:
In the context of big data the Three V’s refer to: Volume, Velocity and Validity
The IT security policy provides categories for individual application, database roles, user groups and information sensitivity.
A Business Glossary forces a business to adopt a single definition of a business term.
A hacker is a person who finds unknown operations and pathways within complex computer system. Hackers are only bad.
Small reference data value sets in the logical data model can be implemented in a physical model in three common ways:
Poorly managed Metadata leads to, among other, redundant data and data management processes.
How does the DMBOK refer to an organization that values data as an asset and manages data through all phases of its lifecycle?
Please select correct term for the following sentence: Any collection of stored data regardless of structure or content. Some large databases refer to instances and schema.
Data profiling also includes cross-column analysis, which can identify overlapping or duplicate columns and expose embedded value dependencies.
The goal of Data Governance is to enable an organization to manage data as an asset. To achieve this overall goal, a DG program must be:
Architecture is the fundamental organization of a system, embodied in its components, their relationships to each other and the environment and the principles governing its design and evolution.
According to the DMBoK2, by creating Data Management Services, IT involves the Data Governance Council:
The impact of the changes from new volatile data must be isolated from the bulk of the historical, non-volatile DW data. There are three main approaches, including:
A e-discovery readiness assessment should examine and identify opportunities for the commercial response program.
An organization can enhance its Data Governance program and thereby improve its approach to enterprise data management. This is important for the following reason:
TESTED 01 Jul 2025