Online Access Free 070-583 Exam Questions

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 custom Microsoft Sync Framework metadata.
• B.Use SQL Azure Data Sync.
• C.Use a Microsoft Sync Framework Partial Participant.
• D.Use a Microsoft Sync Framework file synchronization provider.

You are designing a Windows Azure application that will use a worker role.
The worker role will create temporary files.
You need to recommend an approach for creating the temporary files that minimizes storage transactions.
What should you recommend?

• A.Create the files in Windows Azure Storage block blobs.
• B.Create the files on a Windows Azure Drive.
• C.Create the files in Windows Azure local storage.
• D.Create the files in Windows Azure Storage page blobs.

You are designing a Windows Azure application that will allow for the processing of image files.
Images will be processed in batches by remote applications running on multiple servers.
The application must meet the following requirements:
-Remain operational during batch-processing operations.
-Allow users to roll back each image to previous versions.
Each remote application must have exclusive access to an image while processing it.
You need to recommend an approach for storing the images.
What should you recommend?

• A.Store the images in Windows Azure Blob storage.
• B.Store the images in a Windows Azure Queue.
• C.Store images in a single Windows Azure Drive attached to the web role.
• D.Store the images in Windows Azure Table storage.

You are designing an application that will use Windows Azure Table storage to store millions of data points
each day.
The application must retain each day's data for only one week.
You need to recommend an approach for minimizing storage transactions.
What should you recommend?

• A.Use a separate table for each date. Delete each table when it is one week old.
• B.Use a single table, partitioned by date. Use Entity Group Transactions to delete data when it is one week old.
• C.Use a single table, partitioned by week. Use Entity Group Transactions to delete data when it is one week old.
• D.Use a separate table for each week. Delete each table when it is one week old.

You are planning the migration of a Microsoft SQL Server 2008 database to SQL Azure.
You need to recommend an approach for ensuring that database connectivity does not degrade.
Which two actions should you recommend?
(Each correct answer presents part of the solution. Choose two.)

• A.Implement a retry policy in the data access layer.
• B.Implement transactions for database queries.
• C.Close database connections in the application.
• D.Use Microsoft ADO.NET in the data access layer.