C1000-078 IBM Db2 12 for z/OS Administrator Practice Questions

A financial institution's compliance department requires that a complete and auditable history of all changes to the CUSTOMER_ACCOUNTS table be maintained. It must be possible to query the table to see what a specific account's balance was at any given point in the past. What is the most effective and integrated Db2 feature to meet this requirement?

A development team wants to expose an existing, complex SQL query as a secure, discoverable REST endpoint that returns data in JSON format. They prefer to use built-in Db2 functionality to minimize external dependencies and infrastructure. What is the standard Db2 for z/OS procedure to accomplish this?

An international e-commerce company is consolidating its customer data into a central Db2 for z/OS database. The application needs to store customer names and addresses from around the world, which include characters from various alphabets (e.g., Cyrillic, Kanji, Arabic). The current database objects were created with the default EBCDIC encoding. What is the most appropriate action to ensure all international character data can be stored without corruption?

Following a system change, a critical static SQL query has regressed in performance. Analysis of the dynamic statement cache (DSN_STATEMENT_CACHE_TABLE) shows that a previous execution of the query had a much better access path. The DBA wants to force the optimizer to use this specific, known-good access path for the static package without making broad system changes like reverting statistics. Which is the most precise method to achieve this?

Case Study:

A large, multi-threaded nightly batch job, which processes millions of financial transactions, abended after running for three hours. The job performs INSERT, UPDATE, and DELETE operations across several large table spaces within a single unit of work. The operations team, seeing the abend, immediately resubmitted the job, but it failed instantly with a resource unavailable message (-911 or -913) on one of the primary tables.

Initial Analysis:

• The MVS system log shows the initial abend was an S04E reason 00E70005 (Resource Unavailable).
• A -DISPLAY DATABASE command shows the affected table spaces are available (RW status).
• The job that failed is the only process that updates these tables.

As the on-call DBA, you are tasked with diagnosing the root cause and creating a plan to restart the batch job successfully. What is the most likely cause of the immediate failure on restart, and what is the correct recovery procedure?

A financial services company needs to run frequent, high-performance queries against a large transaction table. The queries filter transactions based on the year and month of the transaction timestamp, which is stored in a TRANSACTION_TS column of data type TIMESTAMP. The current query uses WHERE YEAR(TRANSACTION_TS) = ? AND MONTH(TRANSACTION_TS) = ?, which results in a full table space scan. How should the DBA improve the performance of these queries?

While analyzing buffer pool performance for a critical OLTP application, a DBA notices a high number of synchronous read I/Os and a low buffer pool hit ratio. Further investigation reveals that a nightly batch job performs a full table scan on a large, infrequently accessed table, effectively flushing out the OLTP application's frequently used pages from the buffer pool. Which buffer pool setting should be adjusted to mitigate this issue?

At 2:00 PM, a DBA discovers that a critical application bug introduced logical data corruption starting at approximately 10:00 AM. The business requires that the three affected table spaces (TSFIN01, TSFIN02, TSFIN03) be restored to their state at exactly 09:59 AM, just before the corruption began. All other table spaces in the database must remain online and current. Which utility control statement is the most precise and appropriate for this recovery scenario?

A Db2 12 for z/OS subsystem is currently at function level V12R1M503. The development team requires a new SQL feature that was introduced in function level V12R1M505. What is the correct procedure for the DBA to enable the new functionality?

A healthcare provider must allow external auditors to query patient demographic data. However, compliance regulations mandate that the auditors must not be able to view the actual values in the Social Security Number (PATIENT_SSN) column. The auditors should see a masked value, such as 'XXX-XX-XXXX', while internal applications must continue to see the real SSN. Which Db2 security feature is best suited for this requirement?