More DBA job interview questions and answers at
http://dba.fyicenter.com/Interview-Questions/
(Continued from previous question...)
WHAT EXACTLY IS A DBA? - Data Warehouse Administrator
Data Warehouse Administrator
Organizations that implement data warehouses for performing in-depth data analysis often staff DBAs specifically to monitor and support the data warehouse environment. Data warehouse administrators must be capable DBAs, but with a thorough understanding of the differences between a database that supports OLTP and a data warehouse. Data warehouse administration requires experience with the following:
*
Business intelligence, query, and reporting tools
*
Database design for read-only access
*
Data warehousing design issues such as star schema
*
Data warehousing technologies such as OLAP (including ROLAP, MOLAP, and HOLAP)
*
Data transformation and conversion
*
Data quality issues
*
Data formats for loading and unloading of data
*
Middleware
(Continued on next question...)