Exam Details

  • Exam Code
    :P2090-047
  • Exam Name
    :IBM PureData System for Transactions Technical Mastery Test v1
  • Certification
    :IBM Certifications
  • Vendor
    :IBM
  • Total Questions
    :60 Q&As
  • Last Updated
    :Jul 01, 2025

IBM IBM Certifications P2090-047 Questions & Answers

  • Question 31:

    Within a single PureData System for Analytics, what is the fastest way to copy a 10TB TableA from DatabaseA to another DatabaseB?

    A. Use the COPY command.

    B. Use external tables and UNIX pipes.

    C. Use nzbackup and nzrestore commands.

    D. Use a CTAS (Create Table as Select) SQL statement.

  • Question 32:

    Which statement is NOT true regarding the nzload utility?

    A. nzload runs on windows.

    B. nzload runs on SuSE Linux.

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

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

  • Question 33:

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

    A. From a User Defined Function.

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

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

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

  • Question 34:

    Which file format is NOT supported by the nzload utility?

    A. ASCII delimited format.

    B. Fixed length record format.

    C. gzip compressed file format.

    D. PureData System for Analytics compressed file format.

  • Question 35:

    Which statement is NOT true?

    A. nzrestore can restore selected tables.

    B. nzrestore can restore from an nzbackup UNIX pipe.

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

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

  • Question 36:

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

    A. Install the JDBC driver for windows.

    B. Install the ODBC driver for windows.

    C. Install the OLE-DB Driver for windows.

    D. Install the nzload bulk load for windows.

  • Question 37:

    Which statement regarding temporary tables is true?

    A. They are limited to 1 terabyte in size.

    B. They may include a DISTRIBUTE ON clause.

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

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

  • Question 38:

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

    A. Hash join.

    B. Merge join.

    C. Expression join.

    D. Cross product join.

  • Question 39:

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

    A. nzsql

    B. An ODBC driver manager.

    C. The system does not support 64 bit ODBC.

    D. A 64-bit ODBC driver for the same UNIX environment.

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

  • Question 40:

    What is true about queries submitted on the PureData System for Analytics Appliance?

    A. Queries are uncompressed by the host and sent to the user.

    B. Queries are consolidated by the host and executed together in one block.

    C. Queries are compiled by the host and executed in parallel by the S-Blades.

    D. Queries are compressed by the host and optimized for parallel processing.

Tips on How to Prepare for the Exams

Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only IBM exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your P2090-047 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.