IBM PureData System for Analytics v7.0 Set 3

Projects ✘ Restricts ✘ Aggregate ✘ Decompress ✔

To convert compressed external tables into ASCII text. ✘ To convert between character encodings before loading data. ✘ To translate stored procedures into NZPLSQL compatible syntax. ✘ To upgrade/downgrade the database to a different software version. ✔

nzevents and the pg.log. ✘ nzsql and the ODBC config. ✘ nzinventory and the dbos.log. ✘ nzdumpschema and the execution plan. ✔

When a SAS switch has failed. ✘ When the path the path between an S-Blade and its disks has failed. ✘ When a disk enclosure's voltage sensor is reading outside the nominal range. ✘ When an S-Blade has ownership of more dataslices than is optimal (usually following a disk replacement). ✔

The number of rows in the table. ✘ The number of updated rows in the table. ✘ The minimum and maximum value in each column. ✘ The number of unique or distinct values in each column. ✔

As many columns as possible. ✘ Columns that contain many nulls. ✘ Columns that contain few unique values. ✘ Columns used to join to other large tables. ✔

All user space is available for database expansion. ✘ Each database is assigned it's own section of disk space. ✘ When creating the database you can specify which disks to use. ✘ When you create a database you can set the maximum space it is allowed to use. ✔

Data is likely to negatively affect views. ✘ Data is likely to negatively affect compression. ✘ Data is likely to generate duplicate sequence values. ✘ Data is likely to be unevenly spread across the system. ✔

GROOM TABLE requires space to make a complete copy of the table. ✘ GROOM TABLE only operates on tables that include an ORGANIZE ON clause. ✘ GROOM TABLE prevents nzload from adding data while groom is in progress. ✘ GROOM TABLE allows UPDATE, DELETE, and INSERT operations to occur while groom is in progress. ✔