Which view contains the utility usage data for the prior months?

An Administrator has been tasked with analyzing previous growth and usage patterns by utilities such as Multiload and FastLoad. The aim is to project the likely resource requirements of the existing loads in the next three to six months.

In the last month, the Administrator team have started using AccountString expansion on all user accounts and have started maintenance jobs to housekeep system data older than seven years. Two years ago, the following command was issued on the system: BEGIN QUERY LOGGING WITH ALL ON ALL;

No other logging commands have been issued.

Which view contains the utility usage data for the prior months?
A . AMPUsageV
B . LogOnOffV
C . QryLogUtilityV
D . QryLogV

View Answer

Answer: C

Explanation:

QryLogUtilityV is a specific DBQL (Database Query Logging) view that provides information about utility usage (such as Multiload and FastLoad) on the system. Since the BEGIN QUERY LOGGING WITH ALL ON ALL command was issued two years ago, the DBQL (Database Query Logging) has been tracking various events, including utility usage, which is stored in QryLogUtilityV.

Option A (AMPUsageV) contains AMP (Access Module Processor) level statistics and usage data but not detailed information about utility jobs.

Option B (LogOnOffV) tracks user logon and logoff activities but does not provide information about utility usage.

Option D (QryLogV) logs general query execution data but is not specifically focused on utility usage.