TestInside 70-442 Exam 70-442 dumps Real Microsoft 70-442 Practice exam 70-442 Testing Engine - TestInside

70-442 Exam

PRO:Design & Optimize Data Access by Using MS SQL Serv 2005

  • Exam Number/Code : 70-442
  • Exam Name : PRO:Design & Optimize Data Access by Using MS SQL Serv 2005
  • Questions and Answers : 110 Q&As
  • Update Time: 2011-02-02
  • Price: $ 119.00 $ 69.00

Free 70-442 Demo Download

TestInside offers free demo for Microsoft Licensing 70-442 exam (PRO:Design & Optimize Data Access by Using MS SQL Serv 2005). You can check out the interface, question quality and usability of our practice exams before you decide to buy it. We are the only one site can offer demo for almost all products.

 

Microsoft Microsoft Licensing 70-442 exam braindumps questions and answers

¡¡
¡¡
Exam : Microsoft 70-442
Title : PRO:Design & Optimize Data Access by Using MS SQL Serv 2005


1. You need to design the transfer of sales data to the Accounting database. You are designing the stored procedure that will be used to transfer the data. You must ensure that all requirements are fulfilled. Which Transact-SQL statement should you use first?
A. BEGIN TRANSACTION Acct WITH MARK 'Accounting'
B. BEGIN DISTRIBUTED TRANSACTION Acct
C. SET IMPLICIT_TRANSACTIONS ON
D. SAVE TRANSACTION Acct
Answer: A

2. You design the following stored procedure that will be used by sales managers.
CREATE PROCEDURE StoreSales (@StartDate datetime, @EndDate datetime)
AS
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE
SELECT StoreID, TotalSales
FROM Sales
WHERE SaleDate BETWEEN @StartDate AND @EndDate
While tuning the query, you notice that table locks are occurring. You need to resolve the problem. What should you do?
A. Change the isolation level to READ COMMITTED.
B. Add a HOLDLOCK table hint to the query.
C. Add a NOWAIT table hint to the query.
D. Add a READPAST table hint to the query.
Answer: A

3. You need to design the data access method for accessing the SQL Server 2005 computer. You must ensure that your solution supports the Web site and the smart client application. Which data access technology should you use?
A. SqlXmlCommand
B. updategrams
C. XML template queries
D. HTTP endpoints
Answer: D

4. You need to design the data access strategy for the Tailspin Toys online store search requirement. Which strategy should you use?
A. System.Xml.XmlReader
B. System.Data.SqlClient.SqlDataReader
C. System.Data.DataSet
D. CLR user-defined type
Answer: C

5. You are designing a stored procedure that records a sale and decreases the inventory for the items that are being purchased. The stored procedure contains the following code.
CREATE PROCEDURE UpdateSalesAndInventory (@ProductID int, @quantity int)
AS
SET IMPLICIT_TRANSACTION ON
INSERT INTO Sales.SalesOrder Values(@ProductID, @quantity)
UPDATE Inventory.ProductInventory
SET Quantity = Quantity - @quantity
WHERE ProductID = @ProductID
You run this stored procedure and discover that no updates are applied. You need to resolve the problem. What should you do?
A. Change SET IMPLICIT_TRANSACTION to OFF.
B. Use multiple active result sets (MARS) to execute the stored procedure.
C. Add logic to commit or roll back the transaction based on the successful updates of the data.
D. Add a BEGIN TRANSACTION statement to the stored procedure.
Answer: C

6. BACKGROUND
Company Overview
Margie's Travel is a small regional travel agency that handles many different types of travel arrangements.
Planned Change
Margie's Travel has purchased a COM component named Cruisex to be used to access cruise lines information.
Margie's Travel hosts the component in COM+.Cruisex will be used for two purposes:to retrieve a read-only list of available cruises,and to make reservations on cruises.Cruisex uses all default settings.
Problem Statements
Many of the company's in-house travel agents that the Web site that is used for making travel reservations
is too difficult to use. The company wants to create a smart client application that will deliver a richer client experience for the agents. The solution must support the Web site application for off-site travel agents.
A monthly agent-commission report has been created. This report will be executed once per month.This report currently uses a cursor with the INSENSITIVE argument.The test team reports that this report runs slowly and consumes a significant amount of database server resources.
A stored procedure named UpdateSeatSelection is used to update seat selections for airline reservations.
The test team reports that there is significant blocking when this stored procedure is being executed.
EXISTING ENVIRONMENT
Existing Supporing Infrastructure
The current travel agent application stores its data in a SQL Server 2005 database.
BUSINESS REQUIREMENTS
General Application Solution Requirements
The duplication of application logic must be minimized.
After an airline reservation is made,the aqent must help the customer with seat selection. The seat selection process should not block the application from performing other reservation tasks.However,the agent must have the ability to cancel a seat selection query prior to its completion.The application must receive a reply that cancellatio was successful.
A report named FlightsBooked is being developed.The test team reports that executing the report twice within a single transaction using the same parameters occasionally produces different results. However,subsequnt executions with those same parameters produce consistent results.
A feature must be developed that will allow travel agents to seach for customers by name of partial name.The data that is returned must not include any data that is not yet committed.
Performance
To improve performance for the data access layer,the number of round trips to the database must be limited,particularly for data that changes only infrequently.
Infrequent changes are made to the information about trading partners such as airlines,cruise lines,and hotel chains.Margie's Travel wants to limit the bandwidth that is required to ensure that the smart client application has the current values for trading partners .The company wants to mininize the development effort that is needed to support this requirement.
When an agent queries for available fight information,the data must be returned as quickly as possible.This data will not be modified by the agent.
A monthly agent-commission report has been created.This report will be executed once per month.This report currently uses a cursor with the INSENSITIVE argument.The test team reports that this report runs slowly and consumes a significant amount of database server reslurces.
Recoverability
Once per month,all sales data must be transferred to the Accounting database,which is on the same database server instance.In the case of failure,recovery of the travel agent database and the Accounting database must be ensured to the same logical point in time.
TECHNICAL REQUIREMENTS
Security
External access to company data must be allowed for only a specified set of IP addresses.
9. You need to improve the performance and reduce the database resource usage of the stored procedure that will be used to generate the monthly agent-commission report. What should you do?
A. Remove the INSENSITIVE argument from the cursor declaration.
B. Add the OPTIMISTIC argument to the cursor declaration.
C. Rewrite the stored procedure using set operations.
D. Rewrite the stored procedure as a user-defined type.
Answer: C

7. You are troubleshooting concurrency problems with the code that was originally developed on the SQL Server 2000 database. You discover that there are excessive read locks on important tables. You need to resolve the problem. What should you do?
A. Set the transaction isolation level to REPEATABLE READ.
B. Set the transaction isolation level to SERIALIZABLE.
C. Set the ALLOW_SNAPSHOT_ISOLATION database option to ON.
D. Set the READ_COMMITTED_SNAPSHOT database option to ON.
Answer: D

8. You need to improve the performance and reduce the database resource usage of the stored procedure that will be used to generate the monthly agent-commission report. What should you do?
A. Remove the INSENSITIVE argument from the cursor declaration.
B. Add the OPTIMISTIC argument to the cursor declaration.
C. Rewrite the stored procedure using set operations.
D. Rewrite the stored procedure as a user-defined type.
Answer: C

9. You need to design the user interface that will display availability to pick up items at a retail store for items that are ordered online. You also must minimize the number of connections to the database. Which data access strategy should you use?
A. ActiveX data objects (ADO)
B. multiple active result sets (MARS)
C. System.Data.DataReader
D. System.Data.DataSet
Answer: B

10. You are designing the stored procedure that updates inventory quantities. The stored procedure contains the following code.
CREATE PROCEDURE UpdateInventory (@ProductID int, @Amount int)
AS
BEGIN TRANSACTION
DECLARE @CurrentQuantity int
SELECT @CurrentQuantity = Quantity
FROM Inventory.ProductInventory
WHERE ProductID = @ProductID
UPDATE Inventory.ProductInventory
SET Product.Quantity = @CurrentQuantity + @Amount
WHERE ProductID = @ProductID
IF @@ERROR <> 0
ROLLBACK TRAN
ELSE
COMMIT TRAN
You discover that the ProductInventory column is occasionally updated incorrectly. You need to resolve the problem. What should you do?
A. Add a SET TRANSACTION ISOLATION LEVEL SERIALIZABLE statement to the stored procedure.
B. Remove the SELECT statement from the stored procedure. Perform the update using the Product.Quantity column instead of the @CurrentQuantity variable.
C. Add a NOLOCK hint to the SELECT statement.
D. Move the BEGIN TRANSACTION statement so that it immediately precedes the UPDATE statement.
Answer: B

11. BACKGROUND
company overview
Tailspin toys is a regional toy store chain,with stores in 30 cities.
Planned Changes
The company wants to add an online store to its chain of retail stores.A prototype of the online store was developed by using SQL server 2000 .However,the IT manager wants to move to SQL Sever 2005 to take advantage of its new features.
The IT manager plans to automate certain database maintenance operations,including scripting of database objects,backup and restore activities ,and creation and maintenance of endpoints.
Problem Statement
The nightly processing of the sales data from each store executes very slowly.with the addition of the online store,this performance must be improved in order to complete the processing within the allotted frame.
EXISTING ENVIRONMENT
Existing Application Environment
The prototype of the online store is experiencing poor concurrency.
Existing supporting Infrastructure
Currently,the point of sale(POS) system for the retail stores has a SQL Server 2000 database.Tailspin Toys has an Enterprise Resource planning(ERP) system running on UNIX that must be able to communicate with the online store's Inventory database.
BUSINESS REQUIREMENTS
General Application Solution Requirements
The company is developing an online store that is capable of displaying pictures,prices,and information on products that are sold by Tailspin Toys.
Customers must be able to find out whether toys that are available online are also available at a physical store for pickup.The store inventory for a selected store must be queried real-time as the individual toys are displayed.Inventory quantities for a toy must all be displayed prior to processing the next toy.
Store managers often run reports that query for all sales for a given date range.
New toys are introduced at the online store only once per month.
Performance
When a customer uses the online store to perform a search for toys,it should return results in 15 seconds or less.
Users can search for a toy category. The results of this search should be used for future searches by the same user,to minimize round trips to the database.
TECHNICAL REQUIREMENTS
Resource usage on the database server must be minimized.
The online store will have two databases named Sales and Inventory.When a sale is completed,both databases must be kept consistent with each other.
The IT department has specified that the online store will use a service-oriented architecture for data access.
2. You need to design the data access strategy for the Tailspin Toys online store search requirement. Which strategy should you use?
A. System.Xml.XmlReader
B. System.Data.SqlClient.SqlDataReader
C. System.Data.DataSet
D. CLR user-defined type
Answer: C

12. You need to design the data access object model to be used for the infrequently changing data about trading partners. What should you use?
A. ActiveX data objects (ADO)
B. System.Data.DataReader
C. System.Data.DataSet
D. System.Xml.XmlReader
Answer: C

13. You need to design the data access model for available flight information. What should you use?
A. XML template queries
B. ActiveX data objects (ADO)
C. System.Data.DataSet
D. System.Data.DataReader
Answer: D

14. You are attempting to correct the FlightsBooked report. The report contains the following code segment.
CREATE PROCEDURE FlightBookings (@AsOfTime datetime)
AS
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED
SELECT BookingID, AgentFullName,FlightID, FlightDate
FROM FlightBookings JOIN Agent
ON FlightBookings.AgentID = Agent.AgentID
WHERE BookingTime <= @AsOfTime
You need to correct the problem. What should you do?
A. Set the transaction isolation level to READ COMMITTED.
B. Set the transaction isolation level to REPEATABLE READ.
C. Set the READ_COMMITTED_SNAPSHOT database option to ON.
D. Set the READ_COMMITTED_SNAPSHOT database option to OFF.
Answer: B


Click Online chat to talk with us , get more informations about Cisco CCNP 642-892 practice exam study guides questions and answers

Exam Description

It is well known that 70-442 exam test is the hot exam of Microsoft certification. TestInside offer you all the Q&A of the 70-442 real test . It is the examination of the perfect combination and it will help you pass 70-442 exam at the first time!

Why choose TestInside 70-442 braindumps

Quality and Value for the 70-442 Exam
100% Guarantee to Pass Your 70-442 Exam
Downloadable, Interactive 70-442 Testing engines
Verified Answers Researched by Industry Experts
Drag and Drop questions as experienced in the Actual Exams
Practice Test Questions accompanied by exhibits
Our Practice Test Questions are backed by our 100% MONEY BACK GUARANTEE.

TestInside 70-442 Exam Features

Quality and Value for the 70-442 Exam

TestInside Practice Exams for Microsoft 70-442 are written to the highest standards of technical accuracy, using only certified subject matter experts and published authors for development.

100% Guarantee to Pass Your 70-442 Exam

If you prepare for the exam using our TestInside testing engine, we guarantee your success in the first attempt. If you do not pass the Microsoft Licensing 70-442 exam (ProCurve Secure WAN) on your first attempt we will give you a FULL REFUND of your purchasing fee AND send you another same value product for free.

Microsoft 70-442 Downloadable, Printable Exams (in PDF format)

Our Exam 70-442 Preparation Material provides you everything you will need to take your 70-442 Exam. The 70-442 Exam details are researched and produced by Professional Certification Experts who are constantly using industry experience to produce precise, and logical. You may get questions from different web sites or books, but logic is the key. Our Product will help you not only pass in the first try, but also save your valuable time.

70-442 Downloadable, Interactive Testing engines

We are all well aware that a major problem in the IT industry is that there is a lack of quality study materials. Our Exam Preparation Material provides you everything you will need to take a certification examination. Like actual certification exams, our Practice Tests are in multiple-choice (MCQs) Our Microsoft 70-442 Exam will provide you with free 70-442 dumps questions with verified answers that reflect the actual exam. These questions and answers provide you with the experience of taking the actual test. High quality and Value for the 70-442 Exam:100% Guarantee to Pass Your Microsoft Licensing exam and get your Microsoft Licensing Certification.

TestInside 70-442 practice exam preparation work
TestInside 70-442 braindumps examination test
TestInside 70-442 pdf exam history test questions
TestInside 70-442 video
TestInside 70-442 certification professionals
TestInside 70-442 actual
TestInside 70-442 braindumps notes
TestInside 70-442 study guide questions
TestInside 70-442 practice exam guide
TestInside 70-442 examination guide
TestInside 70-442 certificate file
TestInside 70-442 certification practice tests
TestInside 70-442 preparation work
TestInside 70-442 certified certification
TestInside 70-442 sample certification
TestInside 70-442 braindumps

http://www.saletestinside.com/70-442-exam.html The safer.easier way to get Microsoft Licensing Certification.


Guarantee | Buying Process | F.A.Q. | Payment | Refundment Term | Semples | Testing Engine | privacy | Contact | Sitemap 1 2 3 4

Copyright©2006-2009 saletestinside Limited. All Rights Reserved

saletestinside materials do not contain actual questions and answers from Microsoft's Cisco's Certification Exams.