An application connects to a SQL Azure database.  The applic

题目
单选题
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.

如果没有搜索结果或未解决您的问题,请直接 联系老师 获取答案。
相似问题和答案

第1题:

You are evaluating a Windows Azure application. The application uses one instance of a web role. The role instance size is set to Medium. The application does not use SQL Azure.   You have the following requirements for scaling the application:   - Maximize throughput.  - Minimize downtime while scaling. - Increase system resources.   You need to recommend an approach for scaling the application.  What should you recommend?()  

  • A、 Set up vertical partitioning.
  • B、 Set up horizontal partitioning.
  • C、 Increase the number of role instances.
  • D、 Change the role instance size to large.

正确答案:C

第2题:

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.

正确答案:C

第3题:

windows Azure平台包含了()等重要组成部分。

  • A、windows Azure
  • B、SQL Azure
  • C、Windows Azureplatform App Fabric
  • D、Windows Azure Application

正确答案:A,B,C

第4题:

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.

正确答案:A

第5题:

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,C

第6题:

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.

正确答案:B

第7题:

You are designing an integration test plan for a Windows Azure .NET 3.5 application.   You need to recommend a testing environment that allows developers to debug the application while accessing data in the cloud.  What should you recommend?()

  • A、 Run the application on Windows Azure.  Use the development storage account.
  • B、 Run the application on Windows Azure.  Use a Windows Azure Storage account.
  • C、 Run the application in the development fabric.  Use the development storage account.
  • D、 Run the application in the development fabric.  Use a Windows Azure Storage account

正确答案:D

第8题:

You are evaluating a Windows Azure application.  The application includes the following elements:   - A web role that provides the ASP.NET user interface and business logic   - A single SQL Azure database that contains all application data    Each page must receive data from the business logic layer before returning results to the client.  Traffic has increased significantly.   The business logic is causing high CPU usage.   You need to recommend an approach for scaling the application.  What should you recommend?()

  • A、 Move business logic to a worker role.
  • B、 Vertically partition the SQL Azure database.
  • C、 Store business logic results in Windows Azure local storage.
  • D、 Store business logic resultsin Windows Azure Table storage

正确答案:A

第9题:

You are a database administrator for your company. The company uses a vendor company’s application that is based on a proprietary database. You query data from the application database and import the data into a SQL Server 2005 database. The application vendor provides you with a new OLE DB driver to be used when querying the application database. Company policy prohibits connections between the SQL Server database and the application database, except when querying this data. You need to provide a way to query data from the application database. What should you?()

  • A、Configure a Linked Server connection to the application database.
  • B、Write a query that uses an OPENDATASOURCE command.
  • C、Write a query that uses an OPENQUERY command.
  • D、Configure a Remote Server connection to the application database.

正确答案:B

第10题:

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.

正确答案:B

更多相关问题