首页
外语
计算机
考研
公务员
职业资格
财经
工程
司法
医学
专升本
自考
实用职业技能
登录
计算机
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
52
问题
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
AlmosteveryyearsincetheendofthefinancialcrisishasstartedwithrosyexpectationsamongAmericanforecasters,andthis
Writeanessayof160-200wordsbasedonthefollowingtable.Youressayshould1.describethechangesintheaveragefamilyex
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
In2016,manyshoppersoptedtoavoidthefreneticcrowdsanddotheirholidayshoppingfromthecomfortoftheircomputer.But
LastThursday,theFrenchSenatepassedadigitalservicestax,whichwouldimposeanentirelynewtaxonlargemultinationalst
Thehumanbraincontains10thousandmillioncellsandeachofthesemayhaveathousandconnections.Suchenormousnumbersused
NextmonthBritonswillhaveyetmoresmartphonestochoosefrom,whendevicesfromWiko,atwo-year-oldFrenchcompany,goons
在用户管理组administrators中添加本地用户“sy”。
随机试题
薹神经系统起源于__________,由__________和__________分化而成。
要约的内容必须具体确定。()
安全生产责任制是劳动安全卫生管理制度的________,也是用人单位岗位责任制的一个组成部分。()
监事由______选举产生,由股东代表和公司职工代表担任,两者比例由公司章程规定。
茵陈五苓散用于治疗
土地征收的补偿安置,每公顷被征收耕地的安置补助费,最高不得超过被征收前三年平均年产值的()倍。
某国的政治风险评级为35,财务风险评级为30,经济风险评级为25,则使用PRS集团的计算方法得到的国家综合风险是()。
_______是系统部件之间传送信息的公共通道,各部件由总线连接并通过它传递数据和控制信号。
Unlikemostsports,whichevolvedovertimefromstreetgames,basketballwasdesignedbyonemanto(l)______aparticularpurpo
Archaeologistshavelongthoughtthatstoneshipsservedasgravesforoneorseveralindividuals,andhaveevenbeenviewedas
最新回复
(
0
)