Grade Details - All Questions
Question 1. Question :
(TCO 1) What are the duties of a data administrator (DA) with regards
to a database, and how are a DBA’s (Database Administrator) tasks
different from a DA’s in dealing with a database?
Student
Answer:
Instructor DA separates the business aspects of data resource management from the
Explanation: technology used to manage data. There are more technical aspects of database
design and daily operation requirements of a database. The DBA must understand
the data models built by a DA. The DBA uses the logical model to build the physical
model. The DA is responsible for issues such as:
Identifying data owners and stewards
Setting standards for control and usage of data
Identifying and cataloging the data required by business users
Production of conceptual and logical data models to accurately depict
the relationship among data elements for business processes
Production of an enterprise data model that incorporates all of the
data used by all of the organization’s business processes
Setting data policies for the organization
You can include Chapter 1 and/or page 15, if they apply.
0 -919692112 Short 3
Question 2. Question :
(TCO 2) Each of the major DBMS products changes quite rapidly, and
keeping DBMS software up-to-date can be a difficult task. As a DBA,
what are the issues to consider when upgrading to a new DBMS
version to have little or no disruption?
Student
Answer:
Instructor A DBMS version upgrade can be thought of as a special case of a new installation.
Explanation: All of the procedures required of a new installation apply to an upgrade: you must
plan for appropriate resources, reconsider all system parameters, and ensure that all
supporting software is appropriately connected. However, another serious issue must
be planned for: existing users and applications. An upgrade needs to be planned to
cause as little disruption to the existing users as possible. Furthermore, any
additional software that works with the DBMS (such as purchased applications, DBA
tools, utilities, and so on) must be verified to be compatible with the new DBMS
version.
Chapter 2 and/or page 82, if they apply.
This study source was downloaded by 100000829957125 from CourseHero.com on 01-21-2022 08:09:26 GMT -06:00
https://www.coursehero.com/file/12036806/Week-4-midterm/
Question 1. Question :
(TCO 1) What are the duties of a data administrator (DA) with regards
to a database, and how are a DBA’s (Database Administrator) tasks
different from a DA’s in dealing with a database?
Student
Answer:
Instructor DA separates the business aspects of data resource management from the
Explanation: technology used to manage data. There are more technical aspects of database
design and daily operation requirements of a database. The DBA must understand
the data models built by a DA. The DBA uses the logical model to build the physical
model. The DA is responsible for issues such as:
Identifying data owners and stewards
Setting standards for control and usage of data
Identifying and cataloging the data required by business users
Production of conceptual and logical data models to accurately depict
the relationship among data elements for business processes
Production of an enterprise data model that incorporates all of the
data used by all of the organization’s business processes
Setting data policies for the organization
You can include Chapter 1 and/or page 15, if they apply.
0 -919692112 Short 3
Question 2. Question :
(TCO 2) Each of the major DBMS products changes quite rapidly, and
keeping DBMS software up-to-date can be a difficult task. As a DBA,
what are the issues to consider when upgrading to a new DBMS
version to have little or no disruption?
Student
Answer:
Instructor A DBMS version upgrade can be thought of as a special case of a new installation.
Explanation: All of the procedures required of a new installation apply to an upgrade: you must
plan for appropriate resources, reconsider all system parameters, and ensure that all
supporting software is appropriately connected. However, another serious issue must
be planned for: existing users and applications. An upgrade needs to be planned to
cause as little disruption to the existing users as possible. Furthermore, any
additional software that works with the DBMS (such as purchased applications, DBA
tools, utilities, and so on) must be verified to be compatible with the new DBMS
version.
Chapter 2 and/or page 82, if they apply.
This study source was downloaded by 100000829957125 from CourseHero.com on 01-21-2022 08:09:26 GMT -06:00
https://www.coursehero.com/file/12036806/Week-4-midterm/
