Which of the following is fundamental to BLU acceleration?

• A.Multidimensional clustering
• B.pureScale
• C.Column organized tables
• D.Purchasing new hardware that is compatible with BLU acceleration and compression

Comment: *

Name: *

Email: *

Verification: *

The application owners say they need to be able to query a table and previous versions of that table. Which type of table is appropriate to satisfy this requirement?

• A.Shadow Table
• B.Range-Partitioned Table
• C.Multidimensional Clustered Table
• D.Temporal Table

Comment: *

Name: *

Email: *

Verification: *

Which DB2 product required to allow connections from DB2 LUW to DB2 on z/OS?

• A.DB2 Data Server Client
• B.DB2 Runtime Client
• C.DB2 Connect
• D.DB2 Enterprise Server Edition

Comment: *

Name: *

Email: *

Verification: *

What type of function is created using the following command?
CREATE FUNCTION TAN (X DOUBLE)
RETURNS DOUBLE
LANGUAGE SQL
CONTAINS SQL
NO EXTERNAL ACTION
DETERMINISTIC
RETURN SIN(X)/COS(X)

• A.Row
• B.Table
• C.Scalar
• D.External

Comment: *

Name: *

Email: *

Verification: *

A multi-partition database environment using BLU acceleration is designed to meet which of the following requirements? (Choose two.)

• A.Easy scalability
• B.Management of very large data sets
• C.Continuously available dataset solution
• D.Increased throughput of many concurrent short running queries
• E.Faster response time of long-running or complex queries with I/O spread across many computers

Comment: *

Name: *

Email: *

Verification: *