Certification Questions

Q:

If you want to chose a different set of fields in a vendor account line item display, you choose a different

A. line layout

B. sort variant

C. totals variant

D. additional fields

Answer

Answer : A

Report Error

View answer Workspace Report Error Discuss

Subject: SAP FI

4 4395
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

3 4391
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 4376
Q:

You have a reference computer that runs Windows 7.

You plan to deploy an image of the computer.

You create an answer file named answer.xml.

You need to ensure that the installation applies the answer file after you deploy the image. Which command should you run before you capture the image?

A) Imagex.exe /append answer.xml /check B) Imagex.exe /mount answer.xml /verify
C) Sysprep.exe /reboot /audit /unattend:answer.xml D) Sysprep.exe /generalize /oobe /unattend:answer.xml
 
Answer & Explanation Answer: D) Sysprep.exe /generalize /oobe /unattend:answer.xml

Explanation:
Report Error

View Answer Report Error Discuss

5 4371
Q:

What is one way to limit a user's access to only a specific number of accounts in the MCC?

Answer

Create a new MCC account linked to the original MCC account. Move the specified number of accounts into that MCC and grant the user access to the sub-MCC account.

Report Error

View answer Workspace Report Error Discuss

16 4365
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 4364
Q:

Which command will show you whether a DTE or a DCE cable is plugged into serial 0?

A) sh int s0 B) sh int serial 0
C) show controllers s 0 D) show serial 0 controllers
 
Answer & Explanation Answer: C) show controllers s 0

Explanation:

The Show controllers serial 0 command will show you whether either a DTE or DCE cable is connected to the interface. If it is a DCE connection, you need to add clocking with the clock rate command

Report Error

View Answer Report Error Discuss

Filed Under: CCNA

0 4357
Q:

At which layer of the OSI model would you assume the problem is if you type show interface serial 1 and receive the following message?

Serial 1 is down, line protocol is down

A) Physical layer B) Data Link layer
C) Network layer D) None
 
Answer & Explanation Answer: A) Physical layer

Explanation:

If you see that a serial interface and the protocol are both down, then you have a physical layer problem. If you see serial 1 is up, line protocol is down, then you are not receiving (Data Link) Keepalives from the remote end.

Report Error

View Answer Report Error Discuss

Filed Under: CCNA

0 4319