Certification Questions

Q:

The organizational form in which the project manager has informal authority over team members and little or no input to team member’s performance appraisal is called

A) weak matrix. B) functional.
C) strong matrix. D) composite.
 
Answer & Explanation Answer: A) weak matrix.

Explanation:

“Weak matrices maintain many of the characteristics of a functional organization, and the project manager role is more that of a coordinator or expediter than that of a true project manager.”

Report Error

View Answer Report Error Discuss

Filed Under: PMP Certification

2 4235
Q:

You are the database administrator for a financial services company. Employees enter data 24 hours a day into a SQL Server 2000 database. These employees report slower response times when new account information is gathered from branch offices and added to the database. You currently use the following BULK INSERT statement to add the account information.BULK INSERT finance.dbo.customersFROM 'd:bulkaccts143_10142000.txt'WITH DATAFILETYPE = 'char', FIELDTERMINATOR = 't', ROWTERMINATOR = 'n', TABLOCK You want to ensure that response times do not slow when new account information is added to the database. What should you do?

A) Add the BATCHSIZE option to the BULK INSERT statement, and then set the option equal to 10 percent of the number of rows to be loaded. B) Add the ROWS_PER_BATCH option to the BULK INSERT statement, and then set the option equal to 10 percent of the number of rows to be loaded.
C) Drop the indexes for the Customers table before the data load, and then re-create the indexes after the data load is complete. D) Remove the TABLOCK option from the BULK INSERT statement.
 
Answer & Explanation Answer: D) Remove the TABLOCK option from the BULK INSERT statement.

Explanation:

The TABLOCK hint increases the number of locks during the adding process. This is the reason why response time are slows down during this process. By removing the TABLOCK hint the default more granular row-level lock will be used. This would decrease the scope of the locks which would result in less waiting jobs and performance would improve.


Note: The BULK INSERT statement is used to copy a data file into a database table or view in a format specified by the user. The BULK INSERT statement accepts the TABLOCK hint, which allows the user to specify the locking behavior that the BULK INSERT statement should use. TABLOCK specifies that a bulk update table-level lock is taken for the duration of the bulk copy. If TABLOCK is not specified, the default uses row-level locks.

Report Error

View Answer Report Error Discuss

2 4229
Q:

George is very open with his team members. He invites questions and discussion, and encourages new suggestions and ideas. He considers all this carefully before making any but the most minor project decisions, but ultimately chooses the course he personally believes is the right one. His leadership style is best characterized as

A) Democratic B) Consultative
C) Participative D) Benevolent
 
Answer & Explanation Answer: C) Participative

Explanation:

The Participative leadership style is characterized by 1) allowing a great deal of freedom in identifying problems and solutions, 2) working closely with subordinates, 3) allows extensive participation, but 4) reserving to him/herself the final decision. The consultative style is not so open, with discussion more focused around the leader’s uncertainties than asking for new ideas.

Report Error

View Answer Report Error Discuss

Filed Under: PMP Certification

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

3 4218
Q:

You have started your own company based upon PMI methodologies and have been contracted by the government to develope a new interface for one of its computer applications. You develope a solution and win the bid for the contract but encounter problems at the end of the project when the customer says that you did not fullfill their needs. You are throughly shocked. What is your conclusion of the situation?

A) There are always more customers available B) If the customer is not satisfied, the project is not successful
C) Change control management was not effective D) The customer did not communicate very well
 
Answer & Explanation Answer: B) If the customer is not satisfied, the project is not successful

Explanation:

Answer A is incorrect because without satisfied customers, we do not have potential for new projects. Answer C is incorrect because the change control management process would have likely resolved this problem. Answer D is incorrect because it is the project manager's responsibility to seek communication with the customer to set realistic expectations.

Report Error

View Answer Report Error Discuss

Filed Under: PMP Certification

0 4217
Q:

Which of the following commands sets a trunk port on a 2960 switch?

A) truck on B) truck all
C) switchport trunk on D) switchport mode trunk
 
Answer & Explanation Answer: D) switchport mode trunk

Explanation:

To set a switch port to trunk mode, which allows the data of all VLAN information to pass down the link, use the switchport mode trunk command. 

Report Error

View Answer Report Error Discuss

Filed Under: CCNA

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

2 4211
Q:

Business area is determined for accounting documents generated automatically from logistics modules are on the basis of

A. plant-division combination

B. plant-sales area combination

C. plant-division-distribution channel combination

D. plant-division combination and sales area

Answer

Answer : D

Report Error

View answer Workspace Report Error Discuss

Subject: SAP FI

3 4211