Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
Exam
: Microsoft 70-229
Title
: Microsoft Designing and
Implementing Databases
with Microsoft SQL Server
2000, Enterprise Edition
Version : Demo
Exam1pass
Easiest way to pass IT exams
Exam1pass Help You Pass Any IT Exam
http://www.exam1pass.com
1. You are a database developer for a publishing company. You are designing a series of databases that will
store excerpts of news articles. The database will be used for this purpose only. The data that will be stored
includes text and images. The text columns will be bulk loaded from files. Each database will store data for
one month of articles. Your database maintenance plan includes weekly re-indexing of the tables within
each database.
You must minimize the impact of the database maintenance on users of the database while retaining the
ability to recover from media failure. You want to accomplish this by using the least amount of
administrative effort.
You are creating the first database, which is named Jan00. Which script should you use to create this
database?
A. CREATE DATABASE Jan00 ON ( NAME = Jan00_dat, FILENAME = 'c:\data\Jan00.mdf')
GO ALTER DATABASE Jan00 SET RECOVERY BULK_LOGGED GO
B. ALTER DATABASE model SET RECOVERY BULK_LOGGED GO CREATE DATABASE Jan00 ON
(
NAME = Jan00_dat, FILENAME = 'c:\data\Jan00.mdf') GO
C. CREATE DATABASE Jan00 ON ( NAME = Jan00_dat, FILENAME = 'c:\data\Jan00.mdf') GO ALTER
DATABASE Jan00 SET RECOVERY FULL GO
D. CREATE DATABASE Jan00 ON ( NAME = Jan00_dat, FILENAME = 'c:\data\Jan00.mdf') GO ALTER
DATABASE Jan00 SET RECOVERY SIMPLE
GO
Answer: B
2. You are a database developer for an insurance company. The company has one main office and 18
regional offices. Each office has one SQL Server 2000 database. The regional offices are connected to the
main office by a high-speed network. he main office database is used to consolidate information from the
regional office databases. The tables in the main office database are partitioned horizont