Purchase & study exam preparing with 70-432 pass-king quiz training materials

Microsoft 70-432 Exam Overview:

Microsoft 70-432 Exam Syllabus Topics:

Microsoft TS:MS SQL Server 2008,Implementation and Maintenance Sample Questions:

1. You maintain a SQL Server 2008 instance.
You plan to deploy an instance of SQL Server Reporting Services (SSRS) to the same machine.
You need to ensure that by default. SSRS maintains version histories of all deployed reports.
What should you do?

A) Install the SSRS instance by using the http.sys listener.
B) Configure the SSRS database to use SharePoint integrated mode.
C) Install the SSRS instance by using the Internet Information Services default Web site.
D) Configure the SSRS database to use Native mode.

2. DRAG DROP
You install a Microsoft SQL Server 2008 R2 instance that uses default settings.
You want to add a storage area network (SAN) array. The SAN has two mapped drives: D
and L.
You need to ensure that all new databases meet the following requirements:
- Data files are stored on drive D in the SQLData folder. - Log Files are stored on drive L in the SQLLogs folder.
Which three actions should you perform in sequence? (To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.)

3. You administer a Microsoft SQL Server 2008 R2 instance. The instance has a database named CustomerOrders.
The database is backed up by using the weekly scheduled SQL Server Agent jobs. The backup schedule is shown in the following table:

A drive fails and the CustomerOrders database goes into suspect mode on Sunday at
09:00 hours.
You need to restore the backup.
What should you do?

A) Restore the backup taken on Wednesday only.
B) Restore the backups taken on Sunday and Monday.
C) Restore the backups taken on Wednesday and Thursday at 09:00 hours.
D) Restore the backups taken Wednesday, Friday, and Saturday.
E) Restore the backups taken on Wednesday and Friday.
F) Restore the backup taken on Sunday only.
G) Restore the backups taken on Wednesday, Thursday, and Friday.
H) Restore the backups taken on Wednesday, Thursday at 09:00 hours, and Thursday at
18:00
hours.

4. You design a maintenance plan for a SQL Server 2008 instance that contains a database named SalesDB.
The SalesDB database includes spatial indexes to support queries on spatial data.
You need to perform physical consistency checks on SalesDB. You also need to ensure that the performance effect on the SalesDB database is minimized.
Which Transact-SQL statement should you execute?

A) DBCC RSPAIRDB (SalesDB);
B) DBCC SYS_CHECK (SalesDB);
C) DBCC CHECKDB (SalesDB);
D) DBCC SQLPERF (SalesDB);

5. You administer a SQL Server 2008 instance that has TCP/IP enabled.
You need to verify the port that the SQL Server instance listens on.
What should you do?

A) Open SQL Server Configuration Manager
Expand the SQL Server Network Configuration service. Select the Protocols for (InstanceName) service.
In the right panel, right-click TCP/IP, select the Properties option, and then select the IP Addresses tab.
B) Open SQL Server Configuration Manager
Select the SQL Server Services service.
In the right panel, right-click SQL Server (InstanceName), right-click Properties, and then select the Advanced tab.
C) Open SQL Server Configuration Manager
Select the SQL Server Services service.
In the right panel, right-click SQL Server Browser, right-click Properties, and then select the Advanced tab.
D) Open SQL Server Configuration Manager
Expand the SQL Native Client 10.0 Configuration service.
Select the Client Protocols service. Select the Properties option.

Solutions: