[Free] 2018(Jan) EnsurePass Dumpsleader IBM P2090-050 Dumps with VCE and PDF 71-80

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released P2090-050
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/P2090-050.html

IBM PureData System for Analytics Technical Mastery Test v1

Question No: 71 – (Topic 2)

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

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

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

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

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

CREATE MATERIALIZED VIEW ViewA AS SELECT * FROM TableA ORDER BY

LastName;

Answer: D

Question No: 72 – (Topic 2)

What is the maximum number of columns you can choose as organizing keys for clustered base table?

  1. 1

  2. 2

  3. 4

  4. 8

Answer: C

Question No: 73 – (Topic 2)

Which clause CANNOT be used with a CREATE VIEW statement?

  1. SUM ()

  2. GROUP BY

  3. ORDER BY

  4. OUTER JOIN

Answer: C

Question No: 74 – (Topic 2)

When doing a CREATE TABLE, constraints can be specified at the column level. Which two constraints are NOT automatically enforced via the database? (Choose two.)

  1. NULL

  2. UNIQUE

  3. NOT NULL

  4. PRIMARY KEY

  5. DEFAULT value

Answer: B,D

Question No: 75 – (Topic 2)

Which statement is true regarding any database user?

  1. The user has a table spacedefined.

  2. The user can be assigned to more than one group.

  3. The user must have a corresponding host account.

  4. The user can be removed from the default PUBLIC group.

Answer: B

Question No: 76 – (Topic 2)

What is the function of the Distributed Replicated BlockDevice (DRBD)?

  1. High Availability

  2. Load Balancing

  3. High Concurrency

  4. Work Load Management

Answer: A

Question No: 77 – (Topic 2)

Which statement is true about a simple load using external tables?

  1. The load can be configured to automatically continue toload if the S-Blade resets or fails.

  2. The load can be configured to automatically create a backup file of the table being loaded.

  3. The load can be configured to automatically create a duplicate copy of the table being loaded.

  4. The load can be configured to automatically remove duplicate rows from the table being loaded.

Answer: A

Question No: 78 – (Topic 2)

What is the state of the two hosts on a properly functional PureData System for Analytics Appliance?

  1. Active – Active

  2. Active – Stand by

  3. Stand by -Backup

  4. Stand by – Passive

Answer: B

Question No: 79 – (Topic 2)

nzload is invoked with the quot;allowReplayquot; 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?

  1. nzload will fail.

  2. nzload automatically continues without user intervention.

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

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

Answer: B

Question No: 80 – (Topic 2)

What is the naming convention for system views?

A. _v_…

B. nz_v_…

C. _$v_…

D. sys_v_…

Answer: A

100% Ensurepass Free Download!
Download Free Demo:P2090-050 Demo PDF
100% Ensurepass Free Guaranteed!
P2090-050 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.