Discussion
Home ‣ Certification ‣ Microsoft Certification Comments
- Question
A manager in your office received a new Windows 2000 Professional laptop computer. You have been asked to configure offline files for the manager to work on documents at home. You enable offline files, and have the manager log off of the network. During the logoff process, the expected synchronization of offline files does not occur. You have the manager log back on to the network. What can you do to correct the problem?
Options- A. Enable file and print sharing. When the manager logs off, the files will synchronize.
- B. Manually synchronize all offline files.
- C. On the server, make all files available offline. When the manager logs off, the files will synchronize.
- D. Do nothing. Windows 2000 Professional does not tell you when Synchronization happens.
- Correct Answer
- On the server, make all files available offline. When the manager logs off, the files will synchronize.
- 1. You have a Windows NT 4.0 Workstation computer with an NTFS file system that you use for software development. As your company upgrades their systems to Windows 2000, you will need to be able to test applications in both the Windows NT Workstation environment and the Windows 2000 environment. You decide that the easiest course of action would be to install Windows 2000 Professional in a dual boot environment with Windows NT 4.0 Workstation on your computer. What should you do before installing Windows 2000 Professional?
Options- A. Edit the BOOT.INI file to reflect the new installation of Windows 2000 Professional.
- B. Install Service Pack 3 or later for Windows NT Workstation 4.0.
- C. Install Service Pack 4 or later for Windows NT Workstation 4.0.
- D. Convert the NTFS file system to FAT. Discuss
- 2. You are the administrator of a SQL Server 2000 computer named CorpSQL. The server is a member of a Microsoft Windows NT domain named CORPORATE. Franz maintains a local user account on CorpSQL and is a member of the local Power Users group. He requests access to the SQL Server databases that are stored on CorpSQL.You need to allow Franz to access CorpSQL. Which Transact-SQL statement should you execute?
Options- A. EXEC sp_grantlogin CorpSQL\Franz
- B. EXEC sp_grantlogin Franz
- C. EXEC sp_grantlogin [Power Users\Franz]
- D. EXEC sp_grantlogin CORPORATE\Franz Discuss
- 3. 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?
Options- 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. Discuss
- 4. You are the administrator of eight SQL Server 2000 computers. You configure alerts on each server so that various problem conditions will be reported if they occur.You create 20 operators on one of the servers. You configure these operators by using the e-mail and pager contact information for the employees in your department. You configure the alerts on the server to send e-mail messages and pager messages to the appropriate operators.You need to configure the same 20 operators on the other seven servers. You want to do this with a minimum amount of administrative time.What should you do?
Options- A. Use SQL Server Enterprise Manager to script all of the operators. Use SQL Query Analyzer to run the script on the other seven servers.
- B. Detach the msdb database from the first server. Copy the database to the other seven servers. Attach the database on all eight servers.
- C. Use snapshot replication to replicate the msdb database from the first server to the other seven servers.
- D. Use SQL ServerEnterprise Manager on a single client computer to create the operators on each server. Discuss
- 5. You are the database administrator of a SQL Server 2000 computer. The server contains your company's Accounts database. Hundreds of users access the database each day.Because you have had power interruptions in the past, you want to protect the physical integrity of the Accounts database. You do not want to slow down server operations.What should you do?
Options- A. Create a database maintenance plan to check database integrity and make repairs each night.
- B. Enable the torn page detection database option for each database.
- C. Disablewrite caching on all disk controllers.
- D. Ensure that write caching disk controllers have battery backups. Discuss
- 6. The president of your company collects manager's weekly reports in a shared folder on her Windows 2000 Professional computer called reports. Because the reports contain sensitive information, she asks you to prevent users from enabling offline access for the network share that contains the financial report. What should you do?
Options- A. Use Windows Explorer to disable Offline Files.
- B. Use Windows Explorer to disable Caching for the reports on the network share.
- C. Set the Manager's access level to read-only.
- D. Implement a domain policy to block the synchronization of offline files. Discuss
- 7. As part of trouble shooting errors in a VPN connection, what logs must be checked?
Options- A. IPSec logging
- B. Event viewer
- C. VPNSec Log
- D. All of above Discuss
- 8. 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?
Options- A. IP and UDP port 42
- B. UDP and TCP port 53
- C. TCP 53 but not UDP
- D. PPTP and UDP 21 Discuss
- 9. John is a system administrator for a renowned travel agency.The agency is planning to upgrade its computer systems to Windows XP Professional.Most of the computers are networked but some computers do not have CD-ROM drives.How can John upgrade the computer systems without CD-ROM drives to Windows XP Professional?
Options- A. can attach a portable tape backup unit to each computer and install the operating system from it.
- B. can use the windows installer program to push out the operating system.
- C. can perfom the installation over a network share.
- D. can not install windows XP Professional unless he installs a CD-ROM drive in the computer systems that do not have them. Discuss
- 10. You are setting up a computer for students to use to practice exercises for their certification exams. You want to configure the computer so that users can boot into both Windows 98 and Windows 2000 Professional. You want to ensure that students can access all drive resources from either operating system. What should you do?
Options- A. Create a single FAT32 partition.
- B. Create a single NTFS volume.
- C. Configure one NTFS volume, and one extended FAT32 partition.
- D. Configure a dynamic volume. Discuss
Microsoft Certification problems
Search Results
Correct Answer: Install Service Pack 4 or later for Windows NT Workstation 4.0.
Correct Answer: EXEC sp_grantlogin CorpSQL\Franz
Correct Answer: 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.
Correct Answer: Use SQL Server Enterprise Manager to script all of the operators. Use SQL Query Analyzer to run the script on the other seven servers.
Explanation:
Transact-SQL scripts can be used to create defined operators or alerts. Scripting all the
predefined operators and alerts and copying them to the servers if the same group of operators is responsible for responding to the same alerts on other servers can save time.
Correct Answer: Ensure that write caching disk controllers have battery backups.
Explanation:
The scenario states that power interruptions have occurred in the past. By buying a battery backup solution for the disk controllers the power interruption problem would be prevented.
Correct Answer: Use Windows Explorer to disable Caching for the reports on the network share.
Correct Answer: IPSec logging
Correct Answer: UDP and TCP port 53
Correct Answer: can perfom the installation over a network share.
Correct Answer: Create a single FAT32 partition.
Comments
There are no comments.Programming
Copyright ©CuriousTab. All rights reserved.