Sawaal
0
Q:

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?

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.

Answer:   C) 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.

Subject: MCSE-Microsoft Certified Solutions Expert
Related Questions
Q:

Which operating system(s) can you upgrade to Windows 2000 Server?

A) Windows 95 B) Windows 98
C) Windows for Workgroups D) Windows NT Server 4.0
 
Answer & Explanation Answer: D) Windows NT Server 4.0

Explanation:

The only operating systems that can be upgraded to Windows 2000 Server are Windows NT Server 3.51 and Windows NT Server 4.0 E is the only correct answer.

Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert

0 3786
Q:

You are installing Windows 2000 on a computer that already has another operating system installed on it. You choose to install Windows 2000 in a different folder than the previously installed operating system. What will Windows 2000 do?

A) Abort the installation process B) Delete the previously installed operating system
C) Display an error message indicating that windows 2000 cannot be installed in a different folder D) Cause the computer to dual boot between Windows 2000 and the previously installed operating system
 
Answer & Explanation Answer: D) Cause the computer to dual boot between Windows 2000 and the previously installed operating system

Explanation:

When windows 2000 is installed in the same folder as the other operating system, Windows 2000 will delete the previously installed operating system. When Windows 2000 is installed in a different folder than the other operating system, it will automatically configure the computer to dual boot between Windows 2000 and the previously installed operating system.

Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert

1 3073
Q:

You create a mirrored volume on a Windows 2000 Server computer. What additional item should you create?

A) A new Config.nt file B) A new Auto exec.nt file
C) A fault tolerance boot disk D) A set of Windows 2000 Setup Boot Disks
 
Answer & Explanation Answer: C) A fault tolerance boot disk

Explanation:

A fault tolerance boot disk is a floppy disk that you create that enables you to boot your Windows 2000 computer in the event that the first disk in your computer's mirrored volume fails. This disk contains an edited copy of the Boot.ini file.

Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert

2 4050
Q:

Which hardware platform (or platforms) are supported by Windows 2000?

A) The Intel Pentium/ 166MHZ (and higher) platform B) The Compac Alpha platform
C) The PowerPC platform D) The MIPS R4000 platform
 
Answer & Explanation Answer: A) The Intel Pentium/ 166MHZ (and higher) platform

Explanation:

The Intel Pentium/166MHz (and higher) platform is the only hardwaer platform supported by Windows 2000.

Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert

4 5044
Q:

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?

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.
 
Answer & Explanation Answer: C) Upgrade all of the Windows NT Workstation 4.0 computers and Windows 98 computers to Windows 2000 Professional

Explanation:

To achieve optimum functionality of the client computers, you must upgrade all of them to Windows 2000. Upgrading some of them and/or installing the Directory Service Client will gain some functionality, but the question specifically states that "optimum functionality" is the required result.

Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert

3 4030
Q:

You are installing Windows 2000 on a computer that already has another operating system installed on it. You choose to install Windows 2000 in a different folder than the previously installed operating system. What will Windows 2000 do?

A) Wireless devices B) Multiple displays
C) Advanced Power Management (APM) D) Uninterruptible Power Supplies (UPSs)
 
Answer & Explanation Answer: C) Advanced Power Management (APM)

Explanation:

Of the four features listed, all are supported on both Windows 2000 Professional and Windows 2000 Server Computers except APM. APM is only supported on Windows 2000 Professional computers.

Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert

0 3891
Q:

You are preparing to install Windows 2000 on a computer, and you want this computer to be able to dual  boot between Windows 2000 and Windows 98. Which file system should you use?

A) FAT B) NTFS
C) HPFS D) You can use either FAT or NTFS
 
Answer & Explanation Answer: A) FAT

Explanation:

If you want your computer to dual boot between Windows 2000 and windows 98, you should choose the FAT or FAT 32 file system, because Windows 98 does not support NTFS or HPFS, and Windows 2000 does not support HPFS.

Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert

0 3552
Q:

You decide to change the file system on your Windows 2000 computer. You want to change drive C: from FAT to NTFS. What should you type at the command prompt?

A) FORMAT C: /FS : NTFS B) CONVERT C: /FS : NTFS
C) FORMAT C: /NTFS D) CONVERT C: /NTFS
 
Answer & Explanation Answer: B) CONVERT C: /FS : NTFS

Explanation:

The convert.exe command is used to change a volume's file system from FAT to NTFS.

Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert

0 3187