70-432 Exam Questions

You are the administrator of a SQL Server 2008 instance with a database named named Dworks. The table below shows the two tables of the Dworks database: There are two partitions in...

You are the administrator of a SQL Server 2008 instance. The company wants to export data from SQL Server to a Microsoft Excel file. The company assigns this task to you. You perfo...

You are the administrator of a SQL Server 2008 instance with a database named named Dworks. The Dworks database contains a table named BillDetails which has a clustered primary key...

You are the administrator of a SQL Server 2008 instance with a database named DB1. According to the requirements of the security audit policy only successful and failed logon attem...

You are the administrator of a SQL Server 2008 instance which uses mixed authentication mode. The instance runs on a computer which has Windows Server 2003 installed. You have to m...

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

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

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

You maintain an instance of Microsoft SQL Server 2008. The instance contains a database named Finance. The recovery model of the Finance database is set to Full. A full database ba...

You are mastering the company database, and managing 20 SQL Server 2005 computers which are operated by other administrators that are asked to meet company service level agreements...

You are managing a SQL Server 2008 instance which includes some applications for Home.com. You set the SQL Server Agent service to implement through utilizing the SerTest\Test acco...

You administer a SQL Server 2008 instance. The instance contains a database named DB1. You plan to allow all the application developers to use SQL Server Profiler to capture traces...

You are a database administrator for your company. The company uses a SQL Server 2008 database that includes a table named Inventory. The table contains a column named Price. A com...

You maintain a SQL Server 2008 instance that contains a database named DB1. DB1 stores customer data for the company. The customers use a Web application to access their profile da...

You administer a SQL Server 2008 instance that contains a database named DB1. A table named Sales.Table1 exists in the Sales schema. You need to move the Sales.Table1 table to a ne...

You are a database administrator for your company. There are four automated testing areas for finished items in the company's manufacturing floor. SQL Server 2008 is used to reserv...

You administer a SQL Server 2008 instance that contains a database named DB1. The DB1 database contains the following stored procedure. (Line numbers are included for reference onl...

You are managing a SQL Server 2008 instance for Home.com. You use a Microsoft SQL Server 2008 Analysis Services (SSAS) instance. A data mining structure should be deployed which co...

You are mastering the company database, including the SQL Server 2005 database which include a table called Production. Product. The table has more than 50 columns The most common...

You are mastering the company database, with SQL Server 2008 computer named SQLTEST1 The master database on SQLTEST1 is down. Some SQL Server Agent jobs should be included in the S...

You are mastering the company database; a new SQL Server 2008 computer named TesterDB should be set by yourself. Reporting Services will work in TesterDB. It should be set to run d...

You are mastering the company database called Testing; you should back up the Testing database fully. You do transaction log once every two hours from 08:00 to 17:00. You should ru...

You are mastering the company database, you should check the log of the SQL Server 2008 Enterprise Edition everyday, and you get the information on the torn page errors of the data...

You administer a SQL Server 2008 instance. The instance contains various SQL Server Agent jobs that use seven shared schedules to run each job on each day of the week. You need to...

You administer a SQL Server 2008 instance. You have a stored procedure that implements a database maintenance process. You need to create a SQL Server Agent job that runs the store...

You maintain a SQL Server 2008 instance that contains a database named Finance. The data file and the transaction log file are located on the E: drive. The E: drive has only 5 perc...

You are mastering the company database, with SQL Server 2008 computer named SQLDB. The function of the SQLDB is to perform transaction log backups and so on. SQL1 should be reset b...

You are mastering the company database, On a SQL Server 2008, you find out that one of the data files computer is broken. You should reserve the database which is from the most rec...

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

You maintain a SQL Server 2008 instance. You find a SQL Server Agent job is failing. When you review the job history information, you notice that the job history information is inc...

You administer a SQL Server 2008 instance that contains a database named SpatialDB. The SpatialDB database includes spatial data types. You need to perform a database consistency c...

You are mastering the company database; there is the transaction information which is for company's Web-based order system in the database of the company. The database is set to ut...

You are managing two SQL Server 2008 computers called SQLTEST1 and SQTEST2, which include a copy of a database named Sales. The database is replicated between SQL1 and SQL2 by usin...

You maintain a SQL Server 2008 Enterprise Edition instance that contains a database named Finance. You need to reduce the size of the full database backup files of the Finance data...

You are managing a SQL Server 2008 instance which includes a database called TesterDB for Home.com. The data file and the transaction log file which are located on the D: drive tha...

You are managing your company database. You manage a SQL Server 2005 database called ContractTEST, which is down. You operate a restore by using the following Transact-SQL script....

Yon maintain a SQL Server 2008 instance that contains a database named Finance. The backup strategy for the Finance database specifies the following requirements: - Full database b...

You are managing a SQL Server 2008 computer called SQLTEST1. You should configure the SQL Server service and the SQL Server Agent service to start automatically, and set SQLTEST1 t...

You are managing two SQL Server 2008 computers called SQLTEST1 and SQTEST2, which include a copy of a database named Sales. The database is replicated between SQL1 and SQL2 by usin...

You are mastering the company database; you should use the SQL Server 2005 database which enables business users to operate both ad hoc and predefined searches. You doubt that some...

You administer a SQL Server 2008 instance that contains a database named Sales. A SQL Server login named SalesAppLogin maps to a database user named SalesAppUser in the Sales datab...

You are mastering the company database, with a SQL Server 2008 computer called SQLTEST1. There are three examples of SQL Server in the SQLTEST1. The ability to connect to the dedic...

You are mastering the company database. During the development, you find that Transact- SQL query below is running slowly: SELECT VideoTitle, UpcNum, RetailPrice, Release Date FROM...

You are mastering the company database; there are 15 retail stores in your company. On its own SQL Server 2008 computer, every retail store keeps transactions of point-of-sale in a...

You are mastering the company database, You should check the log of the a SQL Server 2005 Enterprise Edition everyday, You get the information on the torn page errors of the databa...

You are the administrator of a Microsoft Windows Server 2003 computer. Your company purchases a new enterprise sales application that runs SQL Server 2008. The application uses sto...

You work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 i...

You maintain a SQL Server 2008 instance. You have an existing database maintenance plan that performs the following tasks: - Rebuilds indexes. - Checks database integrity. - Writes...

You administer two SQL Server 2008 instances named Instance1 and Instance2. A database named Customers resides on Instance1. You move the Customers database from Instance1 to Insta...

You administer a SQL Server 2008 instance. You configure a single Database Mail profile that is used to send reports to all the employees of your organization. The sp_send_dbmail s...