Microsoft-PRO Designing Database Solutions by Using Microsoft SQL Server 2005 Set 1

You are designing a performance monitoring plan for the database that supports APP1. You need to monitor only necessary indicators. Which indicator or indicators should you include in the baseline? (Choose all that apply.)

You need to cleanse and standardize the data on potential survey participants prior to inserting it into the staging database. What should you do?

You need to provide ad hoc reporting capabilities to fulfill business requirements. What should you do?

You are upgrading the database servers that are used by all of the companys applications. As the first step in the upgrade, you upgrade the development database servers. You need to verify that the upgrade of the database servers did not introduce any errors into the databases. What should you do?

You need to provide analyst reporting capabilities that fulfill the business requirements. What should you do?

You need to design the storage of the application texts for UI elements to fulfill the requirements. Which table and column design should you use?

You are designing the loan application process for the customer terminals. You need to design a Transact-SQL stored procedure that fulfills the business and technical requirements. Which type of Transact-SQL stored procedure should you use?

You need to design the retrieval of advertising statistics without compromising security. What should you do?

You need to design the storage of the loan response message. Which actions or actions should you perform? (Choose all that apply.)

You need to design the database permissions for access from the terminals to the database server. Which action or actions should you perform? (Choose all that apply.)