In order to run reports on an OLTP system during the night, which connection types should be utilized?

The correct choice focuses on the connection types labeled as TPURGENT and HIGH. OLTP (Online Transaction Processing) systems handle a large volume of transactions and are optimized for fast query and update operations. When running reports during off-peak hours, such as at night, it is beneficial to prioritize the connection types to ensure that the reporting processes are completed efficiently and without impacting critical transactional operations.

Using TPURGENT allows the report queries to be prioritized above standard operations, ensuring they receive the resources they need to execute quickly. The HIGH priority level further reinforces this by signaling that these tasks are vital to be completed in a timely manner, usually leading to faster processing times due to minimal contention for system resources.

Other connection types such as LOW or NORMAL would not provide the necessary priority, potentially leading to slower report processing times. MEDIUM and SCHEDULED may introduce delays or insufficient urgency for critical reporting needs, while URGENCY and CRITICAL are not standard designations in typical OLTP systems. Prioritizing reports using TPURGENT and HIGH effectively aligns with the goal of optimizing system performance during those night hours.