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

Question 1

After performing a groom on a clustered base table, which statement is true?

A. The table is redistributed on the ORGANIZE ON clause. B. The table is redistributed on the DISTRIBUTE ON clause. C. The table is reorganized on the DISTRIBUTE ON clause. D. The table is reorganized on the ORGANIZE ON clause.

Discussion 0

Correct Answer: D Vote an answer

Question 2

What is the state of the two hosts on a properly functional PureData System for Analytics Appliance?

A. Stand by - Passive B. Active - Active C. Stand by -Backup D. Active - Stand by

Discussion 0

Correct Answer: D Vote an answer

Question 3

What operating system runs ona PureData System for Analytics host?

A. SUSE Linux B. Nucleus OS C. Redhat Linux D. AIX

Discussion 0

Correct Answer: C Vote an answer

Question 4

When unloading data via an external table, where can the SQL be submitted?

A. From nzsql on an AIX machine networked to the system. B. From an ODBC application on Windows networked to the system. C. From nzsql on Microsoft Windows networked to the system. D. From a User Defined Function.

Discussion 0

Correct Answer: B Vote an answer

Question 5

What will prevent a GROOM TABLE command from running on a table named TableA?

A. If there are any active nzloads running againstthe table TableA. B. If there are any materialized views on the table Table C. If there are any active updates running against the table TableA. D. If there are any active selects running against the table TableA.

Discussion 0

Correct Answer: B Vote an answer

Question 6

You havecreated a group GroupA with JOB MAXIMUM of 4, which statement is true?

A. If users in GroupA submit more than 4 queries they will fail. B. If users in GroupA submit more than 4 queries, then they will queue in order. C. The job maximum cannot be less than the default concurrent query limit of 48. D. No more than 4 users can be assigned to Group

Discussion 0

Correct Answer: B Vote an answer

Question 7

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

A. Set show_plan = true; B. Use pg.log file. C. Use statistics. D. Use explain.

Discussion 0

Correct Answer: D Vote an answer

Question 8

On which component(s) does the UDX run?

A. The host, the S-blades and theFPGAs. B. The host only. C. The S-blades and the FPGAs only. D. The host and the S-blades only.

Discussion 0

Correct Answer: D Vote an answer