Database Management Questions

Database Management Questions
1.)
Alabama Life and Casualty Insurance Corporation specializes in underwriting commercial farm policies throughout the southern United States. The company’s Chief Information Officer (CIO) has become increasingly concerned that one of the company’s recent hires, a tech-savvy actuary, is directly accessing several production SQL Server databases using unapproved tools and access methods. Before approaching the employee’s supervisor, he has asked you, as the database administrator, to gather some additional information on the client application, network protocol, and queries that he believes the actuary is using on a routine basis. Your SQL Server 2012 instance is configured for Windows authentication only, and you manage role security using Active Directory. The database server is accessible only from within the Local Area Network (LAN), and no firewalls are present between the server and client applications. Your discussion board assignment is to:
•Describe the potential pitfalls you envision in trying to execute this plan.
•Explain which data elements you think will be most challenging to capture, and why.
2.)
You work for Resultant Data Corporation, a large and well-respected database consulting firm. One of your clients, an international pharmaceutical company, has requested some assistance in creating a new database. The database will be used for tracking and managing the firm’s $8 billion research and development budget. Your client’s internal project team is under enormous pressure to deliver a substantial component of the database project by year-end. They have chosen to pursue an agile approach to managing the project, with four-week delivery cycles. The technical lead on the project is aware that this will require a series of incremental changes to the SQL Server 2012 database in order to support the application and is, subsequently, concerned that the database may quickly become unmanageable. Write a response that explains how you might incorporate one or more of the following elements to address his concerns:
•Role and schema objects
•Naming conventions
•Data types
3.)
Define DML, DDL, and DCL, and discuss how SQL Server 2012 uses DML, DDL and DCL to manage databases.
4.)
You are employed as a database administrator by a start-up company in Menlo Park, California. The company is developing a new payments system that is attracting a lot of attention from venture capitalists. Customers will be able to process credit card transactions remotely and transmit payment information over the internet to your data center. During the latest round of negotiations for funding, one of the potential backers announced that he or she would be conducting a due diligence assessment to ensure that the new payments system design has adequate security controls. This potential backer is particularly concerned about customer privacy issues, as this is a hot topic in California and elsewhere. Your manager, the Chief Technology Officer (CTO) of the firm, has asked you to make recommendations on several aspects of SQL Server database security. Please consider:
•Securing the client/server connections over the internet
•Authenticating users
•Encrypting sensitive information
5.)
In your role as the database administrator for X-Tex, a small but successful company that designs and manufactures high tech fabrics, you have been asked to help optimize a query that will provide a dynamic view of your supply chain. You are to work with a developer who is tasked with integrating the data into a web portal to be used by the manufacturing operations team. The developer explains that he does not have much experience working with SQL Server 2012, but he seems keen to learn. Please provide the developer with a practical summary of design considerations that will help to ensure the query performs well.
6.)
Choose an organization with which you are familiar; for example, your place of work, the college or university that you attend, or a local community organization. Discuss:
•The data loss risks that the organization faces
•A set of recovery objectives based on the risk assessment and analysis of the business requirements
7.)
You recently joined a small, family-operated accounting business that specializes in preparing state and federal tax returns, as well as providing tax advice for individuals and local small businesses. Although the business is well-established, it is facing competitive pressure from online e-file firms, which offer a basic tax preparation and filing service at a low cost. The Chief Executive Officer (CEO) of your firm recently approved the purchase of a new system for preparing and filing returns, and you have been hired to administer the SQL Server databases. The CEO is particularly concerned about system availability during the peak tax season and has asked you to establish a formal process for monitoring their SQL Server databases. Complete the following:
•Construct a list of daily tasks, and the priority in which they should be performed, to monitor the service.
•Identify which tasks are good candidates for automation, and explain how you would automate these processes.
**** 1 references per question and write half page per question.****

Is this the question you were looking for? If so, place your order here to get started!