最新のP2090-050問題集で試験を準備する

IBM P2090-050 試験概要:

IBM P2090-050 試験シラバストピック:

IBM PureData System for Analytics Technical Mastery Test v1 認定 P2090-050 試験問題：

問題 #1

Which statement is true about optimizer settings?

A. They can be set system wide only.
B. They can be set at the database level only.
C. They can be set at the session and at the group level.
D. They can be set system wide and at the session level.

問題 #2

nzbackup/nzrestore with the -user option has been replaced with which option to allow multi-level security (MLS) information, suchas categories, cohorts, and levels to be backed up/restored?

A. -all
B. -globals
C. -users
D. -mls

問題 #3

Which will result in support for zonemaps on the LastName column?

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));
C. CREATE TABLE TableA (LastName VARCHAR(20));
ALTER TABLE TableA ZONEMAP ON (LastName);
D. CREATE TABLE TableA (LastName VARCHAR(20)) DISTRIBUTE ON (LastName);

問題 #4

Which statement is true about data flowing in/out of the PureData System for Analytics Appliance?

A. Flows through the host.
B. Compressed on the host.
C. Uncompressed on the host.
D. Bypasses the host.

問題 #5

What is true about queries submitted on the PureData System for Analytics Appliance?

A. Queries are consolidated by the host and executed together in one block.
B. Queries are uncompressed by the host and sent to the user.
C. Queries are compiled by the host and executed in parallel by the S-Blades.
D. Queries are compressed by the host and optimized for parallel processing.

解説：