Data Profiling Interview Questions

Q: Which of the following is benefit of SQL Server Profiler ?

The correct answer is All of the mentioned

Q: Point out the correct statement :

The correct answer is SQL Server Profiler also supports auditing the actions performed on instances of SQL Server

Q: Which of the following is an event class ?

The correct answer is SQL:BatchCompleted

Q: Which of the following stored procedure will stop the trace ?

The correct answer is sp_trace_setstatus

Q: Point out the wrong statement :

The correct answer is If a filter is set, all events of the selected event classes are returned in the trace output

Data Profiling interview questions

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

1. Which of the following is benefit of SQL Server Profiler ?

A. Capturing the series of Transact-SQL statements that lead to a problem

B. Finding and diagnosing slow-running queries

C. Correlating performance counters to diagnose problems

D. All of the mentioned

Correct Answer is : All of the mentioned

2. Point out the correct statement :

A. SQL Server Profiler also supports auditing the actions performed on instances of SQL Server

B. A profiler class is a type of event that can be traced

C. A profile category defines the way events are grouped within SQL Server Profiler

D. None of the mentioned

Correct Answer is : SQL Server Profiler also supports auditing the actions performed on instances of SQL Server

3. Which of the following is an event class ?

A. SQL:BatchCompleted

B. Audit Password

C. Lock:Blocked

D. All of the mentioned

Correct Answer is : SQL:BatchCompleted

4. Which of the following stored procedure will stop the trace ?

A. sp_trace_create.

B. sp_trace_setfilter

C. sp_trace_setstatus

D. sp_stop_status

Correct Answer is : sp_trace_setstatus

5. Point out the wrong statement :

A. If a filter is set, all events of the selected event classes are returned in the trace output

B. A trace captures data based on selected event classes, data columns, and filters. For example, you can create a trace to monitor exception errors

C. A data column is an attribute of an event classes captured in the trace

D. All of the mentioned

Correct Answer is : If a filter is set, all events of the selected event classes are returned in the trace output

Data Profiling interview questions

Data Profiling interview questions

Take as many assements as you can to improve your validate your skill rating

Total Questions: 5

1. Which of the following is benefit of SQL Server Profiler ?

2. Point out the correct statement :

3. Which of the following is an event class ?

4. Which of the following stored procedure will stop the trace ?

5. Point out the wrong statement :

Similar Interview Questions

Search for latest jobs

For Employers

For Partner

For Jobseekers

Help

Follow Us

snaprecruit