Microsoft Exam #70-057: Designing and Implementing Commerce Solutions with Site Server 3.0
6 questions. Answers can be found at the end of the quiz.
courtesy of Transcender LLC
Questions
1. You are the Web site developer for an e-commerce Web site that uses Site Server, Commerce Edition. Customers who make purchases on your Web site follow a standard checkout procedure that provides them with a receipt. Currently, that receipt is not saved in your system for later retrieval. You want to add a process for storing and retrieving receipts. Your company will use the receipts for customer service and customer trend analysis. The receipts must be stored so that your company can request the top five items that were sent to a certain ZIP code or the average number of items purchased in orders totaling more than one hundred dollars. What action should you perform to accomplish this task? (Select the best choice.)
a. Save the output of the receipt.asp page as an HTML file in a special receipt folder.
b. Save the order form information by creating a database query. Store this query in the Web site's QueryMap object, and then call the query from a component in the Purchase pipeline.
c. Use the SimpleDBDS object to store the receipt information in a database.
d. Use the DBStorage object to store the receipt information in a database.
2. You want to create a Site Foundation named MySampleSite on the default Web site of your server named WEBSVR01. You have assigned a data source name (DSN) of CommerceDB to your system. The system administrator account, sa, has not been assigned a password. You want to run a Site Foundation from the Microsoft Site Server\Bin directory. Which of the following command lines can you use to create a Site Foundation? (Select the best choice.)
a. cscript mscsadmin.vbs create /WebSiteID:1 /SiteName:MySampleSite
b. cscript mscsadmin.vbs create /WebSiteID:1 /SiteName:MySampleSite/
ConnectionString:DSN=CommerceDB;UID=sa;PWD=;
c. cscript mscsadmin.vbs create /WebSiteID:Default Web Site /SiteName:MySampleSite/ConnectionString:CommerceDB
d. cscript mscsadmin.vbs create /WebSiteID:WEBSVR01 /SiteName:MySampleSite/
ConnectionString:DSN=CommerceDB;UID=sa;PWD=;
3. You have been contracted to design a Web site for Franklin's Hobby Shop, a retailer who specializes in model trains. Franklin's already has a thriving catalog business with more than 500,000 customers around the world. The catalog includes paid ad placements, which should be continued online. Franklin's Hobby Shop has also had great success with its Best Buyer program, which allows frequent purchasers to access special bargains and prerelease ordering. The owner of Franklin's would like to extend this program to its online store. After a customer has made a purchase, Franklin's owner wants to offer that customer related products; this practice has helped Franklin's sales staff to significantly increase sales volume in the past. You take the following actions to implement the Franklin's Hobby Shop Web site:
- Use Membership Authentication to map the Web site to the Membership Directory.
- Allow anonymous access to the majority of the Web site, but add HTML Forms Authentication for the Best Buyer program areas.
Which of the following goals will be achieved by these actions? (Select all choices that are correct.)
a. The Web site will be able to accommodate over 500,000 customer accounts.
b. The Web site will limit entry to the special bargain pages only to those in the Best Buyer program.
c. The Web site will offer related products to customers who have just made a purchase.
d. The Web site will bring additional revenue through the sale of advertisements.
4. You are developing an e-commerce Web site. The following is a description of the components and stages of the Purchase pipeline on the Web site, with one component missing: . You want a query to be run for each item in an order. You will use the MtsTxPipeline object to run the Purchase pipeline. Which of the following components should you use to complete the Purchase pipeline? (Select the best choice.)
a. the SQLItem component
b. the SQLItemADO component
c. the SQLOrder component
d. the SQLOrderADO component
5. You have created a Site Server 3.0, Commerce Edition, Web site that is based on the Trey Research sample site. Your Web site is mapped to a Membership Server and uses the Membership security mode. Your Web site is configured to add, modify and remove user accounts programmatically, but occasionally you must use special procedures to add, modify or remove user accounts. Which of the following tools can be used to modify the user accounts on your Web site? (Select all choices that are correct.)
a. Membership Directory Manager (MDM)
b. Windows User Manager
c. Commerce Site Manager pages
d. Site Server Web-based Administration (WebAdmin) pages
6. You want to allow the customers of your e-commerce retail Web site to view the most popular colors of the items that you sell. A running total of the colors purchased is maintained in the PRODUCT database. You must add ActiveX Data Objects (ADO) code to the Active Server Pages (ASP) script on your purchase confirmation page. The itemSKU field contains the purchased item's stock-keeping unit (SKU) identification. No form of error checking is required in this scenario. Which of the following code segments should you use to update the redTotal field in the PRODUCT database? (Select the best choice.)
a.
Set itemPurchased = Server.CreateObject("ADODB.Recordset")
Set queryString = "SELECT * FROM [items] WHERE (itemSKU = '" & itemSKU & "')"
itemPurchased.Open queryString, , adOpenKeyset, adLockOptimistic, adCmdText
itemPurchased("redTotal") = itemPurchased("redTotal") + 1
itemPurchased.Close
b.
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open MSCSSite.DefaultConnectionString
Set itemPurchased = Server.CreateObject("ADODB.Recordset")
itemPurchased.Open conn, adOpenKeyset, adLockOptimistic, adCmdText
itemPurchased("redTotal") = itemPurchased("redTotal") + 1
itemPurchased.Close
conn.Close
c.
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open MSCSSite.DefaultConnectionString
Set itemPurchased = Server.CreateObject("ADODB.Recordset")
Set queryString = "SELECT * FROM [items] WHERE (itemSKU = '" & itemSKU & "')"
itemPurchased.Open queryString, conn, adOpenKeyset, adLockOptimistic, adCmdText
itemPurchased("redTotal") = itemPurchased("redTotal") + 1
itemPurchased.Close
conn.Close
d.
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open MSCSSite.DefaultConnectionString
Set itemPurchased = Server.CreateObject("ADODB.Recordset")
Set queryString = "SELECT * FROM [items] WHERE (itemSKU = '" & itemSKU & "')"
itemPurchased.Open queryString, conn, adOpenKeyset, adLockOptimistic, adCmdText
itemPurchased("redTotal") = itemPurchased("redTotal") + 1
itemPurchased.Update
itemPurchased.Close
conn.Close
Answers:
1) Choice b is correct. You should create a database query and store the query in the Web site's QueryMap object. The QueryMap object stores queries so that they will be accessible to the entire Web site. These queries can then be used for a variety of purposes, including writing order form information to database tables. The DBStorage object writes order form information to database tables, but it uses a marshalling process that stores all of the information in a single column. You could retrieve a specific receipt or receipts from this database for display, but it would be difficult to use the information for analysis. Similarly, you could store the HTML output that is generated by the receipt.asp page to display individual receipts, but that output would be difficult to analyze. The SimpleDBDS object uses a database to provide a directory services implementation so that you can use the Personalization and Membership features without using the Membership Directory. Reference: SS3CD, Contents, "Commerce Server," "Commerce Server Object Reference," "Dictionary Implementations," "The QueryMap Dictionary."
2) Choice b is correct. The VBScript file mscsadmin.vbs requires the WebSite or WebSiteID parameter, the SiteName parameter, and the ConnectionString parameter. The WebSite or WebSiteID parameter indicates the Web site on which to place the Site Foundation. In this scenario, WebSiteID:1 indicates the default Web site. The SiteName parameter is the name of the Web site that you want to create. In this scenario, MySampleSite is the site name. The ConnectionString parameter is a standard format connection string that takes the form "DSN=xxx;UID=yyy;PWD=zzz;", where xxx is the DSN; yyy is the user ID, usually sa; and zzz is the user password. If no password exists, then zzz remains empty. Reference: SS3CD, Contents, "Commerce Server," "Site Creation, Operation, and Administration," "Commerce Server Administration," "Server Administration from the Command Line," "Creating a New Site Foundation From the Command Line."
3) Only choices a and b are correct. After you map the Web site to the Membership Directory with Membership Authentication, as opposed to Windows NT authentication, the Web site will be able to accommodate millions of customer accounts. Allowing anonymous access to the majority of the Web site but adding HTML Forms Authentication for the Best Buyer program areas will effectively secure entry to only those members. Offering related products to customers who have just made a purchase requires the implementation of Intelligent Cross-sell on the Web site. Ad revenue requires advertisements, which can be implemented by using Ad Server. Reference: SS3CD, Contents, "Getting Results with Microsoft Site Server, Commerce Edition," "Learning the Basics," "Delivering Targeted Information," "Building a Community"; SS3CD, Contents, "Getting Results with Microsoft Site Server, Commerce Edition," "Learning the Basics," "Engaging and Transacting with Customers Online," "Creating a Commerce Site that Sells to Consumers and Businesses."
4) Choice b is correct. You should use the SQLItemADO component in a transacted environment to run a specified query for each item in an order. Although you can use the SQLItem component to run a specified query for each item in an order, it does not support transactions. The SQLOrder and SQLOrderADO components run a specified query for an entire order, rather than each item. The SQLOrderADO component supports transactions, whereas the SQLOrder component does not. Reference: SS3CD, Contents, "Commerce Server," "Pipeline Component Reference," "SQLItemADO"; SS3CD, Contents, "Commerce Server," "The Order Processing Pipeline," "The Order Processing Pipelines," "Business to Consumer Pipelines," "The Purchase Pipeline." t01, 1-92 Component Use: PipeToPipeTransfer
5) Only choices a and d are correct. You can use either MDM or WebAdmin pages to manage users in the Membership Directory. MDM is more powerful, and it allows changes to any aspect of the Membership Directory, including its own schema. WebAdmin pages are simpler and can be made available from remote locations. Windows User Manager can only be used to manage user accounts when the Web site uses the Windows NT security mode. Commerce Site Manager pages are used to manage the site itself, not the users in the Membership Directory. Reference: SS3CD, Contents, "Managing Security in Commerce and Ad Server Sites," "Commerce Site Security Architecture," "Membership Security."
6) Close Choice d is correct. To modify a field in a database record with ADO code, you must first select the record into a recordset, then make the changes, and finally call the recordset Update method. To import the record into a recordset, you must have used the ADO Connection object to create a connection to the database. You must use the CreateObject method of the Server object to create the Connection object, and you must open the connection with the Open method of the Connection object. When the changes have been made and the recordset has been updated, both the recordset and the connection should be closed by using their respective Close methods. Reference: SS3CD, Contents, "Commerce Server," "Accessing the Database," "Database Queries," "Executing Queries"; MSDN Library, Contents, "Platform SDK," "Data Access Services," "Microsoft Data Access Components (MDAC) SDK," "Microsoft ActiveX Data Objects (ADO)," "Microsoft ADO Programmer's Reference," "ADO Samples," "ADO Code Examples," "ADO Code Examples in Microsoft Visual Basic," "Update and CancelUpdate Methods Example (VB)."
These questions and answers are provided by Transcender LLC. Order the full version of this exam simulation online at www.transcender.com, phone 615-726-8779, 8 a.m. - 6 p.m., (CST), M - F, fax 615-726-8884, or mail to or mail to Transcender LLC, 565 Marriott Drive, Suite 300, Nashville, TN 37214.
More Pop Quiz:
|
