70-469 Exam
Improve Microsoft 70-469 - An Overview 1 to 10
We provide real 70-469 exam questions and answers braindumps in two formats. Download PDF & Practice Tests. Pass Microsoft 70-469 Exam quickly & easily. The 70-469 PDF type is available for reading and printing. You can print more and practice many times. With the help of our Microsoft 70-469 dumps pdf and vce product and material, you can easily pass the 70-469 exam.
Q1. You need to implement a solution that solves the performance issues of usp_GetOrdersAndItems.
Which statements should you execute?
A. CREATE INDEX IX_Orders_Active ON Orders(ShipDate, DeliveryDate, Amount)
B. CREATE INDEX IX_Orders_Active ON Orders(DeliveryDate) INCLUDE(Amount) WHERE ShipDate IS NULL
C. CREATE INDEX IX_Orders_Active ON Orders(DeliveryDate, Amount) WHERE ShipDate IS NULL
D. CREATE INDEX IX_Orders_Active ON Orders(ShipDate, DeliveryDate) INCLUDE( Amount)
Answer: B
Q2. You plan to execute the following code:
You need to identify how many rows will be in dbo.Table1 after you execute the code. How many rows should you identify?
A. 0
B. 1
C. 2
D. 3
Answer: A
Q3. You have a table named Rooms that contains three columns. You execute the following query:
You discover the execution plan shown in the exhibit. (Click the Exhibit button.)
You need to recommend a solution to reduce the amount of time it takes to execute the query.
What should you do?
More than one answer choice may achieve the goal. Select the BEST answer.
A. Include the RoomName column and the Position column in the Room_IX index.
B. Create a nonclustered index for RoomName, Id, and Position.
C. Create a clustered index for Id.
D. Use the WITH (INDEX(Room_IX),NOLOCK) query hint.
Answer: B
Q4. You need to implement a solution that addresses the performance issues of the usp_GetOrdersByProduct stored procedure.
Which statement should you execute?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: C
Q5. You need to optimize the index structure that is used by the tables that support the fraud detection services.
What should you do?
A. Add a hashed nonclustered index to CreateDate.
B. Add a not hash nonclustered index to CreateDate.
C. Add a not hash clustered index on POSTransactionId and CreateDate.
D. Add a hashed clustered index on POSTransactionId and CreateDate.
Answer: A
Q6. You execute the following code:
You need to select the task that has an IsFinished value of true from the Project that has an Id value of 1.
Which code segment should you use?
A. Option A
B. Option B
C. Option C
D. Option D
Answer: B
Q7. You need to modify usp_SelectEmployeesByName to support server-side paging. The solution must minimize the amount of development effort required.
What should you add to usp_SelectEmployeesByName?
A. A table variable
B. The ROWNUMBER keyword
C. An OFFSET-FETCH clause
D. A recursive common table expression
Answer: C
Q8. You need to recommend a solution that meets the concurrency problems.
What should you include in the recommendation?
A. Modify the stored procedures to use the SERIALIZABLE isolation level.
B. Modify the order in which usp_AcceptCandidate accesses the Applications table and the Candidates table.
C. Modify the order in which usp_UpdateCandidate accesses the Applications table and the Candidates table.
D. Modify the stored procedures to use the REPEATABLE READ isolation level.
Answer: C
Q9. You need to recommend changes to the ERP application to resolve the search issue. The solution must minimize the impact on other queries generated from the ERP application.
What should you recommend changing?
A. The collation of the Products table
B. The index on the ProductName column
C. The collation of the ProductName column
D. The data type of the ProductName column
Answer: C
Q10. You need to recommend a solution to ensure that SQL1 supports the auditing requirements of usp_UpdateSpeakerName.
What should you include in the recommendation?
A. The Distributed Transaction Coordinator (DTC)
B. Transactional replication
C. Change data capture
D. Change tracking
Answer: A