[Free] 2018(Jan) EnsurePass Pass4sure IBM P2090-050 Dumps with VCE and PDF 91-100

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released P2090-050
100% Free Download! 100% Pass Guaranteed!

IBM PureData System for Analytics Technical Mastery Test v1

Question No: 91 – (Topic 2)

If user A has a minimum resource allocation of 20% and a maximum of 80%, user A can receive what percentage of available resources?

  1. A maximum of 20%of resources when other users are on the system.

  2. A maximum of 50% of resources when other users are on the system.

  3. A maximum of 80% of resources when no other users are on the system.

  4. A maximum of 100% of resources when no other users are on thesystem.

Answer: C

Question No: 92 – (Topic 2)

Given the following query: SELECT * FROM TableA; how does data flow through the PureData System for Analytics components?

  1. Disk to FPGA to Host to User.

  2. Disk to FPGA to S-Blade to User.

  3. Disk to Host to S-Bladeto FPGA to User.

  4. Disk to FPGA to S-Blade to Host to User.

Answer: D

Question No: 93 – (Topic 2)

Which statement regarding temporary tables is true?

  1. They are limited to 1 terabyte in size.

  2. They may include a DISTRIBUTE ON clause.

  3. They are limited to 16per user per database.

  4. They will be included in any nzbackup of the database.

Answer: B

Question No: 94 – (Topic 2)

What is the fastest join utilized by PureData System for Analytics?

  1. Hash join.

  2. Merge join.

  3. Expression join.

  4. Cross product join.

Answer: A

Question No: 95 – (Topic 2)

In a UNIX 64bit environment, a 64bit application requires which software to execute SQL statements via ODBC? (Choose two.)

  1. nzsql

  2. An ODBC driver manager.

  3. The system does not support 64 bit ODBC.

  4. A 64-bit ODBC driverfor the same UNIX environment.

  5. A 32-bit ODBC driver for the same UNIX environment.

Answer: B,D

Question No: 96 – (Topic 2)

OLE-DB based applications requires which PureData System for Analytics software?

  1. Install the JDBC driver for windows.

  2. Install the ODBC driver for windows.

  3. Install the OLE-DB Driver for windows.

  4. Install the nzload bulk load for windows.

Answer: C

Question No: 97 – (Topic 2)

Which statement is NOT true regarding the nzload utility?

  1. nzload runs on windows.

  2. nzload runs on SuSE Linux.

  3. nzload blocks update/delete against the target table.

  4. nzload runs on the PureData System for Analytics host.

Answer: C

Question No: 98 – (Topic 2)

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

  1. From a User Defined Function.

  2. From nzsql on an AIX machine networked to the system.

  3. From nzsql on Microsoft Windows networked to the system.

  4. From an ODBC application on Windows networked to the system.

Answer: D

Question No: 99 – (Topic 2)

Which file format is NOT supported by the nzloadutility?

  1. ASCII delimited format.

  2. Fixed length record format.

  3. gzip compressed file format.

  4. PureData System for Analytics compressed file format.

Answer: C

Question No: 100 – (Topic 2)

Which statement is NOT true?

  1. nzrestore can restore selected tables.

  2. nzrestore can restore from an nzbackup UNIX pipe.

  3. nzrestore can restore to a different database from the backup database.

  4. nzrestore can restore to a different PureData System for Analytics server from the backup server.

Answer: B

100% Ensurepass Free Download!
Download Free Demo:P2090-050 Demo PDF
100% Ensurepass Free Guaranteed!
P2090-050 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
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

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.