ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 70-463 All Questions

View all questions & answers for the 70-463 exam
Go to Exam

Exam 70-463 topic 3 question 62 discussion

Actual exam question from Microsoft's 70-463
Question #: 62
Topic #: 3
[All 70-463 Questions]

HOTSPOT -
You have a data warehouse that is hosted in a SQL Server instance. The data in the data warehouse is loaded by running bcp.exe.
You discover that the transaction logs regularly fill up the local hard disk on the server and that a WRITELOG wait is present.
You need to reduce the amount of disk space used to store the transaction logs and to remove the WRITELOG wait.
Which two database property settings should you modify? To answer, select the appropriate settings in the answer area.
Hot Area:

Show Suggested Answer Hide Answer
Suggested Answer:
by LuckyKatt at Jan. 6, 2020, 2:35 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
cornford
4 years, 9 months ago
Recovery model if changed to bulk logged would reduce the amount of information written to the logs so much less likely to fill up the disks. Delayed durability enabled would remove the log writing contention so reduce the waits.
upvoted 1 times
...
LuckyKatt
5 years, 5 months ago
I think Delayed Durability enabled instead of Concatenate null yields null is correct.
upvoted 2 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel