You need to allow the user access only to the video file, and then revoke access once the user no longer needs
You manage a collection of large video files that is stored in an Azure Storage account.
A user wants access to one of your video files within the next seven days.
You need to allow the user access only to the video file, and then revoke access once the
user no longer needs it.
What should you do?
Which code segment should you use?
You have a database that contains the tables shown in the exhibit. (Click the Exhibit button.)
You need to create a view named uv_CustomerFullName to meet the following
requirements:
• The code must NOT include object delimiters.
• The view must be created in the Sales schema.
• Columns must only be referenced by using one-part names.
• The view must return the first name and the last name of all customers.
• The view must prevent the underlying structure of the customer table from being
changed.
• The view must be able to resolve all referenced objects, regardless of the user’s
default schema.
Which code segment should you use?
To answer, type the correct code in the answer area.
Which URL should you use to access the list?
You administer an Azure Storage account named contoso storage. The account has queue
containers with logging enabled.
You need to view all log files generated during the month of July 2014.
Which URL should you use to access the list?
Which code segment should you use?
You have a database that contains the tables shown in the exhibit. (Click the Exhibit button.)
You need to create a query that calculates the total sales of each OrderId from the
Sales.Details table. The solution must meet the following requirements:
• Use one-part names to reference columns.
• Sort the order of the results from OrderId.
• NOT depend on the default schema of a user.
• Use an alias of TotalSales for the calculated ExtendedAmount.
• Display only the OrderId column and the calculated TotalSales column.
Which code segment should you use?
To answer, type the correct code in the answer area.
Which solution should you recommend?
Your company has two physical locations configured in a geo-clustered environment that
includes:
System Center Virtual Machine Manager 2012 R2 System Center Data Protection Manager
2012 R2 SQL Server 2012 Windows Server 2012 R2 Hyper-V Over 100 virtual machines
(VMs) in each physical location
Your company has recently signed up for Azure.
You plan to leverage your current network environment to provide a backup solution for your
VMs.
You need to recommend a solution that ensures all VMs are redundant and deployable
between locations. You also want the solution to minimize downtime in the event of an
outage at either physical location.
Which solution should you recommend?
Which Transact-SQL query should you use?
You have a Microsoft SQL Server 2012 database that contains tables named Customers
and Orders.
The tables are related by a column named CustomerID.
You need to create a query that meets the following requirements:
Returns the CustomerName for all customers and the OrderDate for any orders that they
have placed.
Results must include customers who have not placed any orders.
Which Transact-SQL query should you use?
You need to implement a solution by using Azure services
You manage an application running on Azure Web Sites Standard tier. The application uses
a substantial amount of large image files and is used by people around the world. Users
from Europe report that the load time of the site is slow. You need to implement a solution by
using Azure services. What should you do?
What are two possible ways to achieve this goal?
You manage a set of virtual machines (VMs) deployed to the cloud service named
fabrikamVM.
You configure auto scaling according to the following parameters:
With an instance range of two to six instances To maintain CPU usage between 70 and 80
percent To scale up one instance at a time With a scale up wait time of 30 minutes To scale
down one instance at a time With a scale down wait time of 30 minutes
You discover the following usage pattern of a specific application:
The application peaks very quickly, and the peak lasts for several hours. CPU usage stays
above 90 percent for the first 1 to 1.5 hours after usage increases. After 1.5 hours, the CPU
usage falls to about 75 percent until application usage begins to decline.
You need to modify the auto scaling configuration to scale up faster when usage peaks.
What are two possible ways to achieve this goal? Each correct answer presents a complete
solution.
Which Transact-SQL statement should you include at the beginning of the stored procedure?
You create a stored procedure that will update multiple tables within a transaction.
You need to ensure that if the stored procedure raises a run-time error, the entire transaction
is terminated and rolled back.
Which Transact-SQL statement should you include at the beginning of the stored
procedure?
Which storage option should you enable?
Your company network has two physical locations configured in a geo-clustered
environment. You create a Blob storage account in Azure that contains all the data
associated with your company.
You need to ensure that the data remains available in the event of a site outage.
Which storage option should you enable?