Certifications :: MCSD.NET - 70-300 Exam Job Interview Questions and Answers

MCSD.NET - 70-300 Exam Frequently Asked Questions in various MCSD.NET - 70-300 Exam Interviews asked by the interviewer. So learn MCSD.NET - 70-300 Exam with the help of this MCSD.NET - 70-300 Exam Interview questions and answers guide and feel free to comment as your suggestions, questions and answers on any MCSD.NET - 70-300 Exam Interview Question or answer by the comment feature available on the page.

1 ► Suppose You need to ensure that transportation brokers are authenticated when they access the brokerWeb site. Which action or actions should you take? (Choose all that apply)A. Create a distribution list of authenticated usersB. Provide a facility for online registrationC. Provide a facility to view passwordsD. Provide secure storage of user names and passwordsE. Secure the exchange of user names and passwords between the client computer and theserverF. Enable e-mail access for transportation brokersAnswer: B, D, E
2 ► Suppose You are completing the technical specification for the new reservation application.Which technique should you recommend for state management?A. ASP.NET ViewStateB. Server-side databaseC. Client-side cookiesD. Application cache
3 ► Explain Which new business process or processes should be supported by the new solution?(Choose all that apply)A. Brokers can order transportation servicesB. Vehicle scheduling capability is providedC. Bar code readers are supportedD. Use of space on vehicles can be trackedE. Brokers can track shipmentsF. Customers can track parcelsAnswer: A, D, E
4 ► Suppose You are writing a list of integration requirements for your solution. Which requirement orrequirements should you include? (Choose all that apply)A. Order data must be read from the accounting applicationB. Shipment tracking must be read from an XML Web serviceC. Customers must be redirected to another Web site to track shipmentsD. Customers must be able to place orders by using an XML Web serviceE. Order data must be written to the accounting applicationF. Order data must be e-mailed to the salespeopleAnswer: A, B, E
5 ► Suppose You are creating the logical design for a use case named Customer updates customer profiles?.Which object or objects should you include in the design? (Choose all that apply)A. Data access objectB. Customer objectC. Flight objectD. Logging objectE. Airline object
6 ► Suppose You need to enable brokers to track their own shipment. To meet this requirement, you need toconsider various specifications. Which four specifications should you consider? (Each correctanswer presents part of the solution)A. Provide a Web-accessible form to authenticate brokers against a table of registered usersB. Provide a Web-accessible form to enable brokers to request vehicle routes for their shipmentsC. Provide a Web-accessible form to query the database for broker shipmentsD. Provide a Web-accessible form to generate waybill numbersE. Identify a parcel in the database as part of a broker shipmentF. Relate a parcel to a specific brokerG. Track the weight of a parcel in the database
7 ► Explain The invoice creation process must be dynamically monitored to track the following information: Average number of seconds to create an invoice Number of invoices created per second Total number of successfully created invoices Total number of failed attempts to create an invoiceMonitoring should occur with a minimum of development effort. What should you do?A. Write statistics to the database and use SQL Query Analyzer to dynamically monitor thestatisticsB. Create a removable Microsoft .NET class to contain statistics. Configure the class as singletonclass. Write a utility that retrieves statistical information from this classC. Write statistics to the application event logD. Use custom performance counters
8 ► Suppose You are writing the technical specification for your solution. You need to select a technology forthe new timesheet application. Which technology should you use?A. an XML Web serviceB. a Web applicationC. a console applicationD. a Windows Forms application
9 ► Suppose You are preparing the functional specification for the new reservation application. Which twofunctionalities should you specify? (Each correct answer presents part of the solution. Choosetwo)A. LocalizationB. Monitoring of application performanceC. Secure storage of customer profile informationD. Availability of application for mobile phones and personal digital assistantsE. Integration with Active Directory
10 ► Suppose You are writing the primary scenario of a use case named Customer retrieves a saved itinerary.Which action or actions should be included?(Choose all that apply)A. Application informs customers that no itineraries existB. Application informs customers that a saved flight is no longer availableC. Customer asks for saved itinerariesD. Application offers alternate flightsE. Application queries the database for saved itinerariesF. Application displays retrieved itineraries
11 ► Explain Which business constraint poses the greatest potential risk to completing your project for BlueYonder Airlines?A. The current IT staff must support the solution in the futureB. All testing scenarios and all necessary rework must be completed during the one-month testingperiod.C. The scheduling vendor will begin providing access by XML Web service in three monthsD. The application must be completed within a five-month development period before it is tested
12 ► Suppose Web application used by Team Leads and Business Planners requires an authenticationmechanism. Which pair of authentication technologies should you recommend?A. IIS Anonymous authentication with ASP.NET Passport authenticationB. IIS Anonymous authentication with ASP.NET Forms authenticationC. IIS Basic authentication with SSL and ASP.NET Windows authenticationD. IIS Integrated Windows authentication with ASP.NET Windows authenticationE. IIS Basic authentication with SSL and ASP.NET Forms authentication
13 ► Suppose You are writing a conceptual diagram of the modules that must be developed for your solution.Which module or modules should be included?(Choose all that apply)A. a Web application for Team Leads and Business PlannersB. a timesheet entry databaseC. a billing databaseD. a notification engine that sends timesheet entry remindersE. a timesheet entry applicationF. a Windows CE applicationG. a utility that uploads information to the billing application
14 ► Explain When the new solution is in place, parcel information and parcel history information must bestored. You need to estimate the amount of data that will be generated by the new solution duringits first year of use. What is the approximate amount?A. 824MBB. 5GBC. 8GBD. 50GB
15 ► Suppose You need to decide whether your conceptual design represents a complete solution.Which four design artifacts are relevant to your decision? (Each correct answer presents part ofthe solution. Choose four)A. Unit test for authenticating brokersB. Component prototypes for tracking shipmentsC. Functional requirements for tracking shipmentsD. Unit test cases for tracking shipmentsE. Use cases for authenticating brokersF. Functional requirements authenticating brokersG. Component prototypes for authenticating brokersH. Use cases for tracking shipments
16 ► Suppose You are listing the operational requirements for the new reservation application.Which requirement should you include?A. ExtensibilityB. LocalizationC. MantainabilityD. AvailabilityE. Deployability
17 ► Suppose You are writing the operational requirements document for your solution. Which should youinclude?A. The application must encrypt all time entry data on client computers and in the database, anddata must be encrypted when transmitted over the internetB. The IT staff will be responsible for fixing bugs in the codeC. The IT staff must be alerted to application problemsD. The application can have no single point of failure
18 ► Suppose You are writing the technical specification for your solution. Your new timesheet application mustbe able to access timesheet entry data. You need to specify the technology that will be used foraccessing this data. Your solution must require the minimum development effort. Whichtechnology should you use?A. a SQLConnection classB. a .NET Remoting object that uses TCP channel and binary formattingC. an XML Web service proxy classD. an interop assembly
19 ► Suppose You are establishing a policy to measure the effectiveness of your deployment process.You decide to track one or more phases of development to identify defects. Which phase orphases should you track?(Choose all that apply)A. Design and analysisB. DevelopmentC. StabilizationD. Requirements
20 ► You are validating the physical design for your solution. Which element or elements should beincluded in the design?(Choose all that apply)A. algorithms for scheduling vehiclesB. scalability to meet increased usageC. authentication of transportation brokersD. online registration facility for transportation brokersE. interface to the bar code readers
21 ► If you are writing the functional specification for your solution. You must include the customerpricing requirements. Which requirement or requirements should you include? (Choose all thatapply)A. Pricing data must be encryptedB. Each user must be uniquely identifiedC. Content must be personalized by userD. Order data must be read from the accounting application
22 ► Suppose You are designing a strategy to migrate data from the existing timesheet application to the newapplication. Which tool or technology should you use?A. XML Schema Definition tool (xsd.exe)B. COM interoperabilityC. Microsoft SQL Server Data Transformation Services (DTS)D. Microsoft SQL Server replication
23 ► Explain Which new module or modules should you develop for Trey Research? (Choose all that apply.)A. An application to export laboratory resultsB. A data storeC. A Web application for trucking supervisorsD. An automated report generatorE. An application to import laboratory reportsF. An OCR interfaceG. An IVR application
24 ► Before you release the solution, you need to develop a process to validate and enforce anappropriate level of quality. Which three statistics should you use?(Each correct answer presents part of the solution)A. Number of defects per componentB. Number of defects per thousand lines of source codeC. Number of defects by developerD. Percentage of successful buildsE. Percentage of requirements testedF. Number of defects detected to dateG. Number of defects corrected to date.
25 ► Suppose You are validating the physical design of a data a data layer class that will return a set of timeentries from the timesheet database. This class will be used by the Web application for TeamLeads and Business Planners and, indirectly, by the new timesheet application.The class must use connection pooling, and it must be as secure and as flexible as possible. Youneed to specify a Microsoft SQL Server authentication strategy that meets these requirements.Which strategy should you use?A. The data class uses SQL Server authentication with an application specific SQL Serveraccount. The account name and password are embedded in a connection stringB. The data class uses Windows authentication when connecting to the database andimpersonates a specific account created for operations on the databaseC. The data class uses Windows authentication when connecting to the database andimpersonates the application userD. The data class uses SQL Server authentication with the SQL Server sa account
26 ► Suppose You are creating the physical design for the customer category data model. For reportingpurposes, you want to optimize access to customer category data. You define a Customer tableand a Category table. What should you do next?A. Define three foreign key columns in the Category table, such that each column references adifferent parent row in the Customer table. Define indexes on the foreign key columns.B. Define three foreign key columns in the Customer table, such that each column references adifferent parent row in the Category table. Define indexes on the foreign key columns.C. Define a foreign key column in the Category table that references the parent row in theCustomer table. Define an index on the foreign key column.D. Define a foreign key column in the Customer table that references the parent row in theCategory table. Define an index on the foreign key column.
27 ► Suppose You need to recommend standard development processes for your solution. Yourrecommendations must assist the development team in learning to use the Microsoft .NETFramework as quickly as possible. Which process or processes should you recommend?(Chooseall that apply)A. Create an automated build processB. Install error-tracking softwareC. Ensure that all assemblies pass unit testingD. Permit individual developers to use any Microsoft .NET languageE. Hold regular code reviews
28 ► Suppose Your team builds a daily release of the timesheet application for testing by the quality assurance(QA) team. You find that the volume of bugs is threatening your project schedule. The followingexample is a typical bug:One method should return a dataset that is based on a date range given as input parameters.However, when the method queries the database, it erroneously interchanges the beginning dateand the end date. An empty dataset is always returned.You need to minimize these kinds of bugs using a minimum of development effort andQA effort. What should you do?A. Require more frequent buildsB. Require the QA team to perform more integration testingC. Require engineers to perform complete integration testing before submitting codeD. Require engineers to perform adequate unit tests before submitting code
29 ► Suppose You need to create a physical design that meets the monitoring requirements of Fabrikam, INC.What should you do?A. Create and use a new event log to record each customer logon eventB. Use the built-in ASP.NET performance counters to monitor application loadC. Use the Trace class to record each customer logon eventD. Create and use new NumberOfItems performance counters to monitor active customer sessions
30 ► Suppose A database architect on your team prepares a logical data model. The model includes entries thatcorrespond to clients, projects and timesheet entries. You are reviewing the model. Which entityrelationship or relationships should be included?(Choose all that apply)A. a Project entity is the parent of a TimesheetEntry entityB. a Client entity is the child of a TimesheetEntry entityC. a many-to-many relationship exists between a Client entity and a Project entityD. a many-to-many relationship exists between a Project entity and a Timesheet Entry entityE. a Client entity is the parent of a Project entityF. a Client entity is the parent of a TimesheetEntry entity
31 ► Suppose You are validating your physical design. You need to ensure that the design maps to thecategorization requirements for customer pricing. Which member should you include in thedesign?A. A GetPrice method of a Product class with no parametersB. A Price property of a Product classC. A Price property of a Customer classD. A GetPrice method of a Product class with a single Customer Object parameter
32 ► Suppose You are analyzing the feasibility of your solution. You need additional information to decidewhether the solution is technically possible. Which additional information do you need?A. A copy of the existing timesheet applicationB. A prototype of the Web application that will be used by Team Leads and Business PlannersC. A list of the different models of Windows CE devices that need to be supportedD. API information and requirements related to integration with the billing application
33 ► Explain The Web application used by Business Planners generates many types of reports. One typedisplays billing information over specified timeframes. The other selects a lawyer and a timeframeand the report displays the average number of minutes billed by that lawyer per day and theaverage number of minutes billed to each client per day over that timeframe. You must ensurethat this report is generated with a minimum network traffic. What should you do?A. Use Microsoft SQL Server indexes to optimize the data calculationsB. Implement the calculations in a business layer classC. Implement the calculations in a data layer classD. Use Microsoft SQL Server stored procedures for the data calculations
34 ► Suppose You need to implement online interactive user assistance for the new reservation application.What should you do?A. Create a manual that can be downloaded from the Web siteB. Create a compiled help module and use context-sensitive help for all screen elementsC. Implement ToolTips to provide information about all screen elementsD. Use the ALT attribute to provide a short textual description for all images and audio files.
35 ► Explain Your functional specification includes the following statement: User identity and a tirnestarnpmust be captured when a driver authenticates to the IVR application or the driver Webapplication. In your technical specification, you need to specify the target where loggedmessages should be written. Which target should you specify?A. The sysmessages table in the Microsoft SOL Server master databaseB. The Security event logC. A table in the applications Microsoft SOL Server databaseD. A custom event log
36 ► Suppose You need to select a strategy that will provide detailed usage information for the new reservationapplication. Information must be provided with a minimum development effort. What should youdo?A. Use Microsoft .NET performance counters in the applicationB. Create a Microsoft Management Console(MMC) snap-in for the applicationC. Add Windows Management instrumentation to the applicationD. Use the application?s configuration file to enable and disable logging
37 ► Suppose You are writing a document that identifies potential project risks. Which business constraint posesthe greatest potential risk?A. The solution must be hosted by Fabrikam, IncB. Testing and deployment of the customer Web site must be complete in six monthsC. The shipping partner will deploy the XML Web service in four monthsD. All customers will try to place orders at the end of the month
38 ► Suppose You are designing the implementation of the interface to the accounting application. You need toensure that the new application can communicate with the accounting application. What shouldyou do?A. Create an XML Web service classB. Create TcpClient objectsC. Create TcpListener objectsD. Create an XML Web service proxy class by using Wsdl.exe
39 ► You must ensure that the new reservation application can be monitored while it is running. Whichapproach should you use?A. TraceSwitch objectsB. Diagnostic toolsC. PerformanceCounter objectsD. Windows Management Instrumentation Job Object provider
40 ► If you are creating the logical design for the new reservation application. Which entity or entities should you include? (Choose all options that apply)A. AirportB. FlightC. CustomerD. GateE. City
41 ► Suppose You are validating your conceptual design in terms of scalability. Which requirement will probablyhave the greatest impact on scalability?A. Scheduling additional vehiclesB. Using the interface to bar code readersC. Reporting use of space in vehiclesD. Handling additional broker shipments
42 ► Explain Which data item or items should you add to the existing applications? (Choose all that apply)A. Waybill informationB. Broker identification informationC. Depot informationD. Parcel dimensionsE. Parcel routing informationF. Information about use of space on vehicles
43 ► Explain Which performance standard should you use for your solution?A. Vehicle usage of at least 80 percent of total capacityB. Database size of less than one terabyteC. CPU utilization of less than 50 percent in the database serverD. Screen response time of two seconds or less