What should you create for each application?
You develop a Microsoft SQL Server 2012 database. The database is used by two web
applications that access a table named Products.
You want to create an object that will prevent the applications from accessing the table
directly while still providing access to the required data.
You need to ensure that the following requirements are met:
• Future modifications to the table definition will not affect the applications’ ability to
access data.
• The new object can accommodate data retrieval and data modification.
• You need to achieve this goal by using the minimum amount of changes to the
existing applications.
What should you create for each application?
Which Azure Power Shell cmdlet should you use?
You manage several Azure virtual machines (VMs). You create a custom image to be used
by employees on the development team.
You need to ensure that the custom image is available when you deploy new servers.
Which Azure Power Shell cmdlet should you use?
How should you host both applications?
You administer a cloud service. You plan to host two web applications named contosoweb
and contosowebsupport. You need to ensure that you can host both applications and qualify
for the Azure Service
Level Agreement. You want to achieve this goal while minimizing costs. How should you host both applications?
Which object should you use?
You develop a Microsoft SQL Server 2012 database.
You need to create a batch process that meets the following requirements:
Returns a result set based on supplied parameters.
Enables the returned result set to perform a join with a table.
Which object should you use?
You need to ensure that messages that are never consumed are retained
You manage a cloud service that utilizes an Azure Service Bus queue. You need to ensure
that messages that are never consumed are retained. What should you do?
Which values should you use within the service configuration file?
DRAG DROP
You plan to deploy a cloud service named contosoapp. The service includes a web role
named contosowebrole. The web role has an endpoint named restrictedEndpoint.
You need to allow access to restricted Endpoint only from your office machine using the IP
address 145.34.67.82.
Which values should you use within the service configuration file? To answer, drag the
appropriate value to the correct location in the service configuration file. 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.
identify the deployment method for each service.
You manage two cloud services named Service1 and Service2. The development team
updates the code for each application and notifies you that the services are packaged and
ready for deployment.
Each cloud service has specific requirements for deployment according to the following table.
In the table below, identify the deployment method for each service. Make only one selection in each column.
Which Transact-SQL statement or statements should you use?
You develop a Microsoft SQL Server 2012 database.
You need to create and call a stored procedure that meets the following requirements:
Accepts a single input parameter for CustomerID.
Returns a single integer to the calling application.
Which Transact-SQL statement or statements should you use? (Each correct answer
presents part of the solution. Choose all that apply.)
You need to configure the Azure Management Portal to notify you when the SLA performance targets are not met
You manage a web application published to Azure Cloud Services.
Your service level agreement (SLA) requires that you are notified in the event of poor
performance from customer locations in the US, Asia, and Europe.
You need to configure the Azure Management Portal to notify you when the SLA
performance targets are not met.
What should you do?
Which table hint should you use?
You develop a Microsoft SQL Server 2012 database that contains a heap named
OrdersHistoncal.
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?