[Free] 2018(Jan) Dumps4cert Testking IBM P2090-050 Dumps with VCE and PDF 11-20

Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Jan IBM Official New Released P2090-050
100% Free Download! 100% Pass Guaranteed!

IBM PureData System for Analytics Technical Mastery Test v1

Question No: 11 – (Topic 1)

Given a plan ID, how would you obtain the query execution plan? (Choose two.)

  1. Turn ODBC tracing ON.

  2. Issue quot;SELECT * FROM _V_SESSION;quot;

  3. Go to the query history within the Windows NzAdmin GUI tool.

  4. Run EXECUTION PLAN before the query has been submitted.

  5. Issue quot;SHOW PLANFILE lt;nngt;;quot; after the query has been submitted.

Answer: C,E

Question No: 12 – (Topic 1)

When is the ToplogyImbalance event triggered?

  1. When a SAS switch has failed.

  2. When the path the path between an S-Blade and its disks has failed.

  3. When a disk enclosure#39;s voltage sensor is reading outside the nominal range.

  4. When an S-Blade has ownership of more dataslices than is optimal (usually following a disk replacement).

Answer: D

Question No: 13 – (Topic 1)

Which component failure does NOT trigger a HardwareServiceRequested event?

  1. Fan

  2. Disk

  3. Host

  4. S-Blade

Answer: C

Question No: 14 – (Topic 1)

Which statement describesadministrative privileges?

  1. Provides audit functionality for the database.

  2. Manages resource allocations for concurrent processing.

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

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

Answer: C

Question No: 15 – (Topic 1)

The query history data collected DOES NOT provide insight to which of the type of performance and behavior questions?

  1. The typical or most common types of queries.

  2. The longest and shortest running queries on the system.

  3. The queries submitted by specific users or groups of users.

  4. The rotational speed of the disk drives during query execution.

Answer: D

Question No: 16 – (Topic 1)

When setting up a crontab entry, what must be done on a PureData Systemfor Analytics server?

  1. Create an nzcron event.

  2. nzstop/nzstart the database.

  3. Stop and start the appliance.

  4. Add entry to active host and standby host.

Answer: D

Question No: 17 – (Topic 1)

Which is a function of the Linux-HA heartbeat?

  1. Performsregeneration of failed disks on the hosts.

  2. Manages communication and processes on the S-Blades.

  3. Performs disk partitioning and status of jobs on the S-Blades.

  4. Manages communication and status of services on the hosts.

Answer: D

Question No: 18 – (Topic 1)

Which High-Availability (HA) mechanism is used by the PureData System for Analytics Appliance?

  1. AIX-HA

  2. Linux-HA

  3. SuSE-HA

  4. Solaris-HA

Answer: B

Question No: 19 – (Topic 1)

Which condition will NOT fail or restart a running query on a PureData System for Analytics Appliance?

  1. Disk resets or fails.

  2. Host resets or fails.

  3. S-Blade resets or fails.

  4. Snippet Processing Unit (SPU) resets or fails.

Answer: A

Question No: 20 – (Topic 1)

Which condition will interrupt a query running on a fully operational PureDataSystem for Analytics?

  1. One fan fails.

  2. One disk fails.

  3. Active host fails.

  4. One power supply fails.

Answer: C

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

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