When choosing a distribution key for a large fact table, what is a valid choice?
any column used in table constraints
any column with low cardinality
a technical or surrogate key
any date column commonly used in queries
The nzhostbackup command backs up which directory by default?
/nz/data/
/nzscratch/
/ex port/ho me/nz
/nz/kit/
What are two primary purposes of UDX?
it is a required component of all Netezza SQL commands
to force execution only on the SPU nodes
to offer new and unique types of analyses through customized code
to showcase one's capability to write UDX code to duplicate existing SQL functions
to accelerate analysis by processing data in-database
How can a user update statistics on a table?
by running UPDATE STATISTICS
by running a query against the table
by running GENERATE STATISTICS
by restarting the database
TESTED 05 Dec 2024
Copyright © 2014-2024 DumpsTool. All Rights Reserved