Database Reference
In-Depth Information
12.6 Summary
his chapter covers management-related issues. Security is the top concern for the databases and
applications deployed to a cloud environment. his chapter addresses the issues related to coni-
dentiality, integrity, and availability in the cloud environment. he cloud environment makes it
easy for database management. Cloud providers take care of the management of infrastructure,
security, database backup, and replication. In the cloud environment, the database administrator
can focus on the management of the database itself, such as user authentication and authorization.
For the management of Windows Azure, the Windows Azure Management Portal and Windows
Azure Service Management API are the tools that can accomplish tasks such as the management
of storage accounts, cloud services, certiicates, and ainity groups. To observe databases and
applications running on Windows Azure, we can use Windows Azure Diagnostics, which is a pro-
gramming-based tool that supports monitoring functionalities. he Windows Azure Management
Portal also provides tools to help monitor and analyze operations. To demonstrate how to manage
databases and applications in Windows Azure, four hands-on activities are provided. hese activi-
ties cover the management of database users, storage accounts, as well as service monitoring.
Review Questions
1. What are the three security requirements for databases running in a cloud environment?
2. State the deinition of conidentiality.
3. State the deinition of integrity.
4. State the deinition of availability.
5. Why is security the top concern for a database running in a cloud environment?
6. What do you do with CSP?
7. Why do you need to keep the integrity of the data stored in Windows Azure SQL Database?
8. How can the hashing technology be used to keep integrity?
9. What tools does Windows Azure provide to carry out hashing?
10. What is the technology used to improve the availability of cloud-based database systems?
11. What should be addressed by a security policy?
12. Why is it easier to manage databases in a cloud environment?
13. How to prevent invalid access to your database server and database hosted by Windows Azure?
14. State the diference between authentication and authorization.
15. What tasks can be accomplished by the Windows Azure Management Portal?
16. What do you do with a certiicate?
17. Why do you need to create an ainity group?
18. What do you do with the Windows Azure Service Management API?
19. What tasks can be performed by Windows Azure Diagnostics?
20. What monitoring tasks can be accomplished with the Windows Azure Management Portal?
