70-462 Free Practice Test

- (Exam Topic 5)
Which of the following SQL Server 2012 tools assists DBAs in running and analyzing trace results?

1. A. SSIS
2. B. SQL Profiler
3. C. AlwaysOn
4. D. EXP

Correct Answer: B
References:
https://msdn.microsoft.com/en-us/library/ms187929(v=sql.110).aspx

- (Exam Topic 5)
You administer a Microsoft SQL Server 2012.
A process that normally runs in less than 10 seconds has been running for more than an hour. You examine the application log and discover that the process is using session ID 60.
You need to find out whether the process is being blocked. Which Transact-SQL statement should you use?

1. A. EXEC sp_who 60
2. B. SELECT * FROM sys.dm_exec_sessions WHERE sessionjd = 60
3. C. EXEC sp_helpdb 60
4. D. DBCC INPUTBUFFER (60)

Correct Answer: A
References:
http://msdn.microsoft.com/en-us/library/ms174313.aspx http://msdn.microsoft.com/en-us/library/ms176013.aspx http://msdn.microsoft.com/en-us/library/ms178568.aspx http://msdn.microsoft.com/en-us/library/ms187730.aspx

- (Exam Topic 4)
You develop a database for a travel application.
You need to design tables and other database objects. You create the Airline_Schedules table.
You need to store the departure and arrival dates and times of flights along with time zone information. What should you do?

1. A. Use the CAST function.
2. B. Use the DATE data type.
3. C. Use the FORMAT function.
4. D. Use an appropriate collation.
5. E. Use a user-defined table type.
6. F. Use the VARBINARY data type.
7. G. Use the DATETIME data type.
8. H. Use the DATETIME2 data type.
9. I. Use the DATETIMEOFFSET data type.
10. J. Use the TODATETIMEOFFSET function.

Correct Answer: I

- (Exam Topic 1)
You administer a Microsoft SQL Server 2012 database.
You provide temporary securityadmin access to User1 to the database server. You need to know if User1 adds logins to securityadmin.
Which server-level audit action group should you use?

1. A. SERVER_STATE_CHANGE_GROUP
2. B. SERVER_PRINCIPAL_IMPERSONATION_GROUP
3. C. SUCCESSFUL_LOGIN_GROUP
4. D. SERVER_ROLE_MEMBER_CHANGE_GROUP

Correct Answer: D
The SERVER_ROLE_MEMBER_CHANGE_GROUP event is raised whenever a login is added or removed from a fixed server role. This event is raised for the sp_addsrvrolemember and sp_dropsrvrolemember stored procedures. Equivalent to the Audit Add Login to Server Role Event Class.

- (Exam Topic 5)
Which of the following SQL Server 2012 database is NOT created by default in a new installation?

1. A. model
2. B. msdb
3. C. tempdb
4. D. sql
5. E. master

Correct Answer: A