Certification Questions

Q:

Which method should you use to group query filters together to form one AND statement?

A. Select the filters, then click the Group Filters button on the toolbar

B. Select the filters, right-click and select Group

C. Drag the queries together

D. Drag the query filters to the Group panel

Answer

Answer : C

Report Error

View answer Workspace Report Error Discuss

Subject: SAP BW

2 3060
Q:

What does a switch do when a frame is received on an interface and the destination hardware address is unknown or not in the filter table?

A) Forwards the switch to the first available link B) Drops the frame
C) Floods the network with the frame looking for the device D) Sends back a message to the originating station asking for a name resolution
 
Answer & Explanation Answer: C) Floods the network with the frame looking for the device

Explanation:

Switches flood all frames that have an unknown destination address. If a device answers the frame, the switch will update the MAC address table to reflect the location of the device. 

Report Error

View Answer Report Error Discuss

Filed Under: CCNA

0 3041
Q:

 In 1:n assignments, the operational charts of accounts in all assigned company codes and in the controlling area must be the same.

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

Explanation:

The charts of accounts must be the same.

Report Error

View Answer Workspace Report Error Discuss

Subject: SAP CO

2 3040
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 3037
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 3034
Q:

Which configuration command must be in effect to allow the use of 8 subnets if the Class C subnet mask is 255.255.25.224?

A) Router(config)#ip classless B) Router(config)#ip version 6
C) Router(config)#ip unnumbered D) Router(config)#ip subnet-zero
 
Answer & Explanation Answer: D) Router(config)#ip subnet-zero

Explanation:

A Class C subnet mask of 255.255.255.224 is 3 bits on and 5 bits off (11100000) and provides 8 subnets, each with 30 hosts. However, if the command ip subnet-zero is not used, then only 6 subnets would be available for use.

Report Error

View Answer Report Error Discuss

Filed Under: CCNA

0 3026
Q:

Which command will configure a switch port to use the IEEE standard method of inserting VLAN membership information into Ethernet frames?

A) Switch (config) #switchport trunk encapsulation ietf B) Switch (config) #switchport trunk encapsulation dot1q
C) Switch (config-if) #switchport trunk encapsulation ietf D) Switch (config-if) #switchport trunk encapsulation dot1q
 
Answer & Explanation Answer: D) Switch (config-if) #switchport trunk encapsulation dot1q

Explanation:

If you are on a 2950 switch, then the interface command is just swichport mode trunk since the 2050 can only run the  IEEE 802.1q version. However, a 3550 can run both ISL and 802.1q, so you must also use the encapsulation command. The argument to choose 802.1q for a trunking protocol is dot1q.

Report Error

View Answer Report Error Discuss

Filed Under: CCNA

1 3010
Q:

Which common usage scenario is missing from the list of usage scenarios below? Implement SAP solution, Monitor SAP solutions, Manage Service Desk, Link to SAP Services, Upgrade SAP solutions

A. Manage change Requests
B. Monitor Service Desk
C. Link to change Request
D. Implement SAP Services

Answer

Answer : A

Report Error

View answer Workspace Report Error Discuss

4 3008