You need to ensure that all users can access SaasApp1
Your company network includes users in multiple directories. You plan to publish a softwareas-a-service application named SaasApp1 to Azure Active Directory.
You need to ensure that all users can access SaasApp1.
What should you do?
You need to change the Block 8lob to a page blob
You are migrating a local virtual machine (VM) to an Azure VM. You upload the virtual hard
disk (VHD) file to Azure Blob storage as a Block Blob.
You need to change the Block 8lob to a page blob.
What should you do?
Which three steps should you perform in sequence?
DRAG DROP
You administer an Azure SQL database named contosodb that is running in Standard/Si tier.
The database is in a server named server1 that is a production environment. You also
administer a database server named server2 that is a test environment. Both database
servers are in the same subscription and the same region but are on different physical clusters.
You need to copy contosodb to the test environment.
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.
You need to supply the stored procedure with multiple event names and their dates as parameters
You develop a database for a travel application. You need to design tables and other
database objects. You create a stored procedure. You need to supply the stored procedure
with multiple event names and their dates as parameters. What should you do?
Which two actions should you perform?
You administer a Microsoft Azure SQL Database data base in the US Central region named
contosodb. Contosodb runs on a Standard tier within the SI performance level.
You have multiple business-critical applications that use contosodb.
You need to ensure that you can bring contosodb back online in the event of a natural
disaster in the US Central region. You want to achieve this goal with the least amount of
downtime.
Which two actions should you perform? Each correct answer presents part of the solution.
Which code segment should you use?
You have a view that was created by using the following code:
You need to create an inline table-valued function named Sales.fn_OrdersByTerritory, which
must meet the following requirements:
• Accept the @T integer parameter.
• Use one-part names to reference columns.
• Filter the query results by SalesTerritoryID.
• Return the columns in the same order as the order used in OrdersByTerritoryView.
Which code segment should you use?
To answer, type the correct code in the answer area.
Which two actions should you perform?
You administer a Microsoft Azure SQL Database database in the US Central region named
contosodb. Contosodb runs on a Standard tier within the SI performance level.
You have multiple business-critical applications that use contosodb.
You need to ensure that you can bring contosodb back online in the event of a natural
disaster in the US Central region. You want to achieve this goal with the least amount of
downtime.
Which two actions should you perform? Each correct answer presents part of the solution.
Which code segment should you use?
You have a database that contains the tables shown in the exhibit. (Click the Exhibit button.)
You deploy a new server that has SQL Server 2012 installed. You need to create a table
named
Sales.OrderDetails on the new server. Sales.OrderDetails must meet the following
requirements:
• Write the results to a disk.
• Contain a new column named LineItemTotal that stores the product of ListPrice and
Quantity for each row.
• The code must NOT use any object delimiters.
The solution must ensure that LineItemTotal is stored as the last column in the table. Which
code segment should you use?
To answer, type the correct code in the answer area.
You need to ensure that each datacenter is a cold site for the other
You manage two datacenters in different geographic regions and one branch office. You
plan to implement a geo-redundant backup solution. You need to ensure that each
datacenter is a cold site for the other. You create a recovery vault. What should you do next?
Which three steps should you perform in sequence?
DRAG DROP
You manage an application deployed to a cloud service that utilizes an Azure Storage account.
The cloud service currently uses the primary access key.
Security policy requires that all shared access keys are changed without causing application downtime.
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.