IBM IBM Certifications P2090-050 Questions & Answers

• Question 101:

  Which two statements are trueabout queries on the PureData System for Analytics Appliance? (Choose two.)

  A. Queries are executed in parallel by the host.

  B. Queries must be compressed before they can be executed.

  C. Queries are compiled into snippets and executed in parallel by the S-Blades.

  D. Queries must be uncompressed by the user and executed in parallel by the host.

  E. A query is compiled into a snippet which is executed across all available S-Blades.

  Correct Answer: CE

• Question 102:

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

  A. Bypasses the host.

  B. Flows through the host.

  C. Compressed on the host.

  D. Uncompressed on the host.

  Correct Answer: B

• Question 103:

  Why is table skew important to manage?

  A. Low table skew negatively impacts performance.

  B. High table skew negatively impacts performance.

  C. Low table skew negatively impacts data compression.

  D. Deleted rows consume disk space until they are freed.

  Correct Answer: B

• Question 104:

  Which statement is true regarding the compress engine?

  A. Data automatically gets compressed.

  B. Columns to be compressed must be defined.

  C. The nzcompress utility must be run to compress the table.

  D. The nzcompress utility must be run to compress thedatabase.

  Correct Answer: A

• Question 105:

  What will occur when two tables are joinedtogether and the data is NOT collocated?

  A. No data movement is required.

  B. A merge join operation will be performed.

  C. A cluster based join method is performed.

  D. Data is dynamically redistributed or broadcasted.

  Correct Answer: D

• Question 106:

  When a temporary table is created, where will the data be stored?

  A. On the host under the /nz/tmp directory.

  B. On the S-Blades under the data partition.

  C. Held in physical memory on the S-Blades.

  D. On the S-Blades under the swap partition.

  Correct Answer: B

• Question 107:

  If 'admin' user is running a query, what percentage of resources are available when Guaranteed Resource Allocation (GRA) is Enabled?

  A. The maximum GRA assigned to the ADMINgroup.

  B. The maximum GRA assigned to the PUBLIC group.

  C. 100% of the resources while other resource groups are active.

  D. Typically half of the resources while other resource groups are active.

  Correct Answer: D

• Question 108:

  What CANNOT be measured and managed by system views?

  A. Temperature values on S-blade.

  B. Status of the host attached storage.

  C. Power supply status for each frame.

  D. Resource group utilization and history.

  Correct Answer: B

• Question 109:

  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 110:

  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