Certification Questions

Q:

The payback period can become an important issue when a large scope project is developed over several years. Maureen has been assigned the responsibility of calculating the payback period for her project that is to be completede in 3 years. The internal rate of return(IRR) is 7% and the annual savings will be $800,000 per year. The total cost is $4,000,000 and the rate of return during this time period is 3%. What is the payback period of Maureen's project?

A) 3 years B) 4 years
C) 5 years D) 13.3 years
 
Answer & Explanation Answer: C) 5 years

Explanation:

The payback period is how long it takes to recoup your investment. In this example, the cost was $4,000,000 and the savings was $800,000 per year. $4,000,000/$800,000 = 5. Therefore, Answer A, B and D are incorrect.

Report Error

View Answer Report Error Discuss

Filed Under: PMP Certification

0 5992
Q:

You are the administrator of a SQL Server 2000 computer. The server contains a database named Inventory. The database has a Parts table that has a field named InStock.When parts are shipped, a table named PartsShipped is updated. When parts are received, a table named PartsReceived is updated. The relationship of these tables is shown in the exhibit. (Click the Exhibit button.)

You want the database to update the InStock field automatically. What should you do?

A) Add triggers to the PartsShipped and the PartsReceived tables that update the InStock field in the Parts table. B) Use a view that creates anInStock field as part of an aggregate query.
C) Create stored procedures for modifying the PartsReceived and the PartsShipped tables that also modify the InStock field in the Parts table. Use these procedures exclusively when modifying data in the PartsReceived and the PartsShipped tables. D) Create a user-defined function that calculates current inventory by running aggregate queries on the PartsShipped and PartsReceived tables.
 
Answer & Explanation Answer: A) Add triggers to the PartsShipped and the PartsReceived tables that update the InStock field in the Parts table.

Explanation:

Triggers are a special class of stored procedure defined to fire automatically when an UPDATE, INSERT, or DELETE statement is issued against a table or view. They are powerful tools that can be used to enforce business rules automatically when data is modified. Triggers can extend the integrity checking logic of SQL Server constraints, defaults, and rules, although constraints and defaults should be used instead whenever they provide all the needed functionality. In this scenario an AFTER UPDATE trigger can be used to update the tables to update the PartsShipped and the PartsReceived tables that update the InStock column in the parts table.

Report Error

View Answer Report Error Discuss

17 5990
Q:

Dynamic Search Ads would be most helpful for

A) Campaigns that need to reduce exposure on competitive keywords. B) Websites with hundreds or thousands of products, services, or listings that frequently change.
C) A local restaurant with a dynamically changing menu that offers fresh new entrees every few months. D) Moving an ads position dynamically in whatever direction a users eyes are looking.
 
Answer & Explanation Answer: B) Websites with hundreds or thousands of products, services, or listings that frequently change.

Explanation:

Dynamic Search Ads are the simplest way to find the customers searching on Google for indubitably what you offer. This is an ideal way for with a well-developed website or with a large inventory. Businesses with websites that contain a lot of content or well-structured URLs will see the best results from using Dynamic Search Ads. 

 

Even well managed Adwords account with many keywords can miss relevant searches, experiance delays in getting ads added for new products or it may be out of Sync with what the website originally have.

 

How to Target : 

You can target 

        • All the web pages  (or)

 

        • Specific webpages containing certain keywords.

 

Benefits of Dynamic Search Ads :

        • Save time. No more mapping keywords, bids, and ad text to each product on your website. Plus, Dynamic Search Ads may help you advertise to new markets faster than other alternatives.
        • Frequent, automatic updates to your ads. When you make changes to pages in our index, we'll crawl your website again to help ensure that your ads are as up to date as possible.
        • Show relevant, dynamically generated headlines with your ads. When a customer's search is relevant to your product or service, AdWords will dynamically generate an ad with a clear headline for the most relevant page on your site.
Report Error

View Answer Report Error Discuss

32 5938
Q:

If one of the host connected to Sw-AC3 wants to send message to ip 190.0.2.5 (or any ip on a different subnet) what will be the destination MAC address ?

Answer

Answer and Explanation:


Because the destination address is on a different subnet from the switch, the packet will be forwarded to its default gateway. To verify the default gateway of this switch, use the show running-config command



From the output above, we can see that its default-gateway is 192.168.1.254. Which can be said to be a layer 3 device (router); in this case, the VLAN-R1 router. You can use the show cdp neighbor detail command verify further.



From the output above, you can confirm that the switch's default gateway is VLAN-R1 router (with the IP address of 192.168.1.254).The interface FastEthernet0/3 shows that the switch is directly connected to VLAN-R1 router through the switchport Fa0/3. To verify the MAC address associated this interface is interface, you use the show mac-address-table command:



Looking closely at the table above, you will discorver that the corresponding MAC address is 000a.b7e9.8360. Although there are some entries on port Fa0/3 with different Vlans ,but they have the same MAC address.


From the output above, you can confirm that the switch's default gateway is VLAN-R1 router (with the IP address of 192.168.1.254).The interface FastEthernet0/3 shows that the switch is directly connected to VLAN-R1 router through the switchport Fa0/3. To verify the MAC address associated this interface is interface, you use the show mac-address-table command
Report Error

View answer Workspace Report Error Discuss

Subject: CCNA

1 5895
Q:

On a systems development project, Richard needs two programmers. He knows John and Smith were able to create a program in 40 days similar to the one he wants to create on his project. He decides to use 40 days as his estimate. This is an example of what type of estimating?

A) Parametric modeling B) Analogous
C) Rule of thumb D) Fixed Rate
 
Answer & Explanation Answer: B) Analogous

Explanation:

Richard is using an estimate based on a project very similar to to his own with staff he will be using.  Answer A is incorrect because perametric modeling involves using a mathematical model to predict costs, such as dollars per line of code. Answer C is incorrect, although close; if the development project is a common item, such as putting down new flooring, a rule -of-thumb measurement can be used, although it is less accurate. Answer D is incorrect because it is not a form of estimating, but a type of pricing.

Report Error

View Answer Report Error Discuss

Filed Under: PMP Certification

0 5894
Q:

What multicast addresses does EIGRPv6 use?

A) FF02::A B) FF02::9
C) FF02::5 D) FF02::6
 
Answer & Explanation Answer: A) FF02::A

Explanation:

EIGRPv6's multicast address stayed very near the same. In IPv4 it was 224.0.0.10; now it is FF02::A (A = 10 in decimal notation)

Report Error

View Answer Report Error Discuss

Filed Under: CCNA

0 5888
Q:

Which hardware platform (or platforms) are supported by Windows 2000?

A) The Intel Pentium/ 166MHZ (and higher) platform B) The Compac Alpha platform
C) The PowerPC platform D) The MIPS R4000 platform
 
Answer & Explanation Answer: A) The Intel Pentium/ 166MHZ (and higher) platform

Explanation:

The Intel Pentium/166MHz (and higher) platform is the only hardwaer platform supported by Windows 2000.

Report Error

View Answer Report Error Discuss

21 5838
Q:

Which of the following statements accurately describe a client in an SAP system?

A. A client corresponds to a customer.
B. A client has its own database.
C. A client may represent an entire company.
D. A client represents a completely independent business entity.

Answer

Answer : C , D


 


Explanation: The data for all clients in an SAP system is stored within a single common database. This data is nevertheless divided by client so that different companies can be administered and controlled in  different clients. A client is not a customer within an SAP system.


 

Report Error

View answer Workspace Report Error Discuss

Subject: SAP MM

24 5835