Top MCSD.NET - 70-300 Interview Questions & Answers:

1. Explain Which performance standard should you use for your solution?
A. Vehicle usage of at least 80 percent of total capacity
B. Database size of less than one terabyte
C. CPU utilization of less than 50 percent in the database server
D. Screen response time of two seconds or less

D. Screen response time of two seconds or less

2. Explain Which data item or items should you add to the existing applications? (Choose all that apply)
A. Waybill information
B. Broker identification information
C. Depot information
D. Parcel dimensions
E. Parcel routing information
F. Information about use of space on vehicles

B. Broker identification information
D. Parcel dimensions
F. Information about use of space on vehicles

3. Suppose You are validating your conceptual design in terms of scalability. Which requirement will probably
have the greatest impact on scalability?
A. Scheduling additional vehicles
B. Using the interface to bar code readers
C. Reporting use of space in vehicles
D. Handling additional broker shipments

D. Handling additional broker shipments

4. 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. Airport
B. Flight
C. Customer
D. Gate
E. City

A:Airport
B. Flight
C. Customer

5. You must ensure that the new reservation application can be monitored while it is running. Which
approach should you use?
A. TraceSwitch objects
B. Diagnostic tools
C. PerformanceCounter objects
D. Windows Management Instrumentation Job Object provider

C. PerformanceCounter objects

6. Suppose You are designing the implementation of the interface to the accounting application. You need to
ensure that the new application can communicate with the accounting application. What should
you do?
A. Create an XML Web service class
B. Create TcpClient objects
C. Create TcpListener objects
D. Create an XML Web service proxy class by using Wsdl.exe

B. Create TcpClient objects

7. Suppose You are writing a document that identifies potential project risks. Which business constraint poses
the greatest potential risk?
A. The solution must be hosted by Fabrikam, Inc
B. Testing and deployment of the customer Web site must be complete in six months
C. The shipping partner will deploy the XML Web service in four months
D. All customers will try to place orders at the end of the month

D. All customers will try to place orders at the end of the mont

8. Suppose You need to select a strategy that will provide detailed usage information for the new reservation
application. Information must be provided with a minimum development effort. What should you
do?
A. Use Microsoft .NET performance counters in the application
B. Create a Microsoft Management Console(MMC) snap-in for the application
C. Add Windows Management instrumentation to the application
D. Use the application?s configuration file to enable and disable logging

A. Use Microsoft .NET performance counters in the application

9. Explain Your functional specification includes the following statement: User identity and a tirnestarnp
must be captured when a driver authenticates to the IVR application or the driver Web
application. In your technical specification, you need to specify the target where logged
messages should be written. Which target should you specify?
A. The sysmessages table in the Microsoft SOL Server master database
B. The Security event log
C. A table in the applications Microsoft SOL Server database
D. A custom event log

C. A table in the application's Microsoft SOL Server database

10. 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 site
B. Create a compiled help module and use context-sensitive help for all screen elements
C. Implement ToolTips to provide information about all screen elements
D. Use the ALT attribute to provide a short textual description for all images and audio files.

C. Implement ToolTips to provide information about all screen elements

Download Interview PDF

11. Explain The Web application used by Business Planners generates many types of reports. One type
displays billing information over specified timeframes. The other selects a lawyer and a timeframe
and the report displays the average number of minutes billed by that lawyer per day and the
average number of minutes billed to each client per day over that timeframe. You must ensure
that this report is generated with a minimum network traffic. What should you do?
A. Use Microsoft SQL Server indexes to optimize the data calculations
B. Implement the calculations in a business layer class
C. Implement the calculations in a data layer class
D. Use Microsoft SQL Server stored procedures for the data calculations

D. Use Microsoft SQL Server stored procedures for the data calculations

12. Suppose You are analyzing the feasibility of your solution. You need additional information to decide
whether the solution is technically possible. Which additional information do you need?
A. A copy of the existing timesheet application
B. A prototype of the Web application that will be used by Team Leads and Business Planners
C. A list of the different models of Windows CE devices that need to be supported
D. API information and requirements related to integration with the billing application

D. API information and requirements related to integration with the billing application

13. Suppose You are validating your physical design. You need to ensure that the design maps to the
categorization requirements for customer pricing. Which member should you include in the
design?
A. A GetPrice method of a Product class with no parameters
B. A Price property of a Product class
C. A Price property of a Customer class
D. A GetPrice method of a Product class with a single Customer Object parameter

D. A GetPrice method of a Product class with a single Customer Object parameter

14. Suppose A database architect on your team prepares a logical data model. The model includes entries that
correspond to clients, projects and timesheet entries. You are reviewing the model. Which entity
relationship or relationships should be included?(Choose all that apply)
A. a Project entity is the parent of a TimesheetEntry entity
B. a Client entity is the child of a TimesheetEntry entity
C. a many-to-many relationship exists between a Client entity and a Project entity
D. a many-to-many relationship exists between a Project entity and a Timesheet Entry entity
E. a Client entity is the parent of a Project entity
F. a Client entity is the parent of a TimesheetEntry entity

A. a Project entity is the parent of a TimesheetEntry entity
E. a Client entity is the parent of a Project entity

15. 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 event
B. Use the built-in ASP.NET performance counters to monitor application load
C. Use the Trace class to record each customer logon event
D. Create and use new NumberOfItems performance counters to monitor active customer sessions

D. Create and use new NumberOfItems performance counters to monitor active customer sessions

16. 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 following
example 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 date
and the end date. An empty dataset is always returned.
You need to minimize these kinds of bugs using a minimum of development effort and
QA effort. What should you do?
A. Require more frequent builds
B. Require the QA team to perform more integration testing
C. Require engineers to perform complete integration testing before submitting code
D. Require engineers to perform adequate unit tests before submitting code

D. Require engineers to perform adequate unit tests before submitting code

17. Suppose You need to recommend standard development processes for your solution. Your
recommendations must assist the development team in learning to use the Microsoft .NET
Framework as quickly as possible. Which process or processes should you recommend?(Choose
all that apply)
A. Create an automated build process
B. Install error-tracking software
C. Ensure that all assemblies pass unit testing
D. Permit individual developers to use any Microsoft .NET language
E. Hold regular code reviews

C. Ensure that all assemblies pass unit testing
E. Hold regular code reviews

18. Suppose You are creating the physical design for the customer category data model. For reporting
purposes, you want to optimize access to customer category data. You define a Customer table
and a Category table. What should you do next?
A. Define three foreign key columns in the Category table, such that each column references a
different 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 a
different 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 the
Customer 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 the
Category 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 the
Category table. Define an index on the foreign key column.

19. Suppose You are validating the physical design of a data a data layer class that will return a set of time
entries from the timesheet database. This class will be used by the Web application for Team
Leads 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. You
need 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 Server
account. The account name and password are embedded in a connection string
B. The data class uses Windows authentication when connecting to the database and
impersonates a specific account created for operations on the database
C. The data class uses Windows authentication when connecting to the database and
impersonates the application user
D. The data class uses SQL Server authentication with the SQL Server sa account

B. The data class uses Windows authentication when connecting to the database and impersonates a specific account created for operations on the database

20. Before you release the solution, you need to develop a process to validate and enforce an
appropriate level of quality. Which three statistics should you use?
(Each correct answer presents part of the solution)
A. Number of defects per component
B. Number of defects per thousand lines of source code
C. Number of defects by developer
D. Percentage of successful builds
E. Percentage of requirements tested
F. Number of defects detected to date
G. Number of defects corrected to date.

E. Percentage of requirements tested
F. Number of defects detected to date
G. Number of defects corrected to date.

21. Explain Which new module or modules should you develop for Trey Research? (Choose all that apply.)
A. An application to export laboratory results
B. A data store
C. A Web application for trucking supervisors
D. An automated report generator
E. An application to import laboratory reports
F. An OCR interface
G. An IVR application

E. An application to import laboratory reports
F. An OCR interface

22. Suppose You are designing a strategy to migrate data from the existing timesheet application to the new
application. Which tool or technology should you use?
A. XML Schema Definition tool (xsd.exe)
B. COM interoperability
C. Microsoft SQL Server Data Transformation Services (DTS)
D. Microsoft SQL Server replication

C. Microsoft SQL Server Data Transformation Services (DTS)

23. If you are writing the functional specification for your solution. You must include the customer
pricing requirements. Which requirement or requirements should you include? (Choose all that
apply)
A. Pricing data must be encrypted
B. Each user must be uniquely identified
C. Content must be personalized by user
D. Order data must be read from the accounting application

B. Each user must be uniquely identified
C. Content must be personalized by user

24. You are validating the physical design for your solution. Which element or elements should be
included in the design?(Choose all that apply)
A. algorithms for scheduling vehicles
B. scalability to meet increased usage
C. authentication of transportation brokers
D. online registration facility for transportation brokers
E. interface to the bar code readers

B. scalability to meet increased usage
C. authentication of transportation brokers
D. online registration facility for

Download Interview PDF

25. 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 or
phases should you track?(Choose all that apply)
A. Design and analysis
B. Development
C. Stabilization
D. Requirements

C. Stabilization

26. Suppose You are writing the technical specification for your solution. Your new timesheet application must
be able to access timesheet entry data. You need to specify the technology that will be used for
accessing this data. Your solution must require the minimum development effort. Which
technology should you use?
A. a SQLConnection class
B. a .NET Remoting object that uses TCP channel and binary formatting
C. an XML Web service proxy class
D. an interop assembly

C. an XML Web service proxy class

27. Suppose You are writing the operational requirements document for your solution. Which should you
include?
A. The application must encrypt all time entry data on client computers and in the database, and
data must be encrypted when transmitted over the internet
B. The IT staff will be responsible for fixing bugs in the code
C. The IT staff must be alerted to application problems
D. The application can have no single point of failure

C. The IT staff must be alerted to application problems

28. Suppose You are listing the operational requirements for the new reservation application.
Which requirement should you include?
A. Extensibility
B. Localization
C. Mantainability
D. Availability
E. Deployability

D. Availability

29. 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 of
the solution. Choose four)
A. Unit test for authenticating brokers
B. Component prototypes for tracking shipments
C. Functional requirements for tracking shipments
D. Unit test cases for tracking shipments
E. Use cases for authenticating brokers
F. Functional requirements authenticating brokers
G. Component prototypes for authenticating brokers
H. Use cases for tracking shipments

C. Functional requirements for tracking shipments
E. Use cases for authenticating brokers
F. Functional requirements authenticating brokers
H. Use cases for tracking shipment

30. Explain When the new solution is in place, parcel information and parcel history information must be
stored. You need to estimate the amount of data that will be generated by the new solution during
its first year of use. What is the approximate amount?
A. 824MB
B. 5GB
C. 8GB
D. 50GB

C. 8GB

31. 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 Planners
B. a timesheet entry database
C. a billing database
D. a notification engine that sends timesheet entry reminders
E. a timesheet entry application
F. a Windows CE application
G. a utility that uploads information to the billing application

A. a Web application for Team Leads and Business Planners
B. a timesheet entry database
E. a timesheet entry application
F. a Windows CE application
G. a utility that uploads information to the billing application

32. Suppose Web application used by Team Leads and Business Planners requires an authentication
mechanism. Which pair of authentication technologies should you recommend?
A. IIS Anonymous authentication with ASP.NET Passport authentication
B. IIS Anonymous authentication with ASP.NET Forms authentication
C. IIS Basic authentication with SSL and ASP.NET Windows authentication
D. IIS Integrated Windows authentication with ASP.NET Windows authentication
E. IIS Basic authentication with SSL and ASP.NET Forms authentication

C. IIS Basic authentication with SSL and ASP.NET Windows authentication

33. Explain Which business constraint poses the greatest potential risk to completing your project for Blue
Yonder Airlines?
A. The current IT staff must support the solution in the future
B. All testing scenarios and all necessary rework must be completed during the one-month testing
period.
C. The scheduling vendor will begin providing access by XML Web service in three months
D. The application must be completed within a five-month development period before it is tested

C. The scheduling vendor will begin providing access by XML Web service in three months

34. 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 exist
B. Application informs customers that a saved flight is no longer available
C. Customer asks for saved itineraries
D. Application offers alternate flights
E. Application queries the database for saved itineraries
F. Application displays retrieved itineraries

C. Customer asks for saved itineraries
E. Application queries the database for saved itineraries
F. Application displays retrieved itineraries

35. Suppose You are preparing the functional specification for the new reservation application. Which two
functionalities should you specify? (Each correct answer presents part of the solution. Choose
two)
A. Localization
B. Monitoring of application performance
C. Secure storage of customer profile information
D. Availability of application for mobile phones and personal digital assistants
E. Integration with Active Directory

B: onitoring of application performance
C: Secure storage of customer profile information