70-432 Exam Questions

You maintain a default SQL Server 2008 instance. You plan to configure FILESTREAM data to meet the following requirements: - Enable FILESTREAM for file I/O streaming access. - Allo...

You configure a SQL Server 2008 instance that contains a database named Customers. The Customers database experiences deadlock problems. You need to capture the deadlock informatio...

You plan to install a SQL Server 2008 instance for a new application on an existing server that contains a default SQL Server 2005 instance. You need to ensure that both database i...

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 j...

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 j...

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 j...

You administer a Microsoft SQL Server 2008 R2 database that contains a schema named Reporting. The Reporting schema contains store procedures, tables, and views. Stored procedures...

You are reviewing and configuring the security of a SQL Server 2008 instance that contains database DB1. The security audit policy specifies the following requirements: - Only succ...

You administer a SQL Server 2008 instance. A user named Julie reports repeated failed connections because of incorrect password usage for the login name srpc8521. Julie has been ab...

You maintain a SQL Server 2008 instance that contains a database named Finance. You need to configure SQL Server to automatically send an e-mail message when any file in the Financ...

You maintain multiple SQL Server 2008 instances. You develop a failure recovery strategy. You need to find out the edition and the build of SQL Server that is deployed in your envi...

You administer a Microsoft SQL Server 2008 instance that contains two databases named Work and WorkHistory. Work uses the Latin1_General_CS_AS collation. WorkHistory uses the Latin...

You administer a Microsoft SQL Server 2008 R2 instance. Mirroring has been configured between two servers. You need to ensure that automatic failover will occur when the principal...

You maintain a SQL Server 2008 instance. You discover that the database named CityPowerLightDB presents data integrity problems. You perform a full database backup at 22:00 hours....

You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems table. The table has the following definition: Currently, the table is partitioned by year with e...

You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems table. The table has the following definition: Currently, the table is partitioned by year with e...

You maintain a SQL Server 2008 instance. You use SQL Server Database Mail to distribute multiple reports that are scheduled and generated every night. You need to enforce a mail re...

You troubleshoot a SQL Server 2008 instance. You suspect that an application uses an inefficient locking strategy and causes concurrency problems. You need to identify the followin...

You administer a SQL Server 2008 instance that contains a very large database named FinanceDB. You plan to create a maintenance plan that meets the following objectives for the Fin...

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 dat...

You administer a SQL Server 2008 instance. You need to identify the network protocol used by the current connection. What should you do?

You administer a Microsoft SQL Server 2008 R2 database that hosts an order-processing application. You need to ensure that the database allows full-text searches on the Customers t...

You install a 64-bit version of a SQL Server 2008 instance by using the default setup and configuration settings. You receive the following error message: "Your SQL Server installa...

You administer a SQL Server 2008 instance that contains a database named AdventureWorks. You plan to use data compression to conserve disk space. You compress a table named VeryLar...

You administer a SQL Server 2008 instance that contains a database named Sales. The Sales database contains a table named Customers that has a column named CompanyName. The current...

You maintain a SQL Server 2008 instance that contains a database named CustomerDB. The CustomerDB database stores customer data for the company. The customers use a Web application...

You administer a Microsoft SQL Server 2008 R2 database. You configure the disk drives according to the following table: You discover that the Windows application log is being fille...

You administer a SQL Server 2008 instance named SQL1. SQL1 contains a database named DB1. You create a new user named User1 in the DB1 database. No additional permissions have been...

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

You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems table. The table has the following definition: Data is grouped into quarterly partitions. You nee...

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 j...

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 j...

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 j...

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 j...

You administer a Microsoft SQL Server 2008 R2 instance. You need to configure mirroring between two servers in high-performance mode. What should you do?

You administer a Microsoft SQL Server 2008 R2 database instance. You need to identify queries or stored procedures that are consuming server resources. You also need to view the qu...

You administer a Microsoft SQL Server database. You plan to deploy a new database application. You want to use SQL Server common language runtime (CLR) integration. You need to ens...

You administer a Microsoft SQL Server database that hosts an order-processing application. Employees in the order entry group perform real-time data entry for customers. Employees...

You administer a SQL Server 2008 instance. A database developer named User1 needs to view the definitions of all database objects in a database and read data from all user-defined...

You administer a database for an online ordering system. You plan to create a disaster recovery plan that uses transaction log backups by using only Microsoft SQL Server native too...

You administer a Microsoft SQL Server 2008 R2 instance. The database has been marked as suspect. You need to place the database into an EMERGENCY state for troubleshooting. What sh...

You administer a Microsoft SQL Server 2008 R2 instance. A disk drive that contains the files for the database is lost. The drive has been replaced, but the data files have been irr...

You administer a Microsoft SQL Server 2008 R2 instance. You need to ensure that no suspect pages have been detected in your database. What should you do?

You maintain a SQL Server 2008 instance that contains a database named Finance. You suspect that three large tables in the Finance database are corrupt. You plan to execute the DBC...

You administer a Microsoft SQL Server 2008 R2 database instance. You plan to automate maintenance tasks. What task types are included in a SQL Maintenance Plan? (Choose all that ap...

You administer a SQL Server 2008 instance that contains a database named InsightDB. The InsightDB database is used by an application that is continuously connected. The application...

You manage two SQL Server 2008 instances on separate servers named Server1 and Server2. The servers are located in different cities. You plan to implement database mirroring betwee...

You maintain a SQL Server 2008 instance. You use the Resource Governor to manage processor resources on the server for a newly deployed application named App1. App1 is assigned to...

You administer a Microsoft SQL Server 2008 R2 instance that contains two databases named Northwind2008R2 and AdventureWorks. The Northwind2008R2 database uses the SQL_Latin1_Genera...

You administer a Microsoft SQL Server 2008 R2 instance. You need to attach a database named Northwind to the server. Which Transact-SQL command should you use?