TeraData TDBL1-16.00 Exam Practice Test Instant Access

Question 1

Which object contains one or more SQL statements, always executed as a single request?

AIndex

BMacro

CTable

DRecursive view

Answer : C

Question 2

Which property allows a table to enforce proper values in each column/

AData statistics

BData parameters

CData types

DData phases

Answer : C

Question 3

What is a potential solution when reports have inconsistent results?

AAllow users to load their own data marts and create their own reports

BCentralize data reporting and distribution to one department

CLoad business data into a common repository for all reporting

DRequire all users to generate customized metrics for their departments

Answer : B

Question 4

Which tool should an administrator use to determine the progress of a long-running query?

AFerret

BWorkload Analyzer

CParallel Studio

DTeradata Viewpoint

Answer : A

Question 5

What does a secure zone provide?

AIt isolates data in a segregated zone from all other data in the system and appears as the entire system to an authorized user.

BIt is a zone where security settings are configured and applied to the macros and users in a database.

CIt is the entry zone for private data coming into Teradata where it is hashed and encrypted before being pushed out to the data tables.

DIt provides a zone for administrative data which is used to manage sensitive databases

Answer : A

Question 6

Which space allocation controls the limits of space that can be used for the results of the intermediate steps of a complex SQL statement?

AVolatile

BTransaction

CTemporary

DSpool

Answer : D

Question 7

Which locking severity is NOT compatible with an ACCESS lock?

AWRITE

BEXCLUSIVE

CROW HASH

DREAD

Answer : D

TeraData TDBL1-16.00 TeraData Database Associate Exam Practice Test