[Free] 2017(Jan) EnsurePass Pass4sure IBM P2090-047 Dumps with VCE and PDF Download 21-30

Ensurepass.com : Ensure you pass the IT Exams 2017 Jan IBM Official New Released P2090-047
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/P2090-047.html

IBM PureData System for Transactions 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 group each 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 ADMIN group.

  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 joined together 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

Question No: 28 – (Topic 1)

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 a fast 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: 29 – (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: 30 – (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

100% Ensurepass Free Download!
Download Free Demo:P2090-047 Demo PDF
100% Ensurepass Free Guaranteed!
Download 2017 EnsurePass P2090-047 Dumps

EnsurePass 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 EnsurePass IT Certification PDF and VCE

Add a Comment

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.