Question 6 of 68
At a large car manufacturer, huge volumes of diagnostic data for cars are collected in the following table:
Exam TDVAN5: Question 6 - Image 1
The master data for each car is stored in the following table:
Exam TDVAN5: Question 6 - Image 2
Many reports require data from both tables by joining via column VehicleId.
A very frequently performed query on the system returns the number of events by FaultCode and ModelType. This query consumes many CPU and I/O resources each day.
Which action should the Administrator take to improve the runtime and resource consumption for this query?
    Correct Answer: A

Question 7 of 68
An Administrator has been given a task to generate a list of users who have not changed their password in the last 90 days.
Which DBC view should be used to generate this list?
    Correct Answer: B

Question 8 of 68
A client has a healthy system but often sees delays in some queries because of workload concurrency limits. These limits have been carefully chosen, so the client needs a solution that will not modify them.
What should the Administrator use to assist this client?
    Correct Answer: C

Question 9 of 68
Given a user creation request on a 10-AMP system:
CREATE USER hr_user AS PERM = 100e9 SKEW = 10 PERCENT,
SPOOL = 100e9 SKEW = 20 PERCENT;
How does the SKEW factor affect the user's Perm space, assuming the total space consumed is under the specified perm space limit?
    Correct Answer: D

Question 10 of 68
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?
    Correct Answer: C