IBM PureData System for Analytics Technical Mastery Test v1 (P2090-050) Free Practice Test

Question 1

Which statement describesadministrative privileges?

A. Manages resource allocations for concurrent processing.

B. Gives additional storage to select members of the administrator group.

C. Gives permission to execute global operations and to create objects.

D. Provides audit functionality for the database.

Correct Answer: C

Question 2

Which two commands can be used to shut the database system down? (Choose two.)

A. service halt nps

B. nzhw stop

C. nzdown

D. nzsystem stop

E. nzstop

Correct Answer: D,E

Question 3

Which statement is true about optimizer settings?

A. They can be set at the database level only.

B. They can be set system wide and at the session level.

C. They can be set at the session and at the group level.

D. They can be set system wide only.

Correct Answer: B

Question 4

You have access to two databases, DEV and PROD. Currently you are connected to the DEV database. Which operation is permitted?

A. Delete from PROD..TableA

B. Insert into PRO.TableA select * from DEV..TableB

C. Select * from PROD..TableA

D. Truncate table PROD..TableA

Correct Answer: C

Question 5

The PureData System for Analytics implements which level of transaction isolation?

A. Uncommitted read

B. Repeatable read

C. Serializable

D. Committed read

Correct Answer: C

Question 6

Using a date column as a distribution key may distribute rows evenly across dataslices, why is this a poor choice of a distribution key?

A. Queries on date range will utilize only host processing.

B. Queries on date range may involve processing skew.

C. Queries on the table will invoke compression.

D. Queries on the table will invoke compression on the date columns.

Correct Answer: B

Question 7

What is the naming convention for system views?

A. sys_v_...

B. nz_v_...

C. _$v_...

D. _v_...

Correct Answer: D

Question 8

When unloading data via an external table, where can the SQL be submitted?

A. From nzsql on Microsoft Windows networked to the system.

B. From a User Defined Function.

C. From nzsql on an AIX machine networked to the system.

D. From an ODBC application on Windows networked to the system.

Correct Answer: D

Question 9

When doing a CREATE SEQUENCE, the largest "maximum value" is based onwhat?

A. VARCHAR(256)

B. NUMERIC(38,0)

C. FLOAT8

D. BIGINT

Correct Answer: D

Welcome to TestSimulate

IBM PureData System for Analytics Technical Mastery Test v1 (P2090-050) Free Practice Test