Exam 70-464 topic 1 question 116 discussion

Actual exam question from Microsoft's 70-464

Question #: 116
Topic #: 1

You have a SQL Server database.
The recovery model is set to full. The transaction log is backed up every night.
You discover that the transaction log never decreases in size.
You execute the DBCC SHRINKFILE statement for the transaction log and you discover that the transaction log is unaffected.
You need to ensure that you can reduce the size of the transaction log.
What should you do first?

A. Truncate the transaction log
B. Kill long-running transactions
C. Change the recovery model to bulk-logged
D. Perform a full backup

Show Suggested Answer

Suggested Answer: A 🗳️
The transaction log must be truncated before running the DBCC SHRINKFILE operation.
Incorrect Answers:
C: The transaction log can be truncated by setting the database recovery model to SIMPLE, or by backing up the log and then running the DBCC SHRINKFILE operation again.
References:
https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-shrinkfile-transact-sql?view=sql-server-2017

by Dolous at Jan. 19, 2021, 12:09 p.m.

Comments

Submit Cancel

Dolous

4 years, 5 months ago

Answer B

upvoted 1 times

...