IBM PureData System for Transactions Technical Mastery Test v1 v3.0

Page:    1 / 9   
Exam contains 132 questions

Which statement is true regarding the compress engine?

  • A. Data automatically gets compressed.
  • B. Columns to be compressed must be defined.
  • C. The nzcompress utility must be run to compress the table.
  • D. The nzcompress utility must be run to compress the database.

Answer : A

The PureData System for Analytics implements which level of transaction isolation?

  • A. Serializable
  • B. Committed read
  • C. Repeatable read
  • D. Uncommitted read

Answer : A

Which two statements are true about queries on the PureData System for Analytics
Appliance? (Choose two.)

  • A. Queries are executed in parallel by the host.
  • B. Queries must be compressed before they can be executed.
  • C. Queries are compiled into snippets and executed in parallel by the S-Blades.
  • D. Queries must be uncompressed by the user and executed in parallel by the host.
  • E. A query is compiled into a snippet which is executed across all available S-Blades.

Answer : C,E

In order to set a runaway query event to trigger when a query runs longer than two minutes, which two items must be configured? (Choose two.)

  • A. The runaway query event was enabled.
  • B. The pg.log file was configured for two minutes.
  • C. The runaway query event was configured for two minutes.
  • D. The nzsystem command was used to set the QUERYTIMEOUT to two minutes.
  • E. The CREATE USER command was used to set the QUERYTIMEOUT to two minutes.

Answer : A,E

Where are the database log files located?

  • A. /var/log
  • B. /usr/local
  • C. /nz/kit/log
  • D. The SYSTEM database

Answer : C

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

  • A. Install the JDBC driver for UNIX.
  • B. Install the ODBC driver for UNIX.
  • C. Install the OLE-DB driver for UNIX.
  • D. OLE-DB is not supported on UNIX.

Answer : D

In order for an ODBC application running on Microsoft Windows to connect to PureData
System for Analytics, which two steps must be performed? (Choose two.)

  • A. Install nzsql for Windows.
  • B. Install nzAdmin for Windows.
  • C. Install an ODBC driver for Windows.
  • D. Install an ODBC Driver Manager for Windows.
  • E. Create or modify a Data Source Name (DSN) for a connection to a database.

Answer : C,E

Which command is used to display operational statistics about system capacity, faults, and performance?

  • A. nzstats
  • B. nzstate
  • C. nzshow
  • D. nzsystem

Answer : A

Which command is used to abort a user's SQL transaction?

  • A. kill
  • B. abort
  • C. nzstop
  • D. nzsession

Answer : D

Which command allows you to show information about the database hardware as well as take actions such as activate or deactivate components, locate components, or delete them from the system?

  • A. sar
  • B. nzhw
  • C. nzsystem
  • D. nzinventory

Answer : B

What is the only predefined database user, which is able to access all objects and perform all tasks against the database?

  • A. root
  • B. public
  • C. admin
  • D. system

Answer : C

What operating system runs on a PureData System for Analytics host?

  • A. AIX
  • B. SUSE Linux
  • C. Nucleus OS
  • D. Redhat Linux

Answer : D

What PureData System for Analytics component is responsible for controlling table storage?

  • A. S-Blade (Snippet-Blade)
  • B. SFI (Switching Fabric Interface)
  • C. FPGA (Field Programmable Gate Array)
  • D. DRBD (Distributed Replicated Block Device)

Answer : A

Click on the exhibit.
Given the following query: SELECT * FROM TableA, TableB WHERE TableA.c_custkey =
TableB.o_custkey; What type of join processing will occur when the query is executed?

  • A. Collocation hash join processing
  • B. Distributed hash join processing
  • C. Broadcast sort merge join processing
  • D. Replication sort merge join processing

Answer : A

Why should you avoid using Boolean data types as a distribution key for a table ?

  • A. Table will not join.
  • B. Table will not broadcast.
  • C. Table is likely to be skewed.
  • D. Table is likely to be evenly spread across data slices.

Answer : C

Page:    1 / 9   
Exam contains 132 questions

Talk to us!

Have any questions or issues ? Please dont hesitate to contact us

Certlibrary doesn't offer Real Microsoft Exam Questions.
Certlibrary Materials do not contain actual questions and answers from Cisco's Certification Exams.
CFA Institute does not endorse, promote or warrant the accuracy or quality of Certlibrary. CFA® and Chartered Financial Analyst® are registered trademarks owned by CFA Institute.