nerdexam
Dell-EMC

E20-329 · Question #224

A customer is deploying a Microsoft SQL database and wants to perform online backups of the SQL database with EMC NetWorker. Their SQL database full backups cannot be completed within the backup…

The correct answer is A. Use stripes with SQL database backups. See the full explanation below for the reasoning.

Question

A customer is deploying a Microsoft SQL database and wants to perform online backups of the SQL database with EMC NetWorker. Their SQL database full backups cannot be completed within the backup window. After checking their backup environment, you find that there are adequate resources to meet their backup window. What could you do with NetWorker or SQL to increase performance without adding cost and complexity?

Options

  • AUse stripes with SQL database backups
  • BEnable SQL filegroup backups
  • CIncrease the value of FILESPERSET
  • DIncrease the value of MAXOPENFILES

How the community answered

(50 responses)
  • A
    72% (36)
  • B
    14% (7)
  • C
    4% (2)
  • D
    10% (5)

Community Discussion

No community discussion yet for this question.

Full E20-329 Practice