What should you do to make sure that sales trend analysis report runs as quickly as possible?
Correct Answer for the following Question is given below
You work in an International company named TAKEEEN. And you’re in charge of the database of your company. You intend to use SQL Server 2008 to create a database solution. There’re two stored procedures in the database. The stored procedures are respectively named AlterSelling and GetSelling. Every day the two procedures are executed very often. The AlterSelling stored procedure updates a table named SellingOrders by using a transaction. From the SellingOrders table, data is retrieved and aggregated by the GetSelling stored procedure for a sales trend analysis report. When users run the sales trend analysis report, they have to wait for a long time.So what should you do to make sure that sales trend analysis report runs as quickly as possible?NOLOCK is equivalent to READUNCOMMITTED.READUNCOMMITTEDSpecifies that dirty reads are allowed. No shared locks are issued to prevent other transactions from modifying data read by the current transaction, and exclusive locks set by other transactions do not block the current transaction from reading the locked data.
Question:
What should you do to make sure that sales trend analysis report runs as quickly as possible?
Options:
For AlterSelling, the isolation level should be changed to SERIALIZABLE
The NOLOCK hint has to be added to the SELECT statements in GetSelling
The NOWAIT hint has to be added to the SELECT statement in GetSelling
For AlterSelling, the isolation level should be changed to READ UNCOMITTED
Correct Answer
The Correct Answer for this Question is
The NOLOCK hint has to be added to the SELECT statements in GetSelling
Explanation
The Question – What should you do to make sure that sales trend analysis report runs as quickly as possible? has been answered correctly and answers for the question is The NOLOCK hint has to be added to the SELECT statements in GetSelling
More about these Exams
These Exam Questions and the order of these questions keep changing. but the answers are obviously same. so if you don’t find a question after another we suggest you search it in the search box and we are sure you’ll find it. you can bookmark this site for Quick access in future.
We hope you found it helpful don’t forget to leave a comment if you feel a need to correct or ask we’re always here to help.
you can find more here at mnccertified
Feel free to contact via comment or email.
Happy Learning
Cheers, Team MNCcertified
