单选题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.
单选题
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.
参考解析
解析：
暂无解析
相关考题：
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.
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 work in a company which is named Wiikigo Corp. The company uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. Now according to the company requirement, you are designing a consolidated repository of performance data. You must make sure that the four requirements below are met: the data collector is used to gather performance information; a single database stores performance information for all instances; performance information that is older than 15 days is deleted; reduce the administrative effort to manage performance to the least. So what action should you perform to achieve this goal? （） A、You should create a SQL Agent job process on each instance to store and delete performance data in a single database for all instances. B、You should configure a management data warehouse process on each instance, then use this process to store and delete performance data in a single database for all instances. C、You should configure an automated server-side trace process on each instance, then use this process to store and delete performance data in a single database for all instances. D、You should create and schedule a single Microsoft SQL Service Integration Services (SSIS) package process, then use this process to store and delete performance data in a single database for all instances.
You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA？（）A、 SQL Tuning AdvisorB、 Undo AdvisorC、 ADDMD、 Memory Advisor
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.
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.
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.
You are designing a strategy for synchronizing a SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships. You need to recommend an approach for ensuring that all changes in the remote databases synchronize with the SQL Azure database. What should you recommend？（）A、 Use SQLAzure Data Sync Service.B、 Use SQL Server replication.C、 Use SQL Server backup and restore.D、 Use SQL Server database snapshots.
You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance which contains a database. Now your company CIO assigns a task to you. You have to check the performance of the SQL Server 2008 instance. You have to find out which common language runtime (CLR) queries takes the longest-running time. So in the options below, which dynamic management view should you choose to use?（） A、sys.dm_os_wait_stats B、sys.dm_exec_requests C、sys.dm_exec_sessions D、sys.dm_exec_query_stats
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.
单选题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.
单选题You are designing a strategy for synchronizing a SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships. You need to recommend an approach for ensuring that all changes in the remote databases synchronize with the SQL Azure database. What should you recommend？（）A Use SQLAzure Data Sync Service.B Use SQL Server replication.C Use SQL Server backup and restore.D Use SQL Server database snapshots.
单选题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 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.
单选题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.
单选题You are maintaining the SALES database for eSoft Corporation. You have not configured ASMM on the database. You want to know what size of the SGA will provide the best performance. Which advisor would you use to determine the suitable size of the SGA？（）A SQL Tuning AdvisorB Undo AdvisorC ADDMD Memory Advisor
单选题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 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 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.