欢迎来到PP题库网 PP题库官网
logo
全部科目 > 微软认证考试 > MCITP > MCITP(70-450)

单项选择题

You are a professional level SQL Sever 2008 Database Administrator in an international corporation named Wiikigo. You are experienced in managing databases in an enterprise-level organization, optimizing and sustaining the database life cycle. In the company, your job is to implement solutions on security, troubleshooting, deployment and optimization. A SQL Server 2008 database solution is managed by you. All data changes are implemented through stored procedures, and only the INSERT, UPDATE, or DELETE statements are utilized by the procedures. A backup strategy should be implemented. The business requirements listed below should be satisfied. Point-in-time recovery for failure is supported by the backup strategy at any time of day. In addition, the least amount of disk space should be utilized by the transaction log. 
Which action should you perform to finish the task?()

    A.To finish the task, hourly database snapshots should be utilized. 
    B.To finish the task, the full-recovery model along with transaction log backups should be utilized.
    C.To finish the task, the full-recovery model along with differential backups should be utilized.
    D.To finish the task, the simple-recovery model along with differential backups should be utilized. 

点击查看答案

相关考题

微信小程序免费搜题
微信扫一扫,加关注免费搜题

微信扫一扫,加关注免费搜题