Microsoft PRO: Designing and Developing Windows Azure Applications Sample Questions:

1. You are analyzing the performance of a SQL Azure database.
You need to recommend an approach for identifying the indexes that should be added to improve
database performance.
What should you recommend?

A) Use SQL Server Profiler to identify missing indexes.
B) Use the Database Engine Tuning Advisor to identify missing indexes.
C) Use a Dynamic Management View to analyze query plans.
D) Use a Dynamic Management View to ascertain the number of pending I/O requests.

2. You are designing a plan for migrating Virtual Hard Disks (VHDs) and video files to Windows Azure
Storage.
The VHDs must be optimized for random read/write operation.
The video files must be optimized for sequential access.
You need to recommend storage types for storing the VHDs and video files.
Which two storage types should you recommend?
(Each correct answer presents part of the solution. Choose two.)

A) Store video files in Windows Azure page blob storage.
B) Store VHDs in Windows Azure block blob storage.
C) Store VHDs in Windows Azure page blob storage.
D) Store video files in Windows Azure block blob storage.

3. You are designing a strategy for synchronizing two geographically disparate SQL Azure databases.
A database named DB1 is located in North America.
A database named DB2 is located in Asia.
DB2 contains a subset of the tables in DB1.
You need to recommend an approach for bidirectionally synchronizing the databases each day.
What should you recommend?

A) Use a Microsoft Sync Framework file synchronization provider.
B) Use custom Microsoft Sync Framework metadata.
C) Use SQL Azure Data Sync.
D) Use a Microsoft Sync Framework Partial Participant.

4. You are designing a Windows Azure application that will store data in two SQL Azure databases.
The application will insert data in both databases as part of a single logical operation.
You need to recommend an approach for maintaining data consistency across the databases.
What should you recommend?

A) Handle errors resulting from the database calls by using compensatory logic.
B) Wrap the database calls in a single transaction scope.
C) Use Microsoft Distributed Transaction Coordinator (MSDTC).
D) Execute database calls on parallel threads.

5. You are planning the migration of an existing application to Windows Azure and SQL Azure.
The current application includes reports that are hosted by SQL Server Reporting Services.
You need to recommend an approach for migrating the reports. What should you recommend?

A) Use Windows Azure to host client report definitions in an ASP.NET webpage.
B) Use SQL Azure to host client report definitions.
C) Use Windows Azure to host server report definitions in an ASP.NET webpage.
D) Use SQL Azure to host server report definitions.

Solutions: