CC6 - Chapter 1 = NOTES

Question 1

manages computer databases. The role may include capacity planning, installation, configuration, database design, migration, performance monitoring, security, troubleshooting, as well as backup and data recovery.

Answer 1

Database administrator (DBA)

Question 2

is responsible for maintaining an organization’s computer networks, including hardware and software. They ensure that networks are secure, efficient, and reliable.

Answer 2

network administrator

Question 3

are data governance employees who collect and maintain data for the organizations they work for while also protecting their data assets.

Answer 3

Data stewards

Question 4

is a leader who uses data to help a company make strategic decisions. They are responsible for integrating data from various sources to create a unified view.

Answer 4

data strategist

Question 5

is a senior executive who manages a company’s data strategy and use. They are responsible for ensuring that data is used effectively to support business decisions.

Answer 5

Chief Data Officer (CDO)

Question 6

• Ensure that data is accurate and of good quality

Answer 6

Data quality

Question 7

• Protect data from unauthorized access, theft, or corruption

Answer 7

Data security

Question 8

• Manage data governance strategies, practices, and requirements

Answer 8

Data governance

Question 9

• Lead the development of a data strategy that aligns with business objectives

Answer 9

Data strategy

Question 10

• Implement data analytics into business processes

Answer 10

Data analytics

Question 11

• Promote data literacy and a data-driven culture

Answer 11

Data literacy

Question 12

• Ensure compliance with data protection and privacy regulations

Answer 12

Regulatory compliance

Question 13

Some examples of basic metadata are:

Answer 13

• author
• date created
• date modified
• file size.

Question 14

is also used for unstructured data such as images, video, web pages, spreadsheets, etc. Web pages often include metadata in the form of meta tags.

Answer 14

Metadata

Question 15

: Identify key business goals that data can support and prioritize data needs aligned with strategic initiatives.

Answer 15

Define Business Objectives

Question 16

: Conduct a comprehensive data audit to identify all data sources, their formats, locations, quality, and usage across the organization.

Answer 16

Data Inventory and Mapping

Question 17

: Assess data accuracy, completeness, consistency, and relevance to identify areas for improvement.

Answer 17

Data Quality Analysis

Question 18

: Identify key stakeholders, their data requirements, and establish communication channels.

Answer 18

Stakeholder Engagement

Question 19

: Develop clear guidelines for data ownership, access control, data quality standards, retention policies, and privacy compliance.

Answer 19

Establish Data Governance Policies

Question 20

: Assign data stewards, data owners, and data custodians with defined accountability for data management.

Answer 20

Data Governance Roles and Responsibilities

Question 21

: Implement processes to monitor and improve data quality through data cleansing, validation, and standardization.

Answer 21

Data Quality Management Plan

Question 22

: Determine which data sources are critical for integration and prioritize based on business needs.

Answer 22

Data Source Selection

Question 23

: Map data elements from different sources to a unified schema and transform data to ensure consistency.

Answer 23

Data Mapping and Transformation

Question 24

: Select appropriate data integration tools to extract, transform, and load (ETL) data from disparate sources.

Answer 24

Data Integration Tools

Question 25

: Choose appropriate data storage architecture (relational, dimensional, cloud-based) to facilitate analysis and reporting.

Answer 25

**Data Warehouse/Lake Design**

Question 26

: Implement robust data security controls including encryption, access controls, and data masking to protect sensitive information.

Answer 26

**Data Security Measures**

Question 27

: Establish a reliable data backup and disaster recovery plan to mitigate data loss risks.

Answer 27

**Data Backup and Recovery Strategy**

Question 28

: Choose appropriate BI tools to visualize and analyze data for decision-making.

Answer 28

**Business Intelligence (BI) Tool Selection**

Question 29

: Create customized dashboards and reports aligned with key business metrics to provide actionable insights.

Answer 29

**Dashboard Development**

Question 30

: Develop data models to enable efficient querying and analysis of data across different dimensions.

Answer 30

**Data Modeling and Analysis**

Question 31

: Regularly monitor data quality metrics to identify and address data quality issues proactively.

Answer 31

**Data Quality Monitoring**

Question 32

: Track key performance indicators (KPIs) related to data management to assess the effectiveness of implemented strategies.

Answer 32

**Performance Evaluation**

Question 33

: Review and update the data management strategy as business needs evolve and new technologies emerge.

Answer 33

**Adapting to Change**

Question 34

: Ensure strong support from leadership and involve key stakeholders throughout the implementation process.

Answer 34

**Organizational Alignment**

Question 35

: Communicate changes effectively and provide training to users to facilitate adoption of new data management practices.

Answer 35

**Change Management**

Question 36

: Adhere to relevant data privacy regulations (e.g., GDPR, CCPA) when managing sensitive data.

Answer 36

**Compliance Requirements**

Question 37

describe the purpose the Knowledge Area and the fundamental principles that guide performance of activities within each Knowledge Area.

Answer 37

**Goals**

Question 38

are the actions and tasks required to meet the goals of the Knowledge Area. Some activities are described in terms of sub-activities, tasks, and steps.

Answer 38

**Activities**

Question 39

* set the strategic and tactical course for meeting data management goals. it s occur on a recurring basis.

Answer 39

**(P)Planning Activities**

Question 40

* are organized around the system development lifecycle (SDLC) (analysis, design, build, test, preparation, and deployment).

Answer 40

**(D)Development Activities**

Question 41

* ensure the ongoing quality of data and the integrity, reliability, and security of systems through which data is accessed and used.

Answer 41

**(C) Control Activities**

Question 42

* support the use, maintenance, and enhancement of systems and processes through which data is accessed and used.

Answer 42

**(O)Operational Activities**

Question 43

are the tangible things that each Knowledge Area requires to initiate its activities. Many activities require the same inputs. For example, many require knowledge of the Business Strategy as input.

Answer 43

**Inputs**

Question 44

are the outputs of the activities within the Knowledge Area, the tangible things that each function is responsible for producing. Deliverables may be ends in themselves or inputs into other activities. Several primary deliverables are created by multiple functions.

Answer 44

**Deliverables**

Question 45

describe how individuals and teams contribute to activities within the Knowledge Area. Roles are described conceptually, with a focus on groups of roles required in most organizations. Roles for individuals are defined in terms of skills and qualification requirements. Skills Framework for the Information Age (SFIA) was used to help align role titles. Many roles will be cross-functional.

Answer 45

**Roles and Responsibilities**

Question 46

are the people responsible for providing or enabling access to inputs for the activities.

Answer 46

**Suppliers**

Question 47

those that directly benefit from the primary deliverables created by the data management activities.

Answer 47

**Consumers**

Question 48

are the people that perform, manage the performance of, or approve the activities in the Knowledge Area.

Answer 48

**Participants**

Question 49

are the applications and other technologies that enable the goals of the Knowledge Area.

Answer 49

**Tools**

Question 50

are the methods and procedures used to perform activities and produce deliverables within a Knowledge Area. Techniques include common conventions, best practice recommendations, standards and protocols, and, where applicable, emerging alternative approaches.

Answer 50

**Techniques**

Question 51

are standards for measurement or evaluation of performance, progress, quality, efficiency, or other effect. The metrics sections identify measurable facets of the work that is done within each Knowledge Area. Metrics may also measure more abstract characteristics, like improvement or value

Answer 51

**Metrics**