hash clusters
index clusters
partitioned tables
indexorganized table (IOT)
第1题:
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.
第2题:
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?()
第3题:
A.invitation
B.introduction
C.requirement
D.application
第4题:
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?()
第5题:
If you want to reset your configuration back to the factory defaults but keep your logs and reports,Which CLI command should you use?()
第6题:
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.A
B.B
C.C
D.D
第7题:
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?()
第8题:
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
第9题:
What is a prerequisite for using the application availability analysis tool in HACMP?()
第10题:
Using the reports server how would you force the orders report in the orders entry application to run every six hours?()