You are planning the deployment of a SQL Azure database.  Yo

第1题：

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 SQL Azure to host client report definitions.
• B、 Use SQL Azure to host server report definitions.
• C、 Use Windows Azure to host client report definitions in an ASP.NET webpage.
• D、 Use Windows Azure to host server report definitions in an ASP.NET webpage.

第2题：

An on-premise .NET application uses an on-premise Microsoft SQL Server 2008 database.  The existing compute infrastructure is insufficient to support peak loads.   You plan to move only the compute-intensive component of the application into Windows Azure.  The component requires access to the on-premise database.   The on-premise database cannot be accessed from outside the network boundary.  You need to recommend a database topology.  What should you recommend？（）

• A、 Use SQL Azure for the on-premise components and the compute-intensive component.
• B、 Configure merge replication with the on-premise database as publisher and the SQL Azure database as subscriber.
• C、 Configure snapshot replication with the on-premise database as publisher and the SQL Azure database assubscriber.
• D、 Configure snapshot replication with the SQL Azuredatabase as publisher and the on-premise database as subscriber.

第3题：

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 DynamicManagement View to ascertain the number of pending I/O requests.

第4题：

Multiple Windows Azure applications connect to multiple SQL Azure servers.  On-premise users connect to the SQL Azure servers for a variety of purposes.   You successfully deploy a new Windows Azure application with its own SQL Azure server.  When on- premise users attempt to connect to the new SQL Azure server they receive connection errors.   You need to recommend an approach for mitigating the connectivity issue.  What should you recommend？ （）

• A、 Open port 1433 on the network firewall.
• B、 Use Security Support Provider Interface （SSPI）.
• C、 Disable the validation of the SSL certificate for the SQL Azure server through theconnection string.
• D、 Change the firewall rules of the new SQL Azure server to allow access by computers on the internalnetwork.

第5题：

An application connects to a SQL Azure database.  The application occasionally loses the connection to the SQL Azure database.   You need to recommend an approach for reliably completing data access operations.  What should you recommend？（）  

• A、 Use Microsoft ADO.NET connection pooling.
• B、 Pass exceptions to the user interface layer.
• C、 Implement a retry policy in the data access layer.
• D、 Begin a transaction before each data access operation.

第6题：

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.

第7题：

You are planning the deployment of a SQL Azure database.  Your company has a Volume Licensing Agreement for Microsoft SQL Server 2008. The SQL Azure database must maintain a monthly availability of 99.9%.   You need to recommend an approach for minimizing the monthly expenses associated with the SQL Azure database.  What should you recommend？（）

• A、 Add a processor license to the existing SQL Server licensing agreement.
• B、 Purchase a Windows Azure consumption platform subscription.
• C、 Purchase a SQL Server Services Provider Licensing Agreement （SPLA）.
• D、 Purchase a SQL Server Web license to extend the existing SQL Server licensing agreement.

第8题：

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.

第9题：

You are designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure. You do not plan to migrate the SQL Server databases to SQL Server 2008 R2.   You need to recommend an approach for performing bulk data transfers from the SQL Server databases to SQL Azure.  What should you recommend？（）

• A、 Use the bcp utility.
• B、 Use the dta utility.
• C、 Use the SQL Server Import and Export Wizard.
• D、 Attach each SQL Server database to SQL Azure.

第10题：

You are designing a plan for migrating an existing Microsoft SQL Server 2008 database to SQL Azure.The database includes a SQL Server Agent job that cleans the application log table.   You need to recommend an approach for ensuring that the SQL Server Agent job continues to run without modification.  What should you recommend？（）

• A、 Use the SQL Azure Data Sync service.
• B、 Run the SQL Server Agent in SQL Azure.
• C、 Use SQL Server Integration Services （SSIS） to connect to SQL Azure.
• D、 Connect the existing on-premise SQL Server Agent jobs to SQL Azure.