Microsoft Certified Solutions Developer (MCSD).NET 70 300 Interview Questions

 
1.
Suppose You need to ensure that transportation brokers are authenticated when they access the broker
Web site. Which action or actions should you take? (Choose all that apply)
A. Create a distribution list of authenticated users
B. Provide a facility for online registration
C. Provide a facility to view passwords
D. Provide secure storage of user names and passwords
E. Secure the exchange of user names and passwords between the client computer and the
server
F. Enable e-mail access for transportation brokers
Answer: 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 ViewState
B. Server-side database
C. Client-side cookies
D. 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 services
B. Vehicle scheduling capability is provided
C. Bar code readers are supported
D. Use of space on vehicles can be tracked
E. Brokers can track shipments
F. Customers can track parcels
Answer: A, D, E
4.
Suppose You are writing a list of integration requirements for your solution. Which requirement or
requirements should you include? (Choose all that apply)
A. Order data must be read from the accounting application
B. Shipment tracking must be read from an XML Web service
C. Customers must be redirected to another Web site to track shipments
D. Customers must be able to place orders by using an XML Web service
E. Order data must be written to the accounting application
F. Order data must be e-mailed to the salespeople
Answer: 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 object
B. Customer object
C. Flight object
D. Logging object
E. Airline object
6.
Suppose You need to enable brokers to track their own shipment. To meet this requirement, you need to
consider various specifications. Which four specifications should you consider? (Each correct
answer presents part of the solution)
A. Provide a Web-accessible form to authenticate brokers against a table of registered users
B. Provide a Web-accessible form to enable brokers to request vehicle routes for their shipments
C. Provide a Web-accessible form to query the database for broker shipments
D. Provide a Web-accessible form to generate waybill numbers
E. Identify a parcel in the database as part of a broker shipment
F. Relate a parcel to a specific broker
G. 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 invoice
Monitoring 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 the
statistics
B. Create a removable Microsoft .NET class to contain statistics. Configure the class as singleton
class. Write a utility that retrieves statistical information from this class
C. Write statistics to the application event log
D. Use custom performance counters
8.
Suppose You are writing the technical specification for your solution. You need to select a technology for
the new timesheet application. Which technology should you use?
A. an XML Web service
B. a Web application
C. a console application
D. a Windows Forms application
9.
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
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 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
11.
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
12.
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
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 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
14.
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
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 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
16.
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
17.
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
18.
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
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 or
phases should you track?(Choose all that apply)
A. Design and analysis
B. Development
C. Stabilization
D. Requirements
20.
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
21.
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
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
23.
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
24.
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.
25.
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
26.
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.
27.
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
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 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
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 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
30.
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
31.
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
32.
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
33.
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
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 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.
35.
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
36.
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
37.
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
38.
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
39.
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
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. Airport
B. Flight
C. Customer
D. Gate
E. City
41.
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
42.
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
43.
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
44.
Suppose You need to ensure that transportation brokers are authenticated when they access the broker
Web site. Which action or actions should you take? (Choose all that apply)
A. Create a distribution list of authenticated users
B. Provide a facility for online registration
C. Provide a facility to view passwords
D. Provide secure storage of user names and passwords
E. Secure the exchange of user names and passwords between the client computer and the
server
F. Enable e-mail access for transportation brokers
Answer: B, D, E
45.
Suppose You are completing the technical specification for the new reservation application.
Which technique should you recommend for state management?
A. ASP.NET ViewState
B. Server-side database
C. Client-side cookies
D. Application cache
46.
Explain Which new business process or processes should be supported by the new solution?
(Choose all that apply)
A. Brokers can order transportation services
B. Vehicle scheduling capability is provided
C. Bar code readers are supported
D. Use of space on vehicles can be tracked
E. Brokers can track shipments
F. Customers can track parcels
Answer: A, D, E
47.
Suppose You are writing a list of integration requirements for your solution. Which requirement or
requirements should you include? (Choose all that apply)
A. Order data must be read from the accounting application
B. Shipment tracking must be read from an XML Web service
C. Customers must be redirected to another Web site to track shipments
D. Customers must be able to place orders by using an XML Web service
E. Order data must be written to the accounting application
F. Order data must be e-mailed to the salespeople
Answer: A, B, E
48.
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 object
B. Customer object
C. Flight object
D. Logging object
E. Airline object
49.
Suppose You need to enable brokers to track their own shipment. To meet this requirement, you need to
consider various specifications. Which four specifications should you consider? (Each correct
answer presents part of the solution)
A. Provide a Web-accessible form to authenticate brokers against a table of registered users
B. Provide a Web-accessible form to enable brokers to request vehicle routes for their shipments
C. Provide a Web-accessible form to query the database for broker shipments
D. Provide a Web-accessible form to generate waybill numbers
E. Identify a parcel in the database as part of a broker shipment
F. Relate a parcel to a specific broker
G. Track the weight of a parcel in the database
50.
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 invoice
Monitoring 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 the
statistics
B. Create a removable Microsoft .NET class to contain statistics. Configure the class as singleton
class. Write a utility that retrieves statistical information from this class
C. Write statistics to the application event log
D. Use custom performance counters
51.
Suppose You are writing the technical specification for your solution. You need to select a technology for
the new timesheet application. Which technology should you use?
A. an XML Web service
B. a Web application
C. a console application
D. a Windows Forms application
52.
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
53.
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
54.
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
55.
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
56.
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
57.
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
58.
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
59.
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
60.
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
61.
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
62.
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
63.
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
64.
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
65.
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
66.
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
67.
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.
68.
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
69.
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.
70.
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
71.
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
72.
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
73.
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
74.
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
75.
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
76.
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
77.
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.
78.
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
79.
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
80.
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
81.
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
82.
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
83.
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
84.
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
85.
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
86.
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
87.
Suppose You need to ensure that transportation brokers are authenticated when they access the broker
Web site. Which action or actions should you take? (Choose all that apply)
A. Create a distribution list of authenticated users
B. Provide a facility for online registration
C. Provide a facility to view passwords
D. Provide secure storage of user names and passwords
E. Secure the exchange of user names and passwords between the client computer and the
server
F. Enable e-mail access for transportation brokers
Answer: B, D, E
88.
Suppose You are completing the technical specification for the new reservation application.
Which technique should you recommend for state management?
A. ASP.NET ViewState
B. Server-side database
C. Client-side cookies
D. Application cache
89.
Explain Which new business process or processes should be supported by the new solution?
(Choose all that apply)
A. Brokers can order transportation services
B. Vehicle scheduling capability is provided
C. Bar code readers are supported
D. Use of space on vehicles can be tracked
E. Brokers can track shipments
F. Customers can track parcels
Answer: A, D, E
90.
Suppose You are writing a list of integration requirements for your solution. Which requirement or
requirements should you include? (Choose all that apply)
A. Order data must be read from the accounting application
B. Shipment tracking must be read from an XML Web service
C. Customers must be redirected to another Web site to track shipments
D. Customers must be able to place orders by using an XML Web service
E. Order data must be written to the accounting application
F. Order data must be e-mailed to the salespeople
Answer: A, B, E
91.
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 object
B. Customer object
C. Flight object
D. Logging object
E. Airline object
92.
Suppose You need to enable brokers to track their own shipment. To meet this requirement, you need to
consider various specifications. Which four specifications should you consider? (Each correct
answer presents part of the solution)
A. Provide a Web-accessible form to authenticate brokers against a table of registered users
B. Provide a Web-accessible form to enable brokers to request vehicle routes for their shipments
C. Provide a Web-accessible form to query the database for broker shipments
D. Provide a Web-accessible form to generate waybill numbers
E. Identify a parcel in the database as part of a broker shipment
F. Relate a parcel to a specific broker
G. Track the weight of a parcel in the database
93.
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 invoice
Monitoring 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 the
statistics
B. Create a removable Microsoft .NET class to contain statistics. Configure the class as singleton
class. Write a utility that retrieves statistical information from this class
C. Write statistics to the application event log
D. Use custom performance counters
94.
Suppose You are writing the technical specification for your solution. You need to select a technology for
the new timesheet application. Which technology should you use?
A. an XML Web service
B. a Web application
C. a console application
D. a Windows Forms application
95.
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
96.
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
97.
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
98.
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
99.
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
100.
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
101.
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
102.
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
103.
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
104.
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
105.
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
106.
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
107.
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
108.
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
109.
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
110.
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.
111.
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
112.
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.
113.
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
114.
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
115.
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
116.
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
117.
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
118.
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
119.
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
120.
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.
121.
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
122.
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
123.
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
124.
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
125.
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
126.
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
127.
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
128.
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
129.
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