1. Home
  2. IBM
  3. P2090-050

IBM PureData System for Analytics Technical Mastery Test v1

Exam Details

  • Exam Code
    :P2090-050
  • Exam Name
    :IBM PureData System for Analytics Technical Mastery Test v1
  • Certification
    :IBM Certifications
  • Vendor
    :IBM
  • Total Questions
    :60 Q&As
  • Last Updated
    :Jun 07, 2025

IBM IBM Certifications P2090-050 Questions & Answers

  • Question 121:

    Given a plan ID, how would you obtain the query execution plan? (Choose two.)

    A. Turn ODBC tracing ON.

    B. Issue "SELECT * FROM _V_SESSION;"

    C. Go to the query history within the Windows NzAdmin GUI tool.

    D. Run EXECUTION PLAN before the query has been submitted.

    E. Issue "SHOW PLANFILE ;" after the query has been submitted.

  • Question 122:

    When is the ToplogyImbalance event triggered?

    A. When a SAS switch has failed.

    B. When the path the path between an S-Blade and its disks has failed.

    C. When a disk enclosure's voltage sensor is reading outside the nominal range.

    D. When an S-Blade has ownership of more dataslices than is optimal (usually following a disk replacement).

  • Question 123:

    Which is NOT a function that can be performed bynzbackup?

    A. Backup data

    B. Backup schemas

    C. Backup users/groups

    D. Backup the /nz/data directory

  • Question 124:

    Which nzload operation statement is correct?

    A. nzload must have a control file.

    B. nzload performs singleton inserts.

    C. nzload user must have CREATE EXTERNAL TABLE privilege.

    D. nzload must be run from the PureData System for Analytics host.

  • Question 125:

    Name the CLI application that allows you to load data from ASCII files to database tables?

    A. nzload

    B. loadmgr

    C. nzimport

    D. nzrestore

  • Question 126:

    You have access to two databases, DEV and PROD. Currently you are connected to the DEV database. Which operation is permitted?

    A. Delete from PROD..TableA

    B. Select * from PROD..TableA

    C. Truncate table PROD..TableA

    D. Insert into PROD..TableA select * from DEV..TableB

  • Question 127:

    Which statement is true?

    A. MATERIALIZED VIEWS can be run against EXTERNAL tables.

    B. GENERATE STATISTICS can be run against EXTERNAL tables.

    C. EXTERNAL table data is deleted using the SQL DELETE command.

    D. EXTERNAL tables can be used to unload data to a Microsoft Windows directory.

  • Question 128:

    nzbackup/nzrestore with the -user option has been replaced with which option to allow multi-level security (MLS) information, suchas categories, cohorts, and levels to be backed up/restored?

    A. -all

    B. -mls

    C. -users

    D. -globals

  • Question 129:

    When loading a local ASCII file into table via an external table, where can the SQL be submitted?

    A. From a User Defined Function.

    B. From a JDBC application networked to the system.

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

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

  • Question 130:

    What function can nzbackup perform?

    A. Back up pg.log files.

    B. Back up TEMP tables.

    C. Back up host data (catalog metadata).

    D. Back up the data using the specified number of streams.

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-050 exam preparations and IBM certification application, do not hesitate to visit our Vcedump.com to find your solutions here.