Try and practice the latest Microsoft : 70-432 real questions & answers

Microsoft 70-432 Exam Overview:

Microsoft 70-432 Exam Syllabus Topics:

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

Question 1

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 contains no indexes.

You need to partition the table by year.
What should you do?

A. Create a new table.
Use the ALTER TABLE statement along with the SWITCH PARTITION clause.
Use the ALTER PARTITION FUNCTION statement along with the MERGE RANGE clause.
B. Run the following statement: CREATE PARTITION SCHEME SEC_FG AS PARTITION FUNC_FG
ALL TO (SECONDARY);
C. Create a new filegroup.
Create a new database file.
Use the ALTER PARTITION SCHEME statement along with the NEXT USED clause.
Use ALTER INDEX REORGANIZE statement.
D. Create a new Filegroup.
Create a new database File.
Use the ALTER PARTITION SCHEME statement along with the NEXT USED clause.
Use the ALTER PARTITION FUNCTION statement along with the SPLIT RANGE clause.
E. Execute the DBCC CLEANTABLEcommand on the OrderItems table.
F. Run the following statement: EXECUTE sp_tableoption @TableNamePattern ='OrderItem3', @OptionName= 'PartltionByYear'; @OptionValue= 'true';
G. Create a new partition function.
Create a new partition scheme.
Add a clustered index to place the data onto the partition scheme.
H. Use the ALTER TABLEstatement to remove the COLLATEoption.
I. Use the ALTER PARTITION FUNCTION ... SPLIT RANGE statement.
J. Remove the clustered index from the table.

Question 2

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 SYS_CHECK (SalesDB);
B. DBCC SQLPERF (SalesDB);
C. DBCC RSPAIRDB (SalesDB);
D. DBCC CHECKDB (SalesDB);

Question 3

You administer a remote SQL Server 2008 instance that contains a database named InsightDB. The InsightDB database is used by an application that is continuously connected.
The application uses the INSERT command extensively and triggers the population of multiple tables.
Users of the application report that the application performance is poor. You suspect that the performance issues are related to blocking.
You need to monitor the state of the instance at regular intervals without affecting the application performance further.
Which tool should you use?

A. SQL Server Resource Governor
B. Windows System Monitor
C. SQL Server Profiler
D. Dynamic Management Views

Question 4

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 instance. According to the company requirement, the names of all user-defined stored procedures must contain the prefix usp_on all instances. Besides this, you must make sure that stored procedures that do not contain this prefix cannot be created by you. What should you do?

A. A condition should be created. The condition targets the name of stored procedure that is evaluated on demand.
B. A policy should be created. The policy targets the name of the stored procedure that is evaluated on demand.
C. A condition should be created. The condition targets the name of the stored procedure that is evaluated on change
D. A policy should be created. The policy targets the name of the stored procedure that is evaluated on change.

Question 5

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 that owns only 10 percent useful space. You should make sure that you move both files to the G: drive.
Which is the correct answer?

A. ALTER DATABASE TesterDB SET OFFLINE WITH ROLLBACK_IMMEDIATE;
B. You should utilize the following Transact-SQL statement.
C. ALTER DATABASE TesterDB
D. mdf'); ALTER DATABASE Finance SET MULTI_USER;
E. You should implement the statement below: ALTER DATABASE Finance SET RESTRICTED_USER WITH ROLLBACK_IMMEDIATE; Move the data file and
F. mdf'); ldf'); ALTER DATABASE TesterDB SET ONLINE;
G. Run the following Transact-SQL statements. ALTER DATABASE Finance MODIFY FILE(NAME = Finance_Data, FILENAME =

Solutions: