[Free] 2018(Jan) Dumps4cert Testking IBM P2090-047 Dumps with VCE and PDF 91-100

Dumps4cert.com : Latest Dumps with PDF and VCE Files
2018 Jan IBM Official New Released P2090-047
100% Free Download! 100% Pass Guaranteed!

IBM PureData System for Transactions Technical Mastery Test v1

Question No: 91 – (Topic 2)

Where are the database log files located?

  1. /var/log

  2. /usr/local

  3. /nz/kit/log

  4. The SYSTEM database

Answer: C

Question No: 92 – (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 the system.

Answer: C

Question No: 93 – (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-Blade to FPGA to User.

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

Answer: D

Question No: 94 – (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 16 per user per database.

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

Answer: B

Question No: 95 – (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: 96 – (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 driver for the same UNIX environment.

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

Answer: B,D

Question No: 97 – (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: 98 – (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: 99 – (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: 100 – (Topic 2)

Which file format is NOT supported by the nzload utility?

  1. ASCII delimited format.

  2. Fixed length record format.

  3. gzip compressed file format.

  4. PureData System for Analytics compressed file format.

Answer: C

100% Dumps4cert Free Download!
Download Free Demo:P2090-047 Demo PDF
100% Dumps4cert Free Guaranteed!
P2090-047 Dumps

Dumps4cert 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