logo

CuriousTab

CuriousTab

Discussion


Home Certification Microsoft Certification Comments

  • Question
  • You are the administrator of a SQL Server 2000 computer. You configure SQL Server to perform C2 auditing. Audit logs are saved in the C:MSSQLAudit folder.The server functions normally for several days, but then the MSSQLServer service shuts down without warning. You cannot restart the service.You need to restart the MSSQLServer service. What should you do?


  • Options
  • A. Start the MSSQLServer service manually by using the -m startup option.
  • B. Start the MSSQLServer service manually by using the -s startup option.
  • C. Set the SQLServerAgent service's startup method to Disabled. Start the MSSQLServer service.
  • D. Delete the audit logs from the C:\MSSQL\Audit folder. Start the MSSQLServer service.

  • Correct Answer
  • Delete the audit logs from the C:\MSSQL\Audit folder. Start the MSSQLServer service. 

    Explanation

    SQL Server functioned for several days but now it is impossible to start it.
    The most likely cause is the size of the auditing log files. The maximum file size for the audit log is fixed at 200 megabytes (MB). When the audit log file reaches 200 MB, a new file will be created and the old file handle will be closed. If the directory fills up, then the instance of Microsoft SQL Server is stopped. The system administrator needs to either free up disk space for the audit log before restarting the instance of SQL Server or restart the instance of SQL Server

    Note 1: SQL Server Agent monitors itself and the SQL Server service.
    SQL Server Agent can restart the local instance of SQL Server if it has terminated for reasons other than a typical shutdown.

    Note 2: Start the MSSQLServer service manually by using the -f startup option would start the service with minimal configuration. It could be used when some configuration errors have been made and the MSSQLServer service isn't able to start.


  • Microsoft Certification problems


    Search Results


    • 1. You plan to install Windows 7 by using a Windows 7 DVD. You need to perform an automated installation of Windows 7. What should you do?

    • Options
    • A. Create an answer file named oobe.xml. Copy the file to a network share.
    • B. Create an answer file named winnt.sif. Place the file on a removable drive.
    • C. Create an answer file named sysprep.inf. Copy the file to a network share.
    • D. Create an answer file named autounattend.xml. Place the file on a removable drive.
    • Discuss
    • 2. You have a computer that runs Windows 7. The computer connects to the corporate network by using a VPN connection. You need to ensure that you can access the Internet when the VPN connection is active. The solution must prevent Internet traffic from being routed through the VPN connection. What should you do?

    • Options
    • A. Configure a static DNS server address.
    • B. Configure a static IP address and default gateway.
    • C. Configure the security settings of the VPN connection.
    • D. Configure the advanced TCP/IP settings of the VPN connection.
    • Discuss
    • 3. Your network consists of a single Active Directory domain that contains two domain controllers. Both domain controllers run Windows Server 2003 Service Pack 2 (SP2). Auditing of successful account logon events is enabled on all computers in the domain. You need to identify the last time a specific user logged on to the domain. What should you do?

    • Options
    • A. Examine the System Event Log on the user's computer.
    • B. Examine the System Event Log on both domain controllers.
    • C. Examine the Security Event Log on both domain controllers.
    • D. Examine the Application Event Log on the user's computer.
    • Discuss
    • 4. Your network consists of a single Active Directory domain. All servers run Windows Server 2003 Service Pack 2 (SP2). You enable auditing for failed logon attempts on all domain controllers. You need to ensure that a record of failed logon attempts is retained for 90 days on all domain controllers. What should you do?

    • Options
    • A. From the Security Templates snap in, open the hisecdc template. Modify the Retain System Log setting.
    • B. From the Security Templates snap in, open the securedc template. Modify the Retain Security Log setting.
    • C. Open the Default Domain Policy. Modify the Retain System Log setting.
    • D. Open the Default Domain Controller Policy. Modify the Retain Security Log setting.
    • Discuss
    • 5. You have a portable computer named Computer1 that runs Windows 7. You have a file server named Server1 that runs Windows Server 2008. Server1 contains a shared folder named Share1. You need to configure Computer1 to meet the following requirements: Ensure that cached files from Share1 are encrypted. Ensure that files located in Share1 are available when Server1 is disconnected from the network. What should you do?

    • Options
    • A. On Server1, encrypt the files in Share1. On Computer1, make Share1 available offline.
    • B. On Server1, configure BitLocker Drive Encryption. On Computer1, make Share1 available offline.
    • C. On Computer1, make Share1 available offline and enable encryption of offline files.
    • D. On Computer1, copy the files from Share1 to the Documents library and configure BitLocker Drive Encryption.
    • Discuss
    • 6. You are preparing to install Windows 2000 server on a new computer at your office. You want to perform an over-the-network installation. Which method will you use to start the installation ?

    • Options
    • A. From a CD-ROM drive
    • B. By using winnt.exe
    • C. By using winnt32.exe
    • D. By using a network installation startup disk
    • Discuss
    • 7. You want to create and format a simple volume on a Windows 2000 computer. Which tool should you use?

    • Options
    • A. Disk Administrator
    • B. Disk Management
    • C. The Convert.exe command -line utility
    • D. The Format.exe command-line utility
    • Discuss
    • 8. You want to implement Active Directory on your Windows 2000 network. Your network consists of Windows 2000 Server computers, Windows 2000 Professional computers, Windows NT Workstation 4.0 computers, and Windows 98 computers. You want to achieve optimum functionality of all the client computers with Active Directory. What should you do?

    • Options
    • A. Install the Directory Service Client on all of the Windows 98 computers.
    • B. Upgrade all of the Windows 98 computers to Windows 2000 Professional
    • C. Upgrade all of the Windows NT Workstation 4.0 computers and Windows 98 computers to Windows 2000 Professional
    • D. Nothing. Windows 2000 will automatically detect all client computers and optimize them to function with Active Directory.
    • Discuss
    • 9. The Backstage View in Word 2010 presents an easy way to access all the tools you need to manage your documents. It helps prevent clutter on the main Word 2010 Ribbon and provides core file management functions. There are 6 tabs across the top of the Backstage View window, one of these is called Info. Which of these functions does Info contain?

    • Options
    • A. Set user permissions for documents
    • B. Know when a document was last printed
    • C. Run accessibility tests
    • D. All of these
    • Discuss
    • 10. A large CRM project took place last year included hundreds of meetings between the various key users. All of the conversations were save in a single Word 2010 document. You need to find all instances of the following words 'bleed' and 'bled'. Which of the following wildcard searches would be best?

    • Options
    • A. ble{2}d
    • B. ble{1,}d
    • C. ble{e2}d
    • D. ble[e2]d
    • Discuss


    Comments

    There are no comments.

Enter a new Comment