nerdexam
Microsoft

70-433 · Question #33

You are tasked with creating a workload that will be used by the Database Engine Tuning Advisor (DTA). You need to create a workload in an appropriate format. Which format should you choose? (Each…

The correct answer is A. XML File B. Transact-SQL Script E. SQL Server Profiler Trace File. Database Engine Tuning Advisor uses trace files, trace tables, Transact-SQL scripts, or XML files as workload input when tuning databases.

Troubleshoot and Optimize Databases

Question

You are tasked with creating a workload that will be used by the Database Engine Tuning Advisor (DTA). You need to create a workload in an appropriate format. Which format should you choose? (Each correct answer represents a complete solution. Choose three.)

Options

  • AXML File
  • BTransact-SQL Script
  • CSQL Server Event Log
  • DSQL Server Transaction Log
  • ESQL Server Profiler Trace File
  • FPerformance Counter Log File

How the community answered

(40 responses)
  • A
    83% (33)
  • C
    5% (2)
  • D
    10% (4)
  • F
    3% (1)

Explanation

Database Engine Tuning Advisor uses trace files, trace tables, Transact-SQL scripts, or XML files as workload input when tuning databases.

Topics

#Database Engine Tuning Advisor#DTA workload formats#trace file#T-SQL script

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full 70-433 Practice