C1000-085 無料問題集「IBM Netezza Performance Server V11.x Administrator」

（A）Create a copy of FACT_SALES table with zip_code as integer data type.

（B）CREATE ORGANIZED view for FACT_SALES table

（C）alter table fact_sales to organize on zip_code. followed by groom.

（D）Create a view with a typecast to integer and use view for query purposes

（A）by running UPDATE STATISTICS

（B）by running a query against the table

（C）by restarting the database

（D）by running GENERATE STATISTICS

（A）NPS Backup and Restore

（B）Cloud Pak for Data

（C）InfoSphere Data Replication

（D）Data Serialization

（E）Netezza Replication Services

（A）The number of snippets depends on query and complexity.

（B）Every query is always turned into four snippets.

（C）Every query is always turned into one snippet.

（D）The number of snippets is always based on the size of the system.

（A）GROOM uses CREATE TABLE AS SELECT (CATAS) for CBT to reclaim space and re-order data.

（B）It reclaims space from deleted rows and re-orders data.

（C）It reclaims space from deleted rows and does not re-order data

（D）Enough space is required for GROOM to make a complete copy of the table

（A）32.000

（B）16.000

（C）65.535

（D）64,000