单选题A Windows Azure application stores data in a SQL Azure database.  The application will start an operation that includes three insert statements.  You need to recommend an approach for rolling back the entire operation if the connection to SQL Azure is 

题目
单选题
A Windows Azure application stores data in a SQL Azure database.  The application will start an operation that includes three insert statements.  You need to recommend an approach for rolling back the entire operation if the connection to SQL Azure is lost.  What should you recommend？（）
A

 Ensure that all statements execute in the same database transaction.

B

 Create a stored procedure in the database that wraps the insert statements in a TRY CATCH block.

C

 Create a stored procedure in the database that wraps the insertstatements in a TRANSACTION block.

D

 Open a new connection to the database. Use a separate transaction scope to roll back the original operation.

相似考题

1. 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

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.

3. You are designing a Windows Azure application that will store data. You have the following requirements：   - The data storage system must support the storage of more than 500 GB of data.   - Data retrieval must be possible from a large number of parallel threads without threads blocking each other.   You need to recommend an approach for storing data.  What should you recommend？（）A、 Use Windows Azure Queues.B、 Use Windows Live Mesh 2011.C、 Use a single SQL Azure database.D、 Use Windows Azure Table storage

4. 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
解析： 暂无解析
更多“单选题A Windows Azure application stores data in a SQL Azure database.  The application will start an operation that includes three insert statements.  You need to recommend an approach for rolling back the entire operation if the connection to SQL Azure is ”相关问题

  • 第1题：

    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

  • 第2题：

    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.

    正确答案:C

  • 第3题：

    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.

    正确答案:D

  • 第4题：

    You are planning the migration of an existing application to Windows Azure and SQL Azure.  The original application includes a Microsoft SQL Server 2008 database.   You need to recommend an approach for ensuring that the database migrates successfully toSQL Azure.  Which two actions should you recommend？（）

    • A、 Remove all clustered indexes from the database.
    • B、 Remove all dependencies on the Microsoft Distributed Transaction Coordinator （MSDTC） from the application.
    • C、 Use SSL and SQL authentication to connect to the database.
    • D、 Use SSL and Windows authentication to connect to the database.

    正确答案:B,C

  • 第5题：

    A Windows Azure application stores data in a SQL Azure database.  The application will start an operation that includes three insert statements.  You need to recommend an approach for rolling back the entire operation if the connection to SQL Azure is lost.  What should you recommend？（）

    • A、 Ensure that all statements execute in the same database transaction.
    • B、 Create a stored procedure in the database that wraps the insert statements in a TRY CATCH block.
    • C、 Create a stored procedure in the database that wraps the insertstatements in a TRANSACTION block.
    • D、 Open a new connection to the database. Use a separate transaction scope to roll back the original operation.

    正确答案:A

  • 第6题：

    A Windows Azure application retrieves data from SQL Azure.   You need to recommend an approach for improving application query performance.  What should you recommend？（）

    • A、 Create a database view to retrieve the data.
    • B、 Use a clustered index on the SQL Azure database tables.
    • C、 Open a new database connection when an operation times out.
    • D、 Create SQL Azure database table indexes basedon application queries

    正确答案:D

  • 第7题：

    单选题
    You are designing a Windows Azure application that will store data. You have the following requirements：   - The data storage system must support the storage of more than 500 GB of data.   - Data retrieval must be possible from a large number of parallel threads without threads blocking each other.   You need to recommend an approach for storing data.  What should you recommend？（）
    A

     Use Windows Azure Queues.

    B

     Use Windows Live Mesh 2011.

    C

     Use a single SQL Azure database.

    D

     Use Windows Azure Table storage


    正确答案： D
    解析： 暂无解析

  • 第8题：

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


    正确答案： C
    解析： 暂无解析

  • 第9题：

    单选题
    A Windows Azure application stores data in a SQL Azure database.  The application will start an operation that includes three insert statements.  You need to recommend an approach for rolling back the entire operation if the connection to SQL Azure is lost.  What should you recommend？（）
    A

     Ensure that all statements execute in the same database transaction.

    B

     Create a stored procedure in the database that wraps the insert statements in a TRY CATCH block.

    C

     Create a stored procedure in the database that wraps the insertstatements in a TRANSACTION block.

    D

     Open a new connection to the database. Use a separate transaction scope to roll back the original operation.


    正确答案： B
    解析： 暂无解析

  • 第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.


    正确答案： B
    解析： 暂无解析

  • 第11题：

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


    正确答案： C
    解析： 暂无解析

  • 第12题：

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


    正确答案： C
    解析： 暂无解析

  • 第13题：

    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

  • 第14题：

    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.

    正确答案:D

  • 第15题：

    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.

    正确答案:D

  • 第16题：

    A Windows Azure application is running in the development fabric.   You need to recommend an approach for deploying the application to Windows Azure.  What should you recommend？（）

    • A、 Use XCopy deployment.
    • B、 Use the Windows Azure AppFabric.
    • C、 Use the Windows Azure Storage Services REST API.
    • D、 Use the Windows Azure Tools for Microsoft Visual Studio 2010.

    正确答案:D

  • 第17题：

    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、 Execute database calls on parallel threads.
    • B、 Wrap the database calls in a single transaction scope.
    • C、 Use Microsoft Distributed Transaction Coordinator （MSDTC）.
    • D、 Handle errors resulting from the database calls by using compensatory logic.

    正确答案:D

  • 第18题：

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


    正确答案： B
    解析： 暂无解析

  • 第19题：

    单选题
    A Windows Azure application is running in the development fabric.   You need to recommend an approach for deploying the application to Windows Azure.  What should you recommend？（）
    A

     Use XCopy deployment.

    B

     Use the Windows Azure AppFabric.

    C

     Use the Windows Azure Storage Services REST API.

    D

     Use the Windows Azure Tools for Microsoft Visual Studio 2010.


    正确答案： D
    解析： 暂无解析

  • 第20题：

    单选题
    You are designing a Windows Azure application.  The application will include occasionally connected clients that reference data stored in Windows Azure Blob storage.  The clients will be able to add data while disconnected.  You need to recommend an approach for synchronizing offline client data with Windows Azure Blob storage.  What should you recommend？（）
    A

     Use SQL Azure Data Sync.

    B

     Use the Microsoft Sync Framework.

    C

     Use Windows Azure Blobstorage snapshots.

    D

     Use the Microsoft SQL Server replication component.


    正确答案： D
    解析： 暂无解析

  • 第21题：

    单选题
    A Windows Azure application retrieves data from SQL Azure.   You need to recommend an approach for improving application query performance.  What should you recommend？（）
    A

     Create a database view to retrieve the data.

    B

     Use a clustered index on the SQL Azure database tables.

    C

     Open a new database connection when an operation times out.

    D

     Create SQL Azure database table indexes basedon application queries


    正确答案： D
    解析： 暂无解析

  • 第22题：

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

     Execute database calls on parallel threads.

    B

     Wrap the database calls in a single transaction scope.

    C

     Use Microsoft Distributed Transaction Coordinator （MSDTC）.

    D

     Handle errors resulting from the database calls by using compensatory logic.


    正确答案： D
    解析： 暂无解析

  • 第23题：

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


    正确答案： D
    解析： 暂无解析

  • 第24题：

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


    正确答案： C
    解析： 暂无解析

相关内容