PrepAway - Latest Free Exam Questions & Answers

Author: admin

What should you do to ensure that the Certkiller .com users who should not have access to the CKFinance databa

You work as a Microsoft ASP.NET developer at Domain.com. Domain.com uses the Microsoft Visual Studio .NET 2005 as their application development platform. The Domain.com network contains an SQL Server 2005 database server named Certkiller -DB01 and a Web server named Certkiller -SR15. Certkiller -DB01 hosts a database named CKFinance that is accessed by an in-house Web application. The Web application is hosted on Certkiller -SR15 and uses SQL Server authentication to access the CKFinance database. Several Domain.com users in the Sales department have access to Certkiller -SR15 but do not have permission to access the CKFinance database. You need to ensure that the Domain.com users who should not have access to the CKFinance database cannot use the Web application to access the database.
What should you do?

What should you do to configure the New Web site dialog box in Visual Studio 2005 to meet your requirements?

You use a Microsoft Windows XP Professional client computer named Certkiller -WS528 as your development computer. Internet Information Services (IIS) is installed on Certkiller -WS528. All ASP.NET 1.1 Web applications hosted by IIS on Certkiller -WS528 are accessed on port 80. You are required to develop a new ASP.NET inventory application named CKInvtry that will be integrated into Domain.com’s existing e-Commerce Web site. You want to store all source files for the CKInvtry application in the
C:InetpubwwwrootCKInvtry folder on TESTING-WS528. During development you must be able to access CKInvtry at the URL "http://localhost:80/CKInvtry". You need to configure the New Web site dialog box in Visual Studio 2005 to meet your requirements.
What should you do?

What should you do to find the cause of the exception being raised in line 05?

You create a Web Form that displays a GridView. The GridViews data source is a DataSet named dsOrders. The DataSet contains two DataTables named Orders and OrderDetails. You create a relation between the two DataTables using the following code segment. (Line numbers are included for reference only.)

01 dtOrders =dsOrders.Tables("Orders")
02 dtOrderDetails = dsOrders.Tables("OrderDetails") 03 colParent = dtOrders.Columns("OrderID")
04 colChild =dtOrderDetails.Columns("ParentOrderID") 05 dsOrders.Relations.Add("Rel1", colParent,colChild, False)

You need to find the cause of the exception being raised in line 05.
What should you do?

What should you do to ensure that the Total column is set to the value of the Price column multiplied?

You are creating a DataTable. You use the following code segment to create the DataTable. (Line numbers are included for reference only.)

01 Dim dt As New DataTable("Products")
02 dt.Columns.Add(New DataColumn("Price", _GetType(Decimal))) 03 dt.Columns.Add(New DataColumn("Quantity", _GetType(Int32))) 04 Dim dc As DataColumn = New DataColumn("Total", _GetType(Decimal)) 05 dt.Columns.Add(dc)

You need to ensure that the Total column is set to the value of the Price column multiplied by the Quantity column when new rows are added or changed. What should you do?

What should you do to find all validation errors in the XML document?

You create a Web application to process XML documents. The Web application receives XML document files from several sources, reads them, and stores them in a Microsoft SQL Server database. The Web application parses all incoming data files to ensure that they conform to an XML schema. You need to find all validation errors in the XML document. What should you do?

What should you do to copy the Web site to the virtual directory on the testing server without precompiling th

You create a Web site that you must copy from a development server to a testing server, along with all source files. You do not have terminal access to the testing server. You need to create the virtual directory. Then you must copy the Web site to the virtual directory on the testing server without precompiling the site. What should you do?

Which two actions should you perform to resolve this error?

You are developing a Web application. The Web application uses the following code segment to connect to a database.

conn.ConnectionString="Server=(local);"&_"Initial Catalog=NorthWind;Integrated Security=SSPI;"

You create logins in Microsoft SQL Server for each user of the Web application. When you run the Web application, you receive the following error message.

"Login failed for user ‘COMPUTERNAMEASPNET’."

You need to resolve this error. Which two actions should you perform? (Each correct answer presents part of the solution. Choose two.)