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

Ensurepass.com : Ensure you pass the IT Exams
2018 Jan IBM Official New Released P2090-050
100% Free Download! 100% Pass Guaranteed!

IBM PureData System for Analytics Technical Mastery Test v1

Question No: 31 – (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: 32 – (Topic 1)

Which two statements are trueabout 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: 33 – (Topic 1)

In order to set a runaway query event totrigger 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: 34 – (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: 35 – (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 driverfor UNIX.

  4. OLE-DB is not supported on UNIX.

Answer: D

Question No: 36 – (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 forWindows.

  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: 37 – (Topic 1)

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

  1. nzstats

  2. nzstate

  3. nzshow

  4. nzsystem

Answer: A

Question No: 38 – (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: 39 – (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

Question No: 40 – (Topic 1)

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

  1. root

  2. public

  3. admin

  4. system

Answer: C

100% Ensurepass Free Download!
Download Free Demo:P2090-050 Demo PDF
100% Ensurepass Free Guaranteed!
P2090-050 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
Free VCE Simulator Yes No No
Instant Download Yes No No

Leave a Reply

Your email address will not be published. Required fields are marked *

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