TerraData TDVAN5 Certification Page2

Question No:-6

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?

  1. Offline
  2. Skip statistics
  3. Online
  4. Dictionary Only

Question No:-7

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?

  1. Use the Query Spotlight Viewpoint portlet to deprioritize the queries.
  2. Use the Flex Throttle option.
  3. Use a TASM system filter.
  4. Use the Query Log Viewpoint portlet to identify and abort the harmful queries.

Question No:-8

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?

  1. The default profile setting for the user will be reset to NULL.
  2. Password attributes defined at the system level in DBC.SecurityDefaultsV will apply.
  3. The system will show a warning message.
  4. SPOOL and DEFAULT DATABASE specifications for the dropped profile will still apply to the user.