单选题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?()Ahash clustersBindex clustersCpartitioned tablesDindex­organized table (IOT)

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


参考解析

解析: 暂无解析

相关考题:

You can ask for an () lateter if you want your parents come for your graduation ceremony A.invitationB.introductionC.requirementD.application

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 SQL Server 2000 computer. Your company purchased an accounting application from a vendor. The application stores its data in a database named Accounting on the server. The tables in this database contain columns that function as primary keys, but PRIMARY KEY and FOREIGN KEY constraints are not used.You need to replicate data from this database to another SQL Server computer. This server will use the replicated data to generate reports. Most reports will run each month, but the accounting department needs to have the ability to run reports at any time. Reports should be accurate through the last full working day.You cannot make any changes to the database, but you need to implement replication. Which two actions should you take? (Each correct answer presents part of the solution. Choose two)A.Implement merge replication.B.Implement snapshot replication.C.Implement transactional replication.D.Schedule replication to run continuously.E.Schedule replication to run during off-peak hours.

You administer your company‘s network. All client computers run Microsoft Windows Vista. A standard user reports that they are unable to install an application. You need to install the applicatin.What should you do?()A.AB.BC.CD.D

You work as a Web Developer at Certkiller.com. You are in the process of creating a Webapplication using Microsoft ASP.NET 3.5.  You host the Web application in Microsoft Internet Information Services (IIS) 6.0. You browse theapplication and receive the following error message:  Server Application Unavailable  The web application you are attempting to access on this web server is currently unavailable.Please hit the "Refresh" button in your web browser to retry your request.  You view the Application event log and discover the following message:  It is not possible to run two different versions of ASP.NET in the same IIS process. Please use theIIS Administration Tool to reconfigure your server to run the application in a separate process.  To ensure productivity you need to solve this problem as quick as possible.  What should you do?()A、You should change the IIS isolation mode.B、You should assign the application to another application pool.C、You should configure all applications that are part of your application's application pool in orderto use the same version of ASP.NET.D、You should run the Aspnet_regiis.exe Tool.E、You should restart the application pool that hosts the 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)

If you want to reset your configuration back to the factory defaults but keep your logs and reports,Which CLI command should you use?()A、resetconfigB、restoreconfigC、loadconfigD、reload

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)

Using the reports server how would you force the orders report in the orders entry application to run every six hours?()A、Schedule the report's execution in the queue manager. B、Schedule the reports execution using the R30RQM command line with scheduled parameter. C、Create a trigger in the application to execute the report every six hours. D、You cannot schedule a reports execution.

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 find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance.  Which advisory component would you refer to, in order to determine the appropriate indexes?() A、Memory AdvisorB、Segment AdvisorC、SQL Access AdvisorD、Automatic Workload Repository (AWR)E、Automatic Database Diagnostic Monitor (ADDM)

You recently installed an application on your computer. The application is configured to automatically start. This application might cause your computer to run slower.  You need to prevent the application from auto starting without uninstalling the application.  What should you do?()A、Use the Microsoft Windows Task Manager application to end the task for the application.B、Use the Control Panel application to uninstall the application. Reboot the computer.C、Use the Software Explorer application to disable the application. Reboot the computer.D、Use the Services application to disable the Application Experience service, and then launch the application.

You administer your companys network. All client computers run Microsoft Windows Vista. A standard user reports that they are unable to install an application. You need to install the application.  What should you do? ()A、While the standard user is logged on, at the consent prompt, click Continue and install the application.B、While the standard user is logged on, at the credential prompt, provide administrative credentials.C、Create a .pwl file that stores administrative credentials. Double-click the installation file.D、Copy the contents of the CD-ROM to the local hard disk. Run the application installation from  the local hard disk.

You are the desktop administrator for your company. Your company’s software developers use Windows XP Professional and IIS on their client computers to develop Web-based applications. All client computers use Microsoft Internet Explorer 6. 0 or later as their Web browser. One of the developers reports that he can no longer access the Web-based application on his desktop by using his Web browser. When you attempt to access the application by using your Web browser, you receive the following error message: “Cannot find server or DNS Error.” You verify that the World Wide Web Publishing Service is started on the developer’s computer. You also verify that you are using the correct URL to access the developer’s computer by using your Web browser. You need to ensure that the developer can access the Web application by using his Web browser. How should you configure the developer’s computer?() A、Start the default Web site.B、Start the IIS Admin Service.C、Run the IPconfig /registerdns command.D、In the default Web site properties,disable the host header setting.

You need to generate the utilization report for the application servers. What should you use to generate the report?()A、Microsoft Assessment and Planning Toolkit (MAP)B、Microsoft Desktop Optimization Pack (MDOP)C、Microsoft System Center Virtual Machine ManagerD、Microsoft System Center Operations Manager

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

单选题You use Microsoft Visual Studio 2010 and Microsoft .NET Framework 4 to create a Windows Presentation Foundation (WPF) application. The application contains a custom control that is used to display customer information. You discover that the custom control is not rendering correctly. You need to identify the WPF element that is causing the issue. You want to achieve this goal by using the minimum amount of administrative effort. What should you do?()AStart the application in debug mode.Place a breakpoint at the main entry point of the application.Use the debugger to step through the application code.BStart the application in debug mode.Place a breakpoint at the main entry point of the application.Use the WPF Tree Visualizer tool.CEnable IntelliTrace and configure Visual Studio to generate a trace log.Start the application in debug mode.DEnable IntelliTrace and configure Visual Studio to generate a trace log.Start the application by double-clicking the executable file (.exe).

单选题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?()Ahash clustersBindex clustersCpartitioned tablesDindex­organized 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 tableB Object tableC External tableD Clustered tableE Global temporary tableF Index-organized table (IOT)

单选题You have created an Oracle 10g database named SALES, which will be used by an application named SalesOrders. Users of the SalesOrders application complain that application response time is slow when they generate reports. The SalesOrders application accesses a table that contains 10 million rows. You decide to create an index on this table using the NOLOGGING option so that the index creation process is completed in the least amount of time. Which of the following is NOT true about an index created with the NOLOGGING option?()A The index can be changed from NOLOGGING to LOGGINGB The index cannot be recovered even in the ARCHIVELOG mode.C The index can only be created if the base table is created with the NOLOGGING option.D The index can be recovered if you perform a backup after the CREATE INDEX statement.

多选题You are designing a Windows Azure web application.  All users authenticate by using their Active Directory Domain Services (AD DS) credentials.  You need to recommend an approach for enabling single sign-on for domain-authenticated users.   Which two actions should you recommend?()AUse Forms authenticationto generate claims.BUse Active Directory Federation Services (AD FS) to generate claims.CUse SqlMembershipProvider in the web application.DUse Windows Identity Foundation in the web application.

单选题You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance.  Which advisory component would you refer to, in order to determine the appropriate indexes?()AMemory AdvisorBSegment AdvisorCSQL Access AdvisorDAutomatic Workload Repository (AWR)EAutomatic Database Diagnostic Monitor (ADDM)

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

单选题You find that the execution time of reports in your datawarehouse application is significantly high. You suspect the lack of indexes to be the reason for the degradation in performance. Which advisory component would you refer to, in order to determine the appropriate indexes?()A Memory AdvisorB Segment AdvisorC SQL Access AdvisorD Automatic Workload Repository (AWR)E Automatic Database Diagnostic Monitor (ADDM)

单选题In order to achieve his objectives, your boss expects that you will _____.Ado your best in your workBshow your management skillsCget along with your colleaguesDwrite reports to upper management

单选题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 tableFindex­organized table (IOT)

单选题You are the desktop administrator for your company's sales department. The IT manager for the sales department needs to distribute a custom application to the Windows XP Professional computers in the sales department. He deploys the software by using Group Policy. Susan is a user in the sales department. She reports that the custom application is not available. You examine her computer, and you verify that the application is not present on her computer. You want to ensure that the software is deployed the next time Susan logs on. Which command should you run?()ASecedit /refreshpolicy user_policy /enforceBSecedit /refreshpolicy machine_policy /enforceCGpupdate /target:computer /syncDGpupdate /target:user /sync