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 tableB、object tableC、external tableD、clustered tableE、global temporary tableF、indexorganized table (IOT)
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、indexorganized table (IOT)
相关考题:
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 replayB. SQL Tuning AdvisorC. SQL Access AdvisorD. SQL Performance AnalyzerE. Automatic Workload Repository compare reports
You are the administrator of a database that contains 64 lookup tables. These tables store static data that should not change. However, users report that some of this data is being changed. You need to prevent users from modifying the data.You want to minimize changes to your security model and to your database applications. How should you modify the database?A.Create a filegroup named LOOKUP. Move the lookup tables to this filegroup. Select the read only check box for the filegroup.B.Create a database role named datamodifier. Grant SELECT permissions to the datamodifier role. Add all users to the role.C.Deny INSERT, UPDATE, and DELETE permissions for all users. Create stored procedures that modify data in all tables except lookup tables. Require users to modify data through these stored procedures.D.Create a view of the lookup tables. Use the view to allow users access to the lookup tables.
If DB2 detects a deadlock between application A and application B (each waiting for a lock held by the other one), what action will DB2 take?()A、Rollback the transaction in both applications.B、Rollback the transaction in one of the two applications.C、Decrease the lock timeout value for both applications, thereby causing a lock timeout situation.D、Send a message to let the administrator know of the situation and decide which application or applications should be terminated.
When a system has both online transaction processing as well as large batch processing, which of the following common procedures will best help to improve system performance?()A、 Boost the priority of batch jobs.B、 Schedule batch runs to reduce contention with OLTP.C、 Schedule OS maintenance such that it includes frequent application of PTFs.D、 Perform incremental backups of transaction processing and full backups of batch processing.
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.
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 tableB、object tableC、external tableD、clustered tableE、global temporary tableF、index-organized table (IOT)
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 replayB、SQL Tuning AdvisorC、SQL Access AdvisorD、SQL Performance AnalyzerE、Automatic Workload Repository compare reports
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、REBUILDB、CASCADEC、TRUNCATED、ROW MOVEMENTE、SHRINK SPACE COMPACTF、SHRINK SPACE CASCADE
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 clustersB、index clustersC、partitioned tablesD、indexorganized table (IOT)
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.
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.
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.
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.
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.
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.
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.
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).
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.
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 OUB、Repackage and re-deploy the application's .mst file to the Sales OUC、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.
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.
单选题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 REBUILDB CASCADEC TRUNCATED ROW MOVEMENTE SHRINK SPACE COMPACTF SHRINK SPACE CASCADE
单选题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?()ADatabase replayBSQL Tuning AdvisorCSQL Access AdvisorDSQL Performance AnalyzerEAutomatic Workload Repository compare reports
单选题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 tableB Object tableC External tableD Clustered tableE Global temporary tableF Index-organized table (IOT)
单选题When a system has both online transaction processing as well as large batch processing, which of the following common procedures will best help to improve system performance?()A Boost the priority of batch jobs.B Schedule batch runs to reduce contention with OLTP.C Schedule OS maintenance such that it includes frequent application of PTFs.D Perform incremental backups of transaction processing and full backups of batch processing.
单选题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?()AModify the application settings by using the Web Site Administration Tool.BModify the application settings by using the Visual Studio property page editor for the project.CModify the application settings by using the resource editor.DModify the application settings by using the Visual Studio start options editor.
单选题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?()Aheap tableBobject tableCexternal tableDclustered tableEglobal temporary tableFindexorganized table (IOT)
单选题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?()AREBUILDBCASCADECTRUNCATEDROW MOVEMENTESHRINK SPACE COMPACTFSHRINK SPACE CASCADE