Ensurepass

QUESTION 41

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 driverfor UNIX.

D.

OLE-DB is not supported on UNIX.

 

Correct Answer: D

 

 

QUESTION 42

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?

 

clip_image002

 

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 43

Which component failure does NOT trigger a HardwareServiceRequested event?

 

A.

Fan

B.

Disk

C.

Host

D.

S-Blade

 

Correct Answer: C

 

QUESTION 44

A SELECT statement spends all its time returning 1 billion rows.What can be done to make this faster?

 

A.

Use a CURSOR.

B.

Use an EXTERNAL table.

C.

Use the COPY command.

D.

Increase the PreFetch Count.

 

Correct Answer: B

 

 

QUESTION 45

Which CREATE DATABASE attributes are required?

 

A.

The database name.

B.

The database name and the redo log file name.

C.

Thedatabase name and the table space name.

D.

The database name and the temporary table space name.

 

Correct Answer: A

 

 

QUESTION 46

Which two characteristics describe materialized views. (Choose two.)

 

A.

Materialized views can contain aggregates.

B.

Materialized views can contain a HAVING clause.

C.

Materialized views can contain a WHERE clause.

D.

Materialized views can contain an ORDER BY clause.

E.

Materialized views can reference only onebase table in the FROM clause.

 

Correct Answer: DE

 

 

QUESTION 47

Columns in a table may be zonemapped. How are those columns chosen?

 

A.

They
are automatically selected by the system.

B.

They are based on the same columns as the table’s distribution key.

C.

They are added via the ALTER TABLE ADD INDEX(column_name) statement.

D.

They are added via the ALTER TABLE ADD ZONEMAP(column_name) statement.

 

Correct Answer: A

 

 

QUESTION 48

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

 

Correct Answer: A

 

 

QUESTION 49

Which procedural logic is NOT supported by NZPLSQL?

 

A.

Scrollable Cursors

B.

Looping (while, for)

C.

Conditionals (if/else)

D.

Returning a scalar result or a result set

 

Correct Answer: A

 

 

QUESTION 50

Which condition will NOT fail or restart a running query on a PureData System for Analytics Appliance?

 

A.

Disk resets or fails.

B.

Host resets or fails.

C.

S-Blade resets or fails.

D.

Snippet Processing Unit (SPU) resets or fails.

 

Correct Answer: A

 

Free VCE & PDF File for IBM P2090-050 Real Exam

Instant Access to Free VCE Files: CompTIA | VMware | SAP …
Instant Access to Free PDF Files: CompTIA | VMware | SAP …

Comments are closed.