Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Lets assume you are a DBA and you manage a very large OLAP database that need to have a backup policy. What is/are your

1. Lets assume you are a DBA and you manage a very large OLAP database that need to have a backup policy. What is/are your best option(s)?

A). Perform a nightly full backup and hourly differential backups using SQL Server backup utility

B). Once a week cold backup should be enough

C). Perform a nightly full backup and hourly transaction log backup using SQL Server backup utility

D). Use database snapshot technology

2. You want to verify your backups. What would you say is the least efficient way to verify the backup?

A). Restore you backups to a test system just to make sure things look good

B).

Restore filelistonly command

C).

When you setup a backup through SMSS, choose the option to verity the backup.

D).

Setup a standby SQL Server to verify backups

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Excel As Your Database

Authors: Paul Cornell

1st Edition

1590597516, 978-1590597514

More Books

Students also viewed these Databases questions

Question

Evaluate the expression. 25) 10P4 A) 1 B) 720 C) 5040 D) 10

Answered: 1 week ago

Question

=+Where do you want to live and work?

Answered: 1 week ago