TE0-126 Teradata 12 Enterprise Architecture Practice Exam

Sample Questions

Q) A user calls the administrator to report that the new system is extremely slow. The administrator investigates and notices an extremely large Transient Journal. Which two reasons might explain the large Transient Journal? (Choose two.)

a) The WAL log did not purge properly.

b) A large table is being duplicated using CREATE TABLE AS.

c) AMultiLoad job is loading 100,000,000 rows into a transaction table.

d) A large number of tactical queries have been submitted, taking up all AWTs.

Q) Which two workload management techniques should be applied to a sandbox environment on the production system? (Choose two.)

a) Place a CPU limit on the sandbox resource partition.

b) Remove query limits or throttles from the sandbox resource partition.

c) Remove CPU limits on the sandbox resource partition during peak hours.

d) Create a dedicated resource partition or allocation group for sandbox users.

Q) Which two benefits does Master Data Management provide in the enterprise intelligence area? (Choose two.)

a) improved data models

b) increased transactional data delivery rates

c) regulatory compliance and risk management

d) increased visibility to business issues and results

Q) A system has high I/O demand due to the mix of queries that are being executed against a very large partitioned table at a particular time every day. Which action can be taken to reduce the I/O demand?

a) Change the table to non-partitioned to enable synchronized scanning.

b) Increase the datablocksize for the very large table to reduce the number of I/O.

c) Implement a filter to delay any queries performing Full Table Scans (FTS) against the very large table.

d) Drop any indexes on the very large table to reduce the number of data blocks that need to be read.

Q) Which two benefits does data oriented metadata provide when designing a data warehouse? (Choose two.)

a) reduced redundant data

b) improved system performance

c) fewerback up and recovery related problems

d) improved ability to deliver business value quickly