Discussion
Home ‣ Certification ‣ Microsoft Certification See What Others Are Saying!
- Question
You are an administrator of a SQL Server 2000 computer. The server contains a database that stores inventory data. Another database administrator has created a number of scheduled jobs to maintain the inventory database. Each weeknight the following jobs occur. - A BULK INSERT job imports data at 10:00 P.M - Indexes are rebuilt at 10:15 P.M - Data integrity checks are performed at 10:30 P.M - A differential backup is performed at 10:45 P.M - A DBCC SHRINKDATABASE job runs at 11:00 P.M. You notice that the final job often fails and returns the following error message: "Server: Msg 3140, Level 16, State 3. Could not adjust the space allocation for file 'inventory_data'."You need to ensure that the final job runs without errors. What should you do?
Options- A. Modify the DBCC SHRINKDATABASE job so that it uses DBCC SHRINKFILE statement to shrink each file individually.
- B. Create a new DBCC SHRINKFILE job to shrink the inventory_data file. Schedule the new job to run at the same time as the DBCC SHRINKDATABASE job.
- C. Increase the time between the differential backup and the DBCC SHRINKDATABASE job.
- D. Increase the time between the data integrity checks and the differential backup.
- Correct Answer
- Increase the time between the differential backup and the DBCC SHRINKDATABASE job.
ExplanationThe DBCC SHRINKDATABSE cannot be executed until the previous job step, the differential backup, has been completed. We should increase the time between these two job steps, or even better configure the last job step to run only after the differential backup has been completed.
Note: The DBCC SHRINKDATABASE statement shrinks data files on a per-file basis but shrinks log files as if all the log files existed in one contiguous log pool. The target size for the data and log files cannot be smaller than the minimum size of a file that was specified when the file was originally created, or the last explicit size set with a file size changing operation such as the ALTER DATABASE statement with the MODIFY FILE option or the DBCC SHRINKFILE statement.
- 1. Which proprietary Cisco STP extensions would put a switch port into err-disabled if a BPDU is received on this port? Discuss
- 2. Which Cisco 802.1d extension stops BPDU from being transmitted out a port? Discuss
- 3. You want to improve network performance by increasing the bandwidth available to hosts and limit the size of the broadcast domains. Which of the following options will achieve this goal?
Options- A. Managed hubs
- B. Bridges
- C. Switches
- D. Switches configured with VLANs Discuss
- 4. What command would you use to set an access list on a VTY line? Discuss
- 5. What is the meaning of amber SYST led on a 2960 switch?
Options- A. This is normal operation
- B. There is a bridging loop
- C. The switch IOS is loading
- D. The switch failed its POST Discuss
- 6. What is the formula for ranking keyword-targeted ads on the Search Network? Discuss
- 7. What are the minimum requirements to run an ad on the Search Network? Discuss
- 8. Why should you use the Ad Preview and Diagnosis tool to check if your ads are live and running on Google? Discuss
- 9. Why is it important to monitor ad campaign performance? Discuss
- 10. What is one way you can increase CTRs? Discuss
More questions
Correct Answer: BPDUGuard
Correct Answer: PortFast
Correct Answer: Switches configured with VLANs
Explanation:
By creating and implementing VLANs in your switched network, you can break up broadcast domains at layer2. For hosts on different VLANs to communicate, you must have a router or layer 3 switch.
Correct Answer: line vty 0 4 access - class 110 in
Correct Answer: The switch failed its POST
Explanation:
Explanation: When the switch failed its POST, Power-On Self Test, the SYST led will turn amber and the IOS did not load
Correct Answer: (Maximum Cost Per Click) x (Quality Score)
Correct Answer: Text ad, keyword list, and a default bid
Correct Answer: By searching for keywords that trigger your ad, you can rack up impressions without clicks, which may lower your Click-Through Rate, which may prevent your ad from appearing as often as it is eligible
Correct Answer: In order to determine if campaigns meet business marketing and conversion goals
Correct Answer: Add negative keywords to the ad group to reduce irrelevant impressions
Comments
There are no comments.Programming
Copyright ©CuriousTab. All rights reserved.