What is the optimal architecture to use when accessing the data warehouse?

A company builds massive data warehouses for customers using proprietary database software
that until recently, ran on proprietary hardware for added speed. The warehouse software is

accessed from Java code using a JDBC driver that exposes the warehouse functionality as a
combination of ANSI SQL-99 syntax coupled with some company-specific extensions.
Performance of queries is important to both the company’s management and its customers. It has
a team of 20 developers who are considered experts in the data warehouse. What is the optimal
architecture to use when accessing the data warehouse?

A company builds massive data warehouses for customers using proprietary database software
that until recently, ran on proprietary hardware for added speed. The warehouse software is

accessed from Java code using a JDBC driver that exposes the warehouse functionality as a
combination of ANSI SQL-99 syntax coupled with some company-specific extensions.
Performance of queries is important to both the company’s management and its customers. It has
a team of 20 developers who are considered experts in the data warehouse. What is the optimal
architecture to use when accessing the data warehouse?

A.
Session beans using ORM

B.
Session beans using a JDBC connection pool

C.
Session beans using EJB 2.x CMP entity beans

D.
Session beans using EJB 2.x BMP entity beans with JPA



Leave a Reply 0

Your email address will not be published. Required fields are marked *