Question 1
- Describe the purpose of filegroups and examine the key ways it helps with minimizing administration to backups or with multiple databases within an organization. Suppose you managed a server with 200 terabytes of data, determine whether you would use full backup, transaction or file groups. Provide a rationale for your response.
- Suppose you are a DBA of a 5,000-person organization. Your boss wants to know the advantages of using a partitioned table and the ways it will affect performance of the server, specifically during peak hours. Decide whether or not a vertical partitioned table is more effective than a horizontal table. Justify your response.
Question 2
- Create an retail store order table with no less than seven fields
- Create an retail online order form to match with the table
- write a php script that will take the data from the form and
- insert it directly into the php table within the database.
Use XAMPP software
Question 3
Assignment: Minimum of 1300 words in APA format with at least three scholarly sources.
- Describe the roles of the CIO and the CISO.
- Describe an information security policy, which provides rules for the protection of the information assets of an organization.
- Describe three continuity strategies, using hot, warm or cold sites.