You Create An ASP.NET Application That Produces Sales Reports For The XYZ Corporation.The Sales Data Is Stored In A Microsoft SQL Server Database That Is Used For Transactionprocessing. The Application Consists Of Complex Transact SQL Statements.Many Users Report That The Report Generation Is Taking Longer To Run Each Day. You Need Toimprove Response Times.What Are Two Possible Ways To Achieve This Goal? (Each Correct Answer Presents A Completesolution. Choose Two)A. Use An OleDbDataAdapter Indexes Exist On The SQL Server Tables.B. Ensure That Appropriate Indexes Exist In The SQL Server Tables.C. Rewrite Your SQL Statements To Use Aliases For All Table Names.D. Rewrite Your Direct SQL Statements As Stored Procedures And Call The Stored Procedures Fromyour Application.E. Configure Queries To Run In The Security Context Of The User Who Is Running The Query.

⟩ You create an ASP.NET application that produces sales reports for the XYZ corporation.The sales data is stored in a Microsoft SQL Server database that is used for transactionprocessing. The application consists of complex Transact-SQL statements.Many users report that the report generation is taking longer to run each day. You need toimprove response times.What are two possible ways to achieve this goal? (Each correct answer presents a completesolution. Choose two)A. Use an OleDbDataAdapter indexes exist on the SQL Server tables.B. Ensure that appropriate indexes exist in the SQL Server tables.C. Rewrite your SQL statements to use aliases for all table names.D. Rewrite your direct SQL statements as stored procedures and call the stored procedures fromyour application.E. Configure queries to run in the security context of the user who is running the query.

B. Ensure that appropriate indexes exist in the SQL Server tables.

D. Rewrite your direct SQL statements as stored procedures and call the stored procedures from

your application.

Is this answer helpful?
0 Yes | 0 No

182 views

You create a serviced component named CompanyScheduler. CompanyScheduler is registeredin a library application. The Scheduler methods parse String objects into Date Time objects. Youwrite a console application named Coverage.exe to test each method in Scheduler. You wantCoverage.exe to test Scheduler for multiple cultures to verify its globalization support.What should you do?A. Create a Culture Info object for each culture locale before calling the CompanySchedulermethods.B. Create a Region Info object for each culture locale before calling the CompanySchedulermethods.C. Set the current threads Current Culture property to each culture locale before calling theCompanyScheduler methods.D. Create a Coverage.exe.config file and add a <location> element to the configuration file foreach culture locale.

You have a .NET Remoting object named Utils. The Utils class is a client-activated .NETRemoting object. You want to write a client application that creates and uses a Utils object. Youwant the client application to hold onto a reference to a Utils object for the duration of itsexecution.What should you do?A. Construct the Utils object, and hold the object in a member variable.B. Construct the Utils object, and set the LifeTimeService.LeaseTime to 0.C. In the client application, create an Implementation of the ISponsor interface. Implement theRenewal method to extend the lease.D. In the client application, create an Implementation of the ILease interface. Implement theCurrentLeaseTime property to return Int32.MaxValue.

Suppose You have an ASP.NET application named ES WebApp. This application uses a private assemblynamed Employee to store and retrieve employee data. Employee is located in the bin directory ofES WebApp. You develop a new ASP.NET application named ESWebApp2 that also needs touse Employee. You assign Employee a strong name, set its version to 1.0.0.0, and install it in theglobal assembly cache. You then create a publisher policy assembly for version 1.0.0.0 andinstall it in the global assembly cache. You compile ESWebApp2 against version 1.0.0.0. You donot recompile My WebApp. You then run ES WebApp.What is the most likely result?A. A Version Not Found Exception is thrown.B. Employee is loaded from the bin directory.C. Version 1.0.0.0 of Employee is loaded from the global assembly cache.D. Version 1.0.0.0 of Employee is loaded by the publisher policy assembly.

Suppose You are developing a Windows-based application that requires the use of a calculation functionnamed Calculate Value. This function includes the following signature int Calculate Value(int x) ;Calculate Value is located in an unmanaged DLL named Company Functions.dll, and is not partof a COM interface.You need to be able to use Calculate Value in your application.Which action or actions should you take? (Choose all that apply)A. Use Regsvr32.exe to register CompanyFunctions.dll.B. Use Visual Studio .NET to add a reference to CompanyFunctions.dll.C. To your application, add the following code segment using CompanyFunctions;D. To your application, add the following code segment [DllImport("CompanyFunctions.dll")]public static extern int Calculate Value(int x);

Suppose Company Ltd. receives product information from manufactures in the form of an XML documents.The product information is stored in a Microsoft SQL Server database. The format of each XMLdocument varies. Each one is located in a MemoryStream object named newProds. You create amerge procedure that reads data and schema information in a Dataset object and merges theinformation into your database. You now need to write code to transfer the XML document and itsschema into a Dataset object.Which code segment should you use?A. Dataset products = new Dataset("prodInfo");XmlTextReader reader = new XmlTextReader(newProds);XmlValidatingReader validReader = newXmlValidatingReader(reader);while (validReader.Read()) { products.WriteXml(validReader.Value);}B. Dataset products = new Dataset("prodInfo");products.ReadXml(newProds);C. Dataset products = new Dataset("prodInfo");XmlDataDocument document = new XmlDataDocument(products);D. document.DataSet.ReadXmlSchema(ne

Suppose You create an XML Web service named Time ESService. Each time ESService is started, itchecks for the existence of an event log named Time ESServiceLog. If TimeServiceLog does notexist, Time ESService creates it. You discover that when Time ESService creates TimeESServiceLog, it throws a System.Security.SecurityException. The exception includes thefollowing message "Requested registry access is not allowed". You need to resolve this problem.What should you do?A. Configure Inetinfo.exe to run as the local administrator user account.B. Create an installer for Time ESService, and create the new event log in the installer code.C. Modify the Web.config file by adding an identity element to impersonate the LOGON userspecified by Internet Information Services (IIS).D. Modify the permissions of theKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesEventlog registry key to givefull control to the IUSR_computername user account.

Suppose You have a .NET Remoting object named ES ProductLoader. The ES ProductLoader class is aserver-activated Singleton object.The ES ProductLoader class loads product data into a Microsoft SQL Server database. The Loadmethod of the ES ProductLoader class is a time-consuming method to call. You are developing aclient application that uses the ES ProductLoader class. You want to ensure that the clientapplication can continue to respond to user input while the Load method of the ES ProductLoaderclass is called.What should you do?A. Use an AsyncDelegate instance to call the Load method.B. Modify the ES ProductLoader class to be derived from IAsyncResult.C. Configure the ES ProductLoader class to be a client-activated .NET Remoting object.D. Configure the client application to have its own remoting channel that matches the serverschannel and formatter.

Suppose You are planning to create a Dataset object named ES DataSet to be used in a bond-tradingapplication. Several developers will need to write code to manipulate myDataSet, and you want toensure that ES DataSet is easy for them to use. You decide to create ES DataSet as a stronglytyped data set. Which two actions should you take? (Each correct answer presents part of thesolution. Choose two)A. Create an XSD schema that defines ES DataSet.B. Create an XDR schema that defines ES DataSet.C. Create a class for ES DataSet that is based on the schema and that inherits from the Datasetclass.D. Create a class for ES DataSet that is based on the schema and that inherits from theXmlSchema class.E. Create a key pair for ES DataSet by using the Strong Name tool (Sn.exe).

Suppose You create a serviced component named Session Dispenser. This computer is in theCompany.Utilities assembly and is registered in a COM+ server application. Session Dispenserhas multiple callers. You discover that there are logic problems in the Create New Sessionmethod. You want to debug any calls to this method. What should you do?A. Open the Session Dispenser solution.Set a breakpoint on the Create New Session method.Start the debugger.B. Attach the debugger to the client process.Set a breakpoint on the SessionDispenser.CreateNewSession method.C. Attach the debugger to the Company.Utilites.exe process.Set a breakpoint on the Create New Session method.D. Attach the debugger to a Dllhost.exe process.Set a breakpoint on the Create New Session method.

Suppose You create an XML Web service named Postal Code. Your project source includes a codebehindfile and a file named PostalCode.asmx. During implementation, you use the Debug class torecord debugging log messages, to verify values, and to report debugging failures. You want todeploy Postal Code to a production computer. You do not want any of the debugging code toexecute on the production computer. What should you do?A. Set the projects active configuration to Release and rebuild the DLL.B. Modify the trace element of the Web.config file by setting the enabled attribute to "false".C. Modify the compilation element of the Web.config file by setting the debug attribute to "false".D. Add code to the constructor of the Postal Code class to set the Auto Flash property of theDebug class to false.E. Add code to the constructor of the Postal Code class to call the Clear method of theDebug.Listeners property.

Question and Answer:

Home MCSD.NET - 70-315 Exam

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

Quick Links: