logo

CuriousTab

CuriousTab

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. 

    Explanation

    The 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.

    • More questions

    • 1. If you wanted administrators to see a message when logging into the router, which command would you use?

    • Options
    • A. message banner motd
    • B. banner message motd
    • C. banner motd
    • D. message motd
      • Discuss
    • 2. At which layer of the OSI model would you assume the problem is if you type show interface serial 1 and receive the following message? Serial 1 is down, line protocol is down

    • Options
    • A. Physical layer
    • B. Data Link layer
    • C. Network layer
    • D. None
      • Discuss
    • 3. Which commands loads a new version of the Cisco IOS into a router?

    • Options
    • A. copy flash ftp
    • B. copy ftp flash
    • C. copy flash tftp
    • D. copy tftp flash
      • Discuss
    • 4. What is the command to copy a Cisco IOS to a TFTP server?
    • Discuss
    • 5. When a PC sends a packet to another PC in a remote network, what destination IP address and MAC address will be in the frame that it sends to its default gateway?
    • Discuss
    • 6. What is the administrative distance of OSPF?

    • Options
    • A. 90
    • B. 100
    • C. 110
    • D. 120
      • Discuss
    • 7. With which network type will OSPF establish router adjacencies but not perform the DR/BDR election process?

    • Options
    • A. Point-to-Point
    • B. Backbone area 0
    • C. Broadcast multi-access
    • D. Non-broadcast multi-access
      • Discuss
    • 8. A network administrator needs to configure a router with a distance-vector protocol that allows classless routing. Which of the following satisfies those requirements?

    • Options
    • A. IGRP
    • B. OSPF
    • C. RIPv1
    • D. EIGRP
      • Discuss
    • 9. You get a call from a network administrator who tells you that he typed the following into his router: Router (config) #router ospf 1 Router (config-router) # network 10.0.0.0. 255. 0.0.0 area 0 He tells you he still can't see any routes in the routing table. What configuration error did the administrator make?

    • Options
    • A. The wildcard mask is incorrect
    • B. The OSPF area is wrong
    • C. The OSPF Process ID is incorrect.
    • D. The AS configuration is wrong
      • Discuss
    • 10. Which proprietary Cisco STP extensions would put a switch port into err-disabled if a BPDU is received on this port?
    • Discuss

    Comments

    There are no comments.
Enter a new Comment




Aptitude

Engineering

Programming

Reasoning

Links

Copyright ©CuriousTab. All rights reserved.