70-432 Exam Questions

You are the administrator of a SQL Server 2008 instance. All the instances run on their independent server. The three instances are respectively named InstanceA, InstanceB, and Ins...

You are the administrator of a SQL Server 2008 instance with a database named DB1. In the Services schema there is a table named Service.Table. The Services.Table has to be moved f...

You are the administrator of a SQL Server 2008 instance with a database named DB1. which contains the following stored procedure. (Line numbers are useded for reference only.) 01 C...

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

You are the administrator of a SQL Server 2008 instance. You notice that the application has a poor performance. On the remote SQL Server instance, you capture a workload of the re...

You are the administrator of a SQL Server 2008 instance. According to the company requirement the names of all user-defined stored procedures must contain the prefix usp_ on all in...

You are the administrator of a SQL Server 2008 instance. There is a n On-Line Analytical Processing (OLAP) database named in the instance. The database contains a dimension table n...

You are the administrator of a SQL Server 2008 instance. There is a text file which is named SQL01.log on the E: drive. A SQL Server Agent job executes every 2 minutes and logs inf...

You are the administrator of a SQL Server 2008 instance. There is a database named DB1 in the instance. On DB1, quite few logged operations are performed. Now according to the requ...

You are the administrator of a SQL Server 2008 instance. According to the company requirement, the names of all user-defined stored procedures must contain the prefix usp_ on all i...

You are the administrator of a SQL Server 2008 instance. The company CIO wants you to configure FILESTREAM data and the two requirements below must be met: you must enable FILESTRE...

You are the administrator of a SQL 2008 instance. There is an Internet Information Services application. This application will use anonymous access to access the SSAS instance. You...

You are the administrator of a SQL Server 2008 with a named Instance01. Instance01 contains a database which is named Dworks. The bulk-logged recovery mode is used by the Dworks da...

You are the administrator of a SQL Server 2008 cluster. According to the company requirement, the failover response of the cluster has to be tested. The company assigns this task t...

You are the administrator of a SQL Server 2008 instance with a database named DB01. The company CIO wants all the application developers can capture traces to troubleshoot the appl...

You are the administrator of a SQL Server 2008 instance. You have to perform the backup of the default trace according to the requirement of your failure recovery plan. The default...

You are the administrator of a SQL Server 2008 instance. There is a database named DB1 in the instance. The backup strategy for DB1 has the following requirements: every day at 9:0...

You are the administrator of a SQL Server 2008 instance with a database named DB1 in the instance. At present about 90 GB of data is stored in DB1. You made some rough calculations...

You are the administrator of a SQL Server 2008 instance with a database named DB1. The latest differential backup is performed at 15:30, the full back up was performed at 13:30, an...

You are the administrator of a SQL Server 2008 instance. There is a database named DB1 in the instance. There are data file and the transaction log file on the E: drive. You find t...

You are the administrator of a SQL Server 2008 instance with a database named DB1. A backup of DB1 is performed every day. You have to minimize the size of the full database backup...

You are the administrator of a SQL Server 2008 instance with a database named DB1. When you are absent, a user will use a login named Mary to log in and maintain the database snaps...

You are the administrator of a SQL Server 2008 instance with a database named DB1 in the instance. The DB1 database includes spatial data types. On DB1 database, you have to perfor...

You are the administrator of a SQL Server 2008 instance containing a database named DB1. An application which is continuously connected uses DB1. The application extensively uses t...

You are the administrator of a SQL Server 2008 instance. You upgraded this instance to SQL Server 2008. You configure the Agent service to use the LocalSystem account. There is a f...

You are the administrator of a SQL Server 2008 instance. A user reports that when he runs a query, it takes a quite long time and it is still unfinished. As the IT support, you hav...

You are the administrator of a SQL Server 2008 instance with a database named DB1. You have set the recovery model of DB1 to Full. At 2:00 There is a full database backup of all th...

You are the administrator of a SQL Server 2008 instance. You get an order from your company CIO to identify whether a database integrity check (DBCC CHECKDB) was run for a particul...

You are the administrator of a SQL Server 2008 instance. Users report that they are unable to connect to the named instances. You check and verify that they can only connect to the...

You are the administrator of a SQL Server 2008 instance. There are user-defined stored procedures. You have to ensure two things. First the names of all user-defined stored procedu...

You are the administrator of a SQL Server 2008 instance. A new SQL Agent job has been created by you. The job includes a Windows PowerShell job step which transfer data between ser...

You are the administrator of a SQL Server 2008 instance. There is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should...

You are the administrator of a SQL Server 2008 instance which contains multiple Agent jobs. The jobs run each job on each day of the week by using seven shared schedules. You have...

You are a database developer for your company. You use the following Transact-SQL code. SELECT e.Resume,j.EmployeeID FROM JobCandidate j, Employee e WHERE j.EmployeeID =* e.Employe...

You are the administrator of a SQL Server 2008 instance. There is a management data warehouse that uses the data collector to collect performance data. You intend to maintain the m...

You are the administrator of a remote SQL Server 2008 instance. You notice that the application has a poor performance. On the remote SQL Server instance, you capture a workload of...

You are the administrator of a SQL Server 2008 instance. According to the company requirement, you have to move the application from Microsoft SQL Server 2000 to Microsoft SQL Serv...

You are the administrator of a SQL Server 2008 instance with a database named DB1. DB1 has two filegroups: one is a filegroup named History that contains historical data stored in...

You are the administrator of a SQL Server 2008 instance. Your company CIO assigns you a task. You have to check the performance of the SQL Server 2008 instance. You have to find ou...

You are a database developer for your company. You are developing a sales report for a given time period. The report must list all sales representatives and their position based on...

You are the administrator of a SQL Server 2008 instance which hosts several applications in your company. A job named DeliveryList is created by you. This job requires a file to be...

You are the administrator of a SQL Server 2008 instance with a database named DB1. On DB1, quite a few logged operations are performed. Now according to the requirement of the comp...

You are the administrator of a SQL Server 2008 instance. There is a SQL Server 7.0 database. You upgrade the database to the SQL Server instance. According to the company requireme...

You are a database developer for your company. You are developing a stored procedure that must accept a parameter of the xml data type and store the data in a relational table stru...

You are the administrator of a SQL Server 2008 instance. You configure the SQL Server instance to use the -T1222 and -T1204 trace flags during startup. You have to make sure that y...

You are the administrator in charge of two instances both of which run on the same computer. One is a SQL Server 2008 instance; another is a SQL Server 2005 instance. There is a da...

You are the administrator of a SQL Server 2008 instance. You make sure that all SQL Server instances are consistently configured for naming conventions, security settings, force in...

You are the administrator of a SQL Server 2008 instance with a database named Dworks. The Dworks database has a table named Orderthings. The Orderthings table is partitioned on the...

You are the administrator of a SQL Server 2008 instance with a database named Dworks. You get a report from users saying that DB1 meets deadlock problems. As the technical support,...

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