| Ananymous 2002-12-19, 2:24 am |
| Where do you get this real exam question ?
>-----Original Message-----
>
>1.You are the administrator of a SQL Server 2000
computer. The server
>contains a database named
>Sales. A company e-commerce application uses the Sales
database to
>store sales transactions. The
>company Web site has grown in popularity, and database
utilization has
>increased.
>
>You need to collect data about the utilization of server
resources so
>that you can provide capacity
>planning. You want to automate the collection process so
that
>information is gathered as quickly as
>possible.
>What should you do?
>
>
>A. Configure System Monitor to collect data and store it
in a SQL
>Server table
>B. Create a SQL Server Agent job that executes the
sp_statistics stored
>procedure daily and
>places the results in a text file
>C. Use SQL Profiler to trace server activity and store
the results in
>SQL Server tables
>D. Configure SQL Server alerts to store information in
the Windows
>application event log
>
>
>which one is correct?
>
>
>
>A or c?
>
>
>
>2.You are the administrator of a SQL Server 2000
computer. You are
>configuring a database for an
>inventory application. The hard disks on your server are
configured as
>shown in the exhibit.
>
>(it is a server contain two physical disks,disk0 and
disk1, disk0 has
>drive C: AND drive D: ,disk1 has drive E: snd F:,
>each drive capacity is 4.5GB)
>
>
>
>The operating system files are located on drive C. Your
database will
>store a maximum of 6 GB of
>data and requires a maximum of 2 GB of disk space for the
transaction
>log.
>You want to optimize database performance. What should
you do?
>A. Add a 2-GB transaction log to drive D, a 3-GB data
file to drive E,
>and a 3-GB data file to
>drive F
>B. Add a 1-GB transaction log to drive C, a 1-GB
transaction log to
>drive D, a 3-GB data file
>to drive E, and a 3-GB data file to drive F
>C. Add a 1-GB transaction log to drive E, a 1-GB
transaction log to
>drive F, a 3-GB data file to
>drive E, and a 3-GB data file to drive F
>D. Add a 2-GB transaction log to drive F, a 3-GB data
file to drive D,
>and a 3-GB data file to
>drive E
>
>
>A or D?
>
>
>3.You are the administrator of a SQL Server 2000 computer
at your
>company's warehouse. All product
>orders are shipped from this warehouse. Orders are
received at 30 sales
>offices. Each sales office
>offers a range of products specific to its region.
>Each sales office contains one SQL Server 2000 computer.
These servers
>connect to the warehouse
>through dial-up connections as needed, typically once a
day. Each sales
>office needs data pertaining
>only to its region.
>You need to replicate inventory data from the server at
the warehouse
>to the servers at the sales
>offices. You want to minimize the amount of time needed
to replicate
>the data.
>Which three actions should you take? (Each correct answer
represents
>part of the solution. Choose
>three.)
>
>
>A. Create one publication for each Subscriber.
>B. Create one publication for all Subscribers.
>C. Enable horizontal filtering.
>D. Enable vertical filtering.
>E. Use pull subscriptions.
>F. Use push subscriptions.
>
>
>ACE or BCE?
>
>---
>View this thread:
http://www.examnotes.net/article86247.html
>billsioc--------------------------------------------------
----------------------
>billsioc's Profile:
http://www.examnotes.net/forums/member.php?
action=getinfo&userid=125295
>
>.
>
|