InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comFri, 24 May 2013 12:37:39 GMT20http://www.sqlservercentral.com/Forums/Topic787946-148-1.aspxIf u are looking at testking and all those resources for just passing the exam dont they also give u a cheat sheet with answers ??????????????????????:-DWed, 16 Sep 2009 07:25:30 GMTvishal.gamjihttp://www.sqlservercentral.com/Forums/Topic787946-148-1.aspxHi,I have some question which I faced in my 70-431 exam in simulation question.I tried a lot but I did not got a clue to solve these problem.If someone already cleared this exam then (s)he may faced these questions. Can anyone please give me some hint on these questions?1. Users report that insert statements against the view namedProduction.vExpensiveExpiredProduct do not succeed. You confirm that the insertstatements that are being used are valid.The only table that the view uses is named Production.ExpiredProduct. The tablehas the following definition:CREATE TABLE Production.ExpiredProduct {_ExpiredProductIDINT IDENTITY CONSTRAINT PK_EXPIREProductPRIMARY KEYName NVARCHAR(50) NOT NULLListPrice MONEY NULL}You need to ensure that insert statements can be complete successfully. You need toapply the fewest possible changes, and you must use SQL Server ManagementStudio (SSMS).2. A query against the Sales.SalesOrderDetail table is performing poorly. You mustcreate an index that will cause the cost of the query to be as low as possible. Youmust minimize the space that is used by the index. The index must contain as fewcolumns as possible._There is an existing clustered index on the table. This index must not be dropped.Because the table is on a production server, it is not possible to create differentindexes and test their performance.You need to create the required indexes by using the New Index dialog box.3. There is an uncommitted transaction in the TestKing database. Yóu must find theprocess that is associated with this transaction, and you must kill that process. Youmust not kill any other processes.You need to kill the process by using the Activity Monitor dialog how within SQLServer Management Studio (SSMS).4. You need to install a new SQL Server 2005 instance on a newly installed WindowsServer 20003 server named TestKing2. This new instance must have the samesettings as the existing SQL Server 2005 instance on a server named TestKing1.The only two services that need to be installed are the SQL Server service and theSQL Server agent service.The default installation folder should be used for the new SLQ Server instance onTestKing2. You will be able to refer to TestKing1 to view the settings to use._You need to complete the installation wizard on TestKing2.Tue, 15 Sep 2009 01:05:27 GMTraj4582