Certification Questions

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 3300
Q:

Subject to which prerequisites can a source of supply be assigned as early as during the MRP run?

A. The 'MRP-relevant' indicator must have been set in a contract item.

B. The source determination facility must be activated at the start of the MRP run.

C. A quota arrangement must exist and the quota arrangement usage indicator must allow use of the quota arrangement in materials planning.

D. An info record must exist for the relevant material and the vendor must have been flagged in the source list as the single/sole source of supply for the purposes of materials planning.

Answer

Answer : C , D

Report Error

View answer Workspace Report Error Discuss

Subject: SAP MM

4 3299
Q:

What are the advantages of Process Model.

A. Easily control the execution of programs.

B. Reduce process run time by running serial program.

C. Repeat individual process steps.

D. Can send notification in all circumstances.

Answer

Answer : A , C , D

Report Error

View answer Workspace Report Error Discuss

Subject: SAP HR

0 3274
Q:

Which of the statements are true when running the dunning program

A. we can recreate the proposal until the dunning clerk is satisfied with the result

B. after completing the dunning proposal list, dunning data is updated in the master records of respective customer/ vendor

C. we cannot delete the proposal

D. we can edit proposal

Answer

Answer : A , D

Report Error

View answer Workspace Report Error Discuss

Subject: SAP FI

2 3274
Q:

Multiple users can share a local temporary table

A) TRUE B) FALSE
Answer & Explanation Answer: B) FALSE

Explanation:

Multiple users can't share a local temporary table

Report Error

View Answer Workspace Report Error Discuss

0 3271
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 3263
Q:

Can’t update primary table’s primary key if row being modified has related rows in secondary table once referential integrity is enforced

A) TRUE B) FALSE
Answer & Explanation Answer: A) TRUE

Explanation:
Report Error

View Answer Workspace Report Error Discuss

0 3263
Q:

You are a project manager for the redevelopment of the Hoover Dam. Your team has been provided with the scope statement, but it lacks many description details. Your team is concerned because the project is in the initiation phase and it wants to postpone it until it has more information. As the project manager, you recommend that

A) The team should go forward, but be caution about the lack of details and the impact upon the timeline for the project B) The project should not go forward until the stakeholders agree about the scope and purpose of the project
C) The team should verify the scope and realize that more details will be available as more project characteristics are progressively elaborated. D) The team should review the project selection criteria for the Hoover Dam project
 
Answer & Explanation Answer: C) The team should verify the scope and realize that more details will be available as more project characteristics are progressively elaborated.

Explanation:

The project details and description will usually have less detail at the beginning of the project and will increase as the characteristics are progressively elaborated. Answer A is incorrect because the team should confirm that they understand the esence of the scope of the project, even if the details might be ambiguous at the beginning of the project. Answer B is incorrect because the project should go forward; however, the team should request further clarification of what the project scope entails. Answer D is incorrect because the project selection criteria should be established before the project begins.

Report Error

View Answer Report Error Discuss

Filed Under: PMP Certification

0 3257