IBM PureData System for Transactions Technical Mastery Test v1 - P2090-047 FREE EXAM DUMPS QUESTIONS & ANSWERS]

Question 1

When is the ToplogyImbalance event triggered?

A. When the path the path between an S-Blade and its disks has failed. B. When an S-Blade has ownership of more dataslices than is optimal (usually following a disk replacement). C. When a disk enclosure's voltage sensor is reading outside the nominal range. D. When a SAS switch has failed.

Discussion 0

Correct Answer: B Vote an answer

Question 2

Which statement is true about data flowing in/out of the PureData System for Analytics Appliance?

A. Flows through the host. B. Uncompressed on the host. C. Bypasses the host. D. Compressed on the host.

Discussion 0

Correct Answer: A Vote an answer

Question 3

The primary copy of a dataslice is spread across how many disks?

A. 12. B. 2. C. 4. D. 1.

Discussion 0

Correct Answer: D Vote an answer

Question 4

Which two characteristics describe materialized views. (Choose two.)

A. Materialized views can contain aggregates. B. Materialized views can contain a WHERE clause. C. Materialized views can contain a HAVING clause. D. Materialized views can reference only one base table in the FROM clause. E. Materialized views can contain an ORDER BY clause.

Discussion 0

Correct Answer: D,E Vote an answer

Question 5

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

A. The queries submitted by specific users or groups of users. B. The typical or most common types of queries. C. The rotational speed of the disk drives during query execution. D. The longest and shortest running queries on the system.

Discussion 0

Correct Answer: C Vote an answer

Question 6

What function can nzbackup perform?

A. Back up the data using the specified number of streams. B. Back up host data (catalog metadata). C. Back up TEMP tables. D. Back up pg.log files.

Discussion 0

Correct Answer: A Vote an answer

Question 7

A group has a resource allocation maximum of 50% and the job maximum is set to 1. Two users within this resource group each execute 1 job at the same time, which statement is correct?

A. Each job gets 25% and both run at the same time. B. You cannot set the job maximum per resource group. C. Each job gets 50% but only one job runs at a time. D. Each job gets 50% and both run at the same time.

Discussion 0

Correct Answer: C Vote an answer

Question 8

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.)

A. PRIMARY KEY B. UNIQUE C. NULL D. DEFAULT value E. NOT NULL

Discussion 0

Correct Answer: A,B Vote an answer

Question 9

Which statement is true about the groom feature?

A. Groom allows the user to reorganize tables based on the ORGANIZE ON clause. B. Groom validates primary key constraints on the table. C. Groom allows the user to add row level security. D. Groom reorders rows based on the DISTRIBUTE ON clause.

Discussion 0

Correct Answer: A Vote an answer