In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables.  What is the bes

第1题：

What is a prerequisite for using the application availability analysis tool in HACMP？（）  

• A、 Tivoli is required to generate reports from the data collected.
• B、 An application monitor must be associated with the application to monitor.
• C、 An "aaatd" daemon must be started and added in as a post event to "node_up_complete".
• D、 Resource group is present on all of the systems in the cluster that have the desired application.

第2题：

Your database supports an online transaction processing (OLTP) application. The application is undergoing some major schema changes, such as addition of new indexes and materialized views. You want to check the impact of these changes on workload performance. What should you use to achieve this?（）

• A、Database replay
• B、SQL Tuning Advisor
• C、SQL Access Advisor
• D、SQL Performance Analyzer
• E、Automatic Workload Repository compare reports

第3题：

In your datawarehousing application， you generate reports frequently. The data is static in the tables being used to generate reports. You are currently using joins， resulting in a large performance overhead. What kind of database structure would you use to reduce the response time of the query？（）

• A、hash clusters
• B、index clusters
• C、partitioned tables
• D、index­organized table （IOT）

第4题：

You want to enable users of a Web application to modify the Web application's UI and behavior. These modifications must be maintained at the user level so that when users return to the Web application, the changes are still in effect. You need to achieve this goal by using the minimum amount of custom code. What should you do?（）

• A、Persist control data by using view state.
• B、Use Web Part controls.
• C、Maintain a profile for each user.
• D、Enable session state on the Web application.

第5题：

You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. The application uses data-bound controls. You discover that when the application is executed by users, one of the controls is not displayed properly. You need to view the property values assigned to the controls. What should you do?（）

• A、 Use IntelliTrace. 
• B、 Use PresentationTraceSource.
• C、 Run the application in debug mode with Visual Studio 2010. Use the Auto window while you step through the application code.
• D、 Run the application in debug mode with Visual Studio 2010. Use the WPF Visualizer while you step through the application code.

第6题：

You use Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. The application requires frequent updates. You want to use the ClickOnce technology to distribute the application to Internet users. You need to ensure that the application is automatically updated without requiring user intervention. You also need to ensure that the users execute the most recent version of the application. What should you do when you publish the application? （）

• A、 Use Install the application from a file share. Select the Application is available online and offline option.
• B、 Use Install the application from CD-ROM or a DVD-ROM. Select the Application will not check for updates option.
• C、 Use Install the application from a Web site. Select the Application is available online only option.
• D、 Use Install the application from a Web site. Select the Application is available online and offline option.

第7题：

Your network contains an Active Directory domain. You have a server that runs Windows Server 2008 R2 and has the Remote Desktop Services server role enabled. All client computers run Windows 7. You need to plan the deployment of a new line-of-business application to all client computers. The  deployment must meet the following requirements：   èUsers must access the application from an icon on their desktops.   èUsers must have access to the application when they are not connected to the network. What should you do？（）

• A、Publish the application as a RemoteApp.
• B、Publish the application by using Remote Desktop Web Access （RD Web Access）.
• C、Assign the application to the Remote Desktop Services server by using a Group Policy object （GPO）.
• D、Assign the application to all client computers by using a Group Policy object （GPO）.

第8题：

You are using windows installer to deploy an application to 750 Windows 2000 Professional computers on your network. The network includes organizational unit （OU） named sales. A Group Policy object （GPO） is created for the Sales OU. The software deployment of the application is unsuccessful. During the deployment， some users in the Sales OU report that the installation is aborting with random errors midway through the installation process. The remaining users in the Sales OU report that the software is installing， but is giving them general protection fault errors. What should you do？（）

• A、Repackage and re-deploy the application's .msi file to the Sales OU
• B、Repackage and re-deploy the application's .mst file to the Sales OU
• C、Re-deploy the application by using the Group Policy object (GPO for the Sales OU)
• D、Restart Windows Installer on all computers in the Sales OU. Then re-deploy the application's .zap file to the sales OU. 

第9题：

第10题：

第11题：

第12题：

第13题：

In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables.  What is the best table structure that you can use to gain optimal performance？（）

• A、heap table
• B、object table
• C、external table
• D、clustered table
• E、global temporary table
• F、index-organized table （IOT）

第14题：

In one of your online transaction processing （OLTP） applications， users are manipulating and querying a database table simultaneously. From the Segment Advisor， you find that one of the tables is highly fragmented and you want to shrink the table immediately without affecting the currently active queries.  Which option would you use with the ALTER TABLE command to achieve this objective？（）

• A、REBUILD
• B、CASCADE
• C、TRUNCATE
• D、ROW MOVEMENT
• E、SHRINK SPACE COMPACT
• F、SHRINK SPACE CASCADE

第15题：

An application uses Windows Azure Table storage. The application uses five tables.  One table used by the application is approaching the limit for storage requests per second.  You need to recommend an approach for avoiding data access throttling.  What should you recommend？（）

• A、 Use a single partition key for the table.
• B、 Compress data before storing it in the table.
• C、 Create additional partition keys for the table.
• D、 Continually remove unnecessary data from the table.

第16题：

You develop a Web application. Your application contains two settings in the Web.config file. You deploy your application to production. You need to modify the application settings in the production environment without manually editing the XML markup in the Web.config file. What should you do? （）

• A、Modify the application settings by using the Web Site Administration Tool.
• B、Modify the application settings by using the Visual Studio property page editor for the project.
• C、Modify the application settings by using the resource editor.
• D、Modify the application settings by using the Visual Studio start options editor.

第17题：

You design a Business Intelligence （BI） solution by using SQL Server 2008. You plan to create a SQL Server 2008 Reporting Services （SSRS） solution. Developers generate random reports against a data source that contains 200 tables. Power users generate random reports against four of the 200 tables. You need to design a strategy for the SSRS solution to meet the following requirements： ·Uses minimum amount of development effort. ·Provides two sets of tables in SSRS to the developers group and the power users group. Which strategy should you use？（）

• A、 Create two Report Builder models.Include the four frequently used tables in the first model and all the tables in the second model.
• B、 Create a Report Builder model by using all the tables.Create a perspective within the model to use only the four frequently used tables.
• C、 Create a Report Builder model by using all the tables. Create two folders.Place the four frequently used tables in the first folder and the remaining tables in the second folder.
• D、 Create two Data Source Views.Include all the tables in one Data Source View and the four frequently used tables in the other Data Source View.Create two Report Builder models so that each model uses one of the Data Source Views.

第18题：

You are the desktop administrator for your company. All users in the network have Windows XP Professional computers. Users in the research department have dual-processor computers. Users in the research department report that when they run 16-bit Windows programs, their computer performance becomes very slow. You use System Monitor to monitor the users’ computers. You discover that when the users are running their 16-bit applications, one processor shows a sustained utilization of more than 90 percent while the other processor only shows utilization of less than 10 percent. You need to improve application performance for the users in the research department. What should you do?（）

• A、Configure each application to run in a separate memory space.
• B、Configure each application to run in AboveNormal priority class.
• C、For each application, set the compatibility mode to Windows 95.  
• D、Configure processor affinity for each application to allow it to run on both processors.

第19题：

You are responsible for migrating client computers from Windows 98 and Windows NT Workstation 4.0 to Windows 2000 Professional. You have installed Windows 2000 Professional and reinstalled the necessary application on 10 computers. You have returned these computers to their users. The users of these computers report that their word processing application will not start. What should you do?（）

• A、Set the permission on the application to Execute.
• B、Add the application to the Run key in the registry.
• C、Apply the Securews.inf security template on the users’ computers.
• D、Apply the compatws.inf security template on the users’ computers.

第20题：

You have a computer that runs Windows XP Professional. Multiple users share the computer. You log on to the computer by using the local administrator account and install a custom application. You need to add an application shortcut to the desktop of all new users who use the computer. The shortcut must appear on the desktop of new users only. What should you do?（）

• A、Copy the shortcut to %systemdrive%/documents and settings/default user/desktop/.
• B、Copy the shortcut to %systemdrive%/documents and settings/all users/desktop/.
• C、Copy the shortcut to your desktop. Modify the %comspec% system environment variable. 
• D、Copy the shortcut to the guest user’s desktop. Assign the Everyone group Read permission to the guest user profile.

第21题：

第22题：

第23题：