70-431 MS certification exam Simulation questions

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

70-431 MS certification exam Simulation questions

Author

Topic

raj4582
Starting Member

16 Posts

Posted - 2009-09-15 : 03:00:46

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.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2009-09-15 : 04:39:32

If you don't know how to do these 4 things, you really shouldn't be sitting 70-431.

These questions are designed for the purpose of ensuring those sitting the exam have the required experience with the product and aren't just cramming or using braindump sites only.

I would suggest that you learn to use SQL for a year or two before sitting the exams.

raj4582
Starting Member

16 Posts

Posted - 2009-09-15 : 05:04:28

I am assuming for first question as I remember there was a instead of trigger in view "Production.vExpensiveExpiredProduct". this view did not have insert statement.
So I think that trigger should be deleted. in exam i was confused because i was trying to Disable it but there was no option for disabling the trigger.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources