MCSE-Microsoft Certified Solutions Expert Questions

Q:

You are the administrator of a Microsoft Windows NT Server 4.0 computer. The server is the PDC in your domain and also runs SQL Server 2000. The server has four processors and 1 GB of RAM.Your network consists of 500 client computers that are running Microsoft Windows Millennium Edition. Users report that when they log on in the morning their computers respond slowly and occasionally return error messages.You use System Monitor to monitor processor performance and RAM utilization. You discover that the % Total Time and % User Time counters average 90 percent and the % Privileged Time counter averages 20 percent. The Available Mbytes counter averages 800 MB. You need to improve server performance for user logons. What should you do?

A) Increase the physical RAM on the computer to 2 GB. B) Increase the virtual RAM on the computer to 4 GB.
C) Configure SQL Server to use only processors 0, 1, and 2. D) Configure SQL Server to use only processors 1, 2, and 3.
 
Answer & Explanation Answer: D) Configure SQL Server to use only processors 1, 2, and 3.

Explanation:

The system monitor clearly indicates that the processors are overloaded. We need to decide which processors we should use for SQL Server. Processor 0 is the default CPU for the I/O subsystem. Network Interface Cards (NIC) are assigned to the remaining CPUs, starting from the highest-numbered CPU. The NIC would get processor 3.
SQL Server would be using all four processors by default.

The Windows NT/2000/XP operating system use processor 0. In order to avoid the logon
problems we should not let SQL Server to use this processor. Instead SQL Server should be configured to use processor 1, 2, and 3.

Note 1: The Affinity mask is used to exclude a processor on a multiprocessor computer from processing SQL Server 2000 threads. Default is equal distribution of SQL Server 2000 processes across all processors.

Note 2: Monitoring the Processor and System object counters provides information about the CPU utilization and helps in determining whether or not a bottleneck exists. The %Total Processor Time is used on multiple CPU Severs to gauge the average activity of the processors and shows the percentage of elapsed time that a processor is busy executing a nonidle thread. Values around 100 percent on a Server computer that processes many client requests indicate that processes are queuing up, waiting for processor time, and causing a bottleneck. Such a sustained high level of processor usage is unacceptable for a server.

Report Error

View Answer Report Error Discuss

0 2129
Q:

You have installed a Windows Server 2003 DNS server, but because of security reasons, you have to install this behind a firewall. What port on the firewall must be opened so that users can access the server?

A) IP and UDP port 42 B) UDP and TCP port 53
C) TCP 53 but not UDP D) PPTP and UDP 21
 
Answer & Explanation Answer: B) UDP and TCP port 53

Explanation:
Report Error

View Answer Report Error Discuss

0 2089
Q:

When you run Sysprep on a Windows 2000 computer, what happens to the user-specific information on the computer?

A) It is preserved in usset.inf B) It is saved and automatically reinstalled
C) It is removed D) It is not altered
 
Answer & Explanation Answer: C) It is removed

Explanation:

The user-specific settings are removed by Sysprep.

Report Error

View Answer Report Error Discuss

0 2080
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

0 2045
Q:

You are archiving a Security Log for later analysis in a spreadsheet. Which file type should you assign to the log when you save it?

A) .evt B) ,txt
C) .csv D) .exe
 
Answer & Explanation Answer: C) .csv

Explanation:

Saving the Security Log as a comma - delimited file is probably the best choice if you want to analyze the data later in a spreadsheet.

Report Error

View Answer Report Error Discuss

0 2031
Q:

You create a System Policy file on a Windows 2000 Server computer to manage Windows NT 4.0 client computers  (and their users) on your Windows 2000 network. What filename should you assign to this System Policy file?

A) Config.pol B) Ntconfig.pol
C) Nt4config.pol D) Winntconfig.pol
 
Answer & Explanation Answer: B) Ntconfig.pol

Explanation:

A Windows NT 4.0 System Policy file should be named NTconfig.pol

Report Error

View Answer Report Error Discuss

0 2024
Q:

You are preparing to install Certificate Services for the first time on your Windows 2000 network. You plan to install Certificate Services on a Windows 2000 Server computer that is a member of the domain. You want the certification authority (CA) to be able to use Active Directory. Which CA type should you select when you install Certificate Services? 

A) Enterprise root CA B) Enterprise subordinate CA
C) Stand-alone root CA D) Stand-alone subordinate CA
 
Answer & Explanation Answer: A) Enterprise root CA

Explanation:

Select Enterprise root CA if you're installing the first certificate server in the forest. This type of CA requires the use of Active Directory.

Report Error

View Answer Report Error Discuss

0 1961
Q:

You are the administrator of a SQL Server 2000 computer. Your company uses the server to store service contract information for its customers. You are also the administrator of an Oracle relational database management system (RDBMS) server. This server is used to store your company's financial information. The financial information is updated frequently throughout the day.You need to create a series of reports that combine the service contract information and the financial information. These reports will be updated several times a day.You want to create these reports on the SQL Server computer by using the minimum amount of disk space. What should you do?

A) Set up SQL Server replication to replicate the data from the Oracle server to the SQL Server computer. B) Set up the Oracle server as a linked server. Create a view that joins the service contract information and the financial information.
C) Set up a Microsoft ActiveX script that connects to the Oracle server and imports the financial information into a SQL Server temporary table. Create a view that joins the service contract information and the temporary table. D) Set up a Data Transformation Services (DTS) package that imports and transforms the data from the Oracle server to the SQL Server computer. Use SQL Server Agent to execute the DTS package throughout the day as needed.
 
Answer & Explanation Answer: B) Set up the Oracle server as a linked server. Create a view that joins the service contract information and the financial information.

Explanation:

SQL Server 2000 permits the creation of links to OLE DB data sources called linked servers. After linking to an OLE DB data source, it is possible to reference rowsets from the OLE DB data sources as tables in Transact-SQL statements and to pass commands to the OLE DB data sources and include the resulting rowsets as tables in Transact-SQL statements. Each distributed query can reference multiple linked servers and can perform either update or read operations against each individual linked server. A single distributed query can perform read operations against some linked servers and update operations against other linked servers. The Microsoft OLE DB Provider for Oracle allows distributed queries to query data in Oracle databases.

Report Error

View Answer Report Error Discuss

0 1957