Which code segment should you use as the body of the GetVideoStream function in the Video-Controller class?
###BeginCaseStudy###
Case Study: 3
Scenario 3
Background
You are developing a video transcoding service. This service is used by customers to upload
video files, convert video to other formats, and view the converted files. This service is used
by customers all over the world.
Business Requirements
The user-facing portion of the application is an ASP.NET MVC application. It provides an
interface for administrators to upload video and schedule transcoding. It also enables
administrators and users to download the transcoded videos.
When videos are uploaded, they are populated with metadata used to identify the video. The
video metadata is gathered by only one system when the video upload is complete.
Customers require support for Microsoft Internet Explorer 7 and later.
The application contains a header that is visible on every page.
If the logged-on user is an administrator, then the header will contain links to administrative
functions. This information is read from a cookie that is set on the server. The administrative
links must not be present if an error condition is present.
Technical Requirements
User Experience:
• The front-end web application enables a user to view a list of videos.
• The main view of the application is the web page that displays the list of
videos.
• HTML elements other than the list of videos are changed with every request
requiring the page to reload.
Compatibility:
• Some customers use browsers that do not support the HTTP DELETE verb.
• These browsers send a POST request with an HTTP header of X-Delete
when the intended action is to delete.
Transcoding:
• The video transcoding occurs on a set of Windows Azure worker roles.
• The transcoding is performed by a third-party command line tool named
transcode.exe. When the tool is installed, an Environment variable named
transcode contains the path to the utility.
• A variable named license contains the license key. The license for the
transcoding utility requires that it be unregistered when it is not in use.
• The transcoding utility requires a significant amount of resources. A maximum
of 10 instances of the utility can be running at any one time. If an instance of
the role cannot process an additional video, it must not prevent any other
roles from processing that video.
• The utility logs errors to a Logs directory under the utilities path.
• A local Azure directory resource named perf is used to capture performance
data.
Development:
• Developers must use Microsoft Remote Desktop Protocol (RDP) to view
errors generated by the transcode.exe utility.
• An x509 certificate has been created and distributed to the developers for this
purpose.
• Developers must be able to use only RDP and not any other administrative
functions.
Application Structure
###EndCaseStudy###
You need to maximize performance of video delivery. Which code segment should you use
as the body of the GetVideoStream function in the Video-Controller class?
Which method should you add to the TranscodeWorkerRole class?
###BeginCaseStudy###
Case Study: 3
Scenario 3
Background
You are developing a video transcoding service. This service is used by customers to upload
video files, convert video to other formats, and view the converted files. This service is used
by customers all over the world.
Business Requirements
The user-facing portion of the application is an ASP.NET MVC application. It provides an
interface for administrators to upload video and schedule transcoding. It also enables
administrators and users to download the transcoded videos.
When videos are uploaded, they are populated with metadata used to identify the video. The
video metadata is gathered by only one system when the video upload is complete.
Customers require support for Microsoft Internet Explorer 7 and later.
The application contains a header that is visible on every page.
If the logged-on user is an administrator, then the header will contain links to administrative
functions. This information is read from a cookie that is set on the server. The administrative
links must not be present if an error condition is present.
Technical Requirements
User Experience:
• The front-end web application enables a user to view a list of videos.
• The main view of the application is the web page that displays the list of
videos.
• HTML elements other than the list of videos are changed with every request
requiring the page to reload.
Compatibility:
• Some customers use browsers that do not support the HTTP DELETE verb.
• These browsers send a POST request with an HTTP header of X-Delete
when the intended action is to delete.
Transcoding:
• The video transcoding occurs on a set of Windows Azure worker roles.
• The transcoding is performed by a third-party command line tool named
transcode.exe. When the tool is installed, an Environment variable named
transcode contains the path to the utility.
• A variable named license contains the license key. The license for the
transcoding utility requires that it be unregistered when it is not in use.
• The transcoding utility requires a significant amount of resources. A maximum
of 10 instances of the utility can be running at any one time. If an instance of
the role cannot process an additional video, it must not prevent any other
roles from processing that video.
• The utility logs errors to a Logs directory under the utilities path.
• A local Azure directory resource named perf is used to capture performance
data.
Development:
• Developers must use Microsoft Remote Desktop Protocol (RDP) to view
errors generated by the transcode.exe utility.
• An x509 certificate has been created and distributed to the developers for this
purpose.
• Developers must be able to use only RDP and not any other administrative
functions.
Application Structure
###EndCaseStudy###
The transcode.exe utility activates its license online when it is installed. You need to ensure
that the registration of the transcode utility is handled as specified in its license. Which
method should you add to the TranscodeWorkerRole class?
Which code segment should you use as the body of the SendAsync method in the DeleteHandler class?
###BeginCaseStudy###
Case Study: 3
Scenario 3
Background
You are developing a video transcoding service. This service is used by customers to upload
video files, convert video to other formats, and view the converted files. This service is used
by customers all over the world.
Business Requirements
The user-facing portion of the application is an ASP.NET MVC application. It provides an
interface for administrators to upload video and schedule transcoding. It also enables
administrators and users to download the transcoded videos.
When videos are uploaded, they are populated with metadata used to identify the video. The
video metadata is gathered by only one system when the video upload is complete.
Customers require support for Microsoft Internet Explorer 7 and later.
The application contains a header that is visible on every page.
If the logged-on user is an administrator, then the header will contain links to administrative
functions. This information is read from a cookie that is set on the server. The administrative
links must not be present if an error condition is present.
Technical Requirements
User Experience:
• The front-end web application enables a user to view a list of videos.
• The main view of the application is the web page that displays the list of
videos.
• HTML elements other than the list of videos are changed with every request
requiring the page to reload.
Compatibility:
• Some customers use browsers that do not support the HTTP DELETE verb.
• These browsers send a POST request with an HTTP header of X-Delete
when the intended action is to delete.
Transcoding:
• The video transcoding occurs on a set of Windows Azure worker roles.
• The transcoding is performed by a third-party command line tool named
transcode.exe. When the tool is installed, an Environment variable named
transcode contains the path to the utility.
• A variable named license contains the license key. The license for the
transcoding utility requires that it be unregistered when it is not in use.
• The transcoding utility requires a significant amount of resources. A maximum
of 10 instances of the utility can be running at any one time. If an instance of
the role cannot process an additional video, it must not prevent any other
roles from processing that video.
• The utility logs errors to a Logs directory under the utilities path.
• A local Azure directory resource named perf is used to capture performance
data.
Development:
• Developers must use Microsoft Remote Desktop Protocol (RDP) to view
errors generated by the transcode.exe utility.
• An x509 certificate has been created and distributed to the developers for this
purpose.
• Developers must be able to use only RDP and not any other administrative
functions.
Application Structure
###EndCaseStudy###
You need to ensure that all customers can delete videos regardless of their browser
capability. Which code segment should you use as the body of the SendAsync method in the
DeleteHandler class?
How should you implement the startup task?
###BeginCaseStudy###
Case Study: 3
Scenario 3
Background
You are developing a video transcoding service. This service is used by customers to upload
video files, convert video to other formats, and view the converted files. This service is used
by customers all over the world.
Business Requirements
The user-facing portion of the application is an ASP.NET MVC application. It provides an
interface for administrators to upload video and schedule transcoding. It also enables
administrators and users to download the transcoded videos.
When videos are uploaded, they are populated with metadata used to identify the video. The
video metadata is gathered by only one system when the video upload is complete.
Customers require support for Microsoft Internet Explorer 7 and later.
The application contains a header that is visible on every page.
If the logged-on user is an administrator, then the header will contain links to administrative
functions. This information is read from a cookie that is set on the server. The administrative
links must not be present if an error condition is present.
Technical Requirements
User Experience:
• The front-end web application enables a user to view a list of videos.
• The main view of the application is the web page that displays the list of
videos.
• HTML elements other than the list of videos are changed with every request
requiring the page to reload.
Compatibility:
• Some customers use browsers that do not support the HTTP DELETE verb.
• These browsers send a POST request with an HTTP header of X-Delete
when the intended action is to delete.
Transcoding:
• The video transcoding occurs on a set of Windows Azure worker roles.
• The transcoding is performed by a third-party command line tool named
transcode.exe. When the tool is installed, an Environment variable named
transcode contains the path to the utility.
• A variable named license contains the license key. The license for the
transcoding utility requires that it be unregistered when it is not in use.
• The transcoding utility requires a significant amount of resources. A maximum
of 10 instances of the utility can be running at any one time. If an instance of
the role cannot process an additional video, it must not prevent any other
roles from processing that video.
• The utility logs errors to a Logs directory under the utilities path.
• A local Azure directory resource named perf is used to capture performance
data.
Development:
• Developers must use Microsoft Remote Desktop Protocol (RDP) to view
errors generated by the transcode.exe utility.
• An x509 certificate has been created and distributed to the developers for this
purpose.
• Developers must be able to use only RDP and not any other administrative
functions.
Application Structure
###EndCaseStudy###
DRAG DROP
You need to ensure that the transcode.exe utility is installed before the worker role starts.
How should you implement the startup task? (To answer, drag the appropriate values to the
correct element or attribute. Each value 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.)
You need to ensure that the username and password values are encrypted when they are deployed
You are developing a project that contains multiple SQL Server Integration Services (SSIS)
packages. The packages will be deployed to the SSIS catalog. One of the steps in each
package accesses an FTP site to download sales transaction data.
You create project parameters to store the username and password that are used to access
the FTP site.
You need to ensure that the username and password values are encrypted when they are
deployed.
What should you do?
You need to ensure that more accurate matches are made by the Fuzzy Lookup transformation without degrading pe
You develop a SQL Server Integration Services (SSIS) package that imports SQL Azure
data into a data warehouse every night.
The SQL Azure data contains many misspellings and variations of abbreviations. To import
the data, a developer used the Fuzzy Lookup transformation to choose the closest-matching
string from a reference table of allowed values. The number of rows in the reference table is
very large.
If no acceptable match is found, the Fuzzy Lookup transformation passes a null value.
The current setting for the Fuzzy Lookup similarity threshold is 0.50.
Many values are incorrectly matched.
You need to ensure that more accurate matches are made by the Fuzzy Lookup
transformation without degrading performance.
What should you do?
You need to create the SSIS catalog on the production server
You install a SQL Server 2012 database engine instance on a production server. A month
later, you install SQL Server 2012 Integration Services (SSIS).
You must develop an SSIS project and deploy it to the server by using the Project
Deployment model.
Operations Log records that are outside the configured retention period must be cleaned
automatically.
You need to create the SSIS catalog on the production server.
What should you do? (Each correct answer presents part of the solution. Choose all that apply.)
Where can you find this information?
A SQL Server Integration Services (SSIS) package on a computer is failing periodically in
production. The package was created less than one year ago and was deployed to the SSIS
catalog.
Sometimes the package is started on a SQL Agent schedule; sometimes the package is
started manually by an SSIS developer by using the Object Explorer in SQL Server
Management Studio.
You need to identify the authenticated user responsible for starting the package each time it
failed in the past.
Where can you find this information?
Which three actions should you perform in sequence?
DRAG DROP
A SQL Server Integration Services (SSIS) package named DataFeed interacts with an
external vendor data feed. The package is executed several times a day, either as part of
other packages’ control flow or by itself. The external data feed is unreliable because
network failures and slow response times are frequent. The package is currently deployed
on the file system.
To analyze the reliability of the external data feed, you must collect execution data.
Every time the DataFeed package is executed, the following information must be logged:
Start Time
End Time
Execution Result
Execution Duration
You need to design a logging solution that meets the requirements by using the least
amount of administrative and development effort.
Which three actions should you perform in sequence? (To answer, move the appropriate
actions from the list of actions to the answer area and arrange them in the correct order.)
Which configuration should you use?
You administer all the deployments of Microsoft SQL Server 2012 in your company.
You need to ensure that an OLTP database that includes up-to-the-minute reporting
requirements can be off-loaded from the primary database to another server. You also need
to be able to add indexes to the secondary database.
Which configuration should you use?