READ Free Dumps For Microsoft- 70-461
| Question ID 15130 | You are developing a Microsoft SQL Server 2012 database for a company. The database
contains a table that is defined by the following Transact-SQL statement:
You use the following Transact-SQL script to insert new employee data into the table. Line
numbers are included for reference only.
If an error occurs, you must report the error message and line number at which the error
occurred and continue processing errors.
You need to complete the Transact-SQL script.
Which Transact-SQL segment should you insert at line 06?
|
| Option A | SELECT ERROR_LINE(), ERROR_MESSAGE()
|
| Option B | DECLARE @message NVARCHAR(1000),@severity INT, @state INT; SELECT @message = ERROR_MESSAGE(), @severity = ERROR_SEVERITY(), @state = ERROR_STATE(); RAISERROR (@message, @severity, @state);
|
| Option C | C. DECLARE @message NVARCHAR(1000),@severity INT, @state INT; SELECT @message = ERROR_MESSAGE(), @severity = ERROR_SEVERITY(), @state = ERROR_STATE(); THROW (@message, @severity, @state);
|
| Option D | THROW;
|
| Correct Answer | B |
Explanation Explanation: When the code in the CATCH block finishes, control passes to the statement immediately after the END CATCH statement. Errors trapped by a CATCH block are not returned to the calling application. If any part of the error information must be returned to the application, the code in the CATCH block must do so by using mechanisms such as SELECT result sets or the RAISERROR and PRINT statements. Reference: TRY...CATCH (Transact-SQL) https://msdn.microsoft.com/en-us/library/ms175976.aspx
| Question ID 15131 | You develop three Microsoft SQL Server 2012 databases named Database1, Database2,
and Database3. You have permissions on both Database1 and Database2.
You plan to write and deploy a stored procedure named dbo.usp_InsertEvent in
Database3. dbo.usp_InsertEvent must execute other stored procedures in the other
databases.
You need to ensure that callers that do not have permissions on Database1 or Database2
can execute the stored procedure.
Which Transact-SQL statement should you use?
|
| Option A | USE Database2
|
| Option B | EXECUTE AS OWNER
|
| Option C | USE Database1
|
| Option D | EXECUTE AS CALLER
|
| Correct Answer | B |
Explanation Reference: http://msdn.microsoft.com/en-us/library/ms188354.aspx Reference: http://blog.sqlauthority.com/2007/10/06/sql-server-executing-remote-stored- procedure-callingstored-procedure-on-linked-server/