Transparency in data management processes

Assignment Help Database Management System
Reference no: EM132994008

1. Data governance is the organization and implementation of
a) right for collaborative action and decision making by corporate management.
b) rules for competitive market share analytics.
c) policies, procedures, structure and roles and responsibilities for managing information assets.
d) data policies to provide accurate record keeping.

2. data lifecycle elements include all of the following, EXCEPT
a) dispose
b) curate
c) build
d) plan

3. ideally data stewards should be organized by
a) division
b) department
c) data domain
d)data dis discipline

4. For data governance, it is necessary to understand where data is located to
a) reduce costs
b) assign data ownership.
c) manage service levels
d) address compliance requirement

5. Data stewards
a) are multidimensional
b) are titles, not roles.
c) must be assigned to exactly one subject area.
d) are data czars

6. Data governance and master data management make the definition of _____ one of the top priorities.
A) authoritative sources
b) Risk Mitigation
c) communication plan
d) end user groups

7. in a multinational corporation that manages global data, it is likely that you'll need _____ data stewards.
a) project
b) location-oriented
c) senior
d) application specific

8. which one of the following is the MOST important for success in implementing Data Governance?
a) identifying actions
b) defining measures
c) setting goals
d) defining scope

9. an organization's information strategy should PRIMARILY be aligned with
a) business and mission objectives.
b) the vision of the CIO.
c) its technology strategy.
d) the demands of the stakeholders.

10. Data Governance provides _______ for effective control and use of data assets.
a) best practices
b) a framework
c) management
context

11. all of the following are important aspects of data governance for MDM EXCEPT
a) establishing accountability for high-quality data maintenance.
b) ensuring data policies are observed.
c) designing conforming dimensions.
d) managing data entities and critical data element.

12. data asset valuation can be established by all of the following methods EXCEPT
a) at the time of corporation sale.
b) as a replacement cost.
c) by performing an inventory.
d) by estimation.

13. transparency in data management processes is important because it provides
a) fewer surprises and no unauthorized data management activities.
b) surprise goals, metrics and monitoring.
c) the elimination of data redundancy, waste and rework.
d) the right data to meet business information needs.

14. data governance business goals should NOT be
a) formalized from guiding principles.
b) unique to the organization.
c) static over time.
d) formalized from a business sector.

15. a leading practice is that data policies must apply to
a) the true value of business data.
b) the business as a whole.
c) clear ownership of the data.
d) various business silos.

16. which of the following models of implementation is likely to lead to a more mature data stewardship practice?
a) data stewardship by Project.
b) data stewardship by Business Process.
c) data stewardship by Domain.
d) data stewardship by Function.

17. data governance stakeholders include all the following EXCEPT
a) those operational interests that drive efficiency and effectiveness.
b) financial management.
c) regulatory compliance officers.
d) product consumers.

18. data lineage provide
a) data structure.
b) data sources.
c) data meaning.
d) data content.

19. the information value chain matrix shows data-to-value for all of the following EXCEPT
a) information.
b) knowledge.
c) wisdom.
d) innovation.

20. data technology alignment processes in a Data Governance (DG) program seek to do all of the following EXCEPT
a) promote technology decisions and implementations that are compatible with data management practices.
b) develop a hierarchical organizational architecture for DG and it operations.
c) ensure that DG practices and IT practices are synergistic, consistent and free of conflict.
d) identify requirements for and participate in selection of data management, MDM and data quality tools and technologies.

21. Data Governance roles include all of the following EXCEPT
a) CFO/CEO
b) Data Modelers.
c) Application Owners.
d) Chief Data Officer

22. which of the following would NOT be considered when designing a data quality program?
a) standards.
b) privacy.
c) requirements.
d) timeliness.

23. for a data governance program, the data owner has responsibility and authority for
a) business definitions and data security management.
b) distribution and retention of data.
c) knowledge of data privacy laws, business rules and business objectives.
d) quality, access, distribution, and business definitions.

24. which of the following issues MOST often impact Data Governance?
a) quantitative goals tracking and continuous improvement.
b) complexity reduction.
c) data quality, security and compliance.
d) standardization and consolidation.

25. ethical data handling does NOT include
a) data maturity analysis.
b) training programs and monitoring.
c) community consultation.
d) controlling for bias.

26. business drivers for a data governance program include all of the following EXCEPT
a) increases accuracy for decision making.
b) hot site deployment.
c) regulatory compliance.
d) maximizing profit.

27. how an organization assigns data stewards is dependent upon all of the following EXCEPT the
a) scope of governed data.
b) number of downstream data users.
c) size of your enterprise.
d) organizational maturity of your data governance program.

28. for a Data Council issue resolution process, the objectives include all of the following EXCEPT
a) meeting with Data Council membership.
b) identifying who is the root cause.
c) providing a forum for issues to be raised.
d) addressing problems instead of symptoms.

29. what is the MOST important policy that should be discussed with data owners in the early stages of designing a data governance program?
a) enterprise resource planning (ERP)
b) data integration
c) data retention
d) data quality metrics

30. the MOST difficult step in overcoming organizational resistance is to
a) get executive sponsorship.
b) recognize it.
c) include all stakeholders.
d) develop respected champions.

31. data architecture needs all the following EXCEPT
a) showing where entity data resides physically.
b) models that describe the various data domains.
c) models that describe business views of the data.
d) direct access to all data sources.

32. data quality and risk management are strongly connected to
a) setting priorities and maintaining roadmap of activities.
b) facilitation and consensus building for a data governance.
c) business requirements for an application.
d) motivations for the need for data governance.

33. data profiling
a) aids requirement analysis.
b) examines existing data to understand content and structure.
c) provides guidance to turn bad habits into good habits.
d) reverse engineers relationships from data instances.

34. when staring a Data Governance program, the biggest challenge is to
a) write and approve a data governance policy.
b) reducing redundant data in an organization.
c) determine the scope of data to be managed.
d) defining a single data subject such as CUSTOMER.

35. all of the following are Data Governance inputs, EXCEPT
a) data requirements.
b) data quality issues.
c) regulatory requirements.
d) policies and procedures.

36. what is the included in a data policy?
a) data quality and data ownership.
b) data governance exceptional management processes, data quality, and business intelligence ownership.
c) data asset ownership, SOX reporting requirements and information protection requirements.
d) dimensions of quality, ownership, roles, responsibilities and exception management processes.

37. metadata in an organization is used to
a) manage its data resource personal effectively.
b) manage its information resource effectively and efficiently.
c) provide for an indirect manner to always reach data using object oriented methods.
d) detail time, scope & sensitivity of the data.

38. taxonomy metadata is used to
a) help people find data items or group of data items.
b) help navigate the data minefield.
c) enforce constraints upon the data.
d) specify roles, classify descriptions, guide and control.

39. the following are ways to measure data stewardship effectiveness, EXCEPT
a) data quality metrics.
b) lowered compliance risk.
c) performance management.
d) game theory optimization.

40. in content management, business data stewards help with all of the following EXCEPT
a) controlled vocabularies.
b) communicating content issues.
c) enterprise taxonomies.
d) search algorithms.

41. data governance treats data as
a) critical for business operation.
b) input into continuous quality improvement.
c) a business unit asset.
d) an enterprise capital asset.

42. successful Data Governance programs are
a) a blend of bottom-up collaborations and top-down implementations.
b) top-down implementations with executive leadership.
c) dependent on fit with culture and capabilities of the organization.
d) bottom-up collaborations amongst business stakeholders.

43. good habits in defining data include all of following EXCEPT
a) adopting short definitions.
b) using business based terms and meanings.
c) establishing a data naming taxonomy.
d) creating inheritance of definitions.

44. technical data stewards are responsible for all of the following EXCEPT
a) data integration.
b) data analysis.
c) data storage.
d) data security.

45. knowing how data has been used and abused in the past is an indicator of how it might be _____.
a) available.
b) compromised.
c) reported.
d) ignored.

46. the two MOST important characteristics to facilitate Data Governance within an organization are _____and _____.
a) trust, communication
b) knowledge, respect
c) acknowledgement, credentials
d) expertise, reward

47. which topic is LEAST likely to be on a data governance council agenda?
a) Non-conformance issues (policies, standards, and procedures).
b) internal and external data security audit findings.
c) Regulatory non-compliance issues.
d) Approving architectural compliance.

48. An organization's social media policy, if implemented, MUST map to its
a) mission statement.
b) employee security policy
c) department policy.
d) corporate governance.

49. all of the following are key metrics for measuring the affectiveness of your data governance program, EXCEPT
a) increased data integration throughout the organization.
b) percent of data governance objective met.
c) percent of organizational KPI target met.
d) increased customer satisfaction.

50. _______ is not a good reason for implementing a new data governance program.
a) a mis-sent marketing mailing
b) Sunsetting a CRM system
c) consolidation of data warehouse system.
d) problems in manufacturing

51. for business intelligence (BI), business data stewards help with all of the following EXCEPT
a) data quality metrics
b) dimensional model development
c) BI requirement
d) BI issues

52. Goal setting, measurement, communications, facilitation, consensus building, and monitoring of data assets are part of the skill set that is required of a
a) data owner
b) data steward
c) project lead
d) data analyst

53. Metadata should be stored
a) remotely in the cloud
b) and categorized
c) in a decentralized database
d) in one huge set

54. reasons to govern data architecture include all of the following EXCEPT
a) you need a subject model that describes the various data domains.
b) the core data management processes of IT departments touch only a small percentage of the enterprise data resource.
c) you need to know where data is reported all the time.
d) you require a matrix map of business unit interactions with data entities.

55. When implement a cloud solution, the SLA must include vendor delegated tasks for
a) speed of data loading into the cloud.
b) economies of scale.
c) data defect correction processes.
d) cybersecurity and data protection.

56. the following are deliverables in a data governance program EXCEPT
a) metadata standard
b) data models
c) communications plan
d) the metrics for data quality scorecard

57. data governance success factors include all of the following EXCEPT
a) commitment
b) autonomy
c) motivation
d) executive buy-in

58. data Governance project priorities require input from Business Analytics team and
a) solution architects
b) data stewards and business users
c) information technology organization
d) service management and support teams

59. An important step in developing a change management plan to implement a data governance program is to identify
a) data owners
b) business champions
c) database authorities
d) configuration managers

60. aspects of data governance include
a) data quality, standardization, and consolidation
b) people, process and business goals
c) data stewards, data custodians, and data owners
d) complex data rules

61. data custodians are responsible for
a) organizing, storage, archiving and backup of data.
b) possessing the data and controlling its use
c) managing and securing IT database infrastructure.
d) preventing loss of data and/or corruption

62. data security policy documents include all of the following EXCEPT
a) Role-based access
b) data classification
c) data audit logs
d) role-based update right

63. the outputs of Data Governance include all of the following EXCEPT
a) procedures
b) policies
c) laws
d) rules

64. a good data quality scorecard include should all of the following EXCEPT
a) technical and non-technical metrics
b) different views of the scorecard for difference audiences.
c) data profiting non-aggregated metrics.
d) data profiting aggregated metrics.

65. data architecture is necessary because
a) organization need to manage federations.
b) organization need to acquire and govern data.
c) enterprise data is disparate and needs to be leveraged
d) enterprise databases often lack documentation and are not secure.

66. decision rights in Data Governance
a) provide absolute authority and unrestricted power.
b) are a means by which to implement authority.
c) specify access, retention and contribution to value.
d) specify how management should control ongoing operation.

67. scope and priorities management on a Data Governance program is a process of
a) predicting iterations in stakeholders and stakeholder interests.
b) configuration control and change management.
c) predicting volatile business environments.
d) balancing stakeholder requests against defined business.

68. Data Governance roles include all of the following EXCEPT
a) data scribe.
b) data curator.
c) data architect.
d) data custodian.

69. policies in data governance are used to
a) develop those directives that are harder to violate than to apply.
b) enforce data design guidelines.
c) make standers durable and enforceable.
d) implement procedures processes for handling exceptions.

70. the easiest way to identify a return on investment (ROI) is through which of the following
a) reacting to stock market value of the company.
b) influencing important company projects.
c) groundswell of interest.
d) correcting key data in a law cost manner.

71. accountability in Data Governance programs
a) cannot be delegated.
b) can be delegated.
c) is assigned to teams.
d) is separated from authority roles.

72. ______ governance consist of addressing a current issue.
a) crisis
b) pre-emptive.
c) predictive.
d) reactive.

73. Data Governance stakeholders maybe have different ______ and ______.
a) drivers; levels of focus
b) policies; collective needs.
c) policies; data governance councils.
d) levels of influence; drivers.

74. the primary operational responsibility for DBAS that has the most Data Governance overlap is
a) creating mechanisms for clustering of data.
b) implementing appropriate backup and recovery mechanism.
c) ensuring performance and reliability of database.
d) scheduling runstats and reorganizations.

75. ______ and ______ are two techniques that must be applied by policy to information to eliminate business risk once data is no longer needed.
a) backup; recovery
b) declassification; redaction
c) shredding; expungement
d) sanitization; recovery

76. a division of your company is moving overseas, you are asked to create a duplicate of all HR data for use in the new location.
a) get signoff from all employees who are moving.
b) no signoffs needed -the data is staying in the company.
c) get signoff from senior management.
d) get signoff from the Legal Department.

77. the data lifecycle is ______ the system development lifecycle.
a) the same as
b) shorter then
c) longer than
d) not related to

78. data governance scope includes all of the following EXCEPT
a) security enforcement.
b) communication.
c) data standards and architecture.
d) regulatory compliance.

79. in a healthcare organization, the key consideration for a data governance program might be _____
a) categorization of vendor relationships.
b) accurate categorization of employee skills.
c) documentation of patient preferences.
d) protection of personally identifiable information.

80. the MOST critical skill in the Data Governance function is
a) process modeling.
b) sponsorship.
c) data modeling.
d) facilitation.

81. For data classification and retention policy development, data governance would NOT typically review
a) data usage and handling specifications.
b) application service level agreements.
c) database retention requirements.
d) records management system data.

82. according to the General Data Protection Regulation (GDPR), an information security due diligence activity should include which of the following?
a) reporting of data exchange with vendors.
b) the organization has an assigned data protection officer role.
c) background checks on employees with data access.
d) notification to Data Protection Authority of change of corporate officers.

83. Data Curators use a data catalog to document
a) data vendor relationships.
b) data quality issues.
c) data interfaces.
d) data provenance.

84. business disputes related to cross-organizational data warehouse development projects are typically resolved by a
a) Data Governance Council
b) Architecture Review Board
c) Change Management Committee
d) MDM Steering Committee

85. who approves the data governance policy?
a) data steward, working groups or project teams.
b) head of Data or Information Architecture.
c) Data Governance Council members.
d) senior manager of the business unit.

86. A Data Governance scorecard feature necessary for understanding critical business problems would br to
a) develop high level measures.
b) create drill-down metrics.
c) link every metric to a dimension quality.
d) update the metrics quarterly.

87. the Data Governance Council plays a pivotal role in approving ______.
a) system change management procedures.
b) penetration testing protocols.
c) organization data ethics policies.
d) business data needs.

88. data specialists (DBAs and Data Modelers, etc.)
a) define data management priorities.
b) define data policies and standards.
c) support data management maturity.
d) guide scope of governed data.

89. factors relevant to data governance initiatives include each of the following EXCEPT
a) IT project portfolio participation.
b) cross functional sponsorship.
c) a well articticulated communications plan.
d) organizational and cultural change.

90. Data Governance includes all EXCEPT
a) high-level planning
b) data operation.
c) monitoring of the management of data assets.

91. to treat Data Governance in the enterprise as a_______ is a misconception.
a) data curation
b) project
c) program
d) change

92. top reasons cited for working around existing data groups in organizations include all of the following EXCEPT
a) perceived to be too slow
b) unknown value provided by the data group.
c) too difficult to work with.
d) unknown to the business stakeholders.

93. precise data definitions in data models are important for
a) data storage capacity.
b) data retention.
c) data integration rule definition.
d) data maturity.

94. all of the following are bad habits of data naming and definition, EXCEPT
a) capturing complete definition but with no size limit.
b) using recognizable abbreviation patterns that are not standardized.
c) using locally unavailable definitions.
d) adopting informal abbreviations.

95. classifying data helps to
a) categorize data architecture and definitions.
b) group together similar kinds of data.
c) apply common standards and processes to create meta-data.
d) create data table, files and records.

96. which of the following would MOST likely be included in a data steward's role description?
a) develop and approve technical data standards.
b) ensure clear unambiguous data element definitions.
c) document the origination and source of authority.
d) maintain the master data management version controls.

97. data risk assessment requires
a) root cause analysis.
b) data to business alignment.
c) known data origins and uses.
d) standard naming and consistent use of data.

98. master data management in organizations may be part of all of the following EXCEPT
a) a vender's particular solution to inconsistent corporate data.
b) an enterprise resource planning program.
c) a customer data integration program.
d) improving data quality standards.

99. Data Architecture focuses on _____ while Data Governance focuses on _____.
a) master set of data models; decision right
b) enterprise value; stakeholder management.
c) network technology; Responsible, Accountable, Consulted and Informed (RACI).
d) Responsible, Accountable, Consulted and Informed (RACI); data models.

100. authority for data sharing in a data governance program is implemented through
a) high scope decision made based on high quality data.
b) executive sponsorship and delegating of authority.
c) autonomous, informed and influential management style.
d) designated decision rights based on data ownership policy.

101. information gaps - the difference between what information is needed and whatever trustworthy information is currently available- represent
a) inadequate information
b) business liabilities.
c) business assets.
d) lost revenues.

102. Data governance is
a) an effort that coordinates the activities of data owners and data specialists.
b) used to develop and operate a set of database files and maintain a changing set models to create flexible and market responsive organization.
c) a program - a set of projects and services designed to manage the data assets.
d) focused on developing, operating, sustaining and growing the data function.

103. a data governance roadmap should include all of the following EXCEPT
a) tasks and data index inventory
b) technologies and communications
c) policies and processes
d) people and organizational structures

104. Data Management Maturity targets should NOT be based on
a) data strategy
b) organization objectives
c) key performance indicators
d) business requirements

106. a business analyst needs to show revenue trends for her company. From a data governance and data handling ethics standpoint, which of the following actions would NOT be considered an ethical use of data?
a) the analyst introduces her presentation with definitions of data used, and provides context for the visualization.
b) the analyst leaves out revenue trends from a recalled product line, noting this in a footnote to the visualization.
c) the data over a year-long period shows decrease in revenue toward the end of the year. The analyst presents a visualization covering the entire year.
d) the data over a year-long period shows decrease in revenue toward the end of the year. The analyst presents a visualization covering the period before the revenue decrease began.

Reference no: EM132994008

Questions Cloud

How much will he have : Listen Dan is saving for a down payment on a house. If he saves $300 at the end of each month for 4 years, how much will he have
Calculate their new monthly payment : A couple has a $420,000 mortgage amortized over 30 years with monthly payments. Calculate their new monthly payment
What the contribution margin ratio : If sales total $3,000,000 and fixed costs total $600,000 and variable costs are $1,000,000 of sales what the contribution margin ratio
What is the stock expected price : The required rate of return on the stock is 14%. What is the stock's expected price 14 years from today (i.e., what is P14)
Transparency in data management processes : Why transparency in data management processes is important - what is the included in a data policy
Business research design and methodology assessment : Business Research Design and Methodology Assessment - demonstrate their ability to apply relevant business research methodology, including proposed sample frame
Why you feel this skill is important to management success : why you feel this skill is important to management success and one thing you might do help improve this skill
Understanding the laws and how they work in practice : Understanding the laws and how they work in practice in relation to mandatory reporting of child abuse and neglect is an issue that only teachers
Health practitioners and informed consent task : Health Practitioners and Informed Consent TASK - explains what you have found out about making a complaint about this particular type of health professional

Reviews

Write a Review

Database Management System Questions & Answers

  Knowledge and data warehousing

Design a dimensional model for analysing Purchases for Adventure Works Cycles and implement it as cubes using SQL Server Analysis Services. The AdventureWorks OLTP sample database is the data source for you BI analysis.

  Design a database schema

Design a Database schema

  Entity-relationship diagram

Create an entity-relationship diagram and design accompanying table layout using sound relational modeling practices and concepts.

  Implement a database of courses and students for a school

Implement a database of courses and students for a school.

  Prepare the e-r diagram for the movie database

Energy in the home, personal energy use and home energy efficiency and Efficient use of ‘waste' heat and renewable heat sources

  Design relation schemas for the entire database

Design relation schemas for the entire database.

  Prepare the relational schema for database

Prepare the relational schema for database

  Data modeling and normalization

Data Modeling and Normalization

  Use cases perform a requirements analysis for the case study

Use Cases Perform a requirements analysis for the Case Study

  Knowledge and data warehousing

Knowledge and Data Warehousing

  Stack and queue data structure

Identify and explain the differences between a stack and a queue data structure

  Practice on topic of normalization

Practice on topic of Normalization

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd