C1000-122 sample questions

Question 1

A Database Administrator is creating a new table space for a transaction history table that is expected to grow to 500 TB over the next five years. The table will be heavily inserted into and queried by range of dates. The DBA decides to use a Partition-by-Range (PBR) Universal Table Space (UTS) with Relative Page Numbering (RPN). What is the primary architectural advantage of selecting RPN for this specific scenario compared to absolute page numbering?

Accepted Answer

It allows for the maximum partition size and the maximum number of partitions to be increased independently of each other.

Answer

It automatically converts the table space to Partition-by-Growth (PBG) if the range limit is exceeded.

Answer

It eliminates the need for an internal RID limit, allowing partitions to grow up to 1 TB regardless of page size.

Answer

It enables the use of Huffman compression for the data pages.

Question 2

A systems programmer is preparing to modify a subsystem parameter (ZPARM) to increase the maximum number of open datasets (DSMAX). The environment requires 24/7 availability. Which method allows the change to take effect immediately without stopping and starting the Db2 subsystem?

Accepted Answer

Update the source macro, reassemble the ZPARM load module, and issue the -SET SYSPARM command.

Answer

Issue the SQL statement ALTER SYSTEM SET DSMAX = .

Answer

Use the ISPF installation panels to update the value and run the DSNTIJUZ job, then recycle the DBM1 address space.

Answer

Update the IRLM procedure parameter and issue the MODIFY command to IRLM.

Question 3

While investigating a performance issue in a Db2 12 environment, a DBA observes high CPU usage in the `ssnmDIST` address space. Which type of workload is most likely generating this activity?

Accepted Answer

Remote applications connecting via DRDA (Distributed Relational Database Architecture).

Answer

Heavy local batch processing using TSO attachment facility.

Answer

System checkpoints and log archiving processes.

Answer

Internal lock management and deadlock detection.

Question 4

A DBA needs to configure connectivity for a new Java application running on Linux to a Db2 for z/OS subsystem. The application requires high availability and workload balancing across the data sharing group. Which TWO configuration items are essential on the client side (e.g., IBM Data Server Driver) to enable Sysplex Workload Balancing? (Select TWO)

Accepted Answer

A connection URL pointing to the Group Virtual IP Address (VIPA) and the Group Location Name

Accepted Answer

enableSysplexWLB=true in the driver properties

Answer

The client must be running on the same z/OS LPAR as the Db2 subsystem

Answer

The DYNAMICRULES bind option must be set to RUN

Question 5

Analyze the following SQL query used in a sales report. The requirement is to rank sales representatives by their total sales within each region, but gaps in ranking numbers should be avoided if two representatives have the exact same sales total.

```sql
SELECT REGION, SALES_REP, TOTAL_SALES,
________(ORDER BY TOTAL_SALES DESC) OVER (PARTITION BY REGION) as RANKING
FROM SALES_DATA
```

Which OLAP function correctly fills the blank to meet the requirement?

Accepted Answer

DENSE_RANK

Answer

NTILE

Answer

RANK

Answer

ROW_NUMBER

Question 6

A developer needs to retrieve specific elements from an XML document stored in a Db2 table column named `CUSTOMER_DATA`. The requirement is to extract the `ZipCode` element from the `Address` node for all customers. Which SQL function should be used to return the value as a relational column in the result set?

Accepted Answer

XMLCAST with XMLQUERY

Answer

XMLQUERY

Answer

XMLEXISTS

Answer

XMLPARSE

Free C1000-122 sample questions

A systems programmer is preparing to modify a subsystem parameter (ZPARM) to increase the maximum number of open datasets (DSMAX). The environment requires 24/7 availability. Which method allows the change to take effect immediately without stopping and starting the Db2 subsystem?

While investigating a performance issue in a Db2 12 environment, a DBA observes high CPU usage in the `ssnmDIST` address space. Which type of workload is most likely generating this activity?

6 more free samples are waiting