The departmental server has Full Text search implemented on its SQL server
database. Currently both the Full Text database and the database files reside on
the same logical drive. You do not want the Full Text indexing to use more than 25%
of the available drive space because you want to allow space for dynamic expansion
of the data files. You want to be able to remotely monitor the amount of space in
use by the catalogs. How should you remotely monitor the space usage with a minimum
number of additional administrative steps?
A. Use the windows NT Performance Monitor to connect to the Server and to
monitor the size of the Microsoft Search catalog
B. Create a scheduled job to regularly monitor the size of the Full Text
indexes and send the result to your E-MAIL address
C. Create a batch file to monitor the size of Full Text indexes and send the
result to you viaNetwork Message. Use the Windows NT Scheduler Service to schedule
the batch file to runregularly
D. Create a batch file to monitor the size of the Full Text indexes and send
the result to
;you via Network Message. Create a scheduled job to run the batch file
regularly.
Answer: A
You are a SQL Server 7.0 system administrator for you company. To provide users
with Full Text search capabilities, you create a Full Text catalog and enable Full
Text indexing for specific tables in a database. From your Windows NT Workstation
computer, you want to remotely monitor the size of the Full Text catalog on Windows
NT server computer that is running SQL Server. Which of the following tools is the
most convenient to use for monitor the Full Text catalog?
A. Performance Monitor B. Query Analyzer
C. The SP_MONITOR system stored procedure D. SQL Server Profiler.
Answer: A
Notice: To obtain real-time information about the size of a specific full-text
catalog, you can continuously monitor the appropriate instance of the Microsoft
search Indexer Catalogs You load a lot data into your database, then you find that
the space for log is almost full, how can you do to ensure the restore: (Choose all
that apply)
A. Make a full backup
B. Make a differential backup
C. Backup the transaction log with the default options
D. Backup the transaction log with truncate only
Answer: A, D
The engine manufacturing application records data about all the engines that
are manufactured at your plant, the database contains approximately 500 Million
records and is approximately 50GB in size. The database increases by 1000 records
per day. You want to accomplish the following goals:
1. Minimize the time required to recover the database
2. Provide the ability to recover the database to a specific time
3. Minimize the number of transaction logs that need to be during recovery
4. Minimize the time required to backup the database
You take the following actions:1. Schedule a full database backup of the entire
database to occur every Sunday at AM 1:00 2. Schedule transactionlog backup to
occur every day at P.M Which result or results do these action produce? ( Choose
all that apply )
A. The time required to recover the database is minimized
B. The database can be recovered to a specific time.
C. The number o
f transaction logs that need to be applied during recovery is
minimized
D. The time required to backup the database is minimized
Answer: B, D
You check the free space on a log file and run a BACKUP LOG WITH NO_LOG on a
database that is a publisher for transactional replication. You check the free
space after running this command and note that free space has not changed. What is
the most likely reason that free space has not changed?
A. The distributor database is full
B. Log reader agent has stopped
Answer: B
You have 2 tables, T1 & T2, GI should be able to update T1, G2 should be only able
to select from T1 and third group G3 able to select and update on T2. The question
is how manyapplication roles do you need?
Answer: 3
Sales representatives use portable computers. They need to implement replication
scenario so that the sales representatives can enter the orders. You want to
minimize network traffic:
A. Transactional B. Snapshot with Pull C. Snapshot With push D. Merge
Answer: B