MCSE2000---sql admin(4)

站 (Thu Apr 19 08:30:44 2001), 转信
46. Laura is the new sales coordinator for your company. She will process al
l orders. You want Laura to be able to modify the Order database only throug
h the Order application. How should you control access to the Order database
?
A. Use a stored procedure that Laura has permission to execute.
B. Use a user-defined application role that has UPDATE permissions on the Or
der database.
C. Use a SQL Server user account that has UPDATE permissions on the Order da
tabase.
D. Use a view of the Order database in which Laura has UPDATE permissions on
the Order database.
Answer: B
47. Your company purchases a new Pentium computer that has 256 MB of RAM and
five 18.2-GB disk drives. The new computer will be used to support the Payr
oll application. The application requires the highest availability and perfo
rmance possible. The Payroll database has been initially sized at 25 GB. You
need to organize the database files on the new computer. Which actions shou
ld you take?
A. Create a hardware RAID 0 configuration that uses all the disk drives. Cre
ate the primary data file and a transaction log data file on the RAID 0 set.
B. Create a software RAID 5 configuration that uses all the disk drives. Cre
ate the primary data file and a transaction log data file on the RAID 5 set.
C. Create one mirrored set that uses drives D and E, Create another mirrored
set that uses drives F and G, Create the primary data file on one of the mi
rrored sets, Create the transaction log file on the other mirrored set.
D. Create a mirrored set that uses drives F and G, Create the transaction lo
g file on the mirrored set. Create a hardware RAID 5 set that uses drives C,
D, and E, Create the primary data file on the RAID 5 set.
Answer: D
48. The Claims database contains more than 50 million rows and requires 100
GB of disk space. It uses five database files. Users in the Usage Analysis d
epartment use a variety of graphical query tools to query the Claims databas
e every business day, between 8 A.M. and 4 P.M. There is a scheduled nightly
batch job that runs at 2 A.M. to update the database with the previous day"
s claims. A full database backup or restore takes approximately six hours. Y
ou need to develop a backup strategy that can support recovery to the end of
the previous business day and that can recover from a failure in less than
12 hours. Which set of backups should you choose?
A. full database backup every Sunday differential database backups every nig
ht after the batch job is completed
B. full database backup every Sunday transaction log backups every six hours
C. full database backup every Sunday database file backup on a rotating basi
s throughout each week transaction log backups every six hours
D. database file backup on a rotating basis throughout each week transaction
log backups every six hours
Answer: A
49. You plan to implement a large batch job. You want to be able to restore
the database quickly and easily in the event that the batch job fails. What
should you do before running the batch job?
A. Perform a differential database backup of the database.
B. Perform a full database backup of the database.
C. Perform a backup of the transaction log.
D. Use a single transaction to perform the batch job.
Answer: B
50. Stephen tries to connect to the Sales database by using SQL Server Enter
prise Manager. He receives the message "Unable to open default database "" .
" You notice that neither Stephen nor the guest account was granted access
to the Sales database. What must you do to give only Stephen access with the
minimum permissions?
A. Remove Stephen from the db_denydatareader and db_denydatawriter roles.
B. Add Stephen"s login as a new user in the Sales database.
C. Change the default database in Stephen"s Login properties dialog box.
D. Add the guest account to the Sales database in the Database users dialog
box.
Answer: B
51. Katrin is the system administrator of SQL Server, and she is in the role
of db owner of the corporate database. Carlos is in the roles of setupadmin
and db_accessadmin. Julia is in the roles of securityadmin and db_securitya
dmin. Katrin must ensure that only she can grant permissions in the database
and that only Julia can grant users and groups access to SQL Server and the
corporate database. How must role membership be changed to meet these requi
rements? (Choose two.)
A. Add Julia to the serveradmin role.
B. Remove Carlos from the db_accessadmin role.
C. Remove Julia from the db_securityadmin role.
D. Add Julia to the db_accessadmin role.
E. Add Katrin to the db_securityadmin role.
F. Add Katrin to the db_accessadmin role.
G. Remove Carlos from the setupadmin role.
Answer: B, C
52. You install merge replication. You are investigating the default conflic
t resolution. You verity that the value of the ContactName field is Carolyn
Seeley for customer 10 in a merge article on both the Publisher and the Subs
criber. The value of ContactName for customer 10 on the Publisher is changed
to Amy Jones. The value of ContactName for customer 10 on the Subscriber is
changed to Jenny Sm. The Merge Agent runs. What is the value of CantactName
for customer 10 on the Publisher and on the Subscriber after conflict resol
ution?
A. Amy Jones on both the Publisher and the Subscriber
B. Jenny Sax on both the Publisher and the Subscriber
C. Amy Jones on the Publisher and Carolyn Seeley on the Subscriber
D. Jenny Sax on the Publisher and Amy Jones on the Subscriber
Answer: A
53. You want to configure SQL Server to notify you by e-mail when an alert o
ccurs. Which series of steps must you perform?
A. Configure the SQL Server Agent service to log on as the local system acco
unt. Log on to the server running SQL Server as your user account, and confi
gure e-mail connectivity. Configure the SQLServerAgent service to use the re
sulting e-mail profile.
B. Configure the SQLServerAgent service to log on as a domain user account.
Log on to the server running SQL Server as the SQL Server Agent account, and
configure e-mail connectivity. Configure the SQLServerAgent service to use
the resulting e-mail profile.
C. Configure the MSSQLServer service to log on as a domain user account. Log
on to the server running SQL Server as the SQL Server account, and configur
e e-mail connectivity. Configure SQL Mail to use the resulting e-mail profil
e.
D. Configure the MSSQLServer service to log on as a domain user account. Log
on to the server running SQL Server as your user account. and configure e-m
ail connectivity. Configure SQL Mail to use the resulting e-mail profile.
Answer: B
54. The Periodicals database is 10 GB in size. You specify multiple tape-bac
kup devices, and you schedule a full database backup to occur nightly. One n
ight, the backup fails while writing to the third tape. You resolve the prob
lem with the tape. What is the fastest way to complete the backup?
A. Rerun the scheduled job.
B. Manually back up the database and use the INIT option.
C. Manually back up the database and use the NOINIT option.
D. Manually back up the database and use the RESTART option.
Answer: D
55. The disk drive containing your master database fails, Your user database
s are unaffected. You cannot locate a recent master database backup, so you
rebuild the master database. What should you do to ensure that your user dat
abases are accessible in the shortest amount of time?
A. Restore the user databases from an existing backup.
B. Attach the existing user databases to the now master database.
C. Manually edit the master database system catalog, and add references to t
he user databases.
D. Do nothing. The process of rebuilding the master database automatically r
estores links to the user databases.
Answer: B
56. Your company"s current applications use Microsoft Access. New applicatio
ns will use SQL Server. The new applications must be able to access data fro
m the Access database. What must you do so that SQL Server queries can acces
s the Access database?
A. Register connection information for the Access database in SQL Server.
B. Register connection information for SQL Server in the Access database.
C. Establish a connection to the Access database when a query is executed.
D. Use the same Microsoft Windows NT domain account for the Access database
and SQL Server.
Answer: A
57. You enable merge replication. What must you do to enable conflict resolu
tion on the articles in your publication?
A. Add a column to each article, and assign the IDENTITY property to each co
lumn.
B. Add a column of the timestamp date type to, each article.
C. Add a column of the uniqueidentifier date type to each article.
D. Do nothing. SQL Server will add a column of the uniqueidentifier data typ
e to each article.
Answer: D
58. You want to schedule the Finances database so that backups occur accordi
ng to the following three requirements: every two hours, Monday through Frid
ay, 8 A.M. to 6 P.M. every four hours, Monday through Friday, 8 P.M. to 4 A.
M. the following day every eight hours, 6 A.M. Saturday to 10 P.M. Sunday Yo
u Want to minimize the number of scheduled jobs. How should you schedule the
backups?
A. Create one single-step job to back up the database. Schedule the job to r
un according to the three requirements.
B. Create one multistep job consisting of three separate steps to back up th
e database according to the three requirements.
C. Create three separate single-step jobs to back up the database. Schedule
the three jobs according to the three requirements.
D. Use the Windows NT at command to create three scheduled jobs to back up t
he database according to the three requirements.
Answer: A
59. The backup schedule for the Accounting database is shown in the followin
g table.
-1:00 A.M. Full database backup
-7:00 A.M. Transaction log backup
-8:00 A.M. Transaction log backup
-9:00 A.M. Transaction log backup
At 8.45 A.M. on October 10, 1998 a user runs a now transaction that incorrec
tly updates data in several tables. The manager of the Accounting department
tells you that all updates after that time can be reconstructed from the pa
per forms. You restore the 1:00 A.M. full database backup. Which set of step
s is the best method to use to restore the database to a consistent state cl
osest to what the state was at 8:45 A.M.?
A. Restore the 7:00 A.M. transaction log backup by using the WITH NORECOVERY
option.
B. Restore the 8:00 A.M. transaction log backup by using the WITH NORECOVERY
option.
C. Restore the 9:00 A.M. transaction log backup by using the WITH RECOVERY o
ption and the STOPAT = "Oct 10. 1998, 8:44 AM" option.
Answer: A
60. The corporate database contains only three tables, which are named sales
, credit, and prices. Four Windows NT groups in the domain are named Marketi
ng_users, Marketing_mgrnt, Finance_users, and Finance_mgmt. All of these gro
ups have SELECT permissions on all three tables. You want only the Marketing
_mgmt group to have UPDATE permissions on the sales table. You want only the
Finance_mgmt group to have UPDATE permissions on the credit and prices tabl
es. What must you do to ensure that the Marketing_mgmt group and the Finance
_mgmt group get the appropriate permissions? (Choose two.)
A. Add the Marketing_mgmt group to the db_denydatawriter role for the credit
and prices tables. Add the Marketing_mgmt group to the db_datawriter role f
or the sales table.
B. Add the Finance_mgmt group to the db_denydatawriter role for the sales ta
ble. Add the Finance_mgmt group to the db_datawriter role for the credit and
prices tables.
C. Grant the Finance_mgmt group UPDATE and DELETE permissions on the credit
and prices tables.
D. Grant the Marketing_mgmt group UPDATE and DELETE permissions on the sales
table.
E. Add the Finance_mgmt group to the db_datawriter role. Grant the Finance_m
gmt group SELECT permissions an the sales table.
F. Add the Marketing_mgmt group to the db_datawriter role. Grant the Marketi
ng_mgmt group SELECT permissions on the credit and prices tables.
Answer: C, D
61. Your company"s network contains UNIX and NetWare legacy systems in addit
ion to a Windows NT 4.0 domain. Many users log in to the legacy systems for
access to e-mail and proprietary software. Currently, only Windows NT accoun
ts are able to access SQL Server. What must you do to give the UNIX and NetW
are Users the same access to the SQL Server database that current members of
the Windows NT domain have? (Choose all that apply)
A. Create SQL Server logins for the UNIX and NetWare users.
B. Create Windows NT accounts for the UNIX and NetWare users.
C. Add the UNIX and NetWare users to the appropriate Windows NT groups.
D. Add the UNIX and NetWare users to the appropriate SQL Server roles.
E. Ensure that security on SQL Server is set to Mixed Mode.
Answer: A, D, E
62. Ketrin and Stefan have Windows NT accounts. They are not members of the
Windows NT Administrators group. You need to give each of them database owne
r access to the Marketing database, but you want to ensure that you can iden
tify the actions of each of them within the database. How should Katrin"s an
d Stefan"s accounts be constructed in order to identify their individual act

ivity?
A. Create a separate SQL Server login for each of them with dbo permissions.
B. Create a separate SQL Server login for each of them, and add these logins
to the db_owner role in the database.
C. Add their Windows NT accounts to the db_owner role in the database.
D. Create a new role with dbo permissions, add Katrin"s Windows NT account t
o this new role and add Stefan"s Windows NT account to the db_owner role.
Answer: C
63. Your company has three servers running SQL Server in adjoining buildings
. You are responsible for monitoring performance of stored procedures and fo
r monitoring the connections to the servers. In order to do this monitoring,
you want to forward all applicable information to the server in your buildi
ng. You also want to automatically start monitoring in the event that SQL Se
rver shuts down and then restarts on any of the three servers. What must you
do to most these goals?
A. Use Windows NT Performance Monitor to monitor all three servers from one
location.
B. Use SQL Server Profiler extended stored procedures to forward a trace to
the server in your building, and make the stored procedures startup stored p
rocedures.
C. Use the Create Trace Wizard in SQL Server Profiler to create a trace on t
he server in your building, and replay the trace on the other two servers.
D. Use the Create Trace Wizard in SQL Server Profiler to create a trace on e
ach server, and replay the trace on the server in your building.
E. Use Windows NT Performance Monitor from each server. Log each server"s ac
tivity and forward it to the server in your building.
Answer: B
64. You are planning the installation of SQL Server onto servers at various
International offices in your company. You want to accomplish the following
goals: . Minimize the time required to complete the Installations. . Minimiz
e network utilization during the Installations. . Minimize the possibility o
f errors during the installations. . Maximize the compatibility of the SQL S

ervers. . Allow each international office to store characters that are speci
fic to Its region. Which course of action will best accomplish your goals?
A. Instruct the server administrators at each international office to instal
l each SQL Server by using the Typical Installation option.
B. Instruct the server administrators at each international office to use th
e character set, sort order, and Unicode collation that are optimal for thei
r region.
C. Create a standardized installation of SQL Server at your office. Back up
the installation to tape by using the Windows NT Backup utility. Send each i
nternational office a copy of the backup tape, and instruct the server admin
istrators at each international office to restore the tape"s contents onto t
heir server.
D. From your office, perform a remote installation of SQL Server for each in
ternational office, using a standardized set of installation options.
Answer: A
65. Your servers run SQL Server 6.5 and 7.0. You want to centrally manage th

ese servers from your workstation by using SQL Server Enterprise Manager. Wh
at must you do?
A. Install only the SQL Server 7.0 administrative tools and Client connectiv
ity components on your workstation
B. Install the SQL Server 6.5 and SQL Server 7.0 administrative tools and cl
ient connectivity components on your workstation.
C. Install the SQL Server 7.0 administrative tools and client connectivity c
omponents on the servers that run SQL Server 6.5.
D. Install the SQL Server 6.5 administrative tools and client connectivity c
omponents on the servers that run SQL Server 7.0.
Answer: B
66. You are planning the installation of SQL Server onto 10 remote servers.
The administrators of the remote servers do not have experience with SQL Ser
ver. You want to implement the installations so that the administrators part
icipation Is minimized. You also want to ensure installations that are compa
tible with your existing SQL Server installation. How should you implement t

he installations?
A. Back up all SQL Server files and registry entries from your existing serv
er to tape. Copy the backup tape, send copies of it to the remote administra
tors, and Instruct them to restore-the backup onto the remote servers.
B. Install SQL Server onto a similarly, configured test server at your locat
ion. Configure the SQL Server services to use the local system account, Use
the resulting setup.iss file to automate the Installations on the remote ser
vers.
C. Install SQL Server onto a similarly configured test server at your locati
on. Configure the SQL Server services to use the local administrator account
, Use the resulting setup.is


收藏到ViVi   收藏此页到365Key
上一篇： MCSE---sql admin(3)
下一篇： 我装Oracle8i for linux的痛苦7天之最终版