[Free] 2017(Jan) Latesttests Passguide IBM P2090-050 Dumps with VCE and PDF 21-30

Latesttests
2017 Jan IBM Official New Released P2090-050
100% Free Download! 100% Pass Guaranteed!
http://www.Latesttests.com/P2090-050.html

IBM PureData System for Analytics Technical Mastery Test v1

Question No: 21 – (Topic 1)

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

  1. Each job gets 25% and both run at the same time.

  2. Each job gets 50% but only one job runs at a time.

  3. Each job gets 50% and both run at the same time.

  4. You cannot set the job maximum per resource group.

Answer: B

Question No: 22 – (Topic 1)

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

  1. Use explain.

  2. Use statistics.

  3. Use pg.log file.

  4. Set show_plan = true;

Answer: A

Question No: 23 – (Topic 1)

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?

  1. DROP TABLE TableA

  2. ALTER TABLE TableA

  3. TRUNCATE TABLE TableA

  4. GRANT SELECT ON TableA TO UserA

Answer: D

Question No: 24 – (Topic 1)

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

  1. The maximum GRA assigned to the ADMINgroup.

  2. The maximum GRA assigned to the PUBLIC group.

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

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

Answer: D

Question No: 25 – (Topic 1)

What CANNOT be measured and managed by system views?

  1. Temperature values on S-blade.

  2. Status of the host attached storage.

  3. Power supply status for each frame.

  4. Resource group utilization and history.

Answer: B

Question No: 26 – (Topic 1)

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

  1. No data movement is required.

  2. A merge join operation will be performed.

  3. A cluster based join method is performed.

  4. Data is dynamically redistributed or broadcasted.

Answer: D

Question No: 27 – (Topic 1)

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

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

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

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

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

Answer: B Explanation:

What is the limitation on join types with floating-point data types?

  1. The system does not have a limitation on floating-point data types.

  2. The system cannot perform any type of join on floating-point data types.

  3. The system cannot perform afast sort merge join on a floating point data type, but instead must perform a slower hash join.

  4. The system cannot perform a fast hash join on a floating point data type, but instead must perform a slower sort merge join.

Answer: D

Question No: 28 – (Topic 1)

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

  1. Bypasses the host.

  2. Flows through the host.

  3. Compressed on the host.

  4. Uncompressed on the host.

Answer: B

Question No: 29 – (Topic 1)

Why is table skew important to manage?

  1. Low table skew negatively impacts performance.

  2. High table skew negatively impacts performance.

  3. Low table skew negatively impacts data compression.

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

Answer: B

Question No: 30 – (Topic 1)

Which statement is true regarding the compress engine?

  1. Data automatically gets compressed.

  2. Columns to be compressed must be defined.

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

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

Answer: A

100% Free Download!
Download Free Demo:P2090-050 Demo PDF
100% Pass Guaranteed!
Download 2017 Latesttests P2090-050 Full Exam PDF and VCE

Latesttests ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

2017 Latesttests IT Certification PDF and VCE

Leave a Reply