Free Microsoft 70-432 Exam Dumps Questions & Answers

You administer a SQL Server 2008 instance that contains a database named AdventureWorks. The AdventureWorks database contains a table named Orders. The Orders table has several indexes and a very large number of rows. The database supports an enterprise Web environment that is constantly used.
Thirty percent of the indexes on the Orders table is fragmented.
You need to defragment the indexes by ensuring that the effect on database availability is minimized.
Which option should you include in the ALTER INDEX statement?

• A.  Pad index
• B.  Sort in tempdb
• C.  Online
• D.  Fill factor

You administer a Microsoft SQL Server 2008 R2 database that contains an OrderItems table. The table has the following definition:

The following DDL has been run on the database:
CREATE PARTITION FUNCTION FUNC_FG (INT)
AS RANGE LEFT FOR VALUES (1, 100, 1000);
You need to create a partition scheme that will place all data to the SECONDARY filegroup.
What should you do?

• A.  Run the following statement:
  CREATE PARTITION SCHEME SEC_FG
  AS PARTITION FUNC_FG
  ALL TO (SECONDARY);
• B.  Use the ALTER PARTITION FUNCTION ... SPLIT RANGE statement.
• 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.  Use the ALTER TABLEstatement to remove the COLLATEoption.
• E.  Run the following statement:
  EXECUTE sp_tableoption
  @TableNamePattern ='OrderItem3',
  @OptionName= 'PartltionByYear';
  @OptionValue= 'true';
• F.  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.
• G.  Execute the DBCC CLEANTABLEcommand on the OrderItems table.
• H.  Create a new partition function.
  Create a new partition scheme.
  Add a clustered index to place the data onto the partition scheme.
• I.  Remove the clustered index from the table.
• J.  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.

You administer a Microsoft SQL Server 2008 R2 instance that contains two databases named Northwind2008R2 and AdventureWorks. The Northwind2008R2 database uses the SQL_Latin1_General_CP1_CI_AS collation and the AdventureWorks database uses the SQL_Latin1_General_CP1_CS_AS collation.
You need to write a query that returns all customers having the same name in each database. You also need to ensure that the query is not case-sensitive.
Which Transact-SQL query should you use?

• A.  Option B
• B.  Option A
• C.  Option D
• D.  Option C

You administer a SQL Server 2008 instance and a SQL Server 2005 instance. Both instances run on the same computer. The SQL Server 2008 instance contains a database named WebApplicationDB that uses the Fulltext indexes.
Several records that include the word "root" are added to the WebApplicationDB database. When the Fulltext index is queried for the word "root," an empty resultset is returned.
You need to ensure that records that contain the word "root" are returned by the query.
What should you do?

• A.  Rebuild the full-text index.
• B.  Stop and restart the MSFTESQL service.
• C.  Add the word "root" to the thesaurus file.
• D.  Add the word "root" to the stop list.

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 utilization, and memory utilization. The network should be considered. the detailed information should be checked for the proper example of SQL Server2008.Which is the correct answer?

• A.  You should check the recovery model of the master database.
• B.  In the databases, you should check the distribution of the statistics which are hosted
• C.  You should check the proper dynamic management views (DMVs).
• D.  You should check a statistics update command??s the output.