最新的IBM PureData System for Analytics Technical Mastery Test v1 - P2090-050免費考試真題

A. Work Load Management

B. High Concurrency

C. High Availability

D. Load Balancing

A. The table is reorganized on the ORGANIZE ON clause.

B. The table is redistributed on the DISTRIBUTE ON clause.

C. The table is redistributed on the ORGANIZE ON clause.

D. The table is reorganized on the DISTRIBUTE ON clause.

A. nzevents and the pg.log.

B. nzdumpschema and the execution plan.

C. nzinventory and the dbos.log.

D. nzsql andthe ODBC config.

A. Compression is performed by the host.

B. Compression is performed by the SAS switches.

C. Compression degrades data scan speeds.

D. Compression ratio is data dependent.

A. CREATE TABLE TableA (LastName VARCHAR(20));
CREATE MATERIALIZED VIEW ViewA AS SELECT * FROM TableA ORDER BY
LastName;

B. CREATE TABLE TableA (LastName VARCHAR(20)) DISTRIBUTE ON (LastName);

C. CREATE TABLE TableA (LastName VARCHAR(20));

D. CREATE TABLE TableA (LastName VARCHAR(20));
ALTER TABLE TableA ZONEMAP ON (LastName);

A. Materialized views can reference only onebase table in the FROM clause.

B. Materialized views can contain a HAVING clause.

C. Materialized views can contain aggregates.

D. Materialized views can contain an ORDER BY clause.

E. Materialized views can contain a WHERE clause.

A. It accepts exactly one input value and produces exactly one output value.

B. It accepts zero or more input values but produces one output value.

C. It accepts zero or more input values and produces one or more output values.

D. it accepts exactly one input value and produces one or more output values.