IBM IBM Certifications P2090-047 Questions & Answers

• Question 91:

  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

  Correct Answer: A

• Question 92:

  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.

  Correct Answer: C

• Question 93:

  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.

  Correct Answer: AE

• Question 94:

  Where are the database log files located?

  A. /var/log

  B. /usr/local

  C. /nz/kit/log

  D. The SYSTEM database

  Correct Answer: C

• Question 95:

  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.

  Correct Answer: D

• Question 96:

  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.

  Correct Answer: CE

• Question 97:

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

  A. nzstats

  B. nzstate

  C. nzshow

  D. nzsystem

  Correct Answer: A

• Question 98:

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

  A. kill

  B. abort

  C. nzstop

  D. nzsession

  Correct Answer: D

• Question 99:

  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

  Correct Answer: B

• Question 100:

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

  A. Serializable

  B. Committed read

  C. Repeatable read

  D. Uncommitted read

  Correct Answer: A