1. Home
  2. IBM
  3. P2090-047

IBM PureData System for Transactions Technical Mastery Test v1

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
    :Jun 14, 2025

IBM IBM Certifications P2090-047 Questions & Answers

  • Question 51:

    What is the maximum number of columns that can participate in a distribution key?

    A. One

    B. Four

    C. Unlimited

    D. Depends on the number of columns of integer datatype.

  • Question 52:

    If data is being nzload'ed into TableA, which of the following operations will be blocked until the load has completed?

    A. A DELETE from TableA

    B. A SELECT from TableA

    C. A TRUNCATE of TableA

    D. An nzbackup of the database in which TableA resides

  • Question 53:

    nzload is invoked with the "allowReplay" option enabled. While the PureData System for Analytics Appliance changes state from online to pausing then to online, which statement is true about the nzload process on the Appliance?

    A. nzload will fail.

    B. nzload automatically continues without user intervention.

    C. nzload must be stopped and resumed by the user from the last check point.

    D. nzload automatically restarts but the user must remove the allowReplay option.

  • Question 54:

    Which statement is true about a simple load using external tables?

    A. The load can be configured to automatically continue to load if the S-Blade resets or fails.

    B. The load can be configured to automatically create a backup file of the table being loaded.

    C. The load can be configured to automatically create a duplicate copy of the table being loaded.

    D. The load can be configured to automatically remove duplicate rows from the table being loaded.

  • Question 55:

    What is the state of the two hosts on a properly functional PureData System for Analytics Appliance?

    A. Active - Active

    B. Active - Stand by

    C. Stand by - Backup

    D. Stand by - Passive

  • Question 56:

    When doing a CREATE TABLE, constraints can be specified at the column level. Which two constraints are NOT automatically enforced via the database? (Choose two.)

    A. NULL

    B. UNIQUE

    C. NOT NULL

    D. PRIMARY KEY

    E. DEFAULT value

  • Question 57:

    Which statement is true regarding any database user?

    A. The user has a table space defined.

    B. The user can be assigned to more than one group.

    C. The user must have a corresponding host account.

    D. The user can be removed from the default PUBLIC group.

  • Question 58:

    What is the function of the Distributed Replicated Block Device (DRBD)?

    A. High Availability

    B. Load Balancing

    C. High Concurrency

    D. Work Load Management

  • Question 59:

    What is the maximum number of columns you can choose as organizing keys for clustered base table?

    A. 1

    B. 2

    C. 4

    D. 8

  • Question 60:

    Which clause CANNOT be used with a CREATE VIEW statement?

    A. SUM ()

    B. GROUP BY

    C. ORDER BY

    D. OUTER JOIN

Related Exams:

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.