70-432 Free Demo Questions and Answers

Test Information:

Total Questions: 206

Test Number: 70-432

Vendor Name: MICROSOFT

Cert Name:  MCTS

Test Name: TS :MS SQL Server@ 2008, Implementation and Maintenance

Official Site: http://www.examsboost.com

For More Details: http://www.examsboost.com/test/70-432/

Question: 1

 

Your workstation has installed Microsoft SQL Server Management Studio (SSMS), and not installed Microsoft Business Intelligence Development Studio (BIDS).

-You should design a package, which has the following features: -The package should be transactional. -The package should be optimized for 10 tables. -The package should be stored safely in the msdb database of a server which is remote.

Which is correct?

 

A. You should create the package by using DTS Designer.

B. You should create the package by using the Package Migration Wizard.

C. You should create the package by using the Microsoft SQL Server Import and Export Wizard.

D. On the Microsoft SQL Server 2005 Integration Services (SSIS) menu, you should click the Create Package submenu.

 

Answer: C    

 

Question: 2

 

You are mastering the company database called TesterDB; the database includes a database that uses SQL Server log shipping. Log shipping will happen half a hour. You should make the full backup.

In order to cut the net bandwidth utilization when maintenance every night.

Which is the correct answer?

 

A. You should set the database to utilize the bulk-logged recovery model.

B. You should reproduce only those indexes that ask it every night.

C. You should add the time during transaction log backups.

D. You should disable log shipping after the nightly maintenance.

 

Answer: B    

 

Question: 3

 

You are mastering the company database, Users complaints that the SQL Server 2008 application is running slowly. You should check the information of the CPU utilization, disk utilization, and memory utilization. The network should be considered. the detailed information should be checked for the proper example of SQL Server2008.Which is the correct answer?

 

A. You should check the proper dynamic management views (DMVs).

B. In the databases, you should check the distribution of the statistics which are hosted

C. You should check a statistics update command??s the output.

D. You should check the recovery model of the master database.

 

Answer: A    

 

Question: 4

 

You maintain a SQL Server 2008 instance that contains a database named Finance. The recovery model of the Finance database is set to Full.

The backup strategy for the Finance database is as shown in the following table.

The system databases, user database data, and log files are stored on separate disks. The hard disks that contain the user database data files are reported to have failed at 15:00 hours on Wednesday.

You need to restore the Finance database from the database backups by ensuring minimal data loss in minimum possible time.

What should you do?

 

A. Restore the full backup taken on Sunday. Restore the differential backup taken on Wednesday.

B. Back up the transaction log. Restore the full backup taken on Sunday. Restore all transaction log backups.

C. Restore the full backup taken on Sunday.

Restore the differential backup taken on Monday and Tuesday. Restore the transaction log backups taken at 08:00 hours and at 12:00 hours on Wednesday.

D. Back up the transaction log. Restore the full backup taken on Sunday. Restore the differential backup taken on Tuesday. Restore all transaction log backups taken during Wednesday

 

Answer: D    

 

Question: 5

 

You maintain a SQL Server 2008 instance that contains a database named Finance.

The Finance database contains the following filegroups:

The PRIMARY filegroup that contains the On-Line Transaction Processing (OLTP) data stored in the F: volume.

A filegroup named Histoiy that contains historical data stored in the G: volume.

The transaction log of the database is stored in the H: volume.

As part of the archiving strategy for the Finance database, data is frequently moved from the PRIMARY filegroup to the History filegroup.

The backup strategy for the Finance database consists of the following requirements:

Backing up the PRIMARY filegroup five times a day

Backing up the History filegroup at the end of each working day