[Free] 2018(Jan) EnsurePass Pass4sure IBM P2090-047 Dumps with VCE and PDF 11-20

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released P2090-047
100% Free Download! 100% Pass Guaranteed!

IBM PureData System for Transactions 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 describes administrative 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 System for 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. Performs regeneration 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 PureData System for Analytics?

  1. One fan fails.

  2. One disk fails.

  3. Active host fails.

  4. One power supply fails.

Answer: C

100% Ensurepass Free Download!
Download Free Demo:P2090-047 Demo PDF
100% Ensurepass Free Guaranteed!
P2090-047 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
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

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