C1000-122 sample questions

Question 1

A financial institution is designing a high-availability architecture using a Db2 12 for z/OS Data Sharing Group. The architecture team needs to ensure that the Coupling Facility (CF) structures are correctly defined to handle inter-Db2 read/write interest efficiently. Specifically, they are concerned about the mechanism used to track page validity across the group buffer pools. Which specific component of the Coupling Facility is primarily responsible for registering interest in pages and ensuring data coherency across members, and what happens when a page is updated by one member?

Accepted Answer

The Cache Structure (Group Buffer Pool); it uses directory entries to track page interest and cross-invalidates local buffer pages of other members upon update.

Answer

The List Structure; it maintains a log of all changed pages and forces a group-wide checkpoint.

Answer

The Lock Structure; it locks the page exclusively, forcing other members to read from disk.

Answer

The Shared Communications Area (SCA); it broadcasts a message to all members to invalidate their local buffer pools.

Question 2

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 3

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 4

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 5

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 6

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.

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

Db2 12 for z/OS DBA Fundamentals Free Sample Questions

Description

Question 1

Question 2

Question 3

Question 4

Question 5

Question 6

Register free for 6 more questions

C1000-122 Sample Questions

Register free for 6 more questions

Related practice tests