Brainscape's Knowledge GenomeTM

Browse over 1 million classes created by top students, professors, publishers, and experts.


See full index

SQL 70-432 > Maintaining a SQL SVR Database > Flashcards

Maintaining a SQL SVR Database Flashcards

1
Q

You are the database administrator for Fabrikam. The Orders database is critical to company operations and is set to the FULL recovery model. You are running full backups daily at 1 A.M., differential backups every four hours beginning at 5 A.M., and transaction log backups every 5 minutes. If the Orders database were to become damaged and go offline, what is the first step in the restore process?

  • Back up the transaction log with the NO_TRUNCATE option.
  • Restore the most recent differential backup with the NORECOVERY option.
  • Restore the most recent full backup with the NORECOVERY option.
  • Back up the transaction log with the TRUNCATE_ONLY option.
A

Back up the transaction log with the NO_TRUNCATE option.

EXPLANATION:

The first step of every restore operation is to back up the tail of the log. However, the BACKUP LOG command writes an entry into the transaction log as well as the master data file. If the database is offline, you can back up the transaction log but not write to the master data file. The NO_TRUNCATE option allows you to back up the transaction log without writing to the master data file.

Exam Objective:
Maintaining a SQL Server Database

Exam SubObjective(s):
 Back up databases.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
2
Q

You are the database administrator at Blue Yonder Airlines and are primarily responsible for the Reservations database, which runs on a server running SQL Server 2008. In addition to customers booking flights through the company’s Web site, flights can be booked with several partners. Once an hour, the Reservations database receives multiple files from partners, which are then loaded into the database using the Bulk Copy Program (BCP) utility. You need to ensure that you can recover the database to any point in time while also maximizing the performance of import routines. How would you configure the database to meet business requirements?

  • Configure the database in the bulk-logged recovery model
  • Set PARAMETERIZATION FORCED on the database
  • Configure the database in the full recovery model
  • Enable AUTO_SHRINK
A

Configure the database in the full recovery model.

EXPLANATION:

The full recovery model ensures that you can always recover the database to any point in time.

Exam Objective:
Maintaining a SQL Server Database

Exam SubObjective(s):
 Back up databases.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
3
Q

The server that the Customers database is running on fails and needs to be replaced. You build a new server and install SQL Server 2008. When you built the new server, you decided that instead of configuring the new server exactly like the old one, you implement a new drive letter and folder structure for data and log files. Which option do you need to use when you restore the Customers database to the new server?

  • MOVE
  • CONTINUE_AFTER_ERROR
  • NORECOVERY
  • PARTIAL
A

MOVE

EXPLANATION:

Because you have a new storage structure on the file system, you need to move the data and log files to new locations. The MOVE option allows you to specify a new location for files when you restore the full backup.

Exam Objective:
Maintaining a SQL Server Database

Exam SubObjective(s):
 Restore databases.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
4
Q

You have a reference database named OrderHistory, which should not allow any data to be modified. How can you ensure, with the least amount of effort, that users can only read data from the database?

  • Grant select permission on the database to all users and revoke insert, update, and delete permissions from all users on the database.
  • Add all database users to the db_datareader role.
  • Create views for all the tables and grant select permission only on the views to database users.
  • Set the database to READ_ONLY.
A

Set the database to READ_ONLY.

EXPLANATION:

Unless the database is in READ_ONLY mode, members of the db_owner role can still change data in the database.

Exam Objective:
Maintaining a SQL Server Database

Exam SubObjective(s):
 Manage and configure database
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
5
Q

A database snapshot can be created against which database? (Choose all that apply. Each answer is a complete solution.)

  1. master
  2. distribution
  3. A database with full text indexes
  4. A database with FILESTREAM data
A
  1. A database with full text indexes
  2. A database with FILESTREAM data

EXPLANATION:

Although you cannot execute full text queries against a database snapshot, you can create a database snapshot against a database that contains full-text indexes.

Although FILESTREAM data is inaccessible through a database snapshot, you can create a database snapshot against a database that is enabled for FILESTREAM.

Exam Objective:
Maintaining a SQL Server Database

Exam SubObjective(s):
 Manage database snapshots.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly
6
Q

Which commands are executed when you run the DBCC CHECKDB command? (Check all that apply.)

  1. DBCC FREEPROCCACHE
  2. DBCC CHECKCATALOG
  3. DBCC CHECKIDENT
  4. DBCC CHECKTABLE
A
  1. DBCC CHECKCATALOG
  2. DBCC CHECKTABLE

EXPLANATION:

A DBCC CHECKDB command executes DBCC CHECKTABLE, DBCC CHECKALLOC, and DBCC CHECKCATALOG.

Exam Objective:
Maintaining a SQL Server Database

Exam SubObjective(s):
 Maintain database integrity.
How well did you know this?
1
Not at all
2
3
4
5
Perfectly

SQL 70-432 (9 decks)

Brainscape helps you reach your goals faster, through stronger study habits.
© 2024 Bold Learning Solutions. Terms and Conditions