Which code segment should you use?
###BeginCaseStudy###
Testlet 1
Background
You are developing an ASP.NET MVC application in Visual Studio 2012 that will be used by Olympic marathon
runners to log data about training runs.
Business Requirements
The application stores date, distance, and duration information about a user’s training runs. The user can view,
insert, edit, and delete records.
The application must be optimized for accessibility.
All times must be displayed in the user’s local time.
Technical Requirements
Data Access:
Database access is handled by a public class named RunnerLog.DataAccess.RunnerLogDb.
All data retrieval must be done by HTTP GETand all data updates must be done by HTTP POST.
Layout:
All pages in the application use a master layout file named \\Views\\Shared\\_Layout.cshtml.
Models:
The application uses the \\Models\\LogModel.cs model.
Views:
All views in the application use the Razor view engine.
Four views located in \\Views\\RunLog are named:
_CalculatePace.cshtml
EditLog.cshtml
GetLog.cshtml
InsertLog.cshtml
The application also contains a \\Views\\Home\\Index.cshtml view.
Controllers:
The application contains a \\Controllers\\RunLogController.cs controller.
Images:
A stopwatch.png image is located in the \\Images folder.
Videos:
A map of a runner’s path is available when a user views a run log. The map is implemented as an Adobe Flash
application and video. The browser should display the video natively if possible, using H264, Ogg, or WebM
formats, in that order. If the video cannot be displayed, then the Flash application should be used.
Security:
You have the following security requirements:
The application is configured to use forms authentication.
Users must be logged on to insert runner data.
Users must be members of the Admin role to edit or delete runner data.
There are no security requirements for viewing runner data.
You need to protect the application against cross-site request forgery.
Passwords are hashed by using the SHA1 algorithm.
RunnerLog.Providers.RunLogRoleProvider.cs contains a custom role provider.
Relevant portions of the application files follow. (Line numbers are included for reference only.)
Application Structure
###EndCaseStudy###
You need to extend the edit functionality of RunLogController.
Which code segment should you use?
Which code segment should you use?
###BeginCaseStudy###
Testlet 1
Background
You are developing an ASP.NET MVC application in Visual Studio 2012 that will be used by Olympic marathon
runners to log data about training runs.
Business Requirements
The application stores date, distance, and duration information about a user’s training runs. The user can view,
insert, edit, and delete records.
The application must be optimized for accessibility.
All times must be displayed in the user’s local time.
Technical Requirements
Data Access:
Database access is handled by a public class named RunnerLog.DataAccess.RunnerLogDb.
All data retrieval must be done by HTTP GETand all data updates must be done by HTTP POST.
Layout:
All pages in the application use a master layout file named \\Views\\Shared\\_Layout.cshtml.
Models:
The application uses the \\Models\\LogModel.cs model.
Views:
All views in the application use the Razor view engine.
Four views located in \\Views\\RunLog are named:
_CalculatePace.cshtml
EditLog.cshtml
GetLog.cshtml
InsertLog.cshtml
The application also contains a \\Views\\Home\\Index.cshtml view.
Controllers:
The application contains a \\Controllers\\RunLogController.cs controller.
Images:
A stopwatch.png image is located in the \\Images folder.
Videos:
A map of a runner’s path is available when a user views a run log. The map is implemented as an Adobe Flash
application and video. The browser should display the video natively if possible, using H264, Ogg, or WebM
formats, in that order. If the video cannot be displayed, then the Flash application should be used.
Security:
You have the following security requirements:
The application is configured to use forms authentication.
Users must be logged on to insert runner data.
Users must be members of the Admin role to edit or delete runner data.
There are no security requirements for viewing runner data.
You need to protect the application against cross-site request forgery.
Passwords are hashed by using the SHA1 algorithm.
RunnerLog.Providers.RunLogRoleProvider.cs contains a custom role provider.
Relevant portions of the application files follow. (Line numbers are included for reference only.)
Application Structure
###EndCaseStudy###
You need to make the “Distance” header of the table bold in the Views/RunLog/GetLog.cshtml view.
Which code segment should you use?
How should you modify RunLogController?
###BeginCaseStudy###
Testlet 1
Background
You are developing an ASP.NET MVC application in Visual Studio 2012 that will be used by Olympic marathon
runners to log data about training runs.
Business Requirements
The application stores date, distance, and duration information about a user’s training runs. The user can view,
insert, edit, and delete records.
The application must be optimized for accessibility.
All times must be displayed in the user’s local time.
Technical Requirements
Data Access:
Database access is handled by a public class named RunnerLog.DataAccess.RunnerLogDb.
All data retrieval must be done by HTTP GETand all data updates must be done by HTTP POST.
Layout:
All pages in the application use a master layout file named \\Views\\Shared\\_Layout.cshtml.
Models:
The application uses the \\Models\\LogModel.cs model.
Views:
All views in the application use the Razor view engine.
Four views located in \\Views\\RunLog are named:
_CalculatePace.cshtml
EditLog.cshtml
GetLog.cshtml
InsertLog.cshtml
The application also contains a \\Views\\Home\\Index.cshtml view.
Controllers:
The application contains a \\Controllers\\RunLogController.cs controller.
Images:
A stopwatch.png image is located in the \\Images folder.
Videos:
A map of a runner’s path is available when a user views a run log. The map is implemented as an Adobe Flash
application and video. The browser should display the video natively if possible, using H264, Ogg, or WebM
formats, in that order. If the video cannot be displayed, then the Flash application should be used.
Security:
You have the following security requirements:
The application is configured to use forms authentication.
Users must be logged on to insert runner data.
Users must be members of the Admin role to edit or delete runner data.
There are no security requirements for viewing runner data.
You need to protect the application against cross-site request forgery.
Passwords are hashed by using the SHA1 algorithm.
RunnerLog.Providers.RunLogRoleProvider.cs contains a custom role provider.
Relevant portions of the application files follow. (Line numbers are included for reference only.)
Application Structure
###EndCaseStudy###
DRAG DROP
You need to implement security according to the business requirements.
How should you modify RunLogController? (To answer, drag the appropriate code segment to the correct
location or locations. Each code segment may be used once, more than once, or not at all. You may need to
drag the split bar between panes or scroll to view content.)
Select and Place:
How should you implement the view?
###BeginCaseStudy###
Testlet 1
Background
You are developing an ASP.NET MVC application in Visual Studio 2012 that will be used by Olympic marathon
runners to log data about training runs.
Business Requirements
The application stores date, distance, and duration information about a user’s training runs. The user can view,
insert, edit, and delete records.
The application must be optimized for accessibility.
All times must be displayed in the user’s local time.
Technical Requirements
Data Access:
Database access is handled by a public class named RunnerLog.DataAccess.RunnerLogDb.
All data retrieval must be done by HTTP GETand all data updates must be done by HTTP POST.
Layout:
All pages in the application use a master layout file named \\Views\\Shared\\_Layout.cshtml.
Models:
The application uses the \\Models\\LogModel.cs model.
Views:
All views in the application use the Razor view engine.
Four views located in \\Views\\RunLog are named:
_CalculatePace.cshtml
EditLog.cshtml
GetLog.cshtml
InsertLog.cshtml
The application also contains a \\Views\\Home\\Index.cshtml view.
Controllers:
The application contains a \\Controllers\\RunLogController.cs controller.
Images:
A stopwatch.png image is located in the \\Images folder.
Videos:
A map of a runner’s path is available when a user views a run log. The map is implemented as an Adobe Flash
application and video. The browser should display the video natively if possible, using H264, Ogg, or WebM
formats, in that order. If the video cannot be displayed, then the Flash application should be used.
Security:
You have the following security requirements:
The application is configured to use forms authentication.
Users must be logged on to insert runner data.
Users must be members of the Admin role to edit or delete runner data.
There are no security requirements for viewing runner data.
You need to protect the application against cross-site request forgery.
Passwords are hashed by using the SHA1 algorithm.
RunnerLog.Providers.RunLogRoleProvider.cs contains a custom role provider.
Relevant portions of the application files follow. (Line numbers are included for reference only.)
Application Structure
###EndCaseStudy###
DRAG DROP
You need to implement the Views\\RunLog\\_CalculatePace.cshtml partial view from Views\\Runlog
\\GetLog.cshtml to display the runner’s average mile pace.
How should you implement the view? (To answer, drag the appropriate code segments to the correct location
or locations. Each code segment may be used once, more than once, or not at all. You may need to drag the
split bar between panes or scroll to view content.)
Select and Place:
Which Transact-SQL query should you use?
Your database contains a table named Purchases. The table includes a DATETIME column named
PurchaseTime that stores the date and time each purchase is made. There is a non- clustered index on the
PurchaseTime column. The business team wants a report that displays the total number of purchases made on
the current day. You need to write a query that will return the correct results in the most efficient manner.
Which Transact-SQL query should you use?
Which table hint should you use?
You develop a Microsoft SQL Server 2012 database that contains a heap named OrdersHistorical.
You write the following Transact-SQL query:
INSERT INTO OrdersHistorical
SELECT * FROM CompletedOrders
You need to optimize transaction logging and locking for the statement.
Which table hint should you use?
Which Transact-SQL statement should you use?
You administer a SQL Server 2012 server that contains a database named SalesDb. SalesDb contains a
schema named Customers that has a table named Regions. A user named UserA is a member of a role named
Sales. UserA is granted the Select permission on the Regions table. The Sales role is granted the Select
permission on the Customers schema.
You need to ensure that the following requirements are met:
The Sales role does not have the Select permission on the Customers schema. UserA has the Select
permission on the Regions table.
Which Transact-SQL statement should you use?
You need to create an object that meets the following r…
You use Microsoft SQL Server 2012 to develop a database application. You need to create an object that
meets the following requirements:
Takes an input variable
Returns a table of values
Cannot be referenced within a view
Which object should you use?
Which Transact-SQL query do you use?
You are a database developer for an application hosted on a Microsoft SQL Server 2012 server. The database
contains two tables that have the following definitions:
Global customers place orders from several countries. You need to view the country from which each customer
has placed the most orders.
Which Transact-SQL query do you use?
You need to improve the performance of the query
You use a Microsoft SQL Server 2012 database that contains two tables named SalesOrderHeader and
SalesOrderDetail. The indexes on the tables are as shown in the exhibit.
(Click the Exhibit button.)
You write the following Transact-SQL query:
You discover that the performance of the query is slow. Analysis of the query plan shows table scans where the
estimated rows do not match the actual rows for SalesOrderHeader by using an unexpected index on
SalesOrderDetail.
You need to improve the performance of the query.
What should you do?