Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

70-431 MS certification exam simulation question Expand / Collapse
Author
Message
Posted Tuesday, September 15, 2009 1:05 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, May 28, 2012 4:06 AM
Points: 11, Visits: 69
Hi,
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 named
Production.vExpensiveExpiredProduct do not succeed. You confirm that the insert
statements that are being used are valid.
The only table that the view uses is named Production.ExpiredProduct. The table
has the following definition:
CREATE TABLE Production.ExpiredProduct {_
ExpiredProductIDINT IDENTITY CONSTRAINT PK_EXPIREProduct
PRIMARY KEY
Name NVARCHAR(50) NOT NULL
ListPrice MONEY NULL
}
You need to ensure that insert statements can be complete successfully. You need to
apply the fewest possible changes, and you must use SQL Server Management
Studio (SSMS).

2. A query against the Sales.SalesOrderDetail table is performing poorly. You must
create an index that will cause the cost of the query to be as low as possible. You
must minimize the space that is used by the index. The index must contain as few
columns 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 different
indexes 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 the
process that is associated with this transaction, and you must kill that process. You
must not kill any other processes.
You need to kill the process by using the Activity Monitor dialog how within SQL
Server Management Studio (SSMS).

4. You need to install a new SQL Server 2005 instance on a newly installed Windows
Server 20003 server named TestKing2. This new instance must have the same
settings 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 the
SQL Server agent service.
The default installation folder should be used for the new SLQ Server instance on
TestKing2. You will be able to refer to TestKing1 to view the settings to use._
You need to complete the installation wizard on TestKing2.
Post #787946
Posted Wednesday, September 16, 2009 7:25 AM
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Sunday, March 16, 2014 10:26 AM
Points: 536, Visits: 516
If u are looking at testking and all those resources for just passing the exam dont they also give u a cheat sheet with answers ??????????????????????
Post #788915
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse