Free Microsoft 70-469 Exam Dumps Questions & Answers

DRAG DROP
Your network contains a server named Server1 that runs SQL Server 2012. Server1 contains an instance named Instance1. Instance1 contains a database named ContentDatabase.
ContentDatabase uses transaction log backups.
The recovery model of ContentDatabase is set to FULL.
You need to shrink the ContentDatabase_Log log file to 10 MB. The solution must ensure that you can continue to back up the transaction log.
Which three code segments should you execute?
To answer, move the appropriate code segments from the list of code segments to the answer area and arrange them in the correct order.

Correct Answer:

You use SQL Server 2014 to maintain the data used by applications at your company.
You want to execute two statements.
You need to guarantee that either both statements succeed, or both statements fail
together as a batch.
Which code should you use?

• A.  Option D
• B.  Option A
• C.  Option B
• D.  Option C
• E.  Option E

You need to implement a solution that meets the data recovery requirements. You update each stored procedure to accept a parameter named @transactionID. What should you add next to the beginning of each stored procedure?

• A.  SAVE TRANSACTION WITH MARK @transactionID
• B.  BEGIN TRANSACTION WITH MARK @transactionID
• C.  COMMIT TRANSACTION @transactionID
• D.  ROLLBACK DISTRIBUTED TRANSACTION @transactionID

You need to add a new column named Confirmed to the Attendees table.
The solution must meet the following requirements:
- Have a default value of false.
- Minimize the amount of disk space used.
Which code block should you use?

• A.  ALTER TABLE Attendees
  ADD Confirmed char(l) DEFAULT '1';
• B.  ALTER TABLE Attendees
  ADD Confirmed bit DEFAULT 1;
• C.  ALTER TABLE Attendees
  ADD Confirmed bit DEFAULT 0;
• D.  ALTER TABLE Attendees
  ADD Confirmed char(l) DEFAULT '1';

You need to encapsulate a T-SQL script into a reusable user-defined object.
The object must meet the following requirements:
Permit insertions into a table variable.
Support structured exception handling.
Prevent changes to the definition of referenced objects.
Support the use of the APPLY operator on the output of the object.
Which type of object should you use?

• A.  A multi-statement table-valued function
• B.  An inline table-valued function
• C.  A stored procedure
• D.  A scalar user-defined function