Microsoft
70-432 · Question #113
You are mastering the company database called TesterDB; The database includes a database that uses SQL Server log shipping. Log shipping will happen half a hour. You should make the full backup. In…
The correct answer is B. You should reproduce only those indexes that ask it every night. See the full explanation below for the reasoning.
Question
You are mastering the company database called TesterDB; The database includes a database that uses SQL Server log shipping. Log shipping will happen half a hour. You should make the full backup. In order to cut the net bandwidth utilization when maintenance every night. Which is the correct answer?
Options
- AYou should set the database to utilize the bulk-logged recovery model.
- BYou should reproduce only those indexes that ask it every night.
- CYou should add the time during transaction log backups.
- DYou should disable log shipping after the nightly maintenance.
How the community answered
(26 responses)- A8% (2)
- B77% (20)
- C4% (1)
- D12% (3)
Community Discussion
No community discussion yet for this question.