TDVAN5 practice questions, page 3 of 3, with answer review and explanations.
Question 11
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?
DBC.LOGONOFFV
DBC.USERSV
DBC.SECURITYDEFAULTSV
DBC.ACCESSLOGV
Question 12
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?
Use a system throttle.
Use Query Group Viewpoint portlet to change the throttle limit temporally.
Use Flex Throttle option.
Use Query Monitor Viewpoint portlet to change query workloads.
Question 13
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?
The per AMP limit of any AMP can reach 20 GB.
The per AMP limit of 100 GB can be breached up to 10 percent.
The per AMP limit of 10 GB can be breached to any percent.
The per AMP limit of any AMP can reach 11 GB.
Question 14
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?