IBM PureData System for Analytics v7.1 Set 1

1.

What mechanism does NPS use for LDAP authentication?

Pluggable Authentication Module (PAM) Generic Security Services API (GSSAPI) Simple Authentication and Security Layer (SASL) Berkeley Software Distribution Authentication (BSDAuth)

2.

The Pure Data System for Analytics implements which level of transaction isolation?

Serializable Committed read Repeatable read Uncommitted read

3.

What is the maximum number of columns you can choose as organizing keys for a clustered base table?

1 2 4 8

4.

Which of the following is NOT true about the createxid column?

They can be queried They are updated to zero during a DELETE operation Rows loaded in a transaction are assigned the same value They contain the ID of the transaction that created the record

5.

What is nzconvert used for?

To convert compressed external tables into ASCII text To convert between character encodings before loading data To translate stored procedures into NZPLSOL compatible syntax To upgrade/downgrade the database to a different software version

6.

Dirty reads occur when a transaction reads data that is written by concurrentuncommitted transactions. Under what conditions are dirty reads allowed on the IBM PDA system?

When an FPGA is busy By turning off serialization within the system They are never permitted under any conditions When the transaction isolation is read-committed

7.

What can be backed up using the nzbackup utility?

Host data pg.log files Temporary tables User permissions

8.

Which of the following will NOT show the current sessions on the Netezza server?

nzsql\act nzsession nzsystem-showSessions

SELECT* FROM_v_session

9.

Which of the following statements about temporary tables is TRUE?

Synonyms can be created for temporary tables Temporary tables have been deprecated as of NPS 7.0.3 Temporary tables can be specified as a base table for materialized views When a user executes the command SET SESSION READ ONLY, they are still able to create and write to temporary tables

10.

Netezza database accounts are NOT created and/or managed using

The NzAdmin tool The Netezza Performance Portal The Netezza command line interface The Netezza host's command line interface

IBM PureData System for Analytics v7.1 Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

IBM PureData System for Analytics v7.1 Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner