Discuss the main tasks associated with the administration and management of a data warehouse.
What will be an ideal response?
The data warehouse administration and management tools must be capable of supporting the
following tasks:
? monitoring data loading from multiple sources;
? data quality and integrity checks;
? managing and updating meta-data;
? monitoring database performance to ensure efficient query response times and resource
utilization;
? auditing data warehouse usage to provide user chargeback information;
? replicating, subsetting, and distributing data;
? maintaining efficient data storage management;
? purging data;
? archiving and backing-up data;
? implementing recovery following failure;
? security management.
You might also like to view...
In CentOS 7, if you need to create a mount point on the current file system you should first create a directory in the file system using the which command?
A. mkdir B. mkfs C. fdisk D. mount
Social bookmarking sites are sometimes called social ________ sites
A) news B) recipe C) do-it-yourself D) image
Answer the following statement(s) true (T) or false (F)
1. Photoshop does not allow you to save composite images. 2. Photoshop CS6 is available for the PC, but not for the Macintosh computer system as of this writing. 3. When Photoshop launches, it does not open a photo by default. 4. As you work in Photoshop, the panels, the selected tool, and the options bar settings are unlikely to change. 5. Most buttons on the options bar in the accompanying figure display words or images to help you remember their functions.
An advantage to naming a range of cells is that you can use the name in a:
A) lookup table. B) table array. C) formula. D) data table.