P2090-047 by IBM Actual Free Exam Questions And Answers

IBM PureData System for Transactions Technical Mastery Test v1 - P2090-047 Exam Practice Test

Question 1

What is the only predefined database user, which is able to access all objects and perform all tasks against the database?

A. root

B. public

C. system

D. admin

Discussion 0

Correct Answer: D Vote an answer

Question 2

If data is being nzload'ed into TableA, which of the following operations will be blocked until the load has completed?

A. A SELECT from TableA

B. A TRUNCATE of TableA

C. A DELETE from TableA

D. An nzbackup of the database in which TableA resides

Discussion 0

Correct Answer: B Vote an answer

Question 3

What will prevent a GROOM TABLE command from running on a table named TableA?

A. If there are any active nzloads running against the table TableA.

B. If there are any active updates running against the table TableA.

C. If there are any active selects running against the table TableA.

D. If there are any materialized views on the table Table

Discussion 0

Correct Answer: D Vote an answer

Question 4

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

A. FLOAT8

B. NUMERIC(38,0)

C. BIGINT

D. VARCHAR(256)

Discussion 0

Correct Answer: C Vote an answer

Question 5

When are zonemaps initially created for a table?

A. CREATE TABLE

B. nzreclaim

C. nzbackup

D. ALTER TABLE ADD ZONEMAPS

Discussion 0

Correct Answer: A Vote an answer

Question 6

nzload is invoked with the "allowReplay" option enabled. While the PureData System for Analytics Appliance changes state from online to pausing then to online, which statement is true about the nzload process on the Appliance?

A. nzload must be stopped and resumed by the user from the last check point.

B. nzload automatically continues without user intervention.

C. nzload will fail.

D. nzload automatically restarts but the user must remove the allowReplay option.

Discussion 0

Correct Answer: B Vote an answer

If you have any question please leave me your email address, we will reply and send email to you in 12 hours.

Our Working Time: ( GMT 0:00-15:00 ) From Monday to Saturday

Support:

Contact now

IBM PureData System for Transactions Technical Mastery Test v1 - P2090-047 Exam Practice Test

Contact Us

Useful Links

Latest Updated