Online Access Free 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.
- Allow remote client computers to have streaming access to FILESTREAM data.
You need to ensure that FILESTREAM data is enabled.
What should you do?

• A.Configure the SQL Server service.
• B.Configure the SQL Server Full Text service.
• C.Modify the Background Intelligent Transfer Service settings.
• D.Modify the Volume Shadow Copy settings.

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?

• A.Create mirroring endpoints on both partner servers.
  Use Microsoft SQL Server Management Studio on both partner servers to select the High Performance option, and start mirroring.
• B.Create mirroring endpoints on both partner servers.
  Use the ALTER ENDPOINT statement along with the ENCRYPTION=DISABLED clause.
• C.Create mirroring endpoints on both partner servers.
  Execute the following stored procedure: Sp_configure 'Lightweight Pooling', 1
• D.Create mirroring endpoints on both partner servers.
  On the principal server, use the ALTER DATABASE statement along with the PARTNER SAFETY OFF clause.

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 installation completed with \a: ures.1
You close the error window before noting the location where additional information about the error is recorded.
You need to locate the additional information.
Where should you search?

• A.The Event Viewer System log file
• B.The Event Viewer Application log file
• C.The C:\Program Files\Microsoft SQL Server\MSSQL\LOG folder
• D.The C:\Program Files\Microsoft SQL Server\100\Setup Bootstrap\Log\ folder

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

You have a server that contains a default SQL Server 2005 instance. You need to install a SQL Server 2008 instance for a new application on the same server. The new application requires SQL Server 2008 functionality.
You need to ensure that both database instances are available for their respective certified third-party applications. The existing application environments remain unchanged.
What should you do?

• A.Upgrade the SQL Server 2005 application to use SQL Server 2008.
• B.Install SQL Server 2008 as the default instance.
• C.Upgrade the SQL Server 2005 instance to a SQL Server 2008 instance.
• D.Install SQL Server 2008 as a named instance.