Database Reference
In-Depth Information
Review Questions
1. What tasks can be done with the query editor provided by SSMS?
2. Which tool in SSMS can be used to script out database objects?
3. Name the tool provided by SSMS to search for Windows Azure SQL Database Database
template.
4. What features can be used to integrate local SQL Server with Windows Azure?
5. Describe a problem that may occur when you migrate database objects from a production
server to an application development server.
6. What tasks can be handled by DAC?
7. What information is packaged into a .bacpac ile by DAC?
8. How does the database administrator create a DAC with existing databases?
9. How do application developers manage a DAC package after it is delivered to an application
development server?
10. What iles are generated by a DAC package after the package is deployed?
11. What should be done by a database administrator before an application can be made avail-
able to the public?
12. What do you do with Windows Azure SQL Database Migration Wizard?
13. What options does a database administrator have when migrating database objects?
14. What is SQL Server Integration Services?
15. What tasks can be accomplished with SQL Server Integration Services?
16. What is a bcp utility?
17. What are the requirements for the bcp?
18. What is the general format of a bcp command?
19. What are the advantages of XML?
20. What are the three types of XML iles?
