70-432 Exam Questions

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?

You have a server that contains a default SQL Server 2005 instance. You need to install a SQL Server 2008 instance for a new application on the same server. The new application req...

You administer three SQL Server 2008 instances on separate servers named Server1, Server2, and Server3. The AdventureWorks database is configured for mirroring between the instance...

You administer two SQL Server 2008 instances on separate servers named Server1 and Server2. The AdventureWorks database is set up for synchronous mirroring between the two instance...

You administer a Microsoft SQL Server 2008 R2 instance. You need to check the physical consistency of the database. What should you do?

You administer a Microsoft SQL Server 2008 R2 instance. You need to rectify a damaged index without losing any data. What should you do?

You administer a SQL Server 2008 instance that contains a database named DB1. DB1 contains a table named Sales.Table1. You need to obtain the effective permissions of a user named...

You administer a SQL Server 2008 instance. A payroll application is used to store sensitive data in a database named PayrollDB. You plan to implement the following security measure...

You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems table. The table has the following definition: Currently, the table is not partitioned and contai...