IBM IBM Certifications P2090-047 Questions & Answers

• Question 111:

  Given the following query: Select count(*) from TableA; How can you view the query plan without executing the query?

  A. Use explain.

  B. Use statistics.

  C. Use pg.log file.

  D. Set show_plan = true;

  Correct Answer: A

• Question 112:

  TableA is currently being accessed in a number of long running queries. Which of the following operations is NOT blocked, thus allowing the operation to immediately proceed?

  A. DROP TABLE TableA

  B. ALTER TABLE TableA

  C. TRUNCATE TABLE TableA

  D. GRANT SELECT ON TableA TO UserA

  Correct Answer: D

• Question 113:

  Which is a function of the Linux-HA heartbeat?

  A. Performs regeneration of failed disks on the hosts.

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

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

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

  Correct Answer: D

• Question 114:

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

  A. AIX-HA

  B. Linux-HA

  C. SuSE-HA

  D. Solaris-HA

  Correct Answer: B

• Question 115:

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

  A. Disk resets or fails.

  B. Host resets or fails.

  C. S-Blade resets or fails.

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

  Correct Answer: A

• Question 116:

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

  A. One fan fails.

  B. One disk fails.

  C. Active host fails.

  D. One power supply fails.

  Correct Answer: C

• Question 117:

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

  A. The typical or most common types of queries.

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

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

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

  Correct Answer: D

• Question 118:

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

  A. Create an nzcron event.

  B. nzstop/nzstart the database.

  C. Stop and start the appliance.

  D. Add entry to active host and standby host.

  Correct Answer: D

• Question 119:

  When is the ToplogyImbalance event triggered?

  A. When a SAS switch has failed.

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

  C. When a disk enclosure's voltage sensor is reading outside the nominal range.

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

  Correct Answer: D

• Question 120:

  Which component failure does NOT trigger a HardwareServiceRequested event?

  A. Fan

  B. Disk

  C. Host

  D. S-Blade

  Correct Answer: C