Chapter 14. Answers to Practice Exam 1

1. B, C

2. C

3. A, E

4. A, D, E

5. C

6. A

7. C

8. A, C, D

9. B

10. D

11. A

12. D

13. D

14. E

15. C, E

16. A

17. B, C

18. D

19. A

20. B

21. D

22. B

23. B

24. C

25. D

26. D, E

27. A

28. A, C

29. B, C

30. B

Question 1	The correct answers are B and C. Because you are planning to sell wine online, you need support for a shopping cart and a means to convert American-dollar prices into commensurate currency around the world. There was no mention of workflow, e-mail, or a need for kiosk support in the case study, which eliminates answers A, D, and E.
Question 2	The correct answer is C. All the answers, except answer C, were explicitly mentioned in the case study. You cannot assume, from the information given, that inventory reordering is part of the requirements.
Question 3	The correct answers are A and E. There was mention of the two lead architects being located in a different city, and one of the interviewees expressed some concern about having only three months. There was no mention at all about the team's technical expertise (they're not even hired yet) or about budget (answers B and C). International language support (answer D) is not that much of a risk in the .NET technology, and it was stated that this support could come in a later release.
Question 4	The correct answers are A, D, and E. The solution is explicitly for sale representatives, wine buyers, and internal staff. There is no mention of direct support to distributors (answer B) or GWA's own vendors (answer C).
Question 5	The correct answer is C. When sales representatives travel the world, you cannot predict accurately what bandwidth, if any, they will have for transferring data to and from their mobile (handheld) PCs. Having a code repository (answer A) is not a feasibility issue for the solution, but is a challenge for the development phase. Browser support for .NET Web controls (answer D) is also not a feasibility problem, as .NET detects and adjusts for the browser level of the user. Answer B, SQL Server 6.5, is not an issue because it was stated in the interview that any software or hardware that didn't meet GWA's new goals would be upgraded.
Question 6	The correct answer is A. There was no mention of integrating with an IBM mainframe, so Component Object Model Transaction Integrator (COMTI) would not be part of this solution. Even if mainframe integration were involved, the selection of a specific product such as COMTI is a technical choice, not a requirement. All the other answers are either stated explicitly in the case study or implied from the user interviews.
Question 7	The correct answer is C. Answer C is the best example of a use case statement. Answers A and B are tactical decisions that are too technical for use cases. Answer D is a requirement, not a use case statement.
Question 8	The correct answers are A, C, and D. Answer B is a user requirement, not an operational one. Answer E is a developer productivity tool that has no bearing on a solution's operational requirements.
Question 9	The correct answer is B. Answer B is the only choice in which security is very high and scalability and availability are also near the top of the list. Although the exact order can be debated, the other answers have at least one or two crucial goals too far down the list.
Question 10	The correct answer is D. There is no reason to select either C# or Visual Basic .NET prematurely. The interview stated that the decision between these two would be made after the developers were selected. GWA already has a classic ASP application (answer C), but it was apparent from the case study that it intended to use the new features of .NET.
Question 11	The correct answer is A. You would expect to see a particular version (or higher) of SQL Server specified to support Unicode data. Answer B is not a likely candidate for your specifications, as you cannot reliably assume that most of your Web customers will have cookies enabled. Answer C is a requirement, not a specification, and answer D is incorrect because you should plan on conforming to HTML 3.2 or higher, as stated in the ASP.NET specifications.
Question 12	The correct answer is D. Answer D is most correct. Answer A describes the opposite of what was askedthe relationship between a client and his or her sales representative. Answer B has nothing to do with clients, and answer C, although maybe correct, is not formed as an ORM fact statement.
Question 13	The correct answer is D. ORM models can automatically generate ER diagrams or database schemas (DDL). This is their main purpose.
Question 14	The correct answer is E. Based on all the information you have been given, it appears that you need a solution with a single data layer and a single business layer, but with three distinct user layers: Web, Windows, and mobile. These three types of users (customers, employees, and sales representatives) are so diverse that having distinct user layers would provide the best experience for each user type and, if done properly, require minimal extra effort. In fact, separating the interfaces is probably easier than providing a "one size fits all" Web interface.
Question 15	The correct answers are C and E. If done properly, minimal additional effort would be required, all near the User Services Layer, to add Web Services support. This solution corresponds to answer C. Answer E is correct because completely new services and logic are required to support the process of interacting with large distributors. Answers A, B, and D are not correct, as a well-designed application should not require disturbing these existing areas.
Question 16	The correct answer is A. The Cache object can be set up to refresh itself automatically, without a single line of code, at a certain time interval (such as daily) or whenever a file (a price file, for example) changes. Answer D, cookies, doesn't work because they exist on the user's machine and could easily become out of date. Answers B and C are not optimal, although the Application object, answer B, would qualify as the second-best answer.
Question 17	The correct answers are B and C. Creating one .resx (satellite) file per language supported is one good approach (answer B). Answer C, storing dates and numbers in a single language (English), makes it easier to create a single business component and a single data component that can serve the entire application (localization). Creating separate DLLs for each language, answer A, was a strategy in the "classic" days of COM, before the rich international support of the .NET Framework. There is no reason to expect that Windows Forms would be a good idea in this Internet solution, which eliminates answer E. Answer D, which seems to support international users, is a business rule that affects the cost of sale, not something that supports the browser-based user interface, as the question asks.
Question 18	The correct answer is D. Windows Management Instrumentation (WMI) can be set up to send notifications automatically, with minimal code. All the other solutions are more complicated and code intensive.
Question 19	The correct answer is A. Making database synchronization asynchronous (say that three times fast) would allow sales representatives to do other things in the meantime. The other three choices are inherently synchronous tasks, in which the activity must be completed before the user can proceed to doing anything of value.
Question 20	The correct answer is B. With Internet users, Windows authentication (answer A) is not practical (you could have users logging in from nonMicrosoft Windows machines), and requiring all potential shoppers to have a Passport account (answer D) is impractical. Encryption, answer C, is not a security model.
Question 21	The correct answer is D. Only answer D is a bad design that might limit your ability to scale out through a Web farm. All the other choices have the potential to assist (or at least not inhibit) scalability.
Question 22	The correct answer is B. SQL Server 6.5 is the only choice that does not offer the Unicode support you need. Access 2000 (answer D) and XML (answer E) are not good candidates for dynamic data, but depending on the situation, they might serve as acceptable alternatives for static data.
Question 23	The correct answer is B. Data concurrency, which by default throws a "catchable" exception in the .NET Framework, must be planned for in your solution. Answers C and D both have the same problem: They are less practical in a disconnected scenario like that of GWA's sales force. Answer A does not help you address concurrent data updates.
Question 24	The correct answer is C. Stored procedures continue to provide the best performance over the other options. Whenever XML is used (answers A and B), there will be a performance penalty. Although dynamic SQL (answer D) provides flexibility in the code, it is not the best performance option.
Question 25	The correct answer is D. If you multiply 6,000 bytes by 8 (8 bits in a byte), and multiply that result by a sales representative's 25 accounts, you get 1,200,000 bits. Dividing that by 24,000 (24Kb), you get 50 seconds.
Question 26	The correct answers are D and E. Answer D would be expected to increase sales, adding to the benefits side of your ROI equation. Answer E would lower your costs. By taking advantage of code that has already been designed, written, and tested, you increase ROI. The other three choices should not make a difference either way.
Question 27	The correct answer is A. Of the tools listed, Enterprise Templates, conceivably set up in advance by the architects in Chicago, would make the most difference to developer productivity.
Question 28	The correct answers are A and C. Answers B, D, and E are explicitly not in compliance with Microsoft-stated coding standards.
Question 29	The correct answers are B and C. From the case study, you can determine that 100% uptime (answer B) and international support (answer C) were not part of the previous solution, but are important to the solution you are currently designing.
Question 30	The correct answer is B. You can offer the majority of what is required as long as an HTML 3.2 browser (or higher) is detected. Of course, with a newer browser (HTML 4.0 specification or higher), the user's response time will improve, as more of the processing can be done on the user's machine without as many round-trips to the server. Author's Note: The practice questions and answers, although representative of the information that will be on the exam, have been created without knowledge of the final exam's contents. If you disagree with the answer provided, or think the question is poorly worded, there are a couple things you might do: Reread the question carefully. Just like the actual exam, phrases such as "simplest" or "best possible" have been used to eliminate what might otherwise be a correct answer. E-mail any of the authors with your concern, supplying details about why you think the question or the answer was wrong. You can find the authors' e-mail addresses in this book's front matter. Move on, realizing that the thought process of selecting an answer to a question is what's most important. Thank you.