Database Administration I

  • Question 1

0 out of 4 points

Which is not a step while configuring alerting events?
Selected Answer:  

d. Define operators and configure notifications when a job fails

Correct Answer:  

c. Delete temp space

  • Question 2

4 out of 4 points

A tail-log backup does not enable you capture all log records that have not been backed up:
Selected Answer:  

b. False

Correct Answer:  

b. False

  • Question 3

4 out of 4 points

This occurs when you perform a read-only, static view of a database at a point in time:
Selected Answer:  

b. Database snapshot

Correct Answer:  

b. Database snapshot

  • Question 4

0 out of 4 points

___________ is considered the baseline for your backup strategy:
Selected Answer:  

d. Log

Correct Answer:  

b. Full

  • Question 5

0 out of 4 points

The___________ log backs up the transaction log between the calculated minimum LSN and the backup end LSN.
Selected Answer:  

a. Checkpoint

Correct Answer:  

d. Backup

  • Question 6

4 out of 4 points

Which of the following is not a recovery objective?
Selected Answer:  

b. Recovery Row Objective (RRO)

Correct Answer:  

b. Recovery Row Objective (RRO)

  • Question 7

0 out of 4 points

A tail-log backup:
Selected Answer:  

c. Enables you to avoid data loss if you plan to perform a restore operation for an online database

Correct Answer:  

d. All of the above

  • Question 8

0 out of 4 points

This backup type was introduced in SQL Server 2012 to make backing up very large databases that contain one or more read-only filegroups easier:
Selected Answer:  

d. Backup wizard

Correct Answer:  

b. Partial backup

  • Question 9

4 out of 4 points

What is the primary mechanism used to manage the transaction log so that it does not grow too large?
Selected Answer:  

a. Log backup

Correct Answer:  

a. Log backup

  • Question 10

0 out of 4 points

When the database cannot write to the transaction log because it is full and a 9002 error is generated, what causes this error?
Selected Answer:  

b. Free space is not available in the transaction log and it cannot grow because there is no more free space left on the disk

Correct Answer:  

d. All of the above

 

"Get Help With Your Essay
. If you need assistance with writing your essay, our professional essay writing service is here to help!

Order Now