Friday, 24 July 2009

Performance Tuning - Question 015

Which of these tuning goals are appropriate for a data warehouse system?

A. Improve the performance of specific SQL statements

B . Subsecond response time

C . High data concurrency

D . 24x7 availability

Explanation:

Answer A:In a Data data Warehouse warehouse system, specific SQL statement performance, accuracy, and availability are key tuning issues. Sub-second response times, 24x7 availability, and high data concurrency are usually requirements for an OLTP system.

No comments:

Post a Comment