[Free] 2018(Jan) EnsurePass Dumpsleader IBM P2090-047 Dumps with VCE and PDF 31-40

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released P2090-047
100% Free Download! 100% Pass Guaranteed!
http://www.EnsurePass.com/P2090-047.html

IBM PureData System for Transactions Technical Mastery Test v1

Question No: 31 – (Topic 1)

Which statement is true regarding the compress engine?

  1. Data automatically gets compressed.

  2. Columns to be compressed must be defined.

  3. The nzcompress utility must be run to compress the table.

  4. The nzcompress utility must be run to compress the database.

Answer: A

Question No: 32 – (Topic 1)

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

  1. Serializable

  2. Committed read

  3. Repeatable read

  4. Uncommitted read

Answer: A

Question No: 33 – (Topic 1)

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

  1. Queries are executed in parallel by the host.

  2. Queries must be compressed before they can be executed.

  3. Queries are compiled into snippets and executed in parallel by the S-Blades.

  4. Queries must be uncompressed by the user and executed in parallel by the host.

  5. A query is compiled into a snippet which is executed across all available S-Blades.

Answer: C,E

Question No: 34 – (Topic 1)

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.)

  1. The runaway query event was enabled.

  2. The pg.log file was configured for two minutes.

  3. The runaway query event was configured for two minutes.

  4. The nzsystem command was used to set the QUERYTIMEOUT to two minutes.

  5. The CREATE USER command was used to set the QUERYTIMEOUT to two minutes.

Answer: A,E

Question No: 35 – (Topic 1)

Where are the database log files located?

  1. /var/log

  2. /usr/local

  3. /nz/kit/log

  4. The SYSTEM database

Answer: C

Question No: 36 – (Topic 1)

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

  1. Install the JDBC driver for UNIX.

  2. Install the ODBC driver for UNIX.

  3. Install the OLE-DB driver for UNIX.

  4. OLE-DB is not supported on UNIX.

Answer: D

Question No: 37 – (Topic 1)

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.)

  1. Install nzsql for Windows.

  2. Install nzAdmin for Windows.

  3. Install an ODBC driver for Windows.

  4. Install an ODBC Driver Manager for Windows.

  5. Create or modify a Data Source Name (DSN) for a connection to a database.

Answer: C,E

Question No: 38 – (Topic 1)

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

  1. nzstats

  2. nzstate

  3. nzshow

  4. nzsystem

Answer: A

Question No: 39 – (Topic 1)

Which command is used to abort a user#39;s SQL transaction?

  1. kill

  2. abort

  3. nzstop

  4. nzsession

Answer: D

Question No: 40 – (Topic 1)

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?

  1. sar

  2. nzhw

  3. nzsystem

  4. nzinventory

Answer: B

100% Ensurepass Free Download!
Download Free Demo:P2090-047 Demo PDF
100% Ensurepass Free Guaranteed!
P2090-047 Dumps

EnsurePass ExamCollection Testking
Lowest Price Guarantee Yes No No
Up-to-Dated Yes No No
Real Questions Yes No No
Explanation Yes No No
PDF VCE Yes No No
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.