MIS 561 Week_4_midterm (GRADED A) | DeVry University, Keller Graduate School of Management

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 Explanation: DA separates the business aspects of data resource management from the 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. 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 Explanation: A DBMS version upgrade can be thought of as a special case of a new installation. 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