| Question 1 | Which of the following reasons explain why Book Seller, Inc. should consider implementing auditing? (Choose two.) A. Response time of the current system is unacceptable. B. Inventory is not consistent between the storefront and the warehouse databases. C. The current auditing scheme is not scalable. D. Affiliates do not have real-time data on your products. E. Manipulations of data should be verified to prevent continuous attacks.
|
| A1: | The correct answers are A and E. Auditing will not directly help you keep inventory consistent between databases (answer B) or obtain real-time data (answer D). No current auditing scheme (answer C) was mentioned in the case study. |
| Question 2 | Which of the following current software items must be integrated into the envisioned solution for Book Seller, Inc.? (Choose all that apply.) A. Service agent provided for affiliates B. Inventory database C. Storefront application D. Storefront database E. Third-party shopping cart software
|
| A2: | The correct answers are B and D. No service agent is currently provided for affiliates (answer A). The storefront application (answer C) and the shopping cart (answer E) were characterized as replaceable items. |
| Question 3 | Which of the following methods could be used to integrate with the inventory management system for transferring data? (Choose two.) A. Use the inventory management system's APIs. B. Consume the inventory management's Web Service. C. Replace the inventory management's database. D. Add triggers in the inventory management system to modify the storefront database on update. E. Use DTS to connect to the inventory database.
|
| A3: | The correct answers are A and E. The inventory management system does not offer a Web Service (answer B), and replacing its database (answer C) is out of the question. It is bad practice to solve data synchronization between two databases through the use of triggers (answer D). |
| Question 4 | In which of the following places should unhandled exceptions be caught in ASP.NET? (Choose two.) |
| A4: | The correct answers are D and E. Catching unhandled exceptions on every page via the error event (answer A) or the page directive (answer B) is not scalable in a large project. The machine.config file (answer C) should be used for machine-level settings, such as connection pools. |
| Question 5 | Which of the following methods could you use to secure the affiliate's service agent transfer of data? (Choose two.) |
| A5: | The correct answers are A and B. There is no packet to sign (answer C) in this scenario, and the use of authentication (answer D) or authorization (answer E) would not secure your transfer, only your request of data. |
| Question 6 | Which of the following are benefits of implementing a service account security policy for Book Seller, Inc.? (Choose two.) A. Secured connection string B. Connection pools C. Stored procedure caching D. Encrypted channel transfer E. Decreased temporary memory consumption
|
| A6: | The correct answers are C and D. The connection string will be less secure (answer A) than if it was Integrated authentication. Service accounts have no bearing on channel transfer encryption (answer D) and will increase temporary memory consumption (answer E) because stored procedure results are being cached. |
| Question 7 | Which of the following service agent technologies would Book Seller, Inc. provide to its affiliates? A. COM objects B. XML Web Services C. APIs D. DTS
|
| A7: | The correct answer is B. Book Seller, Inc.'s affiliates are unknown, so you have no idea if they use Microsoft platforms (answer A). APIs (answer C) and DTS (answer D) would not provide the most scalable and secure approach to transferring data of this magnitude. |
| Question 8 | Book Seller, Inc. plans to implement a reusable shopping cart interface on each form. Which of the following types of control should you choose? |
| A8: | The correct answer is D. A Windows user control (answer A) can be used in a Web form similarly to ActiveX, but the client must have the .NET Framework installed; therefore, this solution is not scalable for your scenario. Server-side includes (answer B) are a Windows DNA methodology and should not be used in .NET. A Web form (answer C) could be provided if the page was split into frames, but this solution is not the most manageable. |
| Question 9 | Which of the following is the most important consideration when designing specifications for Book Seller, Inc.'s state management solution? |
| A9: | The correct answer D. A Web farm (answer A) and server performance (answer B) are very important but not more important than your user base. Current system state (answer C) is not an issue because you are not integrating state solutions in this scenario. |
| Question 10 | Which of the following is the best-practice choice for receiving data from Book Seller, Inc.'s existing SQL database? A. Call a stored procedure to return a DataSet. B. Call a stored procedure to return XML, using the FOR XML statement. C. Call inline SQL to return a DataSet. D. Call inline SQL to return XML, using the FOR XML statement.
|
| A10: | The correct answer is A. SQL 7.0 and earlier do not contain built-in XML support (answers B and D). Inline SQL does not use caching and has more room for errors that are hard to track (answer C). |
| Question 11 | Which of the following items in Book Seller, Inc.'s solution can you choose to store in the Cache object for added performance? |
| A11: | The correct answer is C. Answers A, B, and D pertain to specific information about each user and do not have application scope. |
| Question 12 | Which of the following locations can you use for storing logging information for Billington? (Choose all that apply.) A. Windows Event Viewer's Security log B. RDBMS, such as SQL Server C. Windows Event Viewer's System log D. Windows Event Viewer's Application log E. Text file used for logging
|
| A12: | The correct answers are B, D, and E. You cannot store logging information in the Security (answer A) or System logs (answer C). |
| Question 13 | In the Billington case study, which of the following layers can invoke and participate in ACID transactions? (Choose all that apply.) A. The Data Access Layer can invoke transactions. B. The Data Access Layer can participate in transactions. C. The Business Services Layer can invoke transactions. D. The Business Services Layer can participate in transactions. E. The User Interface Layer can invoke transactions. F. The User Interface Layer can participate in transactions.
|
| A13: | The correct answers are B, C, and D. The Data Access (answer A) and User Interface Layers (answer E) should not invoke transactions; this is the job of business objects and the User Service facade. The User Interface Layer should not directly participate in transactions (answer F). |
| Question 14 | Which of the following items in Billington's existing system could you reuse when building the envisioned system? |
| A14: | The correct answer is E. The database (answer A), mainframe (answer B), and interface (answer C) were mentioned as items that needed to be replaced or upgraded. Currently, no service agent is available for insurance providers (answer D). |
| Question 15 | Using DTS, which of the following items might Billington attempt to salvage from its DB2 and GetBetterSoon.com's Oracle database? (Choose all that apply.) A. Triggers B. Tables C. Procedures D. Data E. Packages
|
| A15: | The correct answers are B and D. Oracle uses PL-SQL to implement advanced SQL-ANSI standards, such as temp tables. The new SQL database supports T-SQL to perform these standards because items such as triggers (answer A), procedures (answer C), and packages (answer E) are often written with the use of T-SQL or PL-SQL, so they are not platform independent. |
| Question 16 | Given that Billington maintains a 28-server Web farm, which of the following global state management solutions should you choose to implement? A. Sessions B. ViewState C. Database sessions D. Cookies
|
| A16: | The correct answer is C. Sessions (answer A) alone do not support the Web farm and must be sticky or database sessions. ViewState (answer B) will be used, but it is a client state management solution. Ten percent of the user base does not accept cookies (answer D), so this option is not viable. |
| Question 17 | Billington has customers worldwide, and latency should be a consideration. Which of the following options would be recommended data transfer approaches? (Choose two.) |
| A17: | The correct answers are A and D. DataSet (answer B) and DataTable (answer E) are stored in memory and are not ideal when latency is an issue because they are much heavier than DataReader (answer A) or XML, for example. A comma-delimited string (answer C) is not an acceptable means of transfer. XML (answer D) is a viable option. |
