What are two possible ways to achieve this goal?
You manage a cloud service that hosts a customer-facing application. The application allows
users to upload images and create collages. The cloud service is running in two medium
instances and utilizes Azure Queue storage for image processing. The storage account is
configured to be locally redundant.
The sales department plans to send a newsletter to potential clients. As a result, you expect
a significant increase in global traffic.
You need to recommend a solution that meets the following requirements:
✑ Configure the cloud service to ensure the application is responsive to the traffic increase.
✑ Minimize hosting and administration costs.
What are two possible ways to achieve this goal? Each correct answer presents a complete
solution.
Which Power Shell cmdlet should you use?
You manage a cloud service on two instances. The service name is Service1 and the role
name is ServiceRole1.
Service1 has performance issues during heavy traffic periods.
You need to increase the existing deployment of Service1 to three instances.
Which Power Shell cmdlet should 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?
What are two possible ways to achieve this goal?
Your company network includes two branch offices. Users at the company access internal
virtual machines (VMs).
You want to ensure secure communications between the branch offices and the internal
VMs and network.
You need to create a site-to-site VPN connection.
What are two possible ways to achieve this goal? Each correct answer presents a complete
solution.
Which configuration should you use?
DRAG DROP
You plan to deploy a cloud service named contosoapp that has a web role named
contosoweb and a worker role named contosoimagepurge.
You need to ensure the service meets the following requirements:
+ Contosoweb can be accessed over the Internet by using http.
+ Contosoimagepurge can only be accessed through tcp port 5001 from contosoweb.
+ Contosoimagepurge cannot be accessed directly over the Internet.
Which configuration should you use? To answer, drag the appropriate configuration setting
to the correct location in the service configuration file. Each configuration setting 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.
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 nonclustered 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?
You need to achieve this goal by using the least amount of administrative effort
You manage an Azure virtual network that hosts 15 virtual machines (VMs) on a single
subnet which is used for testing a line of business (LOB) application. The application is
deployed to a VM named TestWebServiceVM.
You need to ensure that TestWebServiceVM always starts by using the same IP address.
You need to achieve this goal by using the least amount of administrative effort.
What should you do?
You need to store media files in several tables
You develop a database for a travel application. You need to design tables and other
database objects.
You need to store media files in several tables.
Each media file is less than 1 MB in size. The media files will require fast access and will be
retrieved frequently.
What should you do?
You need to create a secure connection for the remote employees who require access to your Azure virtual netwo
Your network environment includes remote employees.
You need to create a secure connection for the remote employees who require access to
your Azure virtual network.
What should you do?
Which three steps should you perform in sequence?
DRAG DROP
Your development team has created a new solution that is deployed in a virtual network
named fabDevVNet.
Your testing team wants to begin testing the solution in a second Azure subscription.
You need to create a virtual network named fabTestVNet that is identical to fabDevVNet.
You want to achieve this goal by using the least amount of administrative effort.
Which three steps 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.