TS: Microsoft SQL Server 2008,
Version: TS: Microsoft SQL Server 2008, Implementation and Maintenance
Microsoft 70-432 Exam QUESTION NO: 1 You work as a database administrator at ABC.com. You have just installed Microsoft SQL Server Management Studio on one of ABC.com’s workstations and the Microsoft Business Intelligence Development Studio. You have been requested to design a 12 table transactional package to be stored on an offsite server’s msdb data store. You decide that BIDS in this scenario is an overkill and you decide to uninstall it. What utility should you run to create the requested package? A. Use the bulk copy program. B. Use the DTS Designer. C. Use the Microsoft SQL Server Import and Export Wizard. D. Use Process Control Tool. E. Use the Package Migration Wizard. F. Use the Process Control Tool G. Use the ISIS. Answer: C Explanation:
QUESTION NO: 2 DRAG DROP You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 instance that contains a database named ABC_DB1. As part of your backup method of ABC_DB1, you do a Full backup every Sunday at 01:00, you do a differential backup weekdays at 22:00, and you do transactional log backup weekdays at 08:00; 12:00 and 16:00. You have received notification that the user database data files have failed on Thursday at 15:00. You need to ensure that ABC_DB1 are retrieve as quickly as possible with as small as possible amount of data loss. What steps should you take? Use only steps that apply.
"Pass Any Exam. Any Time." - www.actualtests.com
2
Microsoft 70-432 Exam
Answer:
"Pass Any Exam. Any Time." - www.actualtests.com
3
Microsoft 70-432 Exam
Explanation:
"Pass Any Exam. Any Time." - www.actualtests.com
4
Microsoft 70-432 Exam
QUESTION NO: 3 DRAG DROP You work as a database administrator at ABC.com. ABC.com is using a SQL Server 2008 instance that contains a database named ABC_Prod. During the night a daily full backup of