A. Use SQL Server Profiler to identify missing indexes.……

单项选择题A Windows Azure application connects to a SQL Azure database.  The database size has increased significantly.   Some queries in the application no longer complete.   You need to recommend an approach for identifying queries that do not complete.  What should you recommend？（）

A. Use the SQL Server Profiler to capture all SQL activities.
B. Use a Dynamic Management View to analyze performance.
C. Use the Database Engine Tuning Advisor to analyze the workload.
D. Use Microsoft SQL Server Management Studio to analyze the SQL logs.

多项选择题A Windows Azure application connects to a SQL Azure database.  Connections to the database are being dropped due to throttling.   You need to recommend an approach for identifying the root cause of the problem.   Which two actions should you recommend？（）

A. Use Dynamic Management Views to analyze performance issues.
B. Decrease the connection timeout in the database connection string.
C. Make sure the application is closing database connections that are not needed.
D. Use SQL Profiler to analyze performance issues by configuring it to connect to SQL Azure.

单项选择题A SQL Azure database generates an error when a row is inserted into any table in the database.  No error is generated when a row is deleted.  You need to recommend an approach for locating the source of the errors.  What should you recommend？（）

A. Use a Dynamic Management View to check for locks.
B. Use a Dynamic Management View to check for blocked queries.
C. Use a Dynamic Management View to check for long-running queries.
D. Use a Dynamic Management View to check the size and maximum size of the database.

单项选择题You are designing a Windows Azure application.   Corporate policy dictates that you must retain all application logs.   You need to recommend an approach for complying with the corporate policy.  What should you recommend？（）

A. Perform on-demand transfers.
B. Configure scheduled transfers.
C. Configure a diagnostic trace listener.
D. Increase the diagnostics buffer quotas.

单项选择题A Windows Azure application requires high Windows Azure Storage throughput.  Windows Azure Diagnostics is configured for scheduled transfers to Windows Azure Storage. The application is experiencing slow response times.   You determine that the current Windows Azure Diagnostics configuration is responsible for the reduced application performance.   You need to recommend an approach for improving application performance.  What should you recommend？（）

A. Increase the number of application role instances.
B. Increase the Windows Azure Diagnostics buffer quota.
C. Decrease the Windows Azure Diagnostics buffer quota.
D. Move Windows Azure Diagnostics to its own Windows Azure Storage account.