You need to analyze the response time of the product catalog page during peak times, from different locations
You administer an Azure Web Site named contosoweb that is used to sell various products.
Contosoweb experiences heavy traffic during weekends.
You need to analyze the response time of the product catalog page during peak times, from
different locations.
What should you do?
Which Azure PowerShell cmdlet should you use with each PowerShell command line?
DRAG DROP
Your company manages several Azure Web Sites that are running in an existing webhosting plan named plan1.
You need to move one of the websites, named contoso, to a new web-hosting plan named plan2.
Which Azure PowerShell cmdlet should you use with each PowerShell command line? To
answer, drag the appropriate Azure PowerShell cmdlet to the correct location in the
PowerShell code. Each PowerShell cmdlet 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 option should you select?
HOTSPOT
You manage an Azure Web Site for a consumer-product company. The website runs in
Standard mode on a single medium instance. You expect increased traffic to the website
due to an upcoming sale during a holiday weekend. You need to ensure that the website
performs optimally when user activity is at its highest. Which option should you select? To
answer, select the appropriate option in the answer area.
Which Transact-SQL query or queries should you use?
You administer a Microsoft SQL Server database that supports a banking transaction
management application.
You need to retrieve a list of account holders who live in cities that do not have a branch
location.
Which Transact-SQL query or queries should you use? (Each correct answer presents a
complete solution. Choose all that apply.)
You need to ensure that clients are able to access the MyApp website by using https
Your company has a subscription to Azure.
You configure your contoso.com domain to use a private Certificate Authority. You deploy a
web site named MyApp by using the Shared (Preview) web hosting plan.
You need to ensure that clients are able to access the MyApp website by using https.
What should you do?
which column in the Employee table should you a create a unique constraint?
You administer a Microsoft SQL Server 2012 database. The database contains a table
named Employee. Part of the Employee table is shown in the exhibit. (Click the Exhibit button.)
Confidential information about the employees is stored in a separate table named
EmployeeData. One record exists within EmployeeData for each record in the Employee
table. You need to assign the appropriate constraints and table properties to ensure data
integrity and visibility. On which column in the Employee table should you a create a unique
constraint?
Which three xplat-cli commands should you perform in sequence?
DRAG DROP
You manage an Azure Web Site named salessite1. You notice some performance issues
with salessite1. You create a new database for salessite1.
You need to update salessite1 with the following changes, in the order shown:
1. Display the list of current connection strings.
2. Create a new connection string named conn1 with a value of:
Server=tcp:samplel.database.windows.net,1433;Database=NewDB;User
ID=User@samplel;Password=Passwordl;Trusted_Connection=False;Encrypt=True;Connec
tion Timeout=30;.
3. Download the application logs for analysis.
Which three xplat-cli commands should you perform in sequence? To answer, move the
appropriate commands from the list of commands to the answer area and arrange them in
the correct order.
Which four steps should you perform next in sequence?
DRAG DROP
You administer an Azure Web Site named contosoweb that uses a production database.
You deploy changes to contosoweb from a deployment slot named contosoweb-staging.
You discover issues in contosoweb that are affecting customer data.
You need to resolve the issues in contosoweb while ensuring minimum downtime for users.
You swap contosoweb to contosoweb-staging.
Which four steps should you perform next 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 column in the Employee table should you use an identity specification to include a seed of 1,000 and an
You administer a Microsoft SQL Server 2012 database. The database contains a table
named Employee. Part of the Employee table is shown in the exhibit. (Click the Exhibit button.)
Unless stated above, no columns in the Employee table reference other tables.
Confidential information about the employees is stored in a separate table named
EmployeeData. One record exists within EmployeeData for each record in the Employee
table.
You need to assign the appropriate constraints and table properties to ensure data integrity
and visibility.
On which column in the Employee table should you use an identity specification to include a
seed of 1,000 and an increment of 1?
Which Transact-SQL query should you use?
You administer a Microsoft SQL Server 2012 database that includes a table named
Products. The Products table has columns named Productld, ProductName, and
CreatedDateTime.
The table contains a unique constraint on the combination of ProductName and
CreatedDateTime.
You need to modify the Products table to meet the following requirements:
• Remove all duplicates of the Products table based on the ProductName column.
• Retain only the newest Products row.
Which Transact-SQL query should you use?