MCSE---sql admin(3)

站 (Thu Apr 19 08:29:42 2001), 转信
1. You need to provide access to the Sales database for Internet users who d
o not have Windows NT accounts. How can you provide access? (Choose all that
apply.)
A. Add a guest user account to the Sales database, and grant the guest user
account the appropriate permissions in the Sales database.
B. Create a SQL Server login for Internet guest access.
C. Add the Windows NT Domain Users account to the SQL Server public role in
the Sales database.
D. Grant the Windows NT Guest account access to SQL Server.
Answer: A, D
2. The trace you currently use is saved. You want to use similar traces freq
uently. How must you edit the saved trace you currently use to include addit
ional events?
A. Import the trace in SQL Server Profiler, and edit the event classes.
B. Open the trace file, and edit the event classes.
C. Open the trace definition, and edit the event classes.
D. Edit the saved registry settings for the trace.
Answer: A
3. The size of your database has increased significantly, and you want to ex
amine performance statistics on specific database objects. The original SQL
Server trace file was saved in a table. How should you replay the trace one
step at a time?
A. Query the trace table for the event classes, and create a trace definitio
n file that uses those events.
B. In SQL Server Profiler, open the trace table, save it to a file, and repl
ay the trace one step at a time.
C. In SQL Server Profiler, open the trace table, and replay the trace one st
ep at a time.
D. In SQL Server Profiler, import the trace definition, and replay the trace
one step at a time.
Answer: C
4. Maria is a member of the Windows NT HumanResource group. You need to deny
database access to the HumanResource group, but you need to ensure that Mar
ia has more than guest access. You deny database access to the HumanResource
group by adding the group to the db_denydatareader and db_denydatawriter ro
les. What must you do to give Maria the access she had before the HumanResou
rce group was denied access?
A. Ensure that you add Maria"s database access after you deny access to the
HumanResource group.
B. Add Maria as a user with a SQL Server login under Mixed Mode.
C. Remove Maria from the HumanResource group, and add her as a user.
D. Maria already has database access as a member of the guest user account a
nd the public role.
Answer: C
5. As the database owner, you grant Franz permissions to create views and cr
eate stored procedures in the Finance database. Franz creates a stored proce
dure that does an update on the dbo.Prices table. He creates a view that sel
ects price information for a report. He grants Suzanne SELECT permissions on
the view and EXECUTE permissions on the stored procedure. What must be done
so that Suzanne can obtain the results by using the view and stored procedu
re?
A. You must grant Suzanne SELECT permissions on the view and the stored proc
edure.
B. Franz must grant Suzanne SELECT permissions on the Prices table.
C. You must grant Suzanne SELECT and UPDATE permissions on the Prices table.
D. Franz must grant Suzanne EXECUTE permissions on the stored procedure and
SELECT permissions on the Prices table.
Answer: C
6. Maria preceded you as administrator for Microsoft Windows NT Server and S
QL Server. Maria created SQL Server logins and passwords matching users" Win
dows NT accounts. When users log in to the Windows NT Server domain, they ob
tain access to SQL Server. Which permissions do users receive when they acce
ss SQL Server by using a trusted connection?
A. only the same permissions as those that are granted to their SQL Server l
ogin
B. only the same permissions as those that are granted to their Windows NT a
ccount
C. the cumulative permissions that are granted to their SQL Server login and
their Windows NT account
D. only the permissions that are granted in common to their SQL Server login
and their Windows NT account
Answer: B
7. To increase security, your company decides to prohibit Windows NT adminis
trators from accessing SQL Server administrative functions. What should you
do to prohibit access?
A. Deny access to the Windows NT Administrators group.
B. Rename the current Windows NT Administrators group, and create an empty W
indows NT Administrators group.
C. Remove the Windows NT Administrators group from the sysadmin role in SQL
Server.
D. Install SQL Server on a member server instead of on a domain controller.
Answer: C
8. You need to set up secure database access for two applications. The appli
cations are named Payroll and Sales. There are two types of users in the Pay
roll application, those who can modify data and those who can only query on
existing data. There is only one type of user in the Sales application, thos
e who can both modify and query on existing data. What should you do to set
up the security access to the database?
A. Create a single application role. Grant permissions on the role for each
type of access for the Payroll application. Grant permissions on the role fo

r the single type of access for the Sales application.
B. Create one application role for each application. Grant permissions on ea
ch role with different passwords.
C. Create two application roles for the Payroll application, and grant permi
ssions on each role for each type of access. Create one application role for
the Sales application, and grant permissions on the role for the single typ
e of access.
D. Create two application roles for the Payroll application, and grant permi
ssions on each role for each type of access. Create one application role for
the Sales application, and grant all users of the Sales application the sam
e permissions.
Answer: C
9. You plan to give users in the Windows NT Sales group limited access to th
e Sales and Inventory databases. All access for data modifications and repor
ting will be through a Microsoft Excel application. How should you set up ac
cess for the Sales group in both databases?
A. Create a single application role. Grant the Sales group permissions on th

at role in each database.
B. Create an application role for each database. Grant the Sales group permi
ssions in each database.
C. Create an application role for each database, and grant permissions on ea
ch role.
D. Create a single application role, and grant it permissions in each databa
se.
Answer: C
10. Your insurance company is purchased by Duluth Mutual Life. The new manag
ement wants a copy of your 120-GB Policy database. Your current procedure is
to back up the Policy database nightly to a media set of two device familie
s, named PolicyBackup1 and PolicyBackup2. Each device family contains three
tapes. The server at Duluth Mutual Life is named Server1. There is adequate
disk space on Server1 to store the database, but there is only one local tap
e drive. What should you do to restore the Policy backup to Server1 with min
imal administrative workload?
A. Make a separate backup device, specifying only one of your tape drives.
B. Restore the tapes from the PolicyBackup1 and PolicyBackup2 media families

by using the single tape drive on Server1. Load the tapes in order of seque
nce number.
C. Detach the Policy database from your server, and attach the database to S
erver1
D. Restore the tapes from the PolicyBackup1 and PolicyBackup2 media families
to Server1 by executing the RESTORE VERIFYONLY statement with the UNLOAD op
tion.
Answer: B
11. You are reviewing a new snapshot replication environment for five large
tables. In order to free up disk space, you want to delete the data objects
that are generated by snapshot replication. Where can you find these objects
?
A. in the msrepl_commands table in the Distribution database
B. in the sysarticles table in the database that is being published
C. in the Mssql7Repldata directory on the Distributor
D. in the Mssql7Repldata directory on the Subscriber
E. in the msdb database
Answer: C
12. To support a new transaction, you create an index on the largest table
in the Sales database. It takes you two hours to create the index. You want

to ensure the fastest possible reconstruction of the index in the event of
a database failure. What should you do immediately after creating the index?
A. Perform a transaction log backup of the Sales database.
B. Perform a full database backup of the Sales database.
C. Perform a differential database backup of the Sales database.
D. Perform a full database backup of the master database.
Answer: B
13. You implement 10 scheduled jobs on your development server, and you veri
fy that they function correctly. You now want to transfer the jobs to your p
roduction server. How should you transfer the jobs with the fewest administr
ative steps?
A. Script the jobs, and execute the resulting script on the production serve
r.
B. Back up the msdb database and restore it onto the production server.
C. Make the test server a master server, and make the production server a ta
rget server. Configure the jobs to run on the target server.
D. Manually re-create the jobs on the production server.

Answer: A
14. You are estimating disk space requirements for a new database. The main
table has approximately 100,000 rows, and each row contains an average of 5,
000 bytes. How much disk space will the data portion of this table require?
A. 5 GB
B. 100MB
C. 500 MB
D. 800 MB
Answer: D
15. You install transactional replication on the Manufacturing server and ma
ke several publications available. The Accounting department subscribes to o
ne of the publications, but Accounting users need data from only the WorkSch
edule article. What is the easiest way to provide only this data for them?
A. Create a subscription directly to the WorkSchedule article on the Account
ing server.
B. Create a filter on the publication so that only the WorkSchedule article
can be subscribed to. Implement a push subscription to the Accounting server
.
C. Create a filter on the publication so that only the WorkSchedule article
can be subscribed to. Implement a pull subscription on the Accounting server
.
D. Create a new publication containing only the WorkSched


收藏到ViVi   收藏此页到365Key
上一篇： MCSE2000--sql admin(2)
下一篇： MCSE2000---sql admin(4)