TeraData TDVAN5 Exam Practice Questions (P. 2)

An Administrator manages a Vantage system that is continually updated. The system is critical to the business and must be available as much as possible. The Administrator decides to use a backup strategy that will allow changes to tables while a backup is in progress.
Which backup strategy should be used?

A client is having many problems with a poorly written SQL. They have product joins running against large tables, and this is causing severe performance issues. The Administrator needs to help the client avoid the harm to the system that is being caused by running these queries.
Which action should be taken by the Administrator to assist this client?

The Administrator has dropped a profile which was associated with a group of users.
What will happen when one of the users from the group logs on to the database?

An Administrator has been asked to improve the response time of the workloads in the tactical tier. Workloads are in all tiers of TASM. They are at CPU and I/O capacity, and they have AWT reserved for tactical. The Administrator begins by analyzing the data and the workload prioritization.
Which action should the Administrator take?

At a large car manufacturer, huge volumes of diagnostic data for cars are collected in the following table:

The master data for each car is stored in the following table:

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?