Exam DP-300 All Questions

View all questions & answers for the DP-300 exam

Exam DP-300 topic 3 question 41 discussion

Actual exam question from Microsoft's DP-300

Question #: 41
Topic #: 3

DRAG DROP
-

You have a database named db1.

The log for db1 contains the following entry.

You need to ensure that db1 can process transactions.

Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

Show Suggested Answer

Suggested Answer:

by kkkiet at Feb. 22, 2023, 8:25 a.m.

Comments

Submit Cancel

amazonalex

Highly Voted 2 years, 1 month ago

my take would be: 1.remove db1 from ag, 2. backup t.log , 3 re-add db1 to ag . shrinking log shouldn't be necessary since log backup will reduce its size

upvoted 12 times

04db10c

11 months, 1 week ago

Log backups wont reduce the size of the file. after a backup we need to shrink seperately, Transaction Log File Behavior: Log Truncation: After a backup (either full or transaction log), SQL Server marks the inactive portion of the transaction log as reusable. This process is known as log truncation. File Size Management: The size of the transaction log file itself is managed separately from backups. It grows as transactions are logged and requires periodic management to maintain an appropriate size.

upvoted 1 times

...

dryd

1 year, 11 months ago

Correct. You need to free the space of available transactional log capacity. Shrinking would reduce the physical size on disk, but not applicable space

upvoted 2 times

...

kkkiet

Highly Voted 2 years, 3 months ago

Back up the transaction log file. Remove db1 from the availability group. Shrink the transaction log file.

upvoted 5 times

Sutariya

2 years, 2 months ago

First need to remove DB from AG then sometime its log file auto clean from full to 90% space then shrink log file and readd into AG

upvoted 4 times

...

jm2015

1 year, 7 months ago

Agree with your answer. Add db1 back to the availability group is not necessary to create some spaces. https://learn.microsoft.com/en-us/troubleshoot/sql/database-engine/availability-groups/error-9002-transaction-log-large

upvoted 1 times

...

dorwai

Most Recent 8 months, 3 weeks ago

1: backup the log, 2: remove the db from AG, 3: add the db back into the AG

upvoted 1 times

...

04db10c

11 months, 2 weeks ago

We do not need to take a backup, because backup is not causing a logfile growth.Actual root cause is AG, so after removed the DB from AG , you can shrink the logfile, so answer is correct.

upvoted 1 times

...

IchiruTake

1 year, 10 months ago

Based on amazonalex with https://www.sqlshack.com/sql-server-transaction-log-backup-truncate-and-shrink-operations/, my answer is Remove db1 from the Availability Group Backup the Transaction Log File Add db1 from the Availability Group

upvoted 3 times

...

vcloudpmp

1 year, 10 months ago

https://learn.microsoft.com/en-us/answers/questions/632536/shrink-a-database-log-file-which-is-synchronized-( Not seeing a need to remove from AG?

upvoted 1 times

vcloudpmp

1 year, 10 months ago

Got it. Avoid shrinking operation and instead back up the the log.

upvoted 1 times

...

MrDuck

2 years, 2 months ago

kkkiet do you have link for this source? trying to learn. thx. can't find a definitive answer

upvoted 1 times

...