CMDB provide the capability to manage and maintain Metdata specifically related to the IT assets, the relationships among them, and contractual details of the assets.
Location Master Data includes business party addresses and business party location, as well as facility addresses for locations owned by organizations.
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.
An advantage of a centralized repository include: High availability since it is independent of the source systems.
The IBM Data Governance Council model is organized around four key categories. Select the answer that is not a category.
Decentralized informality can be made more formal through a documented series of connections and accountabilities via a RACI matrix.
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.
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.
Snowflaking is the term given to normalizing the flat, single-table, dimensional structure in a star schema into the respective component hierarchical or network structures.
The implementation of a Data Warehouse should follow guiding principles, including:
The purpose of data governance is to ensure that data is managed properly, according to policies and best practices. Data governance is focused on how decisions are made about data and how people and processes are expected to behave in relation to data.
A deliverable in the data architecture context diagram includes an implementation roadmap.
Content management includes the systems for organizing information resources so that they can specially be stored.
Governance ensures data is managed, but is not include the actual act of managing data.
In matching, false positives are three references that do not represent the same entity are linked with a single identifier.
Use business rules to support Data Integration and Interoperability at various points, to:
Data access control can be organized at an individual level or group level, depending on the need.
An application DBA leads the review and administration of procedural database objects.
Data governance can be understood in terms of political governance. It includes the following three function types:
Traditional tool sin data visualtization have both a data and a graphical component. Advanced visualization and discovery tools use in-memory architecture to allow users to interact with the data.
Elements that point to differences between warehouses and operational systems include:
There are three basic approaches to implementing a Master Data hub environment, including:
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.
Data governance program must contribute to the organization by identifying and delivering on specific benefits.
Data quality management is a key capability of a data management practice and organization.
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:
Value is the difference between the cost of a thing and the benefit derived from that thing.
A deliverable in the data modelling and design context diagram is the logical data model.
Data architect: A senior analyst responsible for data architecture and data integration.
Domains can be identified in different ways including: data type; data format; list; range; and rule-based.
Change only requires change agents in special circumstances, especially when there is little to no adoption.
ANSI standard 859 has three levels of control of data, based on the criticality of the data and the perceived harm that would occur if data were corrupt or otherwise unavailable, including:
Please select the user that best describes the following description: Uses the business glossary to make architecture, systems design, and development decisions, and to conduct the impact analysis.
Data parsing is the process of analysing data using pre-determined rules to define its content or value.
Effective document management requires clear policies and procedures, especially regarding retention and disposal of records.
Misleading visualisations could be an example where a base level of truthfulness and transparency are not adhered to.
DBAs and database architects combine their knowledge of available tools with the business requirements in order to suggest the best possible application of technology to meet organizational goals.
Data governance requires control mechanisms and procedures for, but not limited to, assignment and tracking of action items.
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.
Functionality-focused requirements associated with a comprehensive metadata solution, include:
Content needs to be modular, structured, reusable and device and platform independent.
Please select the correct general cost and benefit categories that can be applied consistently within an organization.
The best preventative action to prevent poor quality data from entering an organisation include:
Business requirements is an input in the Data Warehouse and Business Intelligence context diagram.