CertyRush
Đang tải...
C CertyRush
Câu hỏi free preview

Câu 14: TDVAN5: Teradata Vantage Administration

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 pr…

Nội dung câu hỏi

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 can the Administrator effectively throttle these stored procedures?

Các lựa chọn

Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.

  1. A. Create a utility limit, classify on username = BATCH_USER and utility = Stored Procedure, and set the limit.
  2. B. Define an AWT resource limit, classify on username = BATCH_USER and utility = Stored Procedure, and set the limit.
  3. C. Create a new workload, classify on username = BATCH_USER and statement type = CALL, and set a throttle. — đáp án hiện tại
  4. D. Define a system throttle, classify on username = BATCH_USER and stored procedure = *.*, and set the limit.

Cộng đồng

0 bình luận công khai. Tên thành viên được ẩn một phần.

Chưa có bình luận. Mở giao diện tương tác để bắt đầu thảo luận.

Câu hỏi liền kề