首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
You are the administrator of SQL Server 2000 computer. The server contains a database named Medical Records. This database conta
You are the administrator of SQL Server 2000 computer. The server contains a database named Medical Records. This database conta
admin
2009-05-19
48
问题
You are the administrator of SQL Server 2000 computer. The server contains a database named Medical Records. This database contains clinical records and administrative records. The database consumes about 30GB of disk space. The data files are configured as shown in the exhibit.
You run full database backups each night after business hours. You notice that the backup is not complete by the time the morning shift begins to use the database.
You need to minimize the time needed to restore data in the event of a system, failure. You also want to reconfigure the database to allow the backups to complete during the evening hours.
Which two actions should you take? (Each correct answer represents part of the solution. Choose two)
A. Reorganize the data files into two groups. Place the system tables in the PRIMARY filegroup and the user-defined tables in the other filegroup.
B. Reorganize the data files into three groups. Place the system tables and shared objects in the PRIMARY filegroup, the clinical records in a filegroup, and the administrative records in a filegroup.
C. Reorganize the data files into three groups. Place the system tables in the PRIMARY filegroup, the indexes in a filegroup, and the tables in the other filegroup.
D. Back up the transaction log each night. Run a filegroup backup on a different filegroup each night.
E. Back up the transaction log each night. Run a filegroup backup on the database each weekend.
F. Back up the transaction log each night. Run a differential backup each Sunday, and run a full backup the first day of each month.
选项
答案
B,D
解析
Explanation:
B: Split the data into three filegroups: one for system tables and shared object, one for clinical records, and one for administrative records.
The primary filegroup must contain the system tables.
D: By separating the data we can rotate the backup of the filegroups and only backup a single filegroup each night. This will make the backup process quicker and would allow it to complete before business starts in the morning. In order to be able to recover we should also make a log backup every night.
Note: SQL Server 2000 supports backing up or restoring individual files or filegroups within a database, it is possible to reduce backup time by placing data and tables in separate filegroups. Tables, indexes, and text, ntext, and image data can be placed in a specific filegroup. A database can only have one primary filegroup. This filegroup contains the primary data file and any other files not placed in another filegroup. All pages for the system tables are allocated from the primary filegroup. However, a number of user-defined filegroups can be defined for a database. It would thus be possible to reorganize the data files into three groups that can each be backed up separately.
The transaction log holds a record of all modifications that have occurred in the database as well as the transaction that have performed each modification since the transaction log was last backed up. With transaction log backups, it is possible to recover the database to a specific point in time or to the point of failure. They generally use fewer resources than database backups and can thus be backed up more frequently than database backups. This would decrease risk of data loss; however, transaction log backups are used only with the Full and Bulk-Logged Recovery models.
Incorrect Answers:
A: Tables, indexes, and text, ntext, and image data can be placed in specific filegroups. However, the user-defined tables would be much larger than the system tables and might require further partitioning to ensure that the backup of this filegroup is complete.
C: Splitting the indexes and the tables into different filegroups could increase performance for join querires. It would not be a good idea in this scenario however since the separate filegroups are backup up on different days. Therefore a restore operation could give a situation where the indexes and the tables not were up to date. In fact if the indexes of a table span multiple filegroups, all filegroups containing the table and its indexes must be backed up together
E: Running a filegroup backup on the weekend would increase the amount of time between data backups and would increase the time required for recovery as each transaction log backup created since the last filegroup backup would have to be restored in the same sequence in which they were created.
F: Running a differential backup each Sunday, and run a full backup the first day of each month while backing up the transaction log each night would increase the required time for data recovery. In this solution we would have to back up the active transaction log, restore the most recent database backup, restore the most recent differential backup and then restore each transaction log backup created since the last differential backup in the same sequence in which they were created.
转载请注明原文地址:https://kaotiyun.com/show/ruhZ777K
本试题收录于:
微软70228题库微软认证分类
0
微软70228
微软认证
相关试题推荐
Severaltypesoffinancialriskareencounteredininternationalmarketing;themajorproblemsincludecommercial,political,an
Ofallthegoodsandservicestradedinthemarketeconomy,pharmaceuticalsareperhapsthemostcontentious.Thoughproducedby
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
Supposeyouorderedahairdryeronlineatthecostof$22,butonlyreceivedanemptypackagebox.Somethingmustbewrong.Wri
EricHansenwritesabouttravelasaparticipatingenthusiastratherthanamereobserver.【T1】Itgivesthesenineessays,based
Herearesomemanagementtoolsthatcanbeusedtohelpyouleadapurposefullife.1.UseYourResourcesWisely.Yourdecisi
Adealisadeal—except,apparently,whenEntergyisinvolved.Thecompany,amajorenergysupplierinNewEngland,provokedjus
InToday’smanagement-theoryindustry,reputation—oratleastthecorporatekind—isa"strategicasset"thatcanbe"leveraged"
NextmonthBritonswillhaveyetmoresmartphonestochoosefrom,whendevicesfromWiko,atwo-year-oldFrenchcompany,goons
Writealettertorecommendyourstudent,LiXu,forapositionofadministratorinacompany.Youshouldincludethedetailsyo
随机试题
在碘量法中,当溶液呈现深蓝色时,这是()。
关于体层摄影支点的说法,正确的是
三期梅毒的标志性表现是
关于基坑土方开挖说法,正确的有()。
团体旅客乘坐火车旅行,如要办理退票,必须在开车()个小时以前办理手续。
罗杰斯的“以学生为本”“让学生自发学习”“排除对学习者自身的威胁”的教学原则属于()。
工作报告在党的机关可用于()。
非正式组织
软件维护活动包括以下儿类:改正性维护、适应性维护、()维护和预防性维护。
ThenightofDecember16,1773,dozensofMassachusettscolonistsquietlyboardedthreeshipsanddumpedwhatwouldnowbeclose
最新回复
(
0
)