89+ MCSE Exam And Interview Questions and Answers with Explanation

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

Filed Under: MCSE-Microsoft Certified Solutions Expert

0 3034

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

Filed Under: MCSE-Microsoft Certified Solutions Expert

0 2999

Q:

As part of trouble shooting errors in a VPN connection, what logs must be checked?

A) IPSec logging	B) Event viewer
C) VPNSec Log	D) All of above

Answer & Explanation Answer: A) IPSec logging

Explanation:

Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert

0 2937

Q:

Sachin works for a computer training institute in North America.After discussing the steps of installing Windows XP professional in the class room, sachin divided the students in a group of two and asked them to complete the installation on their respective machines.But none of the students were able to complete the installation process.Identify the solution that is the cause to the above problem.

A) Needs to run XP Upgrade Adviser to avoid compatibility problem	B) Needs to run XP Upgrade Professional to avoid compatibility problem
C) Needs to run XP Upgrade Home Edition to avoid compatibility problem	D) Needs to run XP Service Pack to avoid compatibility problem

Answer & Explanation Answer: A) Needs to run XP Upgrade Adviser to avoid compatibility problem

Explanation:

Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert

2 2676

Q:

You want to use System Monitor to see how much of the paging file on your Windows 2000 computer is being utilized. Which counter should you use?

A) Paging File-% Usage	B) Paging File-% Usage Peak
C) Memory-Pages/sec	D) Memory-Pool Paged Bytes

Answer & Explanation Answer: A) Paging File-% Usage

Explanation:

The Paging File-% Usage counter is used to measure the percentage of paging file utilization.

Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert

0 2661

Q:

Which master role causes the domain controller that performs this role to be the only domain controller in the forest that can add a new domain to the forest?

A) PDC emulator	B) Schema master
C) Relative ID master	D) Domain naming master

Answer & Explanation Answer: D) Domain naming master

Explanation:

The domain naming master is the only domain controller that can add or remove domains to/form the forest

Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert

0 2658

Q:

You want to prevent the creation of administrative shares on a Windows 2000 server computer. What should you do?

A) Nothing. You can't prevent the creation of administrative shares.	B) Configure the Advanced options in Configure Your Server
C) Configure the Advanced settings on the View tab in Folder Options	D) Use Reged32.exe or the System Policy Editor to edit the registry

Answer & Explanation Answer: D) Use Reged32.exe or the System Policy Editor to edit the registry

Explanation:

Edit the registry to prevent the creation of administrative shares.

Report Error

View Answer Report Error Discuss

Filed Under: MCSE-Microsoft Certified Solutions Expert

0 2630

Q:

You want to enable dynamic routing on a Windows 2000 Server computer on your TCP/IP network . You want this computer to manage the propagation of multicast traffic throught your network. Which routing protocol should you use?

A) IGMP Version2, Router and Proxy	B) Open Shortest Path First (OSPF)
C) RIP Version 2 for Internet Protocol	D) Network Address Translation(NAT)

MCSE-Microsoft Certified Solutions Expert Questions

Quick Links