TerraData TDVAN5 Certification

Question No:-1

Which benefit is achieved by creating profiles?

  1. Reducing the growth of the DBC.AccessRights table
  2. Managing user privileges on database objects
  3. Assigning permanent space for groups of users with similar needs

  4. Defining spool space for groups of users with similar needs

Question No:-2

A customer is complaining that the creation of a large table in the lab environment is getting stuck in the merge step. The customer is using the following command to create the table:

CREATE TABLE ... AS (SELECT * ...) WITH DATA

Which recommendation will help the merge step?

  1. A column that provides good distribution should be specified as PRIMARY INDEX.
  2. The MERGEBLOCKRATIO should be specified for the table to improve the data block merge operation.
  3. The table should be created with "CREATE TABLE ... AS (SELECT *...) WITH NO DATA", and afterwards, "INSERT ... SELECT *" should be used to fill the table.
  4. Users of the lab may have lower priority than other workloads, so the creation of the table should be moved to off-peak hours.

Question No:-3

There is a call center application that repetitively sends tactical queries to Vantage These queries use a few small tables that are joined on the primary index column.

The following maps are defined in the system:

TD_GlobalMap -

TD_Map1 -

TD_DataDictionaryMap -

TD_1AmpSparseMap_1Node -

What can be done to optimize these queries?

  1. Assign these tables to TD_1AmpSparseMap_1Node using different colocation names for each table.
  2. Assign these tables to TD_1AmpSparseMap_1Node using the same colocation name for every table
  3. Assign these tables to TD_Map1 using the same colocation name for every table.
  4. Assign these tables to TD_Map1 using different colocation names for each table.

Question No:-4

Which workload management technique should the Administrator use to reject all QueryGrid queries during a pre-defined critical batch state?

  1. An exception that includes the following Foreign Servers:
  TD_SYSFNLIB.QGInitiatorExport -
  TD_SYSFNLIB.QGInitiatorlmport -
  TD_SYSFNLIB.QGRemoteExport -
  TD_SYSFNLIB.QGRemotelmport

  2. A filter that includes the following functions:
  TD_SYSFNLIB.QGInitiatorExport -
  TD_SYSFNLIB.QGInitiatorlmport -
  TD_SYSFNLIB.QGRemoteExport -
  TD_SYSFNLIB.QGRemotelmport

  3. An exception that excludes the following Foreign Servers:
  TD_SYSFNLIB.QGInitiatorExport -
  TD_SYSFNLIB.QGInitiatorlmport -
  TD_SYSFNLIB.QGRemoteExport -
  TD_SYSFNLIB.QGRemotelmport

  4. A filter that excludes the following functions:
  TD_SYSFNLIB.QGInitiatorExport -
  TD_SYSFNLIB.QGInitiatorlmport -
  TD_SYSFNLIB.QGRemoteExport -
  TD_SYSFNLIB.QGRemotelmport

Question No:-5

What is a use case for Data Mover?

  1. Archiving data to a Hadoop system
  2. Copying data between Vantage systems for active-active replication
  3. Replicating data to a disaster recovery system
  4. Copying data between Hadoop systems