Which of the following is NOT a Prioritized Query Execution priority level? A. Low B. High C. Urgent D. Critical E. Normal

What command would you use to create a query history database? A. nzdb B. nzsql C. nzhistcreatedb D. nzdatacreatedb

The optimizer estimates cost in units of: A. Seconds (e.g. 1=1 second) B. Tenths of seconds (e.g. 10 = 1 second) C. Hundredths of seconds (e.g. 100 = 1 second) D. Thousandths of seconds (e.g. 1000 = 1 second)

When setting up a crontab entry, what must be done on a Pure Data System for Analytics server? A. Pause the appliance B. Create an nzcron event C. Stop and start the appliance D. Add a file entry to both…

What is the definition of appliance topology? A. The ratio of CPU cores to FPGAs to disk drives B. The model number of the appliance, e.g, N1000 C. The map showing which SPUs manage which data slices D. The number…

Which High-Availability (HA) mechanism is used by the PureData System for Analytics Appliance? A. AIX-HA B. Linux-HA C. SuSE-HA D. Solaris-HA

Which statement about nzrestore is NOT true? A. nzrestore can restore selected tables B. nzrestore can perform a redirected restore C. nzrestore can restore from an nzbackup UNIX pipe D. nzrestore can restore to a different Pure Data System for…

Which statement about the GROOM feature is TRUE? A. GROOM requires space to make a complete copy of the table B. GROOM prevents nzload from inserting data while in progress C. GROOM only operates on tables that include an ORGANIZE…

Which of the following statements is TRUE? A. Each table is assigned its own set of data slices B. Each database is assigned its own set of data slices C. When creating a database the maximum allowed space can be…

Which will guarantee that a zonemap is generated for the NAME column? A. CREATE TABLE customer (name VARCHAR(20)); B. CREATE TABLE customer (name VARCHAR(20)); ALTER TABLE customer ZONEMAP ON (name); C. CREATE TABLE customer (name VARCHAR(20)) DISTRIBUTE ON (name); D.…