Designing and Developing Windows Azure Applications: Optimizing Data Access and Messaging

Optimizing Data Access and Messaging weighs 17% of the exam. this category includes topics like, Optimize a data access strategy, Design a reliable data access layer to access SQL Azure, Design an efficient strategy to avoid data access throttling, Design a queue strategy that guarantees idempotency, and Design communication strategies using queues.

Total 5 questions found in this category.

Submit Question   Show By Status: New Submissions   Pending   Deleted   Approved   


QuestionSubjectCategory
Match Problem to Identification Problem 1. Crashing of Root OS 2. Role instance crashing 3. Guest VM crashes 4. Hardware problems How do you identify a. The root agent notices absence of heartbeats from the guest b.The fabric controller notices an absence of heartbeats from the guest. c.Guest fabric controller agent monitors role termination d.Fabric controller agent will report disk, memory, or CPU failure. Designing and Developing Windows AzureOptimizing Data Access and Messaging
You developed an application on Windows Azure and with SQL Azure as database. After hosting the application you are continously getting following error: Msg 40552, Level 20, State 1, Line 1 The session has been terminated because of excessive transaction log space usage. Try modifying fewer rows in a single transaction. From first level of investigation what can be cause of this error? a. Lots of uncommitted transactions. b. Transactions consuming excessive log resources. c. Transactions have consumed significant tempdb space. Designing and Developing Windows AzureOptimizing Data Access and Messaging
You created a Windows Azure application .After successful deployment you found that the SQL Azure takes quite a long time to show reports. You want to know the bottle neck by looking at the execution plan.You write an EP for generating the most IO in SQL Azure. What will you use to do this?Designing and Developing Windows AzureOptimizing Data Access and Messaging
You created a Windows Azure application .After successful deployment you found that the SQL Azure takes quite a long time to show reports. You want to know the bottle neck by looking at the execution plan.You write an EP for generating the most IO in SQL Azure. What will you use to do this?Designing and Developing Windows AzureOptimizing Data Access and Messaging
If you want to know the current state of locking in SQL Azure which DMV should you use?Designing and Developing Windows AzureOptimizing Data Access and Messaging



Submit Interview/Test Questions with Answers and make money from adsense revenue sharing program