TeraData TDVAN5 Quiz 1 Topic 5 Questions 1-5

Question: 1

A Vantage instance includes the following four databases:

Tables Database contains base tables and associated index subtables

Upsert_Database: contains views and other objects to support base table modifications

Query Database: contains views and other objects supporting queries and reporting

Development_Database: contains objects supporting development of new data applications

The Administrator needs to add a new user that will perform batch-level functions.

Which action should the Administrator take to achieve this goal?

AGrant the CHECKPOINT privilege on the Tables_Database to the new user's account.

BSet the user's default role to one that has the CREATE TABLE privilege on the Tables_Database.

CSet the user's profile to one that has the CREATE TABLE privilege on the Tables_Database.

DGrant the CHECKPOINT privilege on the Tables_Database to the new user's profile.

Show Answer

Question: 2

What is a use case for Data Mover?

AArchiving data to a Hadoop system

BCopying data between Vantage systems for active-active replication

CReplicating data to a disaster recovery system

DCopying data between Hadoop systems

Show Answer

Question: 3

How can an Administrator monitor the data volume that is transferred for a Data Mover job via Viewpoint?

ABy accessing the Completed Queries portlet and selecting the Data Mover job

BBy using the Data Mover portlet accessing the log tab

CBy viewing the job statistics tab of the Performance Data Collection portlet

DBy submitting the datamove status -job_name command in the remote console

Show Answer

Question: 4

Which table identifies whether a particular workload is suffering from a shortage of AMP Worker Tasks?

AResUsageSpma

BResUsageSawt

CResUsageSps

DResUsageSvpr

Show Answer

Question: 5

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

q5_TDVAN5

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

q5_TDVAN5

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?

AUse an aggregate join index with columns FaultCode, ModelType, as well as an appropriate aggregate function.

BUse a sparse join index with columns FaultCode and ModelType, as well as an appropriate filter function.

CUse a NUSI on VehicleEvent.FaultCode and a NUSI on Vehicle.ModelType

DUse a single table join index on VehicleEvent hashed by FaultCode and another single table join index on Vehicle hashed by ModelType.

Show Answer

TeraData TDVAN5 Quiz:1 Topic:5 Questions:1-5