网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)
单选题
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.  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.” 相关考题
考题 windows Azure平台包含了()等重要组成部分。A、windows AzureB、SQL AzureC、Windows Azureplatform App FabricD、Windows Azure Application

考题 在Windows Azure存储系统中,()类型提供了结构化的存储。A、Windows Azure BlobB、Windows Azure TableC、Windows Azure QueueD、SQL数据服务

考题 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 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.

考题 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.

考题 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

考题 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

考题 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.

考题 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.

考题 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.

考题 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.

考题 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.

考题 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.

考题 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.

考题 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.

考题 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 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

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

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

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

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

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

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

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

考题 多选题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?()ARemove all clustered indexes from the database.BRemove all dependencies on the Microsoft Distributed Transaction Coordinator (MSDTC) from the application.CUse SSL and SQL authentication to connect to the database.DUse SSL and Windows authentication to connect to the database.

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