- All Exams Instant Download
What will happen when one of the users from the group logs on to the database?
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?A . The default profile setting for the user will be reset to NULL.B . Password attributes defined at the system...
Which action should the Administrator take to improve the runtime and resource consumption for this query?
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...
What can be done to optimize these queries?
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...
Which DBC view should be used to generate this list?
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?A . DBC.LOGONOFFVB . DBC.USERSVC . DBC.SECURITYDEFAULTSVD . DBC.ACCESSLOGVView AnswerAnswer: B Explanation: DBC.USERSV contains information about users,...
What should the Administrator use to assist this client?
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?A . Use a system throttle.B ....
Which benefit is achieved by creating profiles?
Which benefit is achieved by creating profiles?A . Reducing the growth of the DBC.AccessRights tableB . Managing user privileges on database objectsC . Assigning permanent space for groups of users with similar needsD . Defining spool space for groups of users with similar needsView AnswerAnswer: D Explanation: Profiles in Teradata...
Which view contains the utility usage data for the prior months?
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...
How can this be accomplished?
An Administrator needs to provide end users access to data in a Native Object Store using shared credentials. How can this be accomplished?A . Define a FOREIGN TABLE with DEFINER TRUSTED security.B . Define a FUNCTION MAPPING with INVOKER TRUSTED security.C . Use an S3 1AM role or Azure SAS...
Which metrics should be examined for high values to identify the queries?
An application is consuming very high I/O on Teradata Vantage. The Administrator has been asked to identify the queries that are consuming more than 100 million IOs and are suspected of completing Full Table Scans or Large Redistribution. Which metrics should be examined for high values to identify the queries?A...
How can the Administrator effectively throttle these stored procedures?
BATCH_USER submits stored procedures, utility jobs, and other requests. All BATCH_USER work classifies into workload WD-Batch based on username criterion. System performance has slowed due to AWT exhaustion during the batch window. The Administrator determined the AWT exhaustion is due to high concurrency of stored procedure calls from BATCH_USER. How...
